What are the responsibilities and job description for the Database Administrator position at University of Kansas Medical Center?
Description
Job Duties :
Monitor performance of database systems resources and query throughput.
Optimize SQL Code as necessary.
Monitor and maintain database storage resources, maintenance plans for backups, index rebuild / defragment, and database statistics.
Troubleshoot, develop or participate in the development of ETL systems using Visual Studio, SSIS, TSQL, PowerShell for MS SQL Server 2012-2019 Integration Services packages.
Database Installation, Upgrades, Migrations and Configurations, installation of database software service packs and cumulative updates as necessary.
Maintain database documentation as required.
Perform database Ad-hoc backups and restores.
Proactively monitor and respond to database Alerts.
Keep abreast of current Information Technology industry enhancements, theories and practices through self-education, membership in professional associations and formal training.
This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. It is only a summary of the typical functions of the job, not an exhaustive list of all possible job responsibilities, tasks, duties, and assignments. Furthermore, job duties, responsibilities and activities may change at any time with or without notice.
Required Qualifications
Education :
Bachelor's degree and 6 years of relevant experience. Education may be substituted for experience on a year for year basis. Experience used to substitute education is in addition to any required work experience.
Work Experience :
Experience administering relational databases in a Windows environment.
Experience with operating systems, database systems, Windows Clustering with SQL Server, AlwaysOn Availability, system tools, network operations, and communication functions.
Experience in bringing new database systems to productive use in a short period of time.
Experience handling the pressure of several assignments while maintaining good working relationships with technical and user personnel wishing to use the databases.
Preferred Qualifications
Work Experience :
Experience with SQL Server 2012-2019, Visual Studio, SSIS, TSQL, PowerShell for MS SQL Server 2012-2019, Integration Services, Windows Server Failover Clustering.
Experience with maintaining communication and reporting interfaces among technical, functional departments, and senior management.
Experience working with faculty and others in an academic environment.
Required Documents
Resume
Cover letter
Comprehensive Benefits Package :
Coverage begins on day one for health, dental, and vision insurance and includes health expense accounts with generous employer contributions if the employee participates in a qualifying health plan. Employer-paid life insurance, long-term disability insurance, and various additional voluntary insurance plans are available. Paid time off, including vacation and sick, begins accruing upon hire, plus ten paid holidays. One paid discretionary day is available after six months of employment, and paid time off for bereavement, jury duty, military service, and parental leave is available after 12 months of employment. A retirement program with a generous employer contribution and additional voluntary retirement programs (457 or 403b) are available.
Employee Type : Regular
Time Type : Full time
Rate Type : Salary
Compensation Statement :
The pay range listed for this position is determined by our compensation program using market data and salary benchmarking. A combination of factors is considered in making compensation decisions including, but not limited to, education, experience and training, qualifications relative to the requirements of the position, and funding. At the University of Kansas Medical Center, a reasonable estimate for the starting pay range will be the minimum to midpoint of the posted range, taking into account the combination of factors listed above.
Pay Range :
75,000.00 - $115,000.00
Minimum
75,000.00
Midpoint
95,000.00
Maximum
115,000.00
Salary : $75,000 - $115,000
