BT Consultant/Senior Professional, S&IT in Bangalore, India

Key Purpose of Role:

  • To provide 3rd Line support to all Oracle Databases and associated components that form the teams defined supported estate.

  • Provide support and technical consultancy for database components which include but are not limited to : patching, upgrades, new database build activity, delivery of backup strategy/solutions, standard / emergency changes, production incident resolution, performance tuning and supporting system migrations.

  • Ensure database integrity standards are maintained and database access is secured.

  • Under Service Obsession Initiative, contribute to EOSL by managing the removal of legacy databases and systems. In addition improve system reliability and NFMI maturity ratings.

  • Have the drive and focus to work in a Service Obsessed environment, putting the Customer first to improve the overall Customer experience.

  • Celebrate success that has been driven through Continuous Improvement and be demonstrative in working practice by striving to improve processes and automation for all aspects of 3L work.

Key Responsibilities:

  • Install and maintain DBMS software. Ensure databases are deployed in accordance to a predefined design which include RAC as well as HA configurations.

  • Configuration of DBMS parameters to meet the needs of the application.

  • Maintain database integrity and ensure access is secured to BT database standards. Ensure that databases are delivered in accordance to BT Security standards.

  • Provide infrastructure support in accordance with all applicable and defined SLA's covering the defined supported estate for Change, Incident and Problem activities

  • Design data storage structures for the data described logically in application data models taking account of strategic direction, technical feasibility, performance criteria and cost effectiveness.

  • Focusing and prioritising on the key deliverables especially for all those applications deemed critical to BT’s Operations.

  • Monitor database performance, propose and implement agreed performance enhancing changes.

  • 24x7 On-call support for Production Faults

  • To accept and participate in assigned project work

  • To investigate all raised issues impacting any aspect of the defined supported estate and consequently our customers; undertaking any necessary remedial action and completion of all defined administration activities

  • Help achieve significant cost savings through the consolidation/migration of systems onto MI platforms and also shutting down legacy estate.

  • Take responsibility for the planning and structure of all tasks (technical or non-technical) assigned as part of my role to ensure a business efficient service is delivered to our customers

  • Contribute to and participate in all knowledge sharing activities and provide web based media content for TSO, my team and customers.

  • Take an active part in DOMAIN (Expertise) activity to develop LWOW and improve ‘Best Practice’

  • Take part in system performance and service improvement consultancy work Assume management of major incidents and take ownership of escalations in accordance with the agreed SLA and all applicable operational documents across all supported platforms.

  • Establish and maintain effective BAU relationship with all teams that influence my team’s role or raise queries, initiating any contact required to deliver an outcome.

  • Help develop, implement and maintain strategy, standards and procedures for system support

  • Define and Introduce automation across all managed platforms where applicable for all support processes which will contribute to reduced CT’s, increased RFT measures and increased self-service customer support.

  • Ensure all designs for Oracle Databases are fit for purpose and adhere to BT Standards

  • Help to define, develop and implement pre-emptive maintenance, monitoring and housekeeping routines across all defined supported systems to demonstrate a reduction in reactive incidents

  • Provide weekly reports/feedback when requested

  • Help service improvement initiatives – saving space, cost, improving major system performance and reliability, EOSL targets and NFMI scores.

  • Ensure all DAAS/ EC MI build requests are managed and delivered within the defined CT and are RFT.

  • Implement DR and resiliency solutions

  • Ensure all new systems accepted into support have RFT, CT and Automation principles embedded in their design, rejecting anything that is deemed as adding avoidable or manual support overheads

  • Ensure all team Rotas are properly resourced and executed

  • Work in a flexible manner to meet the support needs of the team and the expectations of our customer base .

Skill, Experience and Qualifications:

  • 5 or more years of Oracle 3L DBA experience (10g/11g) supporting production databases. Must have knowledge and experience of 12c.

  • Must have significant and demonstrable experience of supporting large scale mission critical systems.

  • Must have ability to investigate and resolve service affecting issues, providing RCA’s and making contributions to PIR calls.

  • Must have ability to carry out database and application specific, performance reviews and make recommendations to improve throughput and service.

  • Knowledge of planning, installing, upgrading, and patching Oracle Database software

  • Experience of developing and testing backup, recovery and housekeeping strategies for mission critical systems.

  • Excellent communication skills, able to engage at a very detailed technical level with ASG and project teams, through to senior stakeholders adjusting style to suit the audience.

  • Must be prepared to support out of hours when appropriate, this could be for planned build work or to support major service affecting incidents.

Must have experience, well used skills and full understanding of :

RAC ASM

CRS Grid Control / OEM

Scripting Skills RMAN

DB Recovery Database Performance Tuning

Dataguard Commvault / Netbackup

Desirable to have experience and understanding of:

GoldenGate PL/SQL

Exadata Oracle Security (TDE and Database Vault)

Virtulization (VMware, VBox)

Qualifications:

  • Bachelor or Masters Degree preferably in Information technology/ Engineering from reputed institutions.

Job: IT & engineering

Title: Consultant/Senior Professional, S&IT

Location: India-India-Bangalore-Bangalore

Requisition ID: 90298