Postgresql Database Administrator
- NTT DATA, Inc.
- 3 - 8 years
- Pune
- 7 days ago
- Email to a friend
- Report this job
Job Description
If Interested ,please reply with updated Resume asap to ne*********h@nt****a.com
Looking early joiners only .
If not interested please provide the references of interested candidature who worked on same skillsets
Rotational shift (sometimes night for 2 weeks in a month)
Primary Skill- PostgreSQL with any cloud (Azure /GCP /AWS )
Skill required-
Primary- PostgreSQL + Any cloud- Azure/ AWS /GCP
24*7 shift hours support-Hybrid
Shifts Morning /Evening /Night -IST
Preferred Experience:
- Ideal candidate has been supporting traditional server based relational database (Postgresql) for over 3+ years out of which last 2 years in any cloud AWS/azure/GCP.
Hands-on experience with PostgreSQL/MongoDB, including installation, configuration, performance tuning, and troubleshooting.
Demonstrated expertise in managing PostgreSQL databases on AZURE, GCP and AWS RDS.
Experience with features such as automated backups, maintenance, and scaling - Postgresql
Ability to analyze and optimize complex SQL queries for performance improvement.
Proficiency in setting up and managing monitoring tools for PostgreSQL on GCP.
Experience with configuring alerts based on performance metrics.
Experience in implementing and testing backup and recovery strategies for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL.
Knowledge and experience in designing and implementing disaster recovery plans for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL.
Good Understanding of database security principles and best practices.
Proven ability to identify and resolve performance bottlenecks in PostgreSQL databases.
Experience in optimizing database configurations for better performance.
Able to provide 24*7 shift hours support at L2/L3 level
Experience in updating KB articles, Problem Management articles, and SOPs/runbooks
Passion for delivering timely and outstanding customer service
Great written and oral communication skills with internal and external customers
Strong ITIL foundation experience
Ability to work independently or no direct supervision.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Work directly with end customer, business stakeholders as well as technical resources.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Work directly with end customer, business stakeholders as well as technical resources."
Basic Qualifications
"
2+ years of overall operational experience
1+ years of GCP experience as a cloud DBA (Postgresql/Mongo DB)
2+ years of experience working in diverse cloud support database environments in a 24*7 production support model
Query fine tuning - MongoDB
Shell scripts for Monitoring like slow queries, replication lag, nodes fails, disk usage. etc
Backup and restores (Backups should be automated with shell scripts/Ops Manager)
Database Health check (Complete review of Database slow queries, fragmentation, index usage. etc)
Upgrades (Java version, Mongo version. etc)
Maintenance (Data Centre outages etc)
Architecture design as per the Application requirement
Writing best practices documents for shading, replication for Dev/App teams
Log rotation/ maintenance (mongos, mongodb, config etc)
Segregation of duties (User Management designing User roles and responsibilities)
Designing DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable
Database Profiling, Locks, Memory Usage, No of connections, page fault etc.,
Export and Import of Data to and From MongoDB, Run time configuration of MongoDB,
Data Managements in MongoDB Capped Collections Expired data from TTL,
Monitoring of Various issues related with Database,
Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB,
Database software Installation and Configuration in accordance with Client defined standards.
Database Migrations and Updates
Capacity management- MongoDB
Hands on experience in Server Performance tuning and Recommendations
High availability solutions and recommendations
Hands on experience in Root cause analysis for business impacting issues.
Experience with SQL,SQL Developer,TOAD,Pgadmin,mongo db atlas
Experience with python / powershell scripting - preferred
Secondary skill in MySQL/oracle - preferred
Installation, configuration and upgrading of postgresql server software and related products
"
Preferred Certifications
Azure fundamentals certification (AZ-900) - REQUIRED Google Cloud Associate Engineer - REQUIRED
Azure Database Certification (DP-300) - preferred
AWS Certified Database Specialty - preferred
Postgresql certification a plus
MongoDB certification a plus
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: NTT DATA, Inc.Location(s): Pune
Keyskills: postgres database performance tuning gcp troubleshooting public cloud python oracle sql queries toad microsoft azure amazon rds cloud support sql sql azure postgresql powershell scripting mysql shell scripting mongodb itil foundation
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in