Oracle Database Engineer

Join us as a "Oracle Database Engineer " at Barclays, where youll spearhead the evolution of our digital landscape, driving innovation and excellence. Youll harness cutting-edge technology to revolutionise our digital offerings, ensuring unapparelled customer experiences.

You may be assessed on the key critical skills relevant for success in role, such as experience with Oracle DBA, PostgreSQL or MS-SQL, SRE , ESAAS, DevOps, Kubernetes, CI/CD tools as well as job-specific skillsets.

To be successful as a "Oracle Database Engineer , you should have experience with:

Basic/ Essential Qualifications:

• Experience as a Senior Level Database Administrator, with a focus on Oracle and similar database technologies such as PostgreSQL or MS-SQL.
• Proven track record of implementing and leading SRE practices across large organizations or complex teams.
• Expert-level knowledge of telemetry, monitoring, and platform observability tooling (e. g. , ESAAS, Grafana, Prometheus, ) with experience in customizing and scaling these solutions.
• Experience in implementing modern DevOps and SRE practices in enterprise environments.
• Proven expertise in SQL query optimization and database performance tuning at scale.
• Experience with DevOps automation tools such as Code versioning (git), JIRA, Ansible, Containers and Kubernetes (OpenShift), database CI/CD tools and their implementation.
• Recognized as a Oracle subject matter expert, serving as the technical escalation for complex database issues.
• Proven experience in executing database migration strategies at enterprise-scale.
• Exceptional collaboration skills with executives and cross-functional teams
• Extensive experience working with large, distributed, high-performance, high-availability databases with 24/7 uptime.
• Expert knowledge of database administration on Oracle.
• Expert in multiple versions of Oracle - 11g, 12c, 19c.
• Expert knowledge of RMAN, Dataguard, Database Performance Tuning, OEM, plus third-party products such as Imperva.
• Understand and meet the scale, capacity, security, performance attributes, and requirements of the service and technology stack.
• Responsible for debugging the code in case any bug is reported in the Oracle product and fixing the infrastructure/database related issues.
• Hands-on as DevOps on Ansible, Python, PL SQL coding.
• Focus on resilience, scaling, reliability, uptime, and robustness.
• Strong technical skills in areas such as Oracle system administration, networking, cloud infrastructure, automation, and monitoring tools.
• Expert knowledge of Real Application Cluster with Maximum Availability setup.
• Must exhibit SME expertise in solving database contention, Performance Tuning problems (Slow sql response, slow database response etc).
• Database, RAC, OEM, OID installation, configuration and integration.
• Database Upgrade, Migration with ZDLR and Patching.
• Expertise in Goldengate configuration, troubleshooting.
• Database Security policies, fine grained auditing.
• Must have extensive experience as Production support Oracle Database Administrator - strong experience in handling large, high volume and high criticality environments.
• Demonstrate extensive expertise in performance tuning including both query and database optimization.
• Knowledge of the ITIL framework, vocabulary and best practices.
• Excellent spoken and written English communication skills.

Desirable skillsets/ good to have:

• Working experience in a financial environment.
• Cloud experience (AWS, Azure, GCP).
• Oracle Certified Performance Tuning Expert - Oracle 19c, 12c or 11g.
• Oracle Certified Maximum Availability Expert - Oracle 19c, 12c or 11g.
• Experience of working in a highly regulated environment and the associated processes and tools.
• Expert in system configuration management tools such as Chef, Ansible for database server configurations.
• Expert expertise with scripting languages (e. g. PowerShell, Python, Bash) for automation/migration tasks.
• AWS Certified Database - Specialty certification is a plus.

This role will be based out of Pune.

Purpose of the role

To build and maintain infrastructure platforms and products that support applications and data systems, using hardware, software, networks, and cloud computing platforms as required with the aim of ensuring that the infrastructure is reliable, scalable, and secure. Ensure the reliability, availability, and scalability of the systems, platforms, and technology through the application of software engineering techniques, automation, and best practices in incident response.

Accountabilities

• Build Engineering: Development, delivery, and maintenance of high-quality infrastructure solutions to fulfil business requirements ensuring measurable reliability, performance, availability, and ease of use. Including the identification of the appropriate technologies and solutions to meet business, optimisation, and resourcing requirements.
• Incident Management: Monitoring of IT infrastructure and system performance to measure, identify, address, and resolve any potential issues, vulnerabilities, or outages. Use of data to drive down mean time to resolution.
• Automation: Development and implementation of automated tasks and processes to improve efficiency and reduce manual intervention, utilising software scripting/coding disciplines.
• Security: Implementation of a secure configuration and measures to protect infrastructure against cyber-attacks, vulnerabilities, and other security threats, including protection of hardware, software, and data from unauthorised access.
• Teamwork: Cross-functional collaboration with product managers, architects, and other engineers to define IT Infrastructure requirements, devise solutions, and ensure seamless integration and alignment with business objectives via a data driven approach.
• Learning: Stay informed of industry technology trends and innovations, and actively contribute to the organizations technology communities to foster a culture of technical excellence and growth.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.
• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes
• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L - Listen and be authentic, E - Energise and inspire, A - Align across the enterprise, D - Develop others.
• OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
• Take ownership for managing risk and strengthening controls in relation to the work done.
• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc). to solve problems creatively and effectively.
• Communicate complex information. Complex information could include sensitive information or information that is difficult to communicate because of its content or its audience.
• Influence or convince stakeholders to achieve outcomes.