Systems Programmer (Oracle DBA)

Department Overview

ISAP IT Production Centre is an offshore delivery center managing IT Operations (RUN) for Paris, London and Asia. With over 250 people, it constitutes one of two main hubs for the company's IT production teams. This setup is operated in partnership with a Service Provider, who provides most resources on site.

ISAP IT Production Centre is split in 4 departments covering the following aspects:

• INFRA: core infrastructure- systems and network services
• APS: application technical support
• Middleware: Data services and Middleware services
• End-user & Transverse: End-user Services and Transversal activities, including Control Tower, Global Operations Center and Data Security Services.

Position

ORACLE DBA L2 is a technical expert role within the Database team and will be responsible for managing, administration and supporting the ORACLE Database technologies for the bank.

Person will be the technical point of contact for the Run team. He/She will be a technical L2 resource for ORACLE database services in the company. As such, he/she will provide support for all production support activities within the Database team in Singapore. He/She is accountable for the overall health and stability of the technical solutions within his scope. He/She has to effectively work with technical peers such as architects, peer experts and project teams on technology road maps and projects. He/She will work with L2/Service Manager to gain control over the scope of technical activities, develop best practices and gain knowledge over all aspects of support.

ORACLE team in Singapore is responsible for day-to-day operational services on the infrastructure of Europe (mainly France and UK) and Asia remotely from Singapore. France infrastructure represents approximately 80% of the worldwide production activities of the company in Singapore.

Team works in Europe time zones and this role will be aligned primarily to Paris working hours. Flexible rotations are followed based on the nature of duties.

The operational support of the team covers the following technical scope:

• ORACLE RAC, DB advanced performance tuning both Server & DB level
• Oracle Golden Gate, EXACC , CLOUD & Cross platform migrations
• Very good Experirnce in high availability & DR solutions. – Data Guard
• Encryption Solutions: TDE
• Expertise in Backup & recovery solutions
• Database Audit Monitoring solutions
• Vulnerability Management
• Automations –Python, shell script,perlscript

Qualifications and Profile

Functional

• 5 - 8 years of ORACLE DBA experience in administration and management of IT Database technologies primarily EXACC,RAC,Data guard, Golden Gate solutions;
• Knowledge of different domains of IT Security;
• Working & hands-on experience in administering the DB technologies;
• Must have experience in working in similar Production setup in Run (Operations) mode;
• Ability to apply risk based approach while working on assigned responsibilities;
• Experience in defining, implementing, and enforcing Database Security policies for data security solutions;
• Must have working experience in a Large enterprise level environment, working experience in financial organization is preferred;
• Excellent in analytical, communication and documentation skills;
• Ability to organize work and be able to prioritise work as per the needs of Production Operation’s needs;
• Must have strong understanding of ITIL processes and comfortable working in process oriented environment;
• Ability to work independently and as well as a part of team and is able to work under minimal supervision;
• Should have time management skills and able to manage work in fast moving environment;
• Excellent written and oral English language skills;
• Knowledge of French language is preferred.

Technical

• Hands-on experience on Configure and maintain database servers and processes
• experience of High Availability (HA) and Disaster Recovery (DR) options for Oracle technology
• Deployment, integration and administration experience of various components of DB technologies:
• EBS
• Must have experience in defining, designing and configuring Database solution as per the business requirements;
• Deploy, upgrade and troubleshooting knowledge on ORACLE technology solution;
• Scripting knowledge (Python, Powershell,TSQL) is desirable;
• Professional Certifications:

- ORACLE certified is highly preferred

- Cloud ceritication

• Must be experienced to cover the scope as mentioned in the SKILLS MATRIX section of this document.

Technical skills

• Linux Administration: Critical
• Oracle architecture & performance tuning: Critical
• Proficient of RAC: Critical
• Scripting Knowledge (any language but preferably shell, perl or python): Critical
• Proficient of Data Guard: Essential
• Proficient of Golden Gate: Essential
• Knowledge of Access control and security mechanisms like Kerberos: Critical
• Hardware Configurations and setup like racks, disk topology and RAID: Essential
• Knowledge of Virtual Machines in cloud (deployment & configuration): Essential
• Knowledge of any NO SQl technology: Essential
• Proficiency in Python, Java, or Scala Proficiency in TSQL: Desirable
• Experience with ETL process/software: Desirable

General skills

• Ability to analyze and summarize information: Critical
• Ability to prioritize effectively: Critical
• Ability to work autonomously: Critical
• Ability to work successfully in a team: Critical
• Adaptability to changing environments: Essential
• Effectiveness at decision making: Desirable
• Ability to deal with issues: Critical

Other skills

• Capacity to develop others: Desirable
• Capacity to cooperate / work across discipline: Essential
• Capacity to take have a vision and work on the continuous improvement: Desirable

Language skills

• English: Critical
• French: Desirable

Work Schedule

• Work schedule is mainly focused to support Asia and EMEA (Paris) time zone; however, may have to support during non-offce hours for critical incidents or escalation as per the assigned on-call support requirements;
• Rotational Shift schedule is followed;

Work Hours: 2 PM – 11 PM SGT (with 1 week of General shift 9 AM – 6 PM SGT).

Education Requirements

At least a Bachelor’s degree in any of these faculties:

• Computer Science
• Information Technology
• Programming & Systems Analysis
• Science (Computer Studies)

Next Step

Prepare your updated resume and expected package.

Simply click on 'Apply here' or email to [email protected] to drop your resume

All shortlisted candidates will be contacted.

Prasant Sirohi

EA License Number: 91C2918

Registration Number: R22106307