People Prime Worldwide
Website:
people-prime.com
Job details:
About Company
Our client is a trusted global innovator of IT and business services. We help clients transform through consulting, industry solutions, business process services, digital & IT modernisation and managed services. Our client enables them, as well as society, to move confidently into the digital future. We are committed to our clients’ long-term success and combine global reach with local client attention to serve them in over 50 countries around the globe.
Job Title: Postgres DBA with SRE( Postgres + Greenplum + Azure)
Location: Mumbai/Bengluru
Experience: 8+ yrs
Job Type : Contract to hire
Notice Period:- Immediate joiner
Mandatory Skills
· Hands-on experience with Postgres DBA with SRE( Postgres + Greenplum + Azure).
Position is for a Greenplum/Postgres database engineer which is part of core DB-Platform Operations team. . Team is responsible for providing day to day database platform support ex : Greenplum software installation, patch upgrades, performance monitoring, change implementation, performance tuning, user maintenance, new database setup, educating users, troubleshooting user issues, etc.
Team is responsible for coordinating all hardware changes with respective Infrastructure teams and performing software changes/patch upgrades/major upgrades.
Job Responsibilities:
Provide consultation/support to application development groups?
Maintain day to day support of mission critical database plant and ensure plant stability/modernization using industry standard devops practices.
Showcase expertise to regularly improve and enhance the plant functionality of associate DB platforms
Provide 24x7 firm-wide support for distributed databases including occasional weekend rotational on-call
Candidate will contribute in creation of operational best practices and automation of operational tasks related to the existing Postgres DBaaS plant, as well as provide training, guideline and establish procedures for L1 and L2 teams globally
Performance tuning and troubleshooting user issues with deep dive-in issues
Candidates must be well organized, have strong communication and interpersonal skills, should be confident working independently.
Ability to diagnose problems and triage / resolve issues across various tiers (application, network, database, server, or storage tiers)
Ability to implement automation to reduce manual administrative.
Strong troubleshooting/performance tuning skills required. Must be able to improve SQL performance
Strong communication skills and ability to work effectively across multiple business and technical teams
Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
Plans and coordinates the administration of databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation and follow existing operational guidelines.
Proficiency/Familiarity in Linux/Unix OS fundamentals including kernel and os tunning related to DB performance/security , ansible and shell/perl/python scripting
Familiar with Cloud Based Architectures /Data-Warehousing Platforms, prior experience / knowledge in Snowflake Design Patterns and migration workflow would be a plus.
Operational Experience and Understanding of large-scale Infrastructure-as-a-service Platforms preferred (Azure/AWS) would be a plus
Prior experience managing /deploying Geo Redundant database using 3rd party cluster manager like Patroni/Golden Gate etc.
Prior exposure to Cloud Platforms & Architecture is favourable such as Azure , Identity Management Qualifications –
External Skills Required:
Bachelor’s in engineering degree in computer science or master’s degree in related field with 5+ years of work experience as DBA.
Experience in Greenplum Database version 5,6 or higher
Strong experience with Postgres V12+ , Greenplum version 6+?Hands on exposure in Installing and Configuring HADR/Replication Clusters in Postgres for High Availability .
Postgres database administration including installation of database software, configuration, troubleshooting, database object creation, routine maintenance tasks
Greenplum Database Design, Command Center, Workload Management, Query Tuning, Data Loading using gpload/external tables, backup and restore
Strong troubleshooting/performance tuning skills required. Must be able to improve SQL performance
Strong Organizational Skills, ability to work/collaborate with different cross functional teams/projects.
Database performance monitoring and troubleshooting
Proficiency in Unix OS, ansible and shell/perl/python scripting and keen on automation
Effective written & verbal communication skills: ability to communicate with clients, partners, and peers clearly and concisely at all level of the organization (external and internal alike)
Responsibilities
- Writing clean, high-quality, high-performance, maintainable
- code Develop and support software including applications, database integration, interfaces, and new functionality enhancements Coordinate cross-functionally to insure project meets business objectives and compliance standards Support test and deployment of new products and
- features Participate in code reviews.
Qualifications
- Bachelor's degree in Computer Science (or related field)
Click on Apply to know more.