Database Administrator

Department:
Enterprise Development & Support
-
Data Management and Database Administration

Position Title:
Database Administrator

Job Family Group:
Professional Staff

Job Description Summary:
Monitor and maintain the organization's Oracle and Microsoft SQL databases. Help analyze the organization's data and database needs. Monitor policies and carries out procedures related to data security and integrity. Monitor and limit database access as needed. Help oversee the design, maintenance and implementation of the systems that manage an internal database. Data management includes: Monitor the database for efficient operations; migrate data as required, ensure database users have adequate access to data; resolve data conflicts as needed; assist in solving application and ETL (Extract, Transform, and Load) problems; and others as assigned. Other duties include the continual support of the Java Programming needs for Information Resources.

Job 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. https://www.kumc.edu/human-resources/benefits.html

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

Application Instructions:
To learn more and apply online, please visit https://kumc.wd5.myworkdayjobs.com/en-US/kumc-jobs/job/Kansas-City-Metro-Area/Database-Administrator_JR008135 or go to https://careers.kumc.edu/ and search for position number JR008135.

Applications must be submitted directly through the KU Medical Center website to be considered for this position. Any applications submitted via email or this website will NOT be reviewed or considered.

About KU Medical Center:
The University of Kansas Medical Centers mission is to educate exceptional health care professionals through a full range of undergraduate, graduate, professional, postdoctoral and continuing education programs in the schools of Medicine, Nursing and Health Professions. KU Medical Center also advances the health sciences through world-class research programs; provides compassionate and state-of-the-art patient care in an academic medical center environment; and works with communities in every Kansas county to improve the health of Kansans. Learn more at www.kumc.edu.

Benefits:
KUMC offers a range of great benefits that support employees and eligible family members. Our health insurance benefits begin on hire date and KUMC offers other exciting benefits such as paid parental leave, generous employer retirement contributions and other resources to improve health and well-being. For more information, please visit https://www.kumc.edu/human-resources/benefits.html

Equal Employment Opportunity Statement

The University of Kansas Medical Center is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, ethnicity, ancestry, age, protected veteran or disability status, marital status, parental status, or genetic information. http://policy.ku.edu/IOA/nondiscrimination

jeid-ee9ab59ad813fd41a48cfe205e4d90c3