Business Analyst

As a skilled PostgreSQL Database Administrator with over 5 years of experience, you will be responsible for managing, optimizing, and maintaining PostgreSQL environments to ensure scalability, security, and reliability of mission-critical systems. You will work closely with developers and DevOps teams to implement best practices and enhance database performance. - Design, configure, and maintain highly available PostgreSQL environments including replication, partitioning, and clustering. - Define standards, procedures, and best practices for PostgreSQL administration. - Perform query tuning, indexing, and troubleshoot performance issues. - Plan capacity and ensure database scalability for large datasets. - Handle installation, upgrades, patching, and configuration management. - Implement reliable backup/recovery processes and disaster recovery readiness. - Manage database security, access control, and compliance. - Implement monitoring tools, alerts, and dashboards for proactive database management. - Automate routine DBA tasks using Bash/Python/Ansible scripts. - Collaborate with developers to optimize queries and schemas. - Participate in on-call support, incident response, and RCA (Root Cause Analysis). - Support database deployments in CI/CD pipelines. Qualifications Required: - 5+ years of experience in PostgreSQL database administration. - Strong expertise in performance tuning, query optimization, and indexing. - Hands-on experience with replication, partitioning, HA solutions (Patroni, Pgpool-II, repmgr). - Proficiency in Linux/Unix environments, SQL, PL/pgSQL, and scripting (Bash/Python). - Solid understanding of backup/recovery strategies and disaster recovery. - Knowledge of database security and compliance practices. It is beneficial to have experience with AWS RDS/Aurora, Azure, or GCP Cloud SQL, containerized PostgreSQL (Docker/Kubernetes), NoSQL databases (MongoDB, Redis), and understanding of CI/CD, DevOps, and IaC (Terraform/Ansible).,