<ul> <li>Extensive hands-on experience with PostgreSQL (v11 and above). </li><li>Database installation, configuration, and upgrades on Linux/Unix platforms. </li><li>High Availability (HA) setup using streaming replication, Patroni, repmgr, etc. </li><li>Backup and recovery strategies using tools like pgBackRest, Barman. </li><li>Performance tuning and query optimization. </li><li>Strong knowledge of PL/pgSQL scripting and automation. </li><li>Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana). </li><li>Security hardening and compliance (role-based access control, SSL, encryption at rest/in-transit). </li><li>Disaster Recovery planning and execution. </li><li>Capacity planning and data growth forecasting. </li><li>Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL). </li><li>Good communication skills with both technical and management teams. </li></ul> <p>Good-to-Have:</p> <ul> <li>Experience with other databases (Oracle, MySQL, or NoSQL like MongoDB). </li><li>Experience with Kubernetes & PostgreSQL operators (e.g., Zalando, Crunchy). </li><li>Knowledge of Infrastructure as Code (Terraform, Ansible). </li><li>Experience with CI/CD pipelines for database changes </li><li>Experience with Databases (Oracle, DB2 & SQL server). </li><li>Exposure to PostgreSQL clustering and sharding. </li><li>Understanding of logical replication and change data capture (CDC). </li><li>Knowledge of network monitoring and tools </li><li>Excellent stakeholder management and cross-functional collaboration </li><li>Certifications (Optional but Preferred): AWS Certified Database - Specialty </li></ul> <p>Expectations from the Role :</p> <ul> <li>Database Architecture & Design: Design and maintain complex PostgreSQL database schemas. </li><li>Performance Tuning & Optimization: Advanced query tuning and index optimization. Analyze and resolve slow queries using EXPLAIN, ANALYZE, and pg_stat views. </li><li>Backup and Recovery: Implement and manage high-availability backup strategies. Test and document disaster recovery procedures. </li><li>Replication and High Availability: Set up and maintain replication (physical/logical). Experience with HA tools like Patroni, repmgr, or Pgpool-II. </li><li>Security Management: Implement role-based access controls, SSL/TLS, and audit logging. Monitor for vulnerabilities and apply patches. </li><li>Monitoring & Maintenance: Perform routine health checks and maintenance tasks (VACUUM, REINDEX, ANALYZE). </li><li>Upgrades & Migrations: Plan and execute PostgreSQL version upgrades with minimal downtime. Experience migrating from on-prem to cloud (AWS RDS/Aurora, Azure Database for PostgreSQL, or GCP). </li></ul> <p>TCS Employee Benefits Summary:</p> <ul> <li>Disc retionary Annual Incentive. </li><li>Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. </li><li>Family Support: Ma ternal & Parental Leaves. </li><li>Insurance Options: Auto & Home Insurance, Identity Theft Protection. </li><li>Convenience & Professional Growth: Commute r Benefits & Certification & Training Reimbursement. </li><li>Time Off: Vacation, Time Off, Sick Leave & Holidays. </li><li>Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. </li></ul> <p># LI-RJ2</p> <p>Salary Range - $90,000-$120,000 a year</p>