Experience

▪ Total 12+ years of experience in IT infrastructure management services

▪ Total 8+ years of relevant experience in postgre database architecture, including setup, installation,

and maintenance.

▪ Proficiency in PostgreSQL database management and administration.

▪ Strong knowledge of SQL and PL/pgSQL.

▪ Experience with database design, performance tuning, and optimization.

▪ Familiarity with database security best practices.

▪ Experience with database migration and upgrade processes.

▪ Knowledge of backup and recovery techniques.

▪ Strong experience with postgre database, and other databases.

▪ Strong background in Linux system administration.

▪ Experience with Infrastructure-as-Code (IaC) tools such as Terraform and Ansible.

▪ Excellent troubleshooting and problem-solving skills.

▪ Hands-on experience with ITSM tools and processes.

▪ Experience in working in infra projects with BFSI customers.

▪ Experience of global delivery with offshore/ onsite model.

▪ Experience working in agile and DevOps-driven environments.

▪ Familiarity with cloud infrastructure and containerization technologies like Docker and Kubernetes.

Mandatory Skills

▪ Proficiency in PostgreSQL database management and administration.

▪ Strong proficiency in

o EDB Postgres Advance Database Server

▪ Streaming Replication (Sync)

o EDB EFM (Fail over Manager): HA solution for Auto failover

o Security

▪ TDE, Including TDE Master Key rotation.

▪ SSL configuration

▪ Password verification function, row level access and DB Audits

▪ DB logical backup: pg_dump

▪ DB Physical backups and point in time recovery: pg_base backup

▪ DB Maintains Activities

o VACCUM, VACCUM FULL, Freeze and Analise

▪ Performance / SQL Tunning

▪ Locking, Blocking, Deadlocks, Long running queries, Explain Plan, Query tuning ...etc

▪ Table partitioning

▪ Good to have experience in migration of RDBMS from Oracle, MySQL to EDB Postgres and

knowledge on PEM (Postgres Enterprise Manager).

▪ DB connection polling

▪ Strong knowledge of SQL and PL/pgSQL.

▪ Deep knowledge of PostgreSQL database architecture, internals, and features.

▪ Hands-on experience with tools like pgAdmin, pgBouncer, and PostGIS.

▪ Proficiency in SQL and PL/pgSQL programming.

▪ Familiarity with NoSQL and cloud-based databases (e.g., Amazon RDS, Azure Database for

PostgreSQL) is a plus.

▪ Strong skills in Bash, Python, or similar scripting languages.

▪ Experience with configuration management tools like Ansible or Terraform.

▪ Ability to identify and resolve complex database-related issues quickly and effectively.

▪ Experience with database design, performance tuning, and optimization.

▪ Familiarity with database security best practices.

▪ Experience with database migration and upgrade processes.

▪ Knowledge of backup and recovery techniques.

▪ Strong experience with postgre database, and other databases.

▪ Design, implement, and maintain PostgreSQL databases to meet application and business

requirements.

▪ Perform database installation, configuration, and upgrades.

▪ Monitor database health, optimize performance, and troubleshoot issues.

▪ Optimize database performance through indexing, query optimization, and schema design.

▪ Conduct capacity planning to ensure database scalability.

▪ Develop and maintain backup and disaster recovery strategies.

▪ Perform regular backup tests to ensure data integrity and availability.

▪ Implement database security measures, including access controls and encryption.

▪ Ensure compliance with data protection regulations and standards.

▪ Develop automation scripts for routine database tasks using tools like Bash, Python, or Ansible.

▪ Manage database patching and upgrades seamlessly.

▪ Set up and maintain replication (logical/streaming replication) and high-availability solutions.

▪ Implement clustering and failover strategies.

▪ Work closely with application development teams to design database solutions.

▪ Provide technical expertise for database-related aspects of development and deployment.

▪ Use monitoring tools (e.g., pgAdmin, Nagios, or custom scripts) to track database performance.

▪ Generate regular reports on database health, growth, and performance.

▪ Excellent troubleshooting and problem-solving skills.

▪ Hands-on experience with ITSM tools and processes.

▪ Experience in working in infra projects with BFSI customers.

▪ Experience of global delivery with offshore/ onsite model.

Mandatory Soft Skills

▪ Excellent communication and interpersonal skills both written and oral.

▪ Client relationship management

▪ Experience of implementing medium to large scale containers and application projects.

▪ Ability to work hands on tools and processes.

▪ Ability to understand the infrastructure technical components.

▪ Willing to work 24x7 project timelines including visit to data center.

▪ Strong communication and collaboration skills.

▪ Excellent documentation and reporting abilities.

Qualification

▪ Must have bachelor's or master's degree in IT/ engineering or equivalent qualification.

▪ Must be EnterpriseDB Certified Postgres Professional (ECPP)

▪ Must be Certified PostgreSQL DBA (CPSDBA)

▪ Good have ITIL certification.

▪ Must be trained in ITSM tools, process, remedy, service now, jira, confluence, sharepoint.

▪ AWS Certified Database - Specialty