skillindiajobs
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

Postgres DBA

2.00 to 7.00 Years   Mumbai City   16 May, 2022
Pace Business Machines Pvt Ltd
Job LocationMumbai City
EducationNot Mentioned
SalaryRs 3.0 - 6 Lakh/Yr
IndustryOil & Gas / Petroleum
Functional AreaDBA / Datawarehousing
EmploymentTypeFull-time

Job Description

    - Responsible for the monitoring and uptime of all production/Development/UAT databases and also worked in PostgresEnterprise Manager (PEM)-Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.-Develop Stored Procedures and Database Triggers in support of application development.-Participate in application development projects and will 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, 2rArchiving).- Responsible for proactive remediation of database operational problems.- Responsible for Query tuning and preventative maintenance.- Experience with postgres version 9.x, 10.x , 12.x,13.x- Ability to proactively identify, troubleshoot and resolve live databasesystems issues- Anticipate and handle critical situations database issues- Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore- Experience in replication, Load balancing, connection pooling using pgpool and Pgbouncer- Experience with Enterprise DB tools like PEM, BART, EFM and some open source tools like Pgbackrest, Barman, Pgbadger etc.- Knowledge of PostgreSQL replication(hot,cold,warm), cascading, Shared clustering (active, passive).- Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron or other techniques- Expert level of PostgreSQL RDBMS installation/configuration, patching,upgradation, troubleshooting on Linux environment- Strong commitment to following SDLC/Change management principles.- Selfstarter and be able to perform work with minimal supervisory direction.- Knowledge of data quality, data management and data testing strategies and practices.

Keyskills :
postgresqldatabase

APPLY NOW

Postgres DBA Related Jobs

© 2020 Skillindia All Rights Reserved