Orcapod Consulting Services Private Limited

Postgres SQL

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Mumbai
  • Experience: 4-8yrs
  • No. of Positions: 10
  • Salary Range: 7-8 lac
  • Primary Skills: Postgresql Skills highlighted with ‘‘ are preferred keyskills
  • Secondary Skills: Postgresql
  • Job Location: Mumbai
  • Posted Date: 58 days ago
Job Description

 

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

 

Relevant Job Openings
ASP NET Developer
Software Developer Typescript
Hiring Software Development Engineer For Hyderabad
Senior Software Developer Java
SharePoint Developer Multiverse Solutions Pvt Ltd Noida
Software Developer Application Development