Database Administrator (DBA)

ZealHire Inc.; Northern (KY); Hybrid; USD 90,000 - 140,000; Full time

Job summary

ZealHire Inc. is seeking a Database Administrator to oversee PostgreSQL environments across cloud and on-premises. You will ensure reliability, security, and integrity of production and non-production databases, and guide standards and recovery readiness.

The role involves optimizing performance, managing backups, and collaborating with architecture, security, and engineering teams. Remote work is available, with occasional travel for meetings as needed.

Qualifications

• Bachelor’s degree in a computer-related field plus 5+ years of related experience.
• Hands-on PostgreSQL administration incl. install/patch.
• PostgreSQL performance tuning and index strategy.
• Experience with AWS RDS/Aurora for PostgreSQL.
• Strong SQL development for OLTP/analytics.
• English communication skills.
• Experience with AWS Lake Formation and data lake deployment.
• PostgreSQL or Oracle certification preferred.

Responsibilities

• Oversees daily operations of production and non-production database environments.
• Formulates and maintains database policies, procedures, and standards, and monitors activity.
• Reviews database designs and system integrations and recommends enhancements.
• Develops, manages, and tests backup and recovery plans.
• Maintains database security and integrity controls; manages patching and upgrades.
• Optimizes PostgreSQL performance via tuning and indexing.
• Administers Amazon RDS and Amazon Aurora for PostgreSQL; supports migrations with AWS DMS and Glue.
• Monitors performance, resources, availability, and health; takes corrective action.
• Collaborates with architecture, engineering, security, and other stakeholders.

Skills

PostgreSQL

AWS RDS/Aurora

SQL Development

Performance Tuning

Backup & Recovery

Data Migration

Education

Bachelor’s degree in CS/IT

Tools

AWS Glue

AWS Lake Formation

Amazon Redshift

PostgreSQL Tools

Job description

USC onlyNeed LinkedIn with picture- DL copy100% remote

Job Description

Overview

The Database Administrator oversees the design, implementation, operation, security, and integrity of production, non-production, and redundant database environments across cloud and on-premises implementations. This role will maintain reliable database services, guide database standards and strategy, support backup and recovery readiness, and advise technical and organizational leaders on database capabilities and improvements.

Actual pay will be determined based upon a candidate’s job-related knowledge, skills, education, experience, geographic location, and may include other job-related factors such as certification(s), professional licensure, or internal equity considerations.

Responsibilities

• Oversees daily operations of production, non-production, and redundant database environments across internal and customer environments.
• Formulates and maintain database management policies, procedures, and standards, and monitor transaction activity and database utilization.
• Reviews database designs and system integrations and recommend enhancements or improvements.
• Develops, manages, and tests backup and recovery plans to confirm that procedures function properly.
• Maintains database security and integrity controls.
  Installs, configures, upgrades, patches, monitors, and troubleshoots PostgreSQL database environments.
• Optimizes PostgreSQL performance through query optimization, index strategy, vacuum and analyze tuning, and database parameter configuration.
• Administers Amazon RDS and Amazon Aurora for PostgreSQL and supports database migration and data integration activities using AWS Database Migration Service and AWS Glue.
• Monitors database performance, resource utilization, availability, and operational health, and take appropriate corrective action.
• Collaborates effectively with architecture, engineering, security, and other stakeholders while organizing work for timely completion.

Qualifications

• Bachelor’s degree in a computer-related field from an accredited college or university and five or more years of related experience, or an equivalent combination of education, certification, training, and experience.
• Hands‑on experience with PostgreSQL database administration, including installation, configuration, upgrades, and patching.
• Strong expertise in PostgreSQL performance tuning, including query optimization, index strategy, vacuum and analyze tuning, and parameter configuration.
• Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability.
• Experience administering Amazon RDS and Amazon Aurora for PostgreSQL.
• Strong SQL development skills across online transaction processing and analytical data platforms.
• Ability to communicate effectively in English, both orally and in writing, and to follow complex oral and written instructions.
• Ability to organize work for timely completion and maintain effective, cooperative working relationships.
• Experience with AWS Lake Formation and data lake deployment and administration.
• General understanding of Amazon Redshift architecture and service model, including role-based access control, user and group management, and security permissions.
• Experience with AWS Glue and AWS Database Migration Service.
• Database certification in PostgreSQL or Oracle preferred.

Working Conditions:

• Flexible work hours in a fun collaborative environment
• Must have reliable internet connection at all times
• Must have the ability to travel, as needed for company meetings

$000,000 – $000,000 Salary range is not shown on the candidate portal