EY—TechOps-CloudOps-Oracle-DBA-Senior

Job description

Description: At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. Service line - Position Title: TechOps-CloudOps – Senior Oracle Database Administrator At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world. About Global Delivery Services Global Delivery Services refers to EY's worldwide network of service delivery centers. The GDS team plays an important role in EY’s strategy by ensuring effective support to EY’s growth agenda. Our journey started in 2002 with approximately 200 people. Today we stand at 80,000+ professionals in ten locations around the world. We operate in Argentina, China, Hungary, India, Philippines, Poland, Sri Lanka, Mexico, Spain and the United Kingdom. Client service is focused on providing Consulting, Assurance, Tax, Strategy & Transactions, and Knowledge support to our clients around the world. The teams enable account teams worldwide to provide seamless, high-quality, value-added support, helping deliver exceptional client service. Enablement Services provides cost-effective, high-skilled, and innovative services to support EY’s global and local enablement teams. Markets, BMC, AWS, Finance and Accounting, Risk Management, Procurement, People Shared Services, IT Service Delivery and IT Global Infrastructure services, are among the services offered by Enablement Services. Our innovation specialists serve the GDS Client Service and Enablement Services teams, along with Service Lines, Core Business Services and Sectors. The team brings the desired environment, technologies and skilled teams together for facilitation, rapid prototyping and innovative thinking. The competencies offered include analytics, digital, user experience, mobile technology, infrastructure, Microsoft technologies and open innovation. The Opportunity The Senior Oracle Database Administrator is accountable for the reliable, secure and efficient operation of Oracle database platforms supporting business-critical applications. The role combines hands-on database administration with engineering, troubleshooting, lifecycle management, security controls and close collaboration across application, infrastructure, security and DevOps teams. The successful candidate will own operational database activities from installation and configuration through monitoring, performance optimization, backup and recovery, patching, upgrades and production support. The role also contributes database expertise to ensure that database changes are tested, documented, auditable and safely promoted through environments. Your Key Responsibilities - Responsible for decision-making, optimizing processes, resource management, and overseeing team management as needed for task execution. - Accountable for allocating personnel, supervising team members, assigning tasks, ensuring that the team has the necessary tools and support to succeed in their roles and optimizing and evaluating their performance to meet organizational goals. Core database administration - Install, create, configure and maintain Oracle databases on all environments - Administer database instances, schemas, storage, tablespaces, parameters, listeners, services and connectivity in line with agreed standards. - Plan and execute database patching, version upgrades and technical maintenance, including prerequisite checks, rollback planning, validation and evidence capture. - Execute database and schema refreshes across environments using approved native tools and controlled procedures. - Maintain accurate operational documentation, configuration records, runbooks and technical procedures. Performance, availability and resilience - Monitor database health, capacity, availability and performance; identify trends and address risks before they affect service quality. - Perform database performance tuning, investigate bottlenecks and optimize configuration, queries, indexes and resource utilization where appropriate. - Design, operate and test backup, restore and recovery procedures using Oracle RMAN, and ensure recovery evidence is retained. - Operate and troubleshoot high-availability and disaster-recovery capabilities, especially Oracle Data Guard; experience with RAC, ASM and Grid Infrastructure is beneficial. - Support capacity planning, housekeeping, availability reviews and disaster-recovery exercises for critical database services. Security, access and audit - Implement database security controls, including user and role administration, least-privilege access, authentication integration and segregation of duties. - Administer encryption controls such as Transparent Data Encryption and file-system-level encryption, as well as encrypted database connections. - Review vulnerability assessment findings, assess database impact and apply required remediation or patches through controlled change processes. - Configure and maintain database auditing and reporting mechanisms, and provide traceable evidence for reviews and audits. - Troubleshoot Oracle network configuration, listener issues, certificates, connection encryption and authentication problems.   DELIVERY, OPERATIONS AND COLLABORATION - Operational support and service management - Provide advanced troubleshooting and root-cause analysis for database incidents, performance degradation, failed jobs, connectivity issues and application errors. - Participate in incident, problem, change and release processes; communicate technical status, risk, impact and remediation clearly. - Support planned maintenance and, where required by the operating model, on-call or out-of-hours activities for critical services. - Work with application teams to translate business and technical requirements into supportable database solutions. - Coordinate with infrastructure, cloud, network, security and identity teams to resolve cross-platform issues. - Identify opportunities to automate repetitive administration, monitoring, configuration and deployment activities using scripting and configuration-management tools. - Contribute to standards, reusable procedures, knowledge transfer and continuous improvement of database operations. Expected deliverables - Deliverable - Operational documentation - Change artefacts - Health and performance outputs - Security and compliance evidence - Knowledge transfer Typical content - Runbooks, configuration standards, recovery procedures and troubleshooting guides - Implementation plan, test evidence, rollback plan, approvals and post-change validation - Monitoring findings, capacity observations, tuning recommendations and incident analysis - Access reviews, patch evidence, vulnerability remediation, encryption and audit records. - Technical walkthroughs, handover materials and mentoring for operational teams Skills and attributes for success - At least 8 years of hands-on experience in Oracle database administration for enterprise environments. - Demonstrated experience with installation, creation, configuration, patching, upgrades, troubleshooting, performance tuning and optimization. - Strong practical experience in high availability, disaster recovery, backup and recovery, and database monitoring. - Experience supporting business-critical enterprise applications; exposure to regulated sectors such as banking or insurance is advantageous. - Experience with refreshes and migrations of databases or schemas between environments. - Experience analyzing vulnerability findings and implementing database remediation. - Experience establishing database audit and reporting mechanisms. Technical Skills Capability Priority - Oracle platform - Recovery & HA - Performance - Security - Operating systems - Database development - Automation - Advanced Oracle - Replication - Other databases Expected knowledge - Database 12c/19c administration, architecture, installation, configuration, patching and upgrades - RMAN, Data Pump and Data Guard - Monitoring, diagnostics, database optimization - User administration, authentication, TDE, connection encryption, auditing and vulnerability remediation - Strong Unix/Linux knowledge; working knowledge of Windows - SQL and PL/SQL, including functions and procedures - Bash; practical knowledge of PowerShell and/or Ansible - RAC, ASM and Grid Infrastructure - Oracle GoldenGate or comparable third-party replication tools - PostgreSQL, open-source or cloud database platforms Professional skills - Structured troubleshooting and analytical problem solving under operational pressure. - Ability to assess technical risk, define practical mitigations and make evidence-based recommendations. - Clear written and verbal communication with technical and non-technical audiences. - Ability to connect technical solutions with customer and application requirements. - Strong collaboration across distributed, multicultural and cross-functional teams. - Ownership, reliability and attention to detail when working on production systems. - Ability to prepare and deliver technical presentations and knowledge-transfer sessions. Qualifications - Oracle Certified Professional for Oracle Database 12c and/or 19c is mandatory. - ITIL Foundation certification is an advantage. - Relevant degree in computer science, information technology or a comparable discipline is preferred, or equivalent professional experience. What we offer you At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more. Are you ready to shape your future with confidence? Apply today. To help create an equitable and inclusive experience during the recruitment process, please inform us as soon as possible about any disability-related adjustments or accommodations you may need. Our Commitment: As a commitment, we persistently endeavour to embody our values, fulfil our purpose, and champion inclusiveness. Our dedication is to cultivate EY into an environment where diverse perspectives are celebrated, creating a supportive atmosphere for individuals to authentically be themselves and contribute their utmost. Professional Development: From entry-level employees to senior leaders, we believe in continuous learning. We offer opportunities to build new skills, take on leadership roles, and connect and grow through mentorship. People and Culture: In our dynamic workplace, diversity, equity, and inclusiveness are ingrained in our culture. We're united by a commitment to create an environment where every individual's differences are valued, practices are equitable, fostering a sense of belonging. Our shared values include integrity, respect, teaming, inclusiveness, energy, enthusiasm, courage to lead, and building relationships based on doing the right thing. Benefits: Embark on a transformative career journey with us and indulge in a suite of premium benefits, encompassing exclusive health and wellness packages, enticing rewards, and cutting-edge learning opportunities that empower you to continually grow and excel in your professional and personal development. How to Apply: If you are passionate to join us and are aligned with our commitment to building a better working world, we invite you to apply by completing our user-friendly form with personal and professional information and by providing your consent to data privacy. Successful candidates advance to a competency-based interview. If mutual interest persists, a job offer awaits. “We are an equal opportunity employer and are committed to Diversity, Equity & Inclusion”. EY | Building a better working world EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.