hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

PostgreSQL DBA(Contract)

1.00 to 3.00 Years   Mumbai City   27 May, 2021
Zycus Infotech Pvt Ltd
Job LocationMumbai City
EducationNot Mentioned
SalaryNot Disclosed
IndustryInternet / E-Commerce
Functional AreaGeneral / Other Software
EmploymentTypeFull-time

Job Description

The PostgreSQL DBA will be responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases.

  • 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 any need for downtime.
  • Develop Stored Procedures and Database Triggers in support of application development.
  • Responsible to migrate Products on MSSQL / Oracle database to PostgreSQL, planning the cutover and Go-Live in the shortest migration window.
  • 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 of databases and proactive remediation of database operational problems.
  • Responsible for Query tuning and preventative maintenance.
  • Support complex web-based applications.
, Requirements
  • 1-3 years of relevant experience in PostgreSQL required
  • Experience as DBA in high-load, large-sized production DB
  • Must have experience of migration from Oracle, MSSQL and other databases to PostgreSQL.
  • 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 AWS Cloud and Azure Cloud.
  • Good Knowledge of pgbadger and pgclue report analysis
  • Hands-on experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster).
  • Must have strong knowledge of Linux operating systems
  • Strong understanding of command line and server administration.
  • Knowledge of shell scripting (e.g., Bash, Perl).
  • Strong experience in Performance tuning
  • Troubleshooting experience using ASH/AWR/ADDM features and coming up with actionable resolutions.
  • Excellent communication and presentation skills with the ability to communicate at all levels of the organization.
  • Technical leadership and mentoring skills to guide and act as SME.
  • Exceptional problem-solving skills
  • Keen to learn new technology with enthusiasm and critical thinking
  • Ability to work within a team environment. Self-starter and ability to perform work with minimal supervisory direction
  • Excellent analytical and communication skills
  • Familiar with ITIL process of change management and incident management process.
  • Ability to detect and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues. Have proficiency with Linux for basic administrative tasks
  • Experience with Unix/Linux including basic commands and basic shell scripting.

Keyskills :
itil processdisaster recoveryoracle databasechange managementphysical designshell scriptingcode reviewquery tuningproblem solving

APPLY NOW

PostgreSQL DBA(Contract) Related Jobs

© 2019 Hireejobs All Rights Reserved