Contract: 6 Months

Location: Mumbai

No. of Contractors: 1

Experience: 4+ Years

Joining: Immediate Joining

PostgreSQL DBA

Role - Postgres SQL

Job description : Min 4 Years' Experience

Job Responsibilities:

The Database Administrator will be working with development and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing

Three (3) years of experience within the last five (5) years working with PostgreSQL version 9+ up till latest version 12.3 hosted on Linux or Windows platforms

Two (2) years of experience within the last five (5) years as a PostgreSQL database administrator designing and deploying PostgreSQL databases on Cloud platforms such as AWS and Azure Cloud Environment

Three (3) years of experience within the last five (5) years as a senior PostgreSQL database administrator

Three (3) years of experience within the last five (5) years using programming languages such as: UNIX shell scripting, PL/pgSQL, Python, or Perl

Three (3) years of experience within the last five (5) years using instrumentation tools such as: pgAdmin, pgAudit, pgBadger, Nagios, OpenNMS, or vScout

Two (2) years of experience within the last five (5) years using Ansible playbooks or YAML

Two (2) years of experience within the last five (5) years architecting and implementing

PostgreSQL replication solutions using streaming replication including pgPool

Two (2) years of experience within the last five (5) years using pSQL

Two (2) years of experience within the last five (5) years migrating non-PostgreSQL databases to PostgreSQL, such as MS SQL Server, Oracle, or MySQL. 12.

One (1) year experience within the last three (3) years deploying databases in containers such as Open Shift

Install, monitor, and maintain PostgreSQL & MySQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning and assist in business process integration with various data sources

Experience in replication, Slony is a plus

Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage

Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing downtime

Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.

Must have strong knowledge of Linux

Strong understanding of command line and server administration

Develop Stored Procedures and Database Triggers in support of application development

Participate in application development projects and be responsible for the database architecture and design

Participate in the creation of development, staging, and production database instances, and the migration from one environment to another

Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release

Responsible for regular backups and recovery of databases

Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving)

Responsible for pro-active remediation of database operational problems

Responsible for Query tuning and preventative maintenance

Ready to support in a 247 support operation

Support complex web-based applications

Ability to proactively identify, troubleshoot and resolve live database systems issues