Database Administrator - PostgreSQL (Insourcing For UK based Company)

Job Description

CTC Budget is 36 LPA- 42 LPA Responsiblities: • Hands-on maintenance of PostgreSQL databases, ensuring uptime, reliability, and performance. • Design and implement procedures for backup, failover, and recovery to deliver data integrity and business continuity. Provide hands-on database expertise to development teams, advising on schema design, indexing, and query optimization. • Proactively monitor database health and performance; identify and resolve issues before they impact production. Collaborate with internal teams and service providers (AWS, Enterprise DB etc.) in the resolution of issues Work closely with DevOps and Engineering to integrate safe database change processes into delivery pipelines Establish and document database standards, policies, and best practices. Contribute to the broader data architecture strategy as the organization scales and evolves. Recommend and implement best practices for data security, compliance, and scalability. Define, agree and maintain improvement roadmap for the database estate. Knowledge and skills required: Proven experience required 6+ years of hands-on experience working with PostgreSQL in complex, production environments. Demonstrable expertise in hands-on operations, managing the ongoing hygiene of a postgreSQL estate including backup, point-in-time recovery, replication and failover ideally with Barman and a PG load balancer. Deep technical knowledge of PostgreSQL internals with experience in query optimization, indexing strategies, and performance tuning of DB instance and host parameters. Experience working with cloud-based and/or containerized infrastructure Proficient in scripting (e.g., Bash, Python) to automate database operations and maintenance tasks. Solid understanding of Linux system administration as it relates to database performance and configuration. Demonstrates the drive and ability to independently identify required work, negotiate priorities and efficiently deliver on agreed objectives. Strong communication skills, with the ability to explain database concepts and trade-offs to both technical and non technical stakeholders. Desirable: • Exposure to other database technologies (e.g., MySQL, MongoDB, Redis). • Experience with observability and monitoring tools (e.g., Prometheus, Grafana, pg_stat_statements). • Experience with infrastructure-as-code techniques (e.g. Terraform, Ansilble)