The candidate will be a member of a Database Administration team providing infrastructure services and operational support on a global basis for both Oracle and Microsoft SQL technologies. The role will consist of a combination of incident, requests and proactive platform management activities.
Key Accountabilities
Provide excellent technical support for Oracle and SQL Database environment.
Provide operational support for DB issues initiated from Incidents or Changes.
Provide solutions and root-cause analysis of system performance and failure related issues.
Work on an onsite shift-rota and provide off site 24×7 support.
Work on projects and provide close liaison with project teams to ensure the smooth transition of new databases and initiatives into the Production environment.
Working closely with manager and team members.
Review and recommend options to improve the effectiveness of the database infrastructure.
Establish / maintain best practices, processes and procedures to underpin the operations of the business.
Performance monitoring / Testing and capacity planning.
Creation / maintenance of full system documentation, including DR documentation.
Innovation – continually looking at ways to improve infrastructure, for a faster and more efficient environment.
Person Specification: (E- Essential D-Desired)
Skills
Excellent working knowledge of Oracle RDBMS 9i\10\11g
Excellent working knowledge of Oracle RAC
Excellent working knowledge of Oracle Forms
Excellent working knowledge of SQL 2000\2005\2008
Experience using a scripting language to automate tasks
Excellent working knowledge of SQL High Availability features
Experience of performance and tuning optimising SQL DB’s
Experience of monitoring and alerting tools for DB’s
Knowledge
8-10 years of hands on Oracle DBA experience on Linux/Unix.
Oracle Certified Professional (OCP) Certification.
Experience of ITIL v3 standards or a certificate in ITIL v3 foundation skills beneficial
Degree educated preferable.
Hands on experience in Installing & supporting following in Production environment
a. Oracle Dataguard.
b. Oracle 11g RAC.
Experience
Candidate will be a DBA with strong Oracle RDBMS and SQL 2005\2008 experience.
The candidate will be a member of a Database Administration team providing infrastructure services and operational support across a global company.
An ideal candidate would have experience working within a financial institution or similar environment.
Special Job Requirements:
There is a third-line and out-of-hours support requirement, which operates on a rota.
Competencies
Delivering Business Success – Using Market/Technical Knowledge – regarded by customers and the business as an expert and use this expertise to enhance the performance and reputation of the business whilst remaining up to date with external market, technical and professional development.
Leading – Creating Synergies – demonstrates a positive attitude towards working with others and a willingness to move out their ‘comfort zone’ in order to gain a clear vision of overall business goals so as an individual they can understand how their tasks contribute to overall business strategy.
Working With People – Working Together – works sensitively with others and shares openly information and knowledge with the appropriate people at the right time. Encourages a co-operative team approach to handle workloads and overcome difficulties and Maintains continuous dialogue with Unit members as appropriate.
Creating Solutions – Solving Problems – Uses a logical approach to look at straight forward problems or issues and Offers a practical solution to straightforward problems or issues. Recognises the effect a problem will have on the future i.e. sees cause and effect relationships e.g. if X happens then Y will occur and Generates a number of alternative possible ways forward.
Providing Direction – Thinking Strategically – Understands own business’ targets and goals and fully understands the competitive context in which it operates and looks for ways to add value to the organisation. Periodically steps back from immediate operational concerns to check progress against broader goals and their fit with the organisation’s strategic objectives
