Database Administrator
State of Oklahoma
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
State of Oklahoma is seeking a Database Administrator to manage SQL Server databases, including design, maintenance, security, capacity planning, and disaster recovery. You will ensure data integrity, performance, and availability across on-prem and cloud environments.
The role requires strong T-SQL, PowerShell scripting, and experience with HA solutions such as Always On, Failover Clustering, and replication. Oklahoma City office-based, full-time position with comprehensive benefits.
Qualifications
- Six years of experience in information technology or data management (or equivalent education/experience).
- Expertise with SQL Server versions and performance tuning tools.
- Experience designing and supporting high-availability solutions (Always On, Failover Clustering, replication, log shipping).
- Strong T-SQL development and automation using PowerShell.
Responsibilities
- Install, configure, and maintain SQL Server instances across on-prem and cloud environments.
- Monitor performance and tune queries, indexes, and execution plans.
- Develop and implement backup, recovery, and high-availability strategies.
- Manage security, access controls, encryption, and compliance requirements.
- Perform ongoing maintenance, schema changes, and environment refreshes.
- Create scripts and automation for routine tasks; build monitoring/alerting.
Skills
Tools
Job description
090 OFFICE OF MANAGEMENT AND ENTERPRISE SERV
090 OFFICE OF MANAGEMENT AND ENTERPRISE SERV
IS-Data
Refer to the date listed at the top of this posting, if available. Continuous if date is blank.
Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above.
Full time
Regular
As a SQL Server Database Administrator with OMES you will enjoy:
- Generous leave including 15 days of vacation, 15 days of sick leave and 11 paid holidays annually.
- A comprehensive Benefit Package with a generous benefit allowance to offset the cost of insurance premiums for employees and their eligible dependents.
- Full-time 40-hour work weeks.
- Support the Information Services Division.
- Salary is based on education and experience.
- This position is located in Oklahoma City, and you will be required to be in theoffice 5 days per week.
- At this time, we cannot offer sponsorship now or in the future.
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 maximum availability, integrity, confidentiality and security of data.
- Install, configure, and maintain SQL Server instances across on-prem and cloud environments.
- Apply patches, cumulative updates, and perform version upgrades/migrations.
- Configure SQL Server components such as SSIS, SSRS, and SSAS when required.
- Monitor database performance using DMVs, Extended Events, Query Store, and other tools.
- Tune SQL queries, indexes, and execution plans to ensure optimal database performance.
- Troubleshoot blocking, deadlocks, and system bottlenecks.
- Develop and manage reliable database backup and recovery strategies.
- Perform restore scenarios including point-in-time recovery.
- Configure and support high-availability solutions such as Always On AGs, Failover Clustering, log shipping, and replication.
- Participate in disaster recovery planning and testing.
- Manage database security including logins, users, roles, and permissions.
- Implement encryption like TDE or its equivalent, auditing, and best-practice security measures.
- Ensure regulatory and internal compliance standards are met.
- Manage SQL Agent jobs, alerts, and automation processes.
- Perform ongoing maintenance: index management, statistics updates, DBCC integrity checks.
- Monitor database growth, storage utilization, and capacity planning.
- Execute schema changes, deployments, and environment refreshes.
- Diagnose and resolve production incidents, errors, and performance degradation.
- Analyze logs, trace files, deadlock graphs, and memory dumps as needed.
- Provide on-call support for critical systems.
- Create and maintain scripts using T-SQL and PowerShell to automate routine tasks.
- Build monitoring and alerting solutions to proactively identify issues.
- Work closely with users, developers, system administrators, stakeholders and other teams.
- Document configurations, procedures, and runbooks for operational excellence.
- Assist in mentoring junior team members as needed.
This position works in a comfortable office setting with a computer for a large percentage of the workday. The noise level in the work environment is usually mild. Occasional travel may be required.
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.
- Demonstrated expertise with SQL Server 2008/2008 R2/2012/2014/2016/2017/2019/2022 features and performance tuning tools.
- Proven experience designing and supporting SQL server high-availability solutions such as Always On Availability Groups, Failover Clustering, replication, and log shipping.
- Advanced skills in T-SQL development, query tuning, and analyzing execution plans.
- Strong background with PowerShell scripting and automation of administrative tasks.
- Extensive experience managing large-scale databases and high-throughput systems.
- Proven experience building and managing Azure SQL, Azure Managed Instance, AWS RDS for SQL Server, Cloud SQL on Google Cloud Platform, or hybrid cloud architectures
- Experience with ETL tools (SSIS), reporting services (SSRS) and Azure data factory.
- Ability to lead or contribute to database modernization efforts, including cloud migration or consolidation projects.
- Experience in managing PostgreSQL, MySQL and SharePoint Databases.
- Excellent communication skills with the ability to collaborate across technical and business teams.
- Demonstrated ability to work effectively in cross-functional teams, including developers, system administrators, analysts, and business stakeholders.
- Relevant certifications such as: Microsoft Certified: Azure Database Administrator Associate, MCSE: Data Management and Analytics, MCSA: SQL Server
The Office of Management and Enterprise Services provides 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.
OMES is an Equal Opportunity Employer. Reasonable accommodation to individuals with disabilities may be provided upon request.
The State of Oklahoma is an equal opportunity employer and does not discriminate on the basis of genetic information, race, religion, color, sex, age, national origin, or disability.
Current active State of Oklahoma employees must apply for open positions internally through the Workday Jobs Hub.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
