PostgreSQL DBA

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

Bachelor’s degree
5+ years of experience as a Postgres DBA / developer for complex and high-volume data warehouse projects
Candidate must have 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