Oracle PostgreSQL DBA (100% REMOTE/NO C2C)

Amerit Consulting - Irvine, CA

Full-time - Mid Level

Onsite - Irvine, CA

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 provide support for application developers, contributing to the overall database systems planning.

Responsibilities

• Responsible for the maintenance of production, test, and development databases.
• Support development team from a database design and development perspective.
• Ensure optimal performance on PostgreSQL environments.
• Installation, maintenance, configuration, and integrity of PostgreSQL architecture.
• Performance tuning of queries.
• Provide support to application developers, including data refresh and SQL 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
• 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 is a plus.
• Experience in PostgreSQL, AWS RDS Aurora PostgreSQL.
• Hands-on experience with PostgreSQL database administration, performance tuning, and production support in a high-volume environment.
• Data modeling experience
• Some understanding of JAVA
• Experience working in Agile/Scrum programs with multi-disciplinary development teams.
• Excellent written, verbal, and interpersonal communication skills.
• Strong attention to detail and focus on task completion.

Nice-to-haves

• Experience with health IT systems with 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 opportunity
• Possibility of extension beyond initial contract
• Opportunity to work with a Fortune 50 organization