Job Description
Join us as a Oracle Associate Service Engineer II at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence
You'll 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 Associate Service Engineer II, 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 responce etc)
Database, RAC, OEM, OID installation, configuration and integration
Database Upgrade, Migration with ZDLR and Patching
Expertize 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 organization's 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 teams 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
All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship our moral compass, helping us do what we believe is right
They will also be expected to demonstrate the Barclays Mindset to Empower, Challenge and Drive the operating manual for how we behave
Show more Show less
Job Classification
Industry: Financial Services
Functional Area / Department: Engineering - Software & QA
Role Category: DevOps
Role: Site Reliability Engineer
Employement Type: Full time
Contact Details:
Company: Barclays
Location(s): Pune
Keyskills:
12c
oracle
oracle 11g
sql optimization
database performance tuning
database administration
rman