As a Database Administrator (PostgreSQL), you will leverage your data design and development expertise as part of a developing AWS database team. You will maintain the physical data model, queries, and service interface for the loading, querying, and maintenance of data in a Postgres database and other data sources. You will also coordinate data management tasks in support of data quality efforts, tune queries for optimal performance, and develop DDL and DML scripts for Postgres. As a member of our AWS database team, you will be involved in all aspects of the solution involving the backend database. We will rely on your leadership and innovative problem solving skills using a variety of Open Source and enterprise level technologies.

Responsibilities:

• Individual contributor performing data design, modeling, coding and day to day maintenance
• Develop data migration strategies to support a cloud/on premise database environment.
• Work with subject matter experts to locate and understand the data then analyze and implement business requirements within time and cost restraints
• Build database scripts to support ETL, DDL, OLTP, Data Warehouse, and CrUD operations
• Participate in design and code reviews
• Define, develop, document, communicate and implement standards, processes and procedures for the department
• Identify issues and escalate risks to project leadership, if necessary
• Production systems support and on-call duties are also required in this role

Qualifications:

Required

• 2+ years Postgres DBA hands on experience
• Strong understanding of Postgres configuration including vacuuming, user/role permissions and partitioning
• Strong understanding of SQL tuning and optimization of query plans
• Proven knowledge and experience in designing database schemas to align with development and business goals and objectives
• Strong and proactive leadership ability
• Strong communication skills with the ability to transcend the organization with appropriate levels of detail
• Strong teamwork, decision-making, documentation and analytical skills
• Must be committed to incorporating security into all decisions and daily job responsibilities

Required Skills : • AWS knowledge - not a beginner and does not need expert. Other cloud knowledges will work • Postgre - DBA • Understanding SQL, fine toon, optimize, what is causing issues/troubleshooting, how to resolve, etc. - typical DBA
Basic Qualification :
Additional Skills :
Background Check :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Migration
Master Job Title :DBA: Other
Branch Code :St. Louis