Microsoft Database Administrator
Location: Pearland Administrative Office
Department: IT ERP Job Type: Full Time
Kelsey-Seybold Clinic. Changing the way health cares.
Kelsey-Seybold Clinic is Houston's premier multispecialty group practice, founded in 1949 by Dr. Mavis Kelsey.
With 19 clinic locations and more than 400 physicians, Kelsey-Seybold provides medical care in 55 medical specialties and is home to a nationally accredited Breast Diagnostic Center, Endoscopy Center, Infusion Center and Cancer Center. Our mission is to provide our team members with exceptional opportunities for professional and personal growth.
JOB SUMMARY: The Microsoft Database Administrator is a member of the Information Technology ERP support team, working with users across the organization, responsible for providing operational and technical support for the Infor/Lawson Systems and accompanying database servers (MS SQL Server). This position will also be responsible for providing support for the Infor/Lawson data warehouse and ancillary applications.
Bachelor's Degree in Computer Science, Information Technology or equivalent education and/or experience. 4+ years' experience with managing MS SQL server version 2012 and latest. 4+ years' experience supporting Microsoft SSIS administration and development. 4+ years' experience supporting Microsoft SSAS administration and development. 4+ years' experience supporting Microsoft SSRS administration and development. 4+ years' experience supporting Microsoft Data Warehouse environment 4+ years' experience supporting Microsoft Business Intelligence. 4+ years' experience supporting various reporting application such as Crystal Reports, BIRST, PowerBI, etc.
EDUCATION REQUIREMENTS & EXPERIENCE REQUIREMENTS
(A = basics; B = preferred)
Technical Bachelor's degree or equivalent experience.
Four years of Lawson System Administrator experience.
Previous experience in the health care industry with exposure to Lawson systems
Current and valid Texas LVN license
UNIX Certified ProfessionalMicrosoft Certified ProfessionalMicrosoft Certified IT ProfessionalMicrosoft Certified Technology SpecialistMicrosoft Certified Systems AdministratorMicrosoft Certified Systems Engineer
UNIX Server AdministrationMicrosoft OS AdministrationMicrosoft SQL Server AdministrationMicrosoft IIS Server AdministrationMicrosoft Sharepoint AdministrationServer VirtualizationIBM Websphere AdministrationUnix/DOS ScriptingMKS System Administrator
Multiple work assignments including: configuring, testing, documenting, upgrading and implementing systems and/or software Ensuring client requirements are met by actively soliciting, identifying, and responding to customer questions and assisting with issue resolution Working collaboratively and build relationships with customer staff, and third-party consultants They should be comfortable working with highly knowledgeable Lawson end-users and able to quickly understand unique client requirements and configurations.
Infor/Lawson (ERP) Administration: Coordinate applying Lawson/Infor patches with 3rd party vendor. Restart jobs as requested.
Set up recurring batch jobs and setup csv attributes for batch jobs Conduct Dump data out of the database as requested. Determine cause and remedies for batch jobs that error out Administer the Lawson Business Intelligence product (LBI) Monitor the servers and provide troubleshooting assistance as needed Assist with resolution of errors from the monthly recycle of the servers Assist with installing ancillary software used by Lawson/Infor (i.e. Smartoffice, Addins, etc.) Setup, Monitor and Troubleshoot issues with EDI Setup, Monitor and Troubleshoot issues with Lawson Printing Resolve any server log and configuration issues.
Infor/Lawson Security: Add/Remove/Modify users in Lawson Security Administration Grant user access to forms/tables Set up security classes and roles Setup back office access for users in Lawson Security
Infor/Landmark IPA: Resolve issues and restart ProcessFlow Workunits Promote new/modified process flows Setup services and triggers for process flows
MS SQL Server Admin: Provide SQL Server Administration support for Infor/Lawson and Kronos databases Database Backups and Restores Monitor and maintain SQL server database file sizes Resolve database blocking issues and deadlock issues Install MS SQL Server, SSIS, SSAS and SSRS Setup MS SQL Server, SSIS, SSAS and SSRS Apply patches to MS SQL Server Provide SQL Server support for data copy requests Troubleshoot slow performing queries
Kelsey Seybold Clinic