Job Description :
PostgreSQL DBA
Location: Remote
In depth knowledge of the EDB PostgreSQL DB architecture.
Implement best practices on PostgreSQL Databases and Servers
Implement/Support Log Shipping
Implement/Support Failover Solutions
Implement/Support Replication
Participate in migrations for customers
Participate in upgrades
Ensure that customers are have appropriate maintenance in place including backups, index maintenance, and routine vacuuming
Performance tuning
Administrated PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles
Experience in testing database security and enterprise policy guidelines according to established best practices.
Monitored and maintained the backups for database recoverability for all production databases.
Define file organization, indexing methods, and security procedures for specific user applications.
Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
Design and develop logical and physical database designs from application requirements.
Design and implement automation using scripts and database functions.
Design and implement replication and backups for mission critical/tier-1 applications.
Design and implement automation using scripts, must be proficient in scripting.
Resumes to
CST provides its clients with complete, cost-effective, end-to-end personnel solutions across a range of industrial domains. CST''s mission is to empower businesses around the world to make better, faster operational decisions.