Postgre SQL Administrator

In the assigned Job Role of Infrastructure Consultant 2, your Area Of Responsibility will be as below:

Collaborate with internal and client teams to resolve complex incidents, conduct root cause analyses, and document findings with preventive recommendations Participate in evaluation of client IT infrastructure, prepare actionable assessment reports, and support due diligence to document infrastructure maturity and improvement opportunities Contribute to the design of scalable, cost-effective IT infrastructure solutions, review reusable components, and develop technical documentation for deployed systems Align release schedules and environment readiness, execute deployments as per protocols, perform post-deployment testing, and manage version control to track changes Co-ordinate maintenance schedules, emergency fixes, and technology upgrades while ensuring uninterrupted integration into existing systems and processes Facilitate performance data analysis across systems, coordinate insights on system behavior, and support capacity planning to optimize performance Conduct security checks, recovery drills, and compliance audits, implement security measures, and coordinate continuity plans to maintain adherence to standards Gather feedback to identify automation opportunities, analyze existing infrastructure processes, and propose enhancements for efficiency gains Act as liaison with onsite, offshore, and vendor teams to document project requirements, ensuring effective collaboration Develop a centralized repository of technical and procedural knowledge, leveraging insights from other projects to drive efficiency and retain organizational expertise, Technology|Database Administration|PostGreSQL

Technical/Domain Skill 2

Technology|Cloud Platform|AWS Database

Technical/Domain Skill 3

Technology|Open System|Shell scripting

Technical/Domain Skill 4

Technology|Database administration|DB2 Administration

Required Skill and Experience

• Experienced with Postgres SQL and Amazon Aurora Database
• Excellent Analytical and troubleshooting skills.
• Hands-on experience with: Database monitoring tools such as: Cloudwatch, Dynatrace, Zabbix, and Foglight.
• Proficient with Shell scripting with Linux is a plus
• Outstanding in verbal and written communication.
• Creative thinking in implementing Service improvements with: Automation, and Incident reduction.
• Well-Versed with running operations following ITIL processes.
• Practiced with leading geographically separated customers and onshore/offshore teams
• Building and supporting large-scale, high-transaction database environments.
• Database performance tuning, optimization, and deep-dive analysis.
• Configuring, supporting, and tuning PostgreSQL databases.
• Working Knowledge of database backup and recovery strategies.
• Ability to write and debug Shell and Python scripts.
• Excellent communication skills, with the ability to collaborate effectively with business teams, technical teams, and senior management.
• Manage database platforms to ensure high availability and performance, including start, stop, restart, failover operations, and replication-lag monitoring on replica nodes.
• Perform daily health checks for disk, CPU, memory utilization, and PostgreSQL logs, using AI-driven automation where applicable.
• Carry out on-demand backup and restoration activities, including table- and schema-level backups.
• Identify long-running and repetitive queries, run execution plans, and share findings with the development team for further analysis.
• Enact basic user and access management.
• Troubleshoot infrastructure, performance, and availability issues.
• Provide basic query and performance support.
• Monitor weekend job alerts, troubleshoot issues, and escalate to the Compass SME as per SOP.
• Execute database refresh activities during weekends.
• Participate in planned maintenance windows and outage activities and perform database tuning and optimization to meet SLA requirements.
• Handle incident management, change management, and service tasks in accordance with SLA requirements.

Preferred Skill and Experience

• DB2 LUW administration is a plus
• Database monitoring tools: CloudWatch, Zabbix, Dynatrace, Datadog, Fog light.

A collaborative spirit and excellent communication skills. Ability to handle complex incidents and implement resolutions A knack for conducting IT infrastructure assessment and identifying key optimization opportunities Focused approach towards deployment management, system optimization, and process automation initiatives including sector specific focus The ability to work with cross-functional teams, * Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

• This position may require relocation and/or travel to work/project location.
• Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply. Infosys is unable to provide immigration sponsorship for this role now or in the future.

Along with competitive pay, as a full-time Infosys employee you are also eligible for the following benefits:

• Medical/Dental/Vision/Life Insurance
• Long-term/Short-term Disability
• Health and Dependent Care Reimbursement Accounts
• Insurance (Accident, Critical Illness , Hospital Indemnity, Legal)
• 401(k) plan and contributions dependent on salary level
• Paid holidays plus Paid Time Off

Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four 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., The Infosys Retail, Consumer Goods, and Logistics unit stands as a globally respected partner of choice, dedicated to helping clients achieve their business goals through cutting-edge technology and seamless services. Our unit offers a dynamic forum where projects and teams can effectively learn, adopt, and excel in all technologies. We foster a vibrant community that leverages shared skills and experiences to deliver high-quality, value-enhanced solutions. Join us and become part of a team that drives innovation, operational efficiency, and sustainable growth in the retail, consumer goods, and logistics sector. Together, we can shape the future of these industries and achieve remarkable success.