|Department||Administrative Office of the Courts|
|Date Opened||9/21/2017 1:30:00 PM|
|Filing Deadline||1/10/2018 3:39:00 PM|
|Salary||Salary commensurate with Education/Experience|
|Full or Part Time||
Submit resume and cover letter with salary requirements and availability date via email with “Database Administrator” in message title to: firstname.lastname@example.org
The Supreme Court of Oklahoma Administrative Office of the Courts
2100 N. Lincoln Blvd., Suite 3
Oklahoma City, Oklahoma 73105
Salary commensurate with Education/Experience
The Administrative Office of the Courts is in the process of developing a statewide, unified, multi-jurisdictional Case Management System across the Oklahoma Judiciary. We are seeking, eager, talented, self-motivated individuals to join our MIS team to take the construction and implementation of the Oklahoma Case Management System (CMS) forward.
In this capacity, you will have the opportunity to collaborate with a highly experienced team and join them in influencing the implementation of the statewide CMS application by ensuring that all requirements are met in the design, configuration, implementation, and administration of a state-of-the-art case management system. If you would like to bring your talents to bear in the exciting and challenging effort ahead of us, please submit your cover letter and resume for consideration as described above.
The Administrative Office of the Courts (AOC) is seeking a self-motivated person to join the organization as a Database Administrator. The Database Administrator should possess the skills necessary to provide operational support for the information systems of the Administrative Office of the Courts.
The Database Administrator is responsible for all database management functions for the Administrative Office of the Courts. The Database Administrator will be responsible for the tactical planning, administration, and support of all database applications. Working with other senior and junior database administrators, performs database tasks such as security planning, architecture design, performance tuning, capacity planning, backups monitoring, maintenance, trouble shooting, and change control activities.
The Database Administrator provides key data recommendations and best practice solutions to project teams as requested. Will be responsible for all activities associated with the administration and operation of database platforms: implementing data models and designs, creating database tables, indexes, triggers and views to support new and existing applications, designing and implementing incremental and full backup policies and procedures, monitoring database size and performance, writing and tuning SQL, developing prototypes to demonstrate proposed functionality, producing support documentation, and providing operational support.
Install SQL Server software, upgrades and patches, facilitate root cause analysis on database issues, enforce security of application access to databases, perform benchmarking analysis to properly size hardware platforms, and maintain technical documentation relating to database management.
Principal responsibilities include ensuring data integrity, data security and performance of production databases. Support the development of data loads and extracts. Run diagnostics and maintain operation logs and documentation. Provide on-call support as needed.
Responsibilities and essential functions will include (but not be limited to) the following:
• Ability to work as part of a team as well as independently, when required.
• Work closely within the Oklahoma Judiciary to establish tactical plans for storing and warehousing court data.
• Design and construct 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.
• Create databases and database objects such as tables, indexes, views, triggers, and stored procedures.
• 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 standard operating procedures for database maintenance and configuration.
• 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 Applications Developers in best practices for database design, programming, and tuning.
• Work as a member of the technology team to assist in providing maximum availability and support of information technology systems.
• Setup, manage, and maintain database and reporting services security.
• Other duties as assigned.
Knowledge, Experience and Skill Requirements:
• 3+ years of hands-on administration experience with Microsoft SQL Server.
• 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 with data modeling techniques, including relational 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.
• Experience implementing virtual data marts.
• Working knowledge of Windows Server 2012 Operating Systems.
• Must be able to show initiative and flexibility in a dynamic environment.
• Strong communication and presentation skills.
• Experience with Court operations is preferred.
• Bachelors’ degree from an accredited college in Computer Science/Information Systems, math, engineering or related technical field.
• Microsoft Certification or equivalent is a plus.
• Advanced degree is a plus.
• Occasional travel to remote office locations within the state of Oklahoma.
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.
Position open until filled.
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.
Veteran's Preference Points Apply only for initial appointment in the Classified Service.