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 pa