PostgreSQL Database Administrator

Hello,

Hope you are doing good,

Position: Database Administrator II

Location: Remote

Duration: Contract to Hire opportunity

Job Description:

• 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.

• 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

• 5-7+ years of experience as a DBA / developer for complex and high-volume data warehouse projects.?
• Must have AWS certification
• 3+ Years - Strong PL/PGSQL or PL/SQL experience is a plus.
• 3+ Years - Experience in Postgres SQL, AWS RDS Aurora PostgreSQL.
• 3+ Years - Hands-on experience with Postgres database administration, performance tuning and production support in a high volume, customer-facing apps/environment.

• 2+ Years - Data modeling experience
• 2+ years - 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.
• Must be able to perform code reviews in Java.
• Must have Agile/ SAFe experience and be able to talk to it with real examples. Will be highly scrutinized by Prime Partner.

Preferred Qualifications

• 2+ Years - Experience with health IT systems with Electronic Data Interface (EDI) processing
• 2-3+ Years - Experience with 270/271 transactions and/or other X12 data formats

• (Big Plus) Experience with healthcare data, specifically Medicare/Medicaid
• Prime Softrams is BIG on SAFe certifications since they will be doing 2-3 week Sprints.