PostgreSQL DBA

Overview Infosys Cloud unit invites you to drive design and stabilization of scalable IT infrastructures. You will partner with cross-functional teams to resolve complex incidents, assess client environments, and implement economical, secure solutions. The role focuses on PostgreSQL databases, cloud migrations, and automation to boost performance and reliability. You’ll work on critical deployments, capacity planning, and security/compliance, shaping resilient data platforms. This is a hands-on, collaborative opportunity to impact enterprise cloud initiatives. Compensation / BenefitsMedical/Dental/Vision/Life InsuranceDisability401(k) planPaid holidaysPaid Time OffHealth and Dependent Care Reimbursement Accounts ResponsibilitiesResolve complex incidents with root-cause analysis and preventive recommendationsAssess client IT infrastructure and document maturity and improvement opportunitiesDesign scalable, cost-effective infrastructure solutions and prepare technical documentationCoordinate release schedules, deployments, and post-deployment testing with version controlManage maintenance, emergency fixes, and technology upgrades for uninterrupted integrationAnalyze performance data and support capacity planning to optimize systemsConduct security checks, recovery drills, and compliance audits, coordinate continuity plansIdentify automation opportunities and propose efficiency improvements in infrastructure processesLiaise with onsite, offshore, and vendor teams to document project requirementsDevelop a centralized knowledge repository leveraging cross-project insights Key requirementsPostgreSQL Administration: install, configure, secure, monitor, and tune databases; manage replication, backup/recovery, performanceSQL/Oracle to PostgreSQL Migration & Code Remediation: migrations, remediation of procedures and schemas, naming conventionsAWS Database & Cloud Services: manage PostgreSQL deployments in AWS; use AWS DMS; configure CloudWatch, S3, IAMDatabase Performance & High Availability: optimize performance, implement replication and high availabilityBackup, Recovery & Disaster Recovery: design and implement backup/recovery strategies; Multi-AZ and failoverSecurity & Governance: implement policies, access controls, and monitoring; maintain documentationCollaborative spirit and strong communicationAbility to handle complex incidents and implement resolutionsCapability to conduct infrastructure assessments and identify optimization opportunitiesPostgreSQL AdministrationAWS Database & Cloud ServicesDMS (Database Migration Services)