Oklahoma Indigent Defense System · 17 hours ago
Database Administrator
Oklahoma County, OK
Full-time
Onsite
Senior Level
6+ years expOklahoma Indigent Defense System is seeking a SQL Server Database Administrator to support the Information Services Division. The role involves the administration of SQL Server databases including design, development, maintenance, and security administration to ensure maximum availability and integrity of data.
Law Practice
No H1B
Responsibilities
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
Qualification
Required
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
Preferred
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
Benefits
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.
Company
Oklahoma Indigent Defense System
Oklahoma Indigent Defense System is a State of Oklahoma agency located in Norman, Oklahoma
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase