Oracle Database Administrator
Role details
Job location
Tech stack
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, Technology|Database Administration|Oracle
Technical/Domain Skill 2
Technology|Cloud Platform|AWS Database
Required Skill and Experience
- Experience in Oracle GoldenGate or SharePlex replication experience, supporting real-time data replication environments.
- Experience with Oracle Database 19c and above, including Administration, Migration, Upgrades, Backup & Recovery (RMAN), Oracle Patching, and Version Compatibility.
- Extensive experience in performance tuning, health checks, database security configuration, schema design, and 24x7 production support.
- Install, configure, administer, and troubleshoot Oracle GoldenGate and SharePlex for real-time replication across homogeneous and heterogeneous databases.
- Manage and monitor Oracle RAC environments, ensuring high availability, scalability, and optimal performance.
- Perform advanced database tuning and replication optimization to achieve near-zero/zero latency in GoldenGate and SharePlex processes.
- Conduct replication conflict resolution, lag analysis, and capacity planning for mission-critical data flows.
- Develop, maintain, and enforce database and replication documentation, including architecture diagrams, procedures, runbooks, and best practices.
- Collaborate closely with application, development, infrastructure, and operations teams to ensure seamless database integration and system performance.
- Perform regular database audits, security reviews, and health checks to ensure compliance, performance, and stability.
- Support disaster recovery (DR) and high-availability (HA) strategies using GoldenGate and SharePlex.
Requirements
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, * Support Oracle Databases in On-Prem and AWS Cloud infrastructure
- Experience in AWS Services like S3, EC2, EBS, RDS, CloudFormation
- Experience in migrating Oracle to PostgreSQL using ora2pg.
- Experience in GoldenGate replication tuning.
- Experience and desire to work in a Global delivery environment., * 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.
Benefits & conditions
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
