Job Description
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
Your contribution to the team:
• 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
Required Skill and Experience
• Administer, maintain, and optimize PostgreSQL databases across development, test, and production environments.
• Design, implement, and support PostgreSQL high availability, replication and disaster recovery solutions using Patroni.
• Experienced with PostgreSQL performance tuning, backup and recovery, replication, and security.
• Hands-on experience as a PostgreSQL DBA, with working knowledge of Postgres internals (MVCC, WAL, query planner, locking, buffer management) and operational best practices.
• Proven track record managing PostgreSQL in production environments, including incident response, root cause analysis, and performance optimization under heavy traffic.
• Working Knowledge of: SQL skills, including query optimization and execution-plan analysis (EXPLAIN / EXPLAIN ANALYZE).
• Experience with backup and recovery such as: pgDump, pgRestore and tool CoommVault is good to have.
• Proficiency with Linux/Unix operating systems and shell scripting (Bash or similar).
• Create detailed documentation including diagrams of database infrastructure.
• Learn relevant business processes and understand the data flow, criticality and dependencies.
• Candidate must be available to work exclusively for PST time zone and be prepared to operate on rotating shift schedules to ensure 24/7/365 support coverage which includes weekends and holidays.
Shift timings:
Shift 1: 3 AM to 12 PM PST
Shift 2: 11 AM to 8 PM PST
Shift 3: 7 PM to 4 AM PST
Preferred Skill and Experience
• Additional experience with SQL Server, MySQL, or MariaDB in mixed database environments is good to have.
• Worked on tools such as: Qlik Attunity, SolarWinds DPA and Delphix is a plus.
• Experience with backup and recovery such as: pgDump, pgRestore and tool CoommVault is good to have.
• PowerShell programming is a bonus.
• Backup and restore tools such as: EMC Networker, CommVault is an added advantage.
• Good Communication and Analytical skills
Additional Required Qualifications
• 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.
