SQL Server Database Administrator

Recruitment #210217-UNCB-40

Introduction

A resume and cover letter must be submitted with your application.

The Office of Management and Enterprise Services (OMES) is dedicated to providing excellent service, expert guidance, and continuous improvement in support of our partners’ goals. We are a highly-qualified workforce committed to serve those who serve Oklahomans and make government run in the most efficient, innovative manner possible. Achieving this mission takes a collaborative, agile, respectful team with humble leaders who make a difference and get things done. 

For more information about OMES, please visit our website.  

The Office of Management and Enterprise Services is seeking a full time  SQL Server Database Administrator for the Information Services Division. This is an unclassified position in state government, located in Oklahoma City.  OMES offers a comprehensive Benefits Package, including a generous benefit allowance to offset the cost of insurance premiums for employees and their eligible dependentsFor more information about the benefit allowance [click here]. The annual salary for this position is based on education and experience.

This position is assigned responsibilities involving the administration of SQL Server databases.  This includes the design, development, maintenance, security administration, capacity planning, performance monitoring and tuning, upgrade, backup and recovery of SQL Server databases to ensure the availability, integrity, confidentiality and security of information.

Position Responsibilities
• Ensure maximum database availability, performance and security by utilizing best industry practices, and provide database-related assistance to end users and application developers
• Design and implement online databases, security access systems, data sets and jobs; define parameters for file or space utilization; establish direct access files or other file configurations as required; monitor space utilization and makes modifications as needed
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, and code comments
• Install and modify vendor software products; conduct appropriate tests to ensure compatibility of new or modified programs with operating system requirements; use  database performance and tuning tools in order to monitor and enhance response times and system performance
• Respond to database operational emergencies as required, including database recoveries involving the use of database log files, which provide for the recovery of databases with no loss of data and do not require the user to re-enter data into the database
• Create queries, stored procedures, functions and other database objects
• Perform other data management processes utilizing database protocols
• Provide applications development and other unit personnel with database and data security information required to support application development and other activities
• Support repository/database dictionary requirements and activities; develop, implement and  monitor control blocks and data definitions to support databases
• Confer with computer operations, technical support, user and vendor representatives concerning database requirements, system performance, software maintenance, capacity planning, and data security requirements
• Review systems specifications for compliance with departmental, division and database administration standards
• Provide assistance to the data engineering team to make data in agency systems available to the State Data Platform.

Physical Demands and Work Environment
• This position works in a comfortable office setting with a computer for a large percentage of the work day.  The noise level in the work environment is usually mild.  Occasional travel may be required.

OMES is an Equal Opportunity Employer. Reasonable accommodation to individuals with disabilities may be provided upon request.

MINIMUM QUALIFICATIONS

Requirements include six years of experience in an information technology or data management field; OR  an equivalent combination of education and experience, substituting 12 semester hours in computer science or management information systems course work for each year of the required experience.

Preference will be given to candidates who possess
• Experience in building and maintaining multi-node High Availability SQL Clusters
• Experience in Azure including but not limited to building and maintaining Azure SQL databases, Azure Managed Instances, Azure replication and etc.
• Experience in  Azure equivalent cloud technology, like Google Cloud and etc.
• Experience in Power BI Report Server configuration and maintenance.
• Experience in Postgres, MySQL and SharePoint Database maintenance.
• Strong communication and client-facing skills with the ability to work in a centralized technology environment.

NOTES

Please read instructions carefully and include all required documents when you submit your application.

No additional information will be accepted after the application has been submitted.

Conclusion

Veteran’s preference points apply only for initial appointment in the classified service.