Install, configure and maintain Oracle 10g and 11g software on IBM AIX, Sun
Solaris and Red Hat Linux platforms.
Install, configure and maintain Oracle 10g /11gRAC software on Red Hat Linux
Remotely manage Production Oracle database systems
Manage the database Oracle ASM file system on Linux platform
Tune database parameters for optimal system performance.
Ensure proper setting of system memory and semaphore system parameters in
consultation with system administrators
Create and maintain Oracle 10g and 11g databases with optimal file layout for
data file, rollback, and redo objects.
Aid developers in detecting performance problems including analysis of SQL,
PL/SQL, and JDBC code.
Provide continuous monitoring, troubleshooting, historical and real time
performance monitoring of the Oracle 10g and 11g environments using Oracle
Diagnostic and Tuning packs, and Quest Vision tool
Provide backup and restore functions for Oracle 10g, 11g databases.
Understand Database failover technologies using Oracle DG.
Extensive experience supporting complex and integrated application
environments, primarily based on IBM Websphere suite and Oracle relational
Ability to write and maintain technical documentation and procedures Good
understanding of the Software development lifecycle
Follow ITIL processes for incident management, change management and problem
Compliance with ISO 20000 and ISO 27001 standard processes
4 to 7 years relevant experience as a DBA in Oracle 10g in IBM AIX environment
using Veritas File Systems and/or Red Hat Linux .
Relevant Experience in Installing/Upgrading/Managing Oracle RAC Instances
including Critical Patch activities
Experience as DBA in Oracle 10g/11g in Red Hat Linux using ASM storage
Oracle 10g/11g DBA certification is required
Relevant experience in remote management of Production database system
Relevant experience with Oracle ASM file system
Relevant experience with RMAN for backup and recovery.
Experience with using performance analysis using OEM.
Experience in Grid Control is a plus
Experience in Oracle LDAP is a plus
Experience in Oracle Data Guard.
Experience in Oracle 12c is a plus.
Experience in using OEM for job and event management.
Proven expertise in enhancing database performance by query and process optimization
Apply database changes according to change management procedures
Carry out regular capacity planning activities
Database refresh and cloning
Participate actively in all aspects of infrastructure projects and technical upgrades
Provide database provisioning and technical support services to application development projects
Participate in security audits and compliance initiatives. Ensure the database environment is fully compliant with IFC security policies and internal controls.
Provide 24/7 incident response for ITSs production environment thru established escalation processes
Provide periodic and ad-hoc status reports including KPIs as requested by offshore Team lead
Perform R & D activities and manage Infrastructure technical projects.
Should be flexible to work in shifts and weekends on need basis in close co-ordination with onsite and offshore team as well as with end users across the globe, in a multi vendor / service provider environment.
Maintenance of technical documents and creation of problem tickets as per standards followed in ITS
Relevant experience in use of ITIL processes
Relevant experience for SOX compliance of critical financial systems
Effective interpersonal and communication skills
Willingness to work on flexible working hours including weekends