Postgres DBA

Responsibilities:Install and configure PostgreSQL database servers on-premises.Optimize database configuration settings for performance and reliability.Identify bottlenecks and implement performance tuning measures.Use tools and scripts to analyze query performance and recommend optimizations.Develop and implement backup and recovery strategies to ensure data integrity and availability.Regularly review and update security policies and protocols.Plan and execute database migrations and upgrades with minimal downtime.Collaborate with developers and application teams to design efficient database schemas.Ensure normalization and indexing strategies are applied for optimal data retrieval.Diagnose and resolve database-related issues and errors.Provide support to application developers in optimizing database interactions.Document changes made to the database environment and maintain an inventory of databases.Recommending hardware upgrades or changes as necessary.Ensure databases comply with relevant regulations and standards (e.g., GDPR, HIPAA). Requirements:At least 10years of expereince in IT industry.7+ years of experience as a DBA utilizing PostgresMonitor database performance and resource usage.Communicate effectively with stakeholders regarding database status, issues, and plans.Capable of Installing and configuring PostgreSQL database servers on-premises.Proficient in developing scripts for automation of routine DBA tasks (e.g., backups, monitoring).Proficient with UNIX/Linux and shell scriptsShould be able to maintain detailed documentation of database configurations, procedures, and policies.Work closely with development, network, and security teams to ensure database systems align with overall IT strategy.Good in Oracle replication, AWS Redshift, Elasticache, Cassandra (NoSQL), CI/CD – XLR, Jenkins, GIT, Support – ITSM and observability - Dynatrace, Splunk