Overview
Skills
Job Details
Position: Postgre SQL DBA
Location: Multiple Locations Onsite (USA/Canada)
Duration: Long term Contract
Job Description:
Database Administration and Maintenance:
Install, configure, and maintain PostgreSQL database servers and clusters.
Perform regular database maintenance tasks, including backups, restores, vacuuming, and reindexing.
Monitor database performance and resource utilization, identifying and resolving bottlenecks.
Apply database patches and upgrades in a timely and efficient manner.
Manage user accounts, roles, and permissions, ensuring adherence to security policies.
Performance Tuning and Optimization:
Analyze database performance metrics and identify areas for optimization.
Implement query optimization techniques, including indexing, query rewriting, and partitioning.
Configure and manage connection pooling and other performance-related parameters.
Conduct performance testing and benchmarking to ensure optimal database performance.
Security and Compliance:
Implement and enforce database security policies and procedures.
Manage database encryption at rest and in transit.
Conduct regular security audits and vulnerability assessments.
Ensure compliance with relevant data privacy regulations and internal policies.
Implement and manage database auditing and logging.
Backup and Recovery:
Develop, implement, and test comprehensive database backup and recovery strategies.
Ensure the availability and recoverability of critical data in case of failures.
Perform regular disaster recovery drills.
Database Design and Implementation:
Participate in the design and implementation of new database schemas and objects.
Collaborate with developers and application teams to ensure efficient and scalable database designs.
Develop and maintain database documentation, including schema diagrams, data dictionaries, and operational procedures.
Capacity Planning:
Monitor database growth and plan for future capacity needs.
Provide recommendations for hardware and software upgrades.
Clustering