5.0 - 9.0 years

0 Lacs

vadodara, gujarat

On-site

As a skilled and detail-oriented PostgreSQL Database Administrator at PMC India Office in Vadodara, you will be supervised by the Database Service Manager. Your primary responsibility will involve the administration and support of enterprise-level, business-critical PostgreSQL environments. Your role will require a strong foundation in PostgreSQL architecture, performance tuning, high availability configurations, and data security. You will be responsible for managing routine and project-based database tasks, providing Root Cause Analysis (RCA) for incidents, and ensuring optimal performance of databases supporting various applications. Your key accountabilities will include providing incident resolution for PostgreSQL environments to ensure application availability and performance, leading and managing incidents within the PMC resolver group while maintaining SLA compliance, and performing regular DBA responsibilities such as database maintenance, housekeeping, and vacuuming. Additionally, you will be responsible for implementing proactive monitoring, managing backup and Disaster Recovery (DR) processes, tuning OS and PostgreSQL configurations, supporting developers across different environments, and participating in a rotational 24/7 out-of-hours (OOH) support schedule. Your skills and experience should include strong hands-on experience as a PostgreSQL DBA in a high-availability, high-throughput environment, expertise in PostgreSQL configuration, performance tuning, replication, backup/restore, and disaster recovery, familiarity with PostgreSQL on Linux systems, and experience with monitoring and logging tools such as pgBadger, Prometheus, Grafana, and ELK stack. Furthermore, you should have a good understanding of cloud platforms like AWS, Azure, or GCP, proficiency with PostgreSQL extensions like PostGIS, TimescaleDB, knowledge of connection pooling tools like PgBouncer or Pgpool-II, and experience in a 24/7 production support environment. A Bachelor's degree in Computer Science or an equivalent technical discipline is essential. Desirable skills and experience may include experience in full lifecycle PostgreSQL project implementations, familiarity with CI/CD pipelines for database deployment, experience with NoSQL and cloud-native databases, working knowledge of version control systems and DevOps practices, ITIL certification or equivalent understanding of IT service management, and exposure to other RDBMS and data migration tools. In this role, you will provide technical leadership in PostgreSQL database architecture and future strategy, ensure adherence to PMC and client-specific information security policies, and undertake additional responsibilities as required.,

Posted 1 day ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.