Job Description:

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.The experience expected from applicants, as well as additional skills and qualifications needed for this job are listed below.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.