PostgreSQL DBA (100% REMOTE/NO C2C)

Our client, a US Fortune 50 organization and a leading provider of Health care and Health Insurance services, seeks an accomplished PostgreSQL DBA.

NOTE: THIS IS 100% REMOTE ROLE & ONLY W2 CANDIDATES (NO C2C/1099).

Candidate must be authorized to work in USA without requiring sponsorship.

Position: PostgreSQL DBA (Job ID: WLPTJP00047086)

Location: Baltimore MD (100% REMOTE)

Duration: 12 Months + Strong Possibility of Extension

• Responsible for developing detailed logical data designs and metadata content. Works on more complex database design, development and support activities. Primary duties may include but are not limited to: Creates and populates metadata and plans and participates in unit testing for data validation.
• Evaluates test results for fulfillment of all data requirements. Develop conceptual or general designs, including logical design of databases, access methods, metadata presentation, etc. Details of all aspects of functional designs, including record layouts, pseudo-code, detailed data mapping, etc. Productionalizes data-related project components and institute all required changes.
• Provides ongoing support of business, including ongoing data analysis, data quality testing, enhancement of metadata, etc.
• Reviews SQL code and provides turning suggestions. Provides DBMS technical configuration and troubleshooting. Provides user management and DBMS security support. 24x7 production and non-production DBA on-call support.

Database Administrator:

Seeking a Senior Database Administrator/Data Modeler with expertise in PostgreSQL, Athena, and Redshift on Linux and Windows platforms. The role includes data modeling and the administration of production, test, and development databases. This position is part of a collaborative, agile team supporting modern, standards based web applications for mission critical health IT solutions.

Roles and Responsibilities:

• Maintain production, test, and development databases in the cloud
• Provide strong cloud based database administration and support
• Support database design, development, user administration, and deployment activities
• Perform database administration and engineering tasks to ensure optimal performance of PostgreSQL, Athena, Redshift, and related environments
• Install, configure, maintain, and ensure integrity of PostgreSQL, Athena, and Redshift clusters
• Incorporate long term operational and administrative requirements into database planning
• Design, implement, and maintain databases; manage backups, recovery, and configuration
• Optimize database configurations for performance, backup, and recovery; assist with SQL review and tuning
• Support high severity and production issues during weekends/off hours as needed
• Create logical and physical data models using approved tools and established standards
• Train team members in SQL and related tools
• Implement proactive monitoring of cloud database usage and support cost optimization

Required Qualifications:

• Requires an BA/BS degree in Information Technology, Computer Science or related field of study and a minimum of 3 years of information systems experience; or any combination of education and experience, which would provide an equivalent background. Experience in utilizing DBMS system management tools and the ability to implement new DBMS features and functionality strongly preferred.
• Experience with AWS RDS PostgreSQL, Athena, and Redshift
• Experience working on complex, high volume mission critical systems
• Hands on administration, performance tuning, and production support of PostgreSQL, Athena, Redshift, and other RDBMS platforms in high volume, customer facing environments
• Experience in Agile/Scrum environments
• Strong written, verbal, and interpersonal communication skills
• Ability to work in a dynamic team environment and manage priorities
• Ability to identify potential issues and escalate critical items promptly
• Strong attention to detail and commitment to task completion

Preferred Experience:

• Bachelor’s degree with at least 8 years of experience developing systems and applications for Federal clients.
• 7+ years of data modeling and database administration experience
• 4+ years with AWS RDS PostgreSQL on Linux/Unix
• 6+ years administering relational databases in the cloud
• 4+ years consulting with senior business SMEs to gather requirements
• 4+ years data modeling with ERWin or similar tools
• AWS certification and SAFe experience
• SQL development experience in Java
• SQL development experience in Python
• Dimensional modeling
• SQL Server experience
• Experience working on multi-disciplinary development teams