Job Description
Everforth ECS is seeking a Database Administrator 2 to work Remotely.
The Database Administrator 2 with strong PostgreSQL and ETL expertise to support mission-critical database operations in a secure enterprise environment. This role will focus heavily on PostgreSQL administration, performance tuning, scripting, data movement, and ETL support, while also requiring working knowledge of Oracle database administration and cloud-based database platforms.
The ideal candidate brings hands-on experience managing PostgreSQL environments, supporting ETL workflows, optimizing database performance, and maintaining secure, reliable data systems across on-prem and cloud-hosted infrastructure.
Key Responsibilities
- Administer, maintain, and support PostgreSQL database environments, including installation, configuration, patching, upgrades, backup, recovery, and performance tuning
- Support ETL processes and data integration workflows, ensuring reliable movement, transformation, and validation of data across multiple systems
- Develop, maintain, and troubleshoot PostgreSQL scripts, stored procedures, and database objects using PL/pgSQL
- Manage PostgreSQL schemas, user roles, permissions, access controls, and security models
- Perform database performance analysis and tuning using explain plans, monitoring tools, query optimization, indexing strategies, and normalization techniques
- Support backup and recovery operations using tools such as pg_dump, pg_basebackup, and point-in-time recovery (PITR)
- Work closely with application, ETL, and infrastructure teams to support data pipelines, database interfaces, and external system integrations
- Provide database administration support for Oracle environments, including configuration, upgrades, backup and recovery, and performance troubleshooting
- Support Oracle 19c/21c environments, including experience with Data Guard, RMAN, cloning, resource management, and OEM Grid administration
- Maintain and support databases across multiple operating systems, including Linux, RHEL, and Windows
- Support cloud-based infrastructure and databases in AWS, including CloudWatch, CloudTrail, EC2, Oracle, Aurora, and PostgreSQL RDS
- Create and maintain shell scripts to automate recurring database administration, ETL support, and daily monitoring activities
- Assist with database and system patching, software upgrades, performance tuning, and maintenance of COTS products and operating systems
Salary Range: $110,000- $122,000
