What are the responsibilities and job description for the PostgreSQL DBA position at Zora Corp?
Experience supporting PostgreSQL 7.x – 10.x database support and administration with large high-volume transaction databases.
Working knowledge of various other RDBMS such as MySQL and Oracle.
Experienced in relational database design, normalization, and transaction control.
ETL and some data warehouse design experience, especially with Greenplum.
Excellent SQL skills including query optimization, complex nested and co-related subqueries, common table expressions, window functions, and business analytical reporting.
Confident with Linux system administration and networking.
Full ownership of 24/7 enterprise database servers running on Linux or AWS Linux.
Some experience with Cloud Computing environment e.g. AWS RDS and Aurora migrations and optimization.
Able to identify, tune, and monitor table and index bloat, index maintenance, and transaction wraparound issues using personally developed monitoring queries or pg_repack, and pgstattuple.
Extensive experience with managing table locking problems in a high transaction production database.
Experienced in back end support coordinated with development teams, throughout the full life-cycle of product development from design through QA, release, and maintenance.
Familiarity with Agile DevOps and source code version control with Git.
Familiarity with various replication architectures (PITR, log shipping, log streaming, hot standby)automation using either shell scripts or 2nd Quadrant’s repmgr utility.
Knowledge of old-school logical replication methods (Slony and Londiste), PostgreSQL troubleshooting, and system management (full automation of backup, replication and cloning), including basic Linux system administration.
Job Types: Full-time, Part-time, Contract
Pay: $31,810.00 - $178,351.00 per year
Schedule:
- 8 hour shift
Ability to commute/relocate:
- Greenbelt, MD: Reliably commute or planning to relocate before starting work (Preferred)
Experience:
- MySQL: 3 years (Preferred)
- Database administration: 5 years (Preferred)
- PostgreSQL: 3 years (Required)
Work Location: One location