Oracle Database Administrator

Infosys•Indianapolis, IN

About The Position

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 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. Required Skill and Experience Strong experience with Oracle database administration. Monitor and maintain an Oracle 19c Enterprise Edition database, including development, test, training, pre-production, and production systems. Establish database storage structures and modify the database as needed to meet evolving application demands. Plan and execute major Oracle upgrades, coordinating with hosting and development teams to ensure a low-risk upgrade with minimal downtime. Update design documentation to reflect new software or infrastructure information related to database, operating system, or data exchange with the customer’s application. Monitor database backup status, conduct database restore tests, and recommend changes as needed to the backup and restore plans. Proactively monitor database storage and plan for growth as part of an overall capacity management strategy. Help troubleshoot escalated data quality concerns, applying SQL queries and an understanding of the application workflows to identify potential data anomalies. Work with business intelligence analysts to support data analysis efforts. Install, manage and troubleshoot all Goldengate setup for oracle and non-oracle replication setup. Manage data guard and other oracle tools in scope Preferred Skill and Experience Excellent Communications and client interaction skills along with exceptional written and verbal skills as well as technical documentation. Hands-on experience in working in Global Delivery Model with onsite/offshore resources. Exceptional organizational skills. Ability to manage and prioritize tasks efficiently. Readiness to demonstrate a proactive attitude. Ability to work in team in diverse/ multiple stakeholder environment. 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. In order to comply with legal requirements, this role is limited to “U.S. persons” as defined by 22 C.F.R. §120.15. U.S. persons include U.S. citizens, U.S. Lawful Permanent Residents, and certain refugees and asylees. Overview The Infosys Communications, Media, and Technology (CMT) unit is a dynamic and innovative division dedicated to driving digital transformation and growth for clients in the telecommunications, media, and technology sectors. Our vision is to become the strategic and trusted partner for our clients by enabling their digital transformation and growth. We achieve this by leading technological changes. Join us to be part of a team that leverages deep industry insights and strategic leadership to deliver innovation-led transformation through digital, cloud, and AI-first solutions.We are committed to building and nurturing a high-impact partner ecosystem and driving long-term, strategic client relationships.

Requirements

Strong experience with Oracle database administration.
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.
In order to comply with legal requirements, this role is limited to “U.S. persons” as defined by 22 C.F.R. §120.15. U.S. persons include U.S. citizens, U.S. Lawful Permanent Residents, and certain refugees and asylees.

Nice To Haves

Excellent Communications and client interaction skills along with exceptional written and verbal skills as well as technical documentation.
Hands-on experience in working in Global Delivery Model with onsite/offshore resources.
Exceptional organizational skills.
Ability to manage and prioritize tasks efficiently.
Readiness to demonstrate a proactive attitude.
Ability to work in team in diverse/ multiple stakeholder environment.

Responsibilities

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
Monitor and maintain an Oracle 19c Enterprise Edition database, including development, test, training, pre-production, and production systems.
Establish database storage structures and modify the database as needed to meet evolving application demands.
Plan and execute major Oracle upgrades, coordinating with hosting and development teams to ensure a low-risk upgrade with minimal downtime.
Update design documentation to reflect new software or infrastructure information related to database, operating system, or data exchange with the customer’s application.
Monitor database backup status, conduct database restore tests, and recommend changes as needed to the backup and restore plans.
Proactively monitor database storage and plan for growth as part of an overall capacity management strategy.
Help troubleshoot escalated data quality concerns, applying SQL queries and an understanding of the application workflows to identify potential data anomalies.
Work with business intelligence analysts to support data analysis efforts.
Install, manage and troubleshoot all Goldengate setup for oracle and non-oracle replication setup.
Manage data guard and other oracle tools in scope