Oracle Database Administrator with Golden Gate

About LTIMindtree

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 750 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world.

Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree — a Larsen & Toubro Group company — combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale.

Job Title: Oracle DBA with Golden Gate

Location: Rutherford, NJ (Onsite)

Pay Range: 110K - 120K

The Senior Oracle Database Administrator is responsible for assisting with Database administration activities, including Service management, technical guidance, and support coordination with the Technology Infrastructure team. This role requires expertise and experience in High Availability (RAC), Partitioning, Replication technologies, VLDB, Golden gate configuration, setup and maintenance. The overall objective is to use infrastructure technology knowledge and identified policies to process data, resolve issues and execute administrative tasks.

Responsibilities:

• Review and Oversee Critical Changes in Production DB environment.
• Ensure DB standards and tools are implemented as per global standards.
• Build strong client relationships with Application Managers and Production support.
• Performance and capacity review of Production DB environments
• Analytical & Problem-solving skills
• Database automation & Service Improvement
• Project / Program management and implementation experience
• Create complex project plans, perform impact analyses, solve/work high impact problems/projects, and provide resolution to restore services
• Provide Root Cause Analysis (RCA) post restoration of service
• Design testing approaches, complex processes, reporting streams, and assist with the automation of repetitive tasks
• Provide technical/strategic direction to application teams
• Review requirement documents, define hardware requirements and update processes and procedures as necessary
• Ensure ongoing compliance with regulatory requirements
• Responsible for applications dealing with the overall operating system
• Conduct project related research
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.
• Qualifications:
• Significant experience in Oracle Database Management
• Experience with Oracle 12c or 19c.
• RAC and high availability
• Advanced backup, restore, and recovery strategies
• Experience in upgrading, patching and migrating databases
• Database performance and tuning experience
• Experience in database contingency planning, configurations and support
• Experience running SQLT Explain plans and other Advisors
• Application SQL tuning experience is a plus
• Experience in and Golden Gate replication.
• Strong development & scripting background (Python, Perl a must; Power shell & Java script a plus)
• Experience with Ansible and Ansible playbook development is a plus.
• Required to provide off-hours support as and when needed
• General IT Audit experience is a plus
• Ability to communicate technical concepts to non-technical audience
• Ability to work with virtual and in-person teams, and work under pressure or to a deadline
• Experience in a Financial Services or large complex and/or global environment preferred
• Effective written and verbal communication skills
• Effective analytic/diagnostic skills