Postgre Database Consultant

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
- EDB Postgres Advance Database Server
- Streaming Replication (Sync)
- EDB EFM (Fail over Manager): HA solution for Auto failover
- 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
- 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.

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.
- 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
- 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 Cer