PostgreSQL DBA

**Hello Connections,**

**Position:** PostgreSQL DBA

Rate: $50/hr on C2C
**Location:** Anywhere from a US Infosys Office onsite / Canada Infosys Office
**Experience:** 10+ Years

**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 promptly and efficiently.
– Manage user accounts, roles, and permissions, ensuring compliance with security policies.

**Performance Tuning and Optimization:**
– Analyze database performance metrics and identify areas for improvement.
– 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 for data 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.
– Manage clustering configurations.

hashtag#JobOpening hashtag#PostgreSQL hashtag#DBA hashtag#DatabaseAdministrator hashtag#DatabaseJobs hashtag#ITJobs hashtag#TechCareers hashtag#DataManagement hashtag#JobSearch hashtag#NowHiring hashtag#CareerOpportunity hashtag#WorkFromAnywhere hashtag#Infosys hashtag#DatabaseAdministration hashtag#SQL hashtag#TechJobs hashtag#JobAlert hashtag#OnsiteJobs hashtag#Hiring hashtag#InformationTechnology

**To apply, please send your resume to suraj.v@wiselinkglobal.com.**