E T Consultant

International Finance Corporation - IFC 

E T Consultant

Job #:	req10546
Organization:	IFC
Sector:	Information Technology
Grade:	EC1
Term Duration:	1 year 0 months
Recruitment Type:	Local Recruitment
Location:	Chennai,India
Required Language(s):	English
Preferred Language(s):
Closing Date:	1/18/2021 (MM/DD/YYYY) at 11:59pm UTC

 

Description IFC, a member of the World Bank Group, is the largest global development institution focused on the private sector in emerging markets. Working with more than 2,000 businesses worldwide, we use our capital, expertise, and influence to create markets and opportunities in the toughest areas of the world. In FY17, we delivered a record $19.3 billion in long-term financing for developing countries, leveraging the power of the private sector to help end poverty and boost shared prosperity. For more information, visit www.ifc.org  Information technology is an integral part of the strategic initiatives for all the Core Business Functions at IFC. Corporate Information Technologies (CIT) Teams provide comprehensive IT support for IFC's Investment & Advisory Services, Financial Operations, Treasury & the Asset Management Company. There is a rich and diverse landscape of business applications that encompass a wide variety of In-house and Customized COTS products which meets the business needs of IFC. Duties & Accountabilities This job position is for Oracle database administrator (Oracle DBA) performing physical and logical infrastructure activities in the CITCC unit of ITS VPU. The candidate will be responsible for install , configure, patch and maintain Oracle software on Unix/Exadata environment focusing on Red Hat Linux platform including ASM, RAC, RAC-Data guard infrastructure setup, Administration and maintenance of Oracle infrastructure services, Oracle database performance management, Assisting development team and DBAs in detecting performance problems, Providing backup and restore functionality and Implementing database failover technologies DG broker following WBG database security standard implementation process for Oracle database environment. Essential Job Functions: • Install, configure and maintain Oracle 11g/12c/18c/19c software on  Linux/Exadata platform • Install, configure and maintain Oracle 11g/12c/18c/19c RAC software on Linux/Exadata platform • Install configure and maintain Oracle Data Guard in Single Instance and Oracle RAC environment • Manage the Oracle ASM file system on Linux/Exadata 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 11g/12c/18c/19c databases with optimal file layout for data file, rollback, and redo objects. • Assist developers and logical DBAs 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 11g/12c/18c/19c environments using Oracle Diagnostic and Tuning packs • Provide backup and restore functions for Oracle 11g/12c/18c/19c databases. • Implement Database failover technologies. Additional Technologies to support. - PostgreSQL logical DBA support - Hadoop administrative support - MongoDB DBA support - Support the IFC license provisioning function. • Participate in On Call weekly shift supporting off hours and weekend activity. This is rotating assignment shared with other members of the team as necessary • Follow ITIL processes for incident management, change management and problem management • Compliance with ISO 20000 and ISO 27001 standard processes. • Understanding of HIPAA and SOX Oracle compliance and controls Selection Criteria Educational Qualifications and Experience: • Minimum education requirement of Bachelors in Computer Science, IT. Masters is desirable • 5 – 7 years relevant experience as a DBA in Oracle 11g/12c/18c/19c. • Relevant experience in remote management of Production database system of large scale. Required Skills/Abilities: • Extensive experience in Oracle RAC • Experience in operating Oracle in the Cloud is a plus • Experience with Oracle Exadata is a plus • Experience as DBA in Oracle 11g/12c/18c/19c in Red Hat Linux using ASM storage and ext3 file systems • Relevant experience with Oracle RAC in Red Hat Linux platform • Relevant experience with Oracle ASM file system • Relevant experience with RMAN for backup and recovery • Unix Shell Scripting experience is required • Experience in Oracle Transparent Data encryption • Relevant experience in use of ITIL processes • Relevant experience for SOX/ICFR compliance of critical financial systems Desired Skills/Abilities (not required but a plus): • Experience in Cloud Control is a plus • Experience in Oracle LDAP is a plus • Experience in using OEM for job and event management is a plus • Good Technical Documenting Skills is a plus • PostgreSQL logical DBA experience is a plus • Hadoop administrative experience is a plus • MongoDB DBA experience is a plus • Knowledge the license provisioning function is a plus. Experience Matrix for Levels: • 7+ years of relevant experience For more information and online application click here