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

U3k2OGV4RXJxcW9hSzJ3a1lHekZlNStQUHc9PQ==
  • 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

CMP.jobs

Warehouse Worker - Package Handler Job at CMP.jobs

Warehouse Worker UPS Quick Apply Applying for this role online is quick and easy you could even get a job offer in 10 minutes!...  ...work. Who exactly are UPS Warehouse Workers? Also known as package handlers, many of our warehouse workers load/unload packages in... 

RPI Philadelphia

Sports-Minded Marketing Assistant Job at RPI Philadelphia

 ...direct marketing firm in Philadelphia with a zeal for promotions and brand management. We are searching for determined, imaginative, keen, and career-oriented individuals to fill our available Entry Level Marketing Assistant position. Our Entry Level Marketing Assistant will... 

ActioNet, Inc.

Cyber Security Analyst (Entry to Senior Level) - Hawaii|Req#4114 Job at ActioNet, Inc.

DescriptionActioNet is looking for a Cyber Security Analyst (Entry, Mid Level, or Senior)with an Active Secret Clearance for the Defense Program, located in Hawaii (Joint Base Pearl Harbor Hickam).The Cyber Security Analystwill provide network defense support... 

TechMagic

Remote Middle Salesforce developer Job at TechMagic

 ...We are looking for an experienced Salesforce developer with 4+ years of commercial experience to join our successful and stable project from the UK. Must have At least 4 years of experience in web development Experience with Lightning Web Components Experience... 

Somerby Franklin

Dishwasher Job at Somerby Franklin

 ...attention to cleanliness Must be drug-free (exceptions made for marijuana, in compliance with local laws) No felony convictions (background check required) We Offer: A supportive and respectful work environment Consistent schedule and reliable hours Competitive...