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 apply software engineering techniques, automation, and best practices in incident response, to ensure the reliability, availability, and scalability of the systems, platforms, and technology through them.

Accountabilities

• Availability, performance, and scalability of systems and services through proactive monitoring, maintenance, and capacity planning.
• Resolution, analysis and response to system outages and disruptions, and implement measures to prevent similar incidents from recurring.
• Development of tools and scripts to automate operational processes, reducing manual workload, increasing efficiency, and improving system resilience.
• Monitoring and optimisation of system performance and resource usage, identify and address bottlenecks, and implement best practices for performance tuning.
• Collaboration with development teams to integrate best practices for reliability, scalability, and performance into the software development lifecycle, and work closely with other teams to ensure smooth and efficient operations.
• 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.

Analyst Expectations

• To perform prescribed activities in a timely manner and to a high standard consistently driving continuous improvement.
• Requires in-depth technical knowledge and experience in their assigned area of expertise
• Thorough understanding of the underlying principles and concepts within the area of expertise
• They lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources.
• 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 develop technical expertise in work area, acting as an advisor where appropriate.
• Will have an impact on the work of related teams within the area.
• Partner with other functions and business areas.
• Takes responsibility for end results of a team s operational processing and activities.
• Escalate breaches of policies / procedure appropriately.
• Take responsibility for embedding new policies/ procedures adopted due to risk mitigation.
• Advise and influence decision making within own area of expertise.
• Take ownership for managing risk and strengthening controls in relation to the work you own or contribute to. Deliver your work and areas of responsibility in line with relevant rules, regulation and codes of conduct.
• Maintain and continually build an understanding of how own sub-function integrates with function, alongside knowledge of the organisations products, services and processes within the function.
• Demonstrate understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Make evaluative judgements based on the analysis of factual information, paying attention to detail.
• Resolve problems by identifying and selecting solutions through the application of acquired technical experience and will be guided by precedents.
• Guide and persuade team members and communicate complex / sensitive information.
• Act as contact point for stakeholders outside of the immediate function, while building a network of contacts outside team and external to the organisation.