Job Description

Database Administrator
Frankfort, KY/Hybrid
Long-term Indefinite

Work Arrangement: This position is hybrid, and the selected candidate is expected to work in the office 3 days per week and follow the same schedule as state workers.

Seeking a  Database Administrator (DBA)with strong  mainframe experience to support the Service Mining project. This role focuses primarily on maintaining and enhancing existing  Oracle databases and  mainframe systems rather than performing new installations or configurations. The ideal candidate will have extensive experience in  database analysis, development, and maintenance , with strong technical skills in writing  views, packages, procedures, and functions .

Key Responsibilities:

• Maintain and support mainframe and Oracle database environments for the Service Mining project.
• Develop and enhance database components, including  views, packages, procedures, and functions .
• Collaborate with application and business teams to support evolving business processes and functional enhancements.
• Learn and understand the existing Oracle database architecture and associated systems.
• Ensure database performance, reliability, and integrity across production and development environments.
• Utilize mainframe database tools such as  Toad or  DbForge Pro for database management and development.
• Partner with Commonwealth Office of Technology (COT) DBAs who manage all  installation and configuration activities.
• Assist in troubleshooting, optimization, and documentation of database processes.

Required Skills and Qualifications:

• Minimum 3 years of experience working with  mainframe databases and Oracle environments.
• Strong experience developing and maintaining  views, packages, procedures, and functions in Oracle.
• Proficiency using  Toad or  DbForge Pro for database development and maintenance.
• Solid understanding of  mainframe systems and their integration with Oracle databases.
• Ability to analyze and enhance existing database functionality to meet business needs.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications:

• Experience supporting legacy mainframe applications in a government or large enterprise environment.
• Familiarity with Oracle PL/SQL and data modeling best practices.
• Demonstrated ability to work collaboratively across technical and business team

The job tasks of the Database Administrator would include

• Meet with programs to learn business processes utilized in SMIS; work closely with agency staff and IT staff in prepare comprehensive documentation of technical requirements, processes, and specifications for the Surface Mining Information System.
• Create and Refine Complex Queries: Construct efficient and accurate database queries, procedures, and audits to ensure seamless data retrieval and integrity across supported systems.
• Work closely with IT leads and developers in the ongoing development and implementation of enhancements for the Surface Mining Information System (SMIS) to meet changing user requirements and improve operational effectiveness.
• Collaborate and Communicate Effectively: Partner with users, business analysts, and team members to address system needs, troubleshoot issues, and convey technical concepts to diverse audiences.

Job Tags

Work at office, 3 days per week,

Similar Jobs