Oracle PostgreSQL DBA (100% REMOTE/NO C2C)

Amerit Consulting - Las Vegas, NV

Full-time - Mid Level

Onsite - Las Vegas, NV

1,001-5,000 employees

Administrative and Support Services

About the position

The Oracle PostgreSQL DBA position is a remote role focused on the maintenance and administration of PostgreSQL databases for a leading healthcare organization. The role involves supporting development teams, ensuring optimal database performance, and managing database architecture and integrity. The DBA will also conduct code reviews, performance tuning, and collaborate on database systems planning to meet long-term operational requirements.

Responsibilities

• Maintain production, test, and development databases.
• Support development teams from a database design and development perspective.
• Ensure optimal performance on PostgreSQL environments.
• Install, maintain, configure, and ensure the integrity of PostgreSQL architecture.
• Tune performance of SQL queries.
• Provide support to application developers, including data refresh and performance tuning.
• Conduct code reviews with application developers.
• Include long-term requirements of systems operations in database systems planning.
• Design, implement, and maintain new databases, backup/recovery, and configuration management.

Requirements

• Bachelor's degree in a relevant field.
• 5+ years of experience as a Postgres DBA/developer for complex and high-volume data warehouse projects.
• AWS certification.
• Strong PL/PGSQL or PL/SQL experience.
• Experience in PostgreSQL and AWS RDS Aurora PostgreSQL.
• Hands-on experience with PostgreSQL database administration and performance tuning in high-volume environments.
• Data modeling experience.
• Understanding of JAVA.
• Experience working in Agile/Scrum programs with multi-disciplinary teams.
• Excellent written, verbal, and interpersonal communication skills.
• Strong attention to detail and task completion.

Nice-to-haves

• Experience with health IT systems and Electronic Data Interface (EDI) processing.
• Experience with 270/271 transactions and/or other X12 data formats.
• Experience with healthcare data, specifically Medicare/Medicaid.

Benefits

• Remote work flexibility
• Opportunity for extension beyond initial contract
• Work with a leading healthcare organization
• Engagement in complex and high-volume projects