Database Administrator

Responsibilities

• Responsible for the maintenance of production, test and development databases.

• Brings solid understanding of database administration.

• Supports development team from a database design and development perspective.

• Responsible for database administration or engineering activities, ensure optimal performance on PostgreSQL environments.

• Responsible for the installation, maintenance, configuration, and integrity of PostgreSQL architecture.

• Performance tuning of the queries.

• Provide support to the application developers, including, but not limited to data refresh, SQL and PL/pgSQL performance tuning and best practice recommendations.

• Conduct code reviews with application developers.

• Ensure the long-term requirements of systems operations and administration are included in the overall database systems planning of the organization.

• Perform many related database functions across one or more teams, including designing, implementing, and maintaining new databases, backup/recovery and configuration management.

Required Qualifications

• Bachelor’s degree

• 3+ years of experience as a DBA / developer for complex and high-volume data warehouse projects.

• AWS certification

• Strong PL/PGSQL or PL/SQL experience is a plus.

• Experience in PostgresSQL, AWS RDS Aurora PostgreSQL.

• Hands-on experience with Postgres database administration, performance tuning and production support in a high volume, customer-facing apps/environment.

• Data modeling experience

• Experience working in Agile/ Scrum programs with multi-disciplinary development teams

• Excellent written, verbal, and interpersonal communication skills

• Manages time extremely well, can quickly sense when issues need to be addressed

• Strong attention to detail and focus on task completion.

• ***Able to obtain a U.S. Federal Position of Trust clearance designation. ***

Preferred Qualifications

• 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

• 5+ years of experience as a DBA / developer for complex and high-volume data warehouse projects.