Job Description
Join us as a Software 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 Software 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 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 organization's 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
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: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time
Contact Details:
Company: Barclays
Location(s): Pune
Keyskills:
12c
oracle
oracle 11g
sql optimization
database performance tuning
database administration
rman