PostgreSQL DBA

Job details


Job Role


Infrastructure Consultant 2


Career Role


Consultant - Infrastructure Management - US


Work Location


Irvine, CA, San Antonio, TX


State / Region / Province


California, Texas


Country


USA


Domain


Delivery


Interest Group


Infosys Limited


Company


ITL USA


Requisition ID


153380BR


Technical Skills 1


Technology|Database Administration|PostGreSQL


Technical Skills 2


Technology|Cloud Platform|AWS Database


Technical Skills 3


Technology|Database Administration|PostGreSQL

Overview


The Infosys Cloud unit is dedicated to empowering enterprises with innovative cloud solutions that drive digital transformation and operational excellence. We specialize in leveraging advanced cloud technologies and AI-driven insights to create scalable, secure, and resilient infrastructures. Our solutions enable organizations to achieve agility, efficiency, and sustainable growth in a hyperconnected world. Join us to be part of a pioneering team at the forefront of cloud and AI innovation. You'll have the opportunity to work with cutting-edge technologies, collaborate with industry experts, and contribute to transformative projects that shape the future of business. We are committed to fostering a culture of continuous learning and growth, ensuring that our team members thrive in a dynamic and supportive environment. If you're passionate about cloud and AI, and eager to make a significant impact, the Infosys Cloud unit is the perfect place for you to grow and excel.



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


PostgreSQL Administration

• Install, configure, manage, secure, monitor, and tune PostgreSQL databases.

• Manage replication, high availability, backup/recovery, and performance optimization.

• Support database scalability, availability, and operational stability.

• Perform regular database maintenance activities including vacuuming, indexing, and query tuning.

SQL/Oracle to PostgreSQL Migration & Code Remediation

• Lead migrations from SQL Server and Oracle databases to PostgreSQL.

• Perform hands-on remediation and conversion of stored procedures, triggers, functions, and database schemas.

• Resolve naming convention differences including Snake Case, Pascal Case, and other standards.

• Partner with application teams to troubleshoot and resolve functional issues during migration activities.

AWS Database & Cloud Services

• Manage PostgreSQL deployments within AWS environments.

• Utilize AWS DMS for database migration activities.

• Configure and maintain AWS services including CloudWatch, S3, and IAM.

• Support cloud-native database operations and monitoring.

Database Performance & High Availability

• Optimize database performance and scalability across multiple PostgreSQL versions.

• Manage streaming replication, logical replication, and high availability configurations.

• Implement monitoring and proactive performance tuning strategies.

• Ensure database resilience through robust architecture and operational best practices.

Backup, Recovery & Disaster Recovery

• Design and implement database backup and recovery strategies.

• Leverage native PostgreSQL capabilities and AWS services for recovery operations.

• Support Multi-AZ deployments and failover configurations.

• Ensure disaster recovery readiness and business continuity requirements are met.

Security & Governance

• Implement and maintain PostgreSQL security policies, roles, and privileges.

• Enforce database governance, access controls, and compliance standards.

• Monitor database health using pgAdmin, AWS CloudWatch, and other monitoring solutions.

• Maintain documentation for database environments, configurations, standards, and procedures.

Collaboration & Operational Support

• Collaborate with development and infrastructure teams to support application requirements.

• Provide database operational support and troubleshooting.

• Participate in platform improvement initiatives and migration planning.

• Ensure delivery of reliable, secure, and scalable database services.


Preferred Skill and Experience


Preferred but not required


Certifications :

PostgreSQL Certified Professional (or equivalent)

AWS Certified Solutions Architect - Associate/Professional


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.


Additional Details


Estimated annual compensation range for candidate based in the below locations will be

Irvine, CA 81,102 to 109,353


Benefits

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

About Us
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.



EEO
Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.