Postgre Sql Admin

JOB Description :

Please share profiles who have "AWS Certified Database – Specialty” and/or "AWS Certified Data Analytics – Specialty as mandatory certification for the position for Aurora-Postgres DBA.

Location – India (Bangalore/Hyderabad/Pune)

Exp – 7+ Yrs

Infosys is seeking a Senior Database Administrator. This position will interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation, Application Architecture definition and Design; play an important role in creating the high level design artifacts; deliver high quality code deliverables for a module, lead validation for all types of testing and support activities related to implementation, transition and warranty; be part of a learning culture, where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.

Required Qualifications:

• Bachelor's degree required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• Minimum 7 years of IT Experience as the Senior Database Administrator, expertise in various Database Technology like PostgreSQL, MySQL, ORACLE etc.,
• 3+ year of Hands-on experience as a Senior PostgreSQL DBA with the preferred exposure in AWS Cloud database administration

Preferred Qualifications:

Essential Skills:

• Hands on experience in PostgreSQL installation/Setup and Configuration in Linux platform
• Sound understanding with the Core PostgreSQL Architecture
• Expertise on Maintenance in PostgreSQL- Vacuum a Database and remove data fragmentation., Updating Planner statistics, Analyze and routine Re-indexing.
• Expertise in User Access Management and Database Security
• Very Strong Experience in Performance Tuning
• Query optimization – Calculate Query Cost and Explain plan.
• Leveraging features in the latest PostgreSQL release
• PostgreSQL Patching and Upgrade
• Experience in DB Backup, Restore, Disaster Recovery & Replication
• Table partitioning and DB schema maintenance- psql CLI/Commands
• Familiar with PostgreSQL admin tools and utilities
• Good Communication, Interpersonal, and Client Interfacing skills with the ability to manage work pressure and timelines effectively.
• Perform on-going support on database issues and ticket management.
• Perform other specific Database administration duties as defined in Working Practices
• At least 3 years of experience in Project life cycle activities on support and maintenance projects.
• Experience and desire to work in a Global delivery environment with basic understanding of ITIL framework - Incident & Problem Management
• Provide after-hours and on-call support to critical databases.
• The job entails sitting as well as working at a computer for extended periods of time.
• Should be able to communicate by telephone, email or face to face.

Preferred skills

• Experience in AWS Cloud Database Administration-RDS (Aurora-PostgreSQL, Aurora-MySQL) and AWS services S3, Athena, EMR, Lambda, Kinesis, Glue, Lake Formation, DynamoDB, CloudWatch etc.,
• Redshift Database Administration
• Azure Cloud Database

Preferred Qualifications

• Certified PostgreSQL DBA
• AWS Certified Cloud Practitioner
• AWS Certified Database Specialty
• ITIL Foundation Certification

About Us

Infosys is a global leader in next-generation digital services and consulting. We enable clients in 46 countries to navigate their digital transformation. With over three decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

To learn more about Infosys and see our ideas in action please visit us at www.Infosys.com.