Senior Database Administrator

Recruitment #210401-UNCB-69

Introduction

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

opportunities@oscn.net

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

http://www.oscn.net
---------------------------------------------------------------------------------------------------------  

 

Position open until filled.

Senior Database Administrator
Salary commensurate with Education/Experience

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, extract-transform-load (ETL) processes, capacity planning, backups, monitoring, index maintenance, trouble shooting, maintenance plans 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, creating database tables, indexes, and views to support new and existing applications, design and implementing transaction 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, functions, and stored
 procedures.
•Ensure compliance with RDBMS license agreement.
•Create and maintain customized database reports and perform data analysis using Business
 Intelligence tools like PowerBI, Reporting Services , and Analysis Services
•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 integrity.
•Ensuring data integrity, data security and performance of production databases.
•Enforcing policies for effective data management.
•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:
•10+ 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 modeling.
•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.
•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.

Candidates who are eligible to work in the United States are encouraged to apply.   The Administrative Office of the Courts will not sponsor a work visa (H-1B, etc.) to fill this position.

As a condition of employment, any successful candidate who receives an offer of employment will be required to pass a background investigation.

The Oklahoma Supreme Court is an Equal Opportunity Employer.

 

Conclusion

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