Job Title

Job Title: Oracle DBALocation: Remote, UKDuration: 6months+Banking client experience requiredJob DescriptionResponsible for the design build and day-to-day support of the Oracle databases. These databases are each 100TB in size(and growing) , hold over 13 Billion rows of data each and together process circa 1 billion SQL statements per day. As part of a DevOps team, you will work closely with the application and infrastructure POD SMEs to ensure these critical services function to the required standards. Maintain and improve SLA’s and ensure compliance to client policies at all times.Actively participate to achieve organization objectives for efficiencies, innovations, and quality delivery. Perform pro-active analysis on day-to-day work, identify areas for automation, report and follow up on process or technical gaps, reduce repeat or false incidents, and standardize tasks/processes.Support is required 24 hrs. x 7 days in week x 365 days from office or on call depending on business needs (usually 1 week in 4 on-call) . Required to work on weekends (usually 1 in 4) often at short notice. Resource will get compensatory time- off for as per HR guidelinesResponsibilitiesAll aspects of the Oracle DBA Support including the design, build, ongoing enhancements (e.g. automation) and 24* 7 supportRAC, Oracle 19, Database Restoration, TroubleshootingMust have strong experience of Oracle (v19c) RDBMS, RAC and Dataguard on a LINUX platformincluding:o Perform Database software installation, upgrades and apply relevant patcheso Perform Database migrations – intra platform or inter platformso Build and Deploy/Implement Solutions. Perform Capacity Planning and DR Planning.o Troubleshooting and fixing incidentso Creating / altering / dropping tablespaceso Clone one environment from anothero Database backup / restoreo Data Archival activitieso Assist the development community with the resolution of miscellaneous queries and problemso Database space managemento Implementing releases / service requestso Server monitoring including health checks at server level and database levelo Keeping the systems up and running cleanlyo Timely escalation of issues to Team Leado Performance and Tuning of database• Scripting Skills• Customer Service and Problem Resolution• Actively participate in crisis calls taking the lead from an Oracle DB perspective• Participate in identifying problem situations and resolve to give maximum customer satisfaction-Experience of Oracle databases running on RedHat Linux• Experience on Delphix will be good to haveKind Regards--Priyanka SharmaSenior Delivery ConsultantOffice: 02033759240Email: psharma@