Senior Database Administrator

Recruitment #190307-UNCB-28


Submit resume and cover letter with salary requirements and availability date via email with
“Senior Database Administrator” in message title to:

  The Supreme Court of Oklahoma Administrative Office of the Courts
2100 N. Lincoln Blvd., Suite 3
Oklahoma City, Oklahoma 73105

Senior Database Administrator

The Administrative Office of the Courts (AOC) is seeking a self-motivated person to assume the responsibilities of the Senior Database Administrator.  The Senior Database Administrator should possess the skills necessary to plan, coordinate and supervise all activities related to the design, development, implementation, improvement, and maintenance of Court databases in close collaboration with the Information Management and Infrastructure Teams.  The Senior Database Administrator oversees the database design and development, while working with multi-functional groups of Project Managers, Business Analysts, Network Administrators, Security Analysis, Quality Assurance Specialists, implementation teams, and court users to ensure continuous quality, on-time delivery, and customer satisfaction. 

Reporting to the Data Systems Manager, the Senior Database Administrator is responsible for the design, installation, implementation, administration, support, security and documentation of databases from all supported database platforms.

Position Description:
The Senior Database Administrator is responsible for all database management functions for the Administrative Office of the Courts. The Administrator will be responsible for the strategic planning, managing, support, and performance tuning of all database applications.

Working with other database administrators and the development team, performs database tasks such as security planning, architecture design, performance tuning, capacity planning, backups monitoring, maintenance, trouble shooting, and change control activities.

The Senior Administrator provides key data recommendations and best practice solutions to project teams and governance committees as requested. They are responsible for all activities associated with the management and operation of database platforms: implementing data models and designs. Additional responsibilities are creating database tables, indexes, triggers and views to support new and existing applications, design and implementing incremental and full backup policies and procedures, monitoring database size and performance, tuning SQL queries, developing prototypes to demonstrate proposed functionality, produce support documentation, and provide production support. Install SQL Server software and oversee upgrades and patches, facilitate root cause analysis on database issues, manage security of application access to databases, perform benchmarking analysis to properly size hardware platforms, and maintain technical documentation relating to database management. 

Responsibilities and essential functions will include (but not be limited to) the following:
•Ability to work as a part of a team as well as independently, when required.
•Work closely within the Oklahoma Judiciary to establish strategic directions
 and plans for storing, warehousing, and archiving court data.
•Lead the design and construction of highly available and secure databases, data 
 warehouses, data marts, and business intelligence platforms.
•Support departmental operations in a high-throughput production environment by
 proactively managing the performance, integrity, and security of Court Applications'
 databases and database servers.
•Setup, monitor, and maintain disaster recovery solutions for production databases.
•Create databases and database objects such as tables, indexes, views, triggers, and
 stored procedures.
•Ensure compliance with RDBMS license agreement.
•Create and maintain customized database reports and perform data analysis.
•Assist in the management of the hardware and software as related to the operations of the SQL Server DBMS, including system development, maintenance, and recommendations of purchases of new hardware and software.
•Perform under limited supervision, maintain reliability of data and databases, and
 assist in developing and implementing standards for database maintenance,
 configuration and performance.
•Responsible for synchronizing and migrating data and database objects between
 development, quality assurance, and production environments.
•Mentor and provide support to other Database Administrators and Software Applications
 Developers in best practices for database design, programming, and tuning.
•Identify training opportunities for him/herself and the team
•Maintains technical knowledge by attending educational workshops; reviewing
 publications; establishing personal networks; participating in technical societies
•Work as a member of the technology team to assist in providing maximum availability
 and support of information technology systems.
•Perform tests and evaluations regularly to ensure data security, privacy and
•Ensuring data integrity, data security and performance of production databases.
•Enforcing policies for effective data management.
•Understand, apply, and maintain Transparent Data Encryption (TDE) and Transport Layer
 Security (TLS) protocols on database servers.
•Maintain, backup, and secure encryption certificates and keys required for
 restoration of encrypted databases.
•Support the development of data loads and extracts.
•Run diagnostics and maintain operation logs and documentation.
•Provide on-call support as needed
•Setup, manage, and maintain database and reporting services security.
•Other duties as assigned.

Knowledge and Skill Requirements:
•Six (6) plus years of hands-on experience with Microsoft SQL Server with at least 5
 year’s database administration experience.
•Experience maintaining multiple large database systems consisting of normalized and
 de-normalized data and table structures.
•Experience maintaining and administering a SQL Server Reporting Services server.
•Experience maintaining and administering an Analysis Services Server.
•Proficient in ETL operations using (but not limited to) SSIS (integration Services)
•Experience with data modeling techniques, including normal form and dimensional
•Experience with physical data modeling techniques including use of indexes,
 materialized views, system aggregates, etc.
•System architecture, including database and system performance tuning, as well as
 hardware and network workload balancing experience.
•Experience implementing virtual data marts.
•Working knowledge of Windows Server 2012 Operating Systems.
•Working knowledge of MS Project and MS Project Server is a plus.
•Proficient in Microsoft Office (365 and/or latest desktop version)
•Must be able to show initiative and flexibility in a dynamic environment.
•Strong communication and presentation skills.
•Experience with Court operations is preferred.

Education / Experiences:
•Bachelors’ of science degree from an accredited college in Computer Science/Information Systems, math, engineering or related technical field.
•MSCA SQL 2016 Database Administration or equivalent and MSCA SQL 2016 Database Development is a plus.
•Project Management Program (PMP) certification a plus
•Advanced degree is a plus.

The standard benefits for the State of Oklahoma includes employee leave, retirement and a health plan package. Applicant must be willing to self-relocate if applicable. 




Veteran's Preference Points Apply only for initial appointment in the Classified Service.