Job Description

Designation:-Principal DBA ConsultantSalary:-Hike on CtcExperience:-15 Years exp minGender:- AnyLocation:- Chandigarh and PAN India
Duties/Responsibilities:
Responsible for understanding operational requirements including hardware,
architecting, configuring, integrating, and maintaining mission-critical Production
PostgreSQL databases.
Responsible for all PostgreSQL backup, recovery, PITR replication.
Experience on community-supported tools like Pgbadger, PGadmin, Pgpool, Pgbouncer.
Clusters and upgrading/migrating various PostgreSQL database version on various
platform including Cloud and On-premises.
Database administration and tuning of PostgreSQL databases on Open
source/enterprise platform like EDB.
Cluster and database automation using Ansible, terraform or equivalent tools.
Provide technical guidance for planning, design, development, integration, and testing
of PostgreSQL production systems/databases.
Support several Open-Source technologies including PostgreSQL, MySQL, or MongoDB.
Install, configure, upgrade and patching for Postgres and other open-source databases.
Contribute to improving and creating DBA policies, procedures, and standards.
Experience with Database Migration tools like AWS SCT/DMS or Ora2pg.
Experience with Database Migration tools like GCP/Azure DMS.
Plan, develop and implement processes and procedures for database backup and
recovery.
Analyze, document and present database hardware and technology requirements.
Continually improve database administration standards, guidelines, and procedures.
Review database development activities to assure conformance with design
specifications.
Database monitoring and administration using shell/python coding.
The individual filling this position is expected to provide production support ownership,
tracking, and resolving database related tasks.
Additionally, fulfilling requests, resolving incidents within SLAs, reviewing service-related
reports (e.g., database backups, maintenance, monitoring) on a daily basis, to ensure
service-related issues are identified and resolved within established SLA.
The position involves a mix of production support and project delivery activities.
The individual will also be responsible for initiating and performing changes on
production systems and proactively escalating any issues that cannot be resolved within
the established timeframes.
Design and implement automation solutions for routine tasks, system reporting, alerts,
and notifications using custom scripts (Shell/Python/Ansible).
Experience working on any Public cloud technologies (AWS, Azure, OCI or GCP) is
preferred.
Experience of Infrastructure as code tool like Terraform or equivalent is good to have.
Knowledge of Linux/storage/network is good to have.
Necessary Knowledge, Qualifications, Skills, and Abilities:
15 plus years of core DBA experience.
Experience with multiple relational databases including PostgreSQL.
Deep knowledge of PostgreSQL and Oracle Internals.
Automation using Ansible or similar tool is preferred.
Bachelors in computer science or Engineering, or equivalent experience.
A deep understanding of data replication with experience in at least one replication
technology.
Excellent problem-solving skills.
Experience coding in shell and Python is must.
Knowledge of DevOps CI/CD tools like Jenkins, AWS Code deploy good to have.
Knowledge of Postgres on EDB or AWS RDS/Aurora or other cloud platform is preferred.
Education: Any Graduate
Industry: Consulting Services

Skills Required