Oracle Database Administrator Job at Harvey Nash Group, Frankfort, KY

TlIzNHFnbG1NbEV1RmVydXZLSFBZYlFLT0E9PQ==
  • Harvey Nash Group
  • Frankfort, KY

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

UPMC Western Maryland

Licensed Practical Nurse - Clinical Resource Pool Job at UPMC Western Maryland

 ...UPMC Western Maryland is seeking full-time, Licensed Practical Nurses to support their Clinical Resource Team (Float Pool)! Joining the Clinical Resource Team will qualify you toreceive a 10% float pool differential! Qualified LPNs are also eligible for a generous... 

Veolia

Environmental Specialist I Job at Veolia

 ...Company Description Veolia in North America is the top-ranked environmental company in the United States for three consecutive years, and...  ...: Sample waste streams according to prescribed policies and procedures. Manifesting, packaging, spill clean-up response... 

Domino's Franchise

Domino's Delivery Driver Job at Domino's Franchise

 ...must be outgoing, energetic, efficient, and willing to work in a fun and fast paced environment. $11.50 - $23.00 per hour Cash Paid Daily! Minimum Age 18+ with 2 years driving experience Valid Driver's License with safe driving record that meets... 

Passionate Private Duty

Caregiver Job at Passionate Private Duty

 ...Responsibilities: Enables clients to stay in their homes by monitoring and recording patient conditions, and providing support and...  ...services, such as bathing, dressing, and grooming. Helps clients care for themselves by assisting with the use of a cane or walker,... 

McKinley Paper

Electrical & Instrumentation Technician Job at McKinley Paper

 ...at all hours. CERTIFICATES AND LICENSES : Associates degree in electronics or related field, state indentured Electrician or Instrumentation journeyman card, or equivalent schooling and experience to become and maintain the appropriate license needed to perform the...