Oracle 9i Database Administration Oracle 9i Database Performanc
Resume:
*******.*******@*****.***
KHRIESA THEUNUO
PROFESSIONAL SUMMARY:
15+ years of work experience in IT industry with 12+ years experience as an Oracle DBA.
Worked extensively in Banking & Financial domains - more than 5 years as Oracle DBA in Data Center supporting Core Banking Application,1200 branches (13000 concurrent users) working in the Core Banking Solution – Finacle.
Oracle Certified DBA (OCP) 10G, with extensive experience in database administration, Backup Recovery, Capacity Planning & System, Application and SQL Tuning.
Installation and Configuration of Oracle Server 8i, 9i, 10g and 11g on different operating systems.
Experience in Very Large Multi Terabyte Databases (VLDB) and also on high volume transactions OLTP databases.
Experience in configuration and maintaining Oracle Standby Database/Dataguard.G
Experience in installation and maintenance of RAC, ASM, Failsafe (Windows);
Good understanding of Oracle internals (latches, system waits, resource allocation, data dictionary)
Database migration from 8 to 8i, 8i to 9i, 9i to 10g and 10 to 11g.
Migrate Stand-alone database to RAC;
Monitoring and optimising the Database Performances through Database Tuning, System Tuning, and Application/SQL Tuning.
Experience in Partitioning.
Experience in SQL*Loader, Datapump, Grid Control, PL/SQL & RMAN.
Performance Tuning of Database by optimizing SQL & PL/SQL scripts, SGA and tuning of initialization parameters.
Knowledge of using logminer and oracle flashback utilities.
Experience in UNIX administration, Shell scripting and kernel set-up for Oracle database on the UNIX environment.
Basic functional knowledge of MS SQL Server.
Good knowledge in Banking domain (Core Banking Solution - Finacle from Infosys);
Good knowledge in inter-banks payment gateway applications like Real Time Gross Settlement (RTGS) and National Electronic Fund Transfer (NEFT).
PROFESSIONAL CERTIFICATIONS:
Oracle Certified Professional (10g)
Sun Solaris (5.9) Administration (Level I)
EDUCATION / PROFESSIONAL QUALIFICATION :
Bachelor of Engg. (Computer Science) - 1st Class (Passed Out: July 1998, Madurai Kamaraj Univ. / Mepco Schlenk Engg. College, Sivakasi, INDIA)
TECHNICAL SKILLS:
Languages : COBOL, C & C++
DBMS : FoxPro / Visual FoxPro
RDBMS : Oracle 8i / 9i / 10g/11g, MS SQL Server 2000 & MS- Access
Tools : VB 6.0 & Developer 2000
Platforms Worked On : DOS, LAN, Windows' 2K / NT, Linux, UNIX-HP &IBM, UNIX (Sun Solaris 8/9/10) – E25K, SF6900, SF6800, etc.
Web Servers : Tomcat, Apache Web Server
Storage Technologies : SAN & NAS
Other Technologies : Veritas Netbackup, Verities Volume Manager & IBM Websphere.
PROFESSIONAL TRAINING:
Oracle 9i Database Administration
Oracle 9i Database Performance Tuning
Oracle 9i Database Partitioning
Oracle 9i Data Guard & RAC
System Administration (Sun Solaris 8) –I
System Administration (Sun Solaris 8) –II
System Administration(Sun Solaris 8) –III
Sun Cluster (3.0) Administration
Veritas Volume Manger
PROFESSIONAL EXPERIENCE:
CRICKET COMMUNICATIONS APR’07 – Till date
SR. ORACLE DATABASE ADMINISTRATOR (Contractor)
Cricket provides innovative, high-value wireless services to a fast-growing, young and ethnically diverse customer base. The Company operate in 23 states and hold licenses in 35 of the top 50 U.S. markets. Through its affordable, flat-rate service plans, Cricket offers customers a choice of unlimited voice, text, data and mobile Web services.
RESPONSIBILITIES:
Installation, configuration and upgrading of Oracle software and related products.
Work as team member for providing 24X7 support ;
Manages more than 200 instances (Development, QA & Production) – all are in 11g;
The largest database is 30+TB;
Manages multiple Dataguard / RAC set-ups;
Monitoring the databases, estimating the space requirement, and allocating the resources for the databases and capacity planning.
Establish and maintain sound backup and recovery policies and procedures.
Upgrade / Migration of databases;
Installing and configuring Grid agent for multiple nodes.
Implement and maintain database security (create and maintain users and roles, assign privileges).
Perform database tuning and performance monitoring.
Developing shell scripts for monitoring database servers.
Dataguard Switch over/ Failover testing at Database level.
Performed technical trouble shooting and give support to development team.
Take up with Oracle Corporation for technical support when required.
Setup and maintain documentation and standards for database administration;
Preparation of DR policy & implementation of Oracle Data Guard;
ENVIRONMENT: Oracle 11g / 10g / 9i / 8i / 7.x, Grid Control, TOAD, Unix HP, Linux, Unix Sun Solaris 8 & 9 (Sun Fire 6800/6900), Microsoft Windows 2000, XP.
ICICI BANK LTD., MUMBAI, INDIA JAN’05 – FEB’07
ORACLE DATABASE ADMINISTRATOR
Database administration for Financial Application (Core Banking Solution), RTGS (Real Time Gross Settlement) & NEFT (National Electronic Fund Transfer) applications (both Production &Test Databases). The size of the main production database (Financial) was more 3.3 TB.
ii) Supporting RTGS (Real Time Gross Settlement) application.
iii) Supporting NEFT (National Electronic Fund Transfer) application.
RESPONSIBILITIES:
Database Team leader in Data centre providing 24x7 onsite supports for Production, Development & test databases.
Performed Oracle database backups involving production and development servers.
Restoration and Recovery of Oracle databases due to data corruption in the event of physical disk failure, etc.
Monitoring the Oracle databases, estimating the space requirement, and allocating the resources for the databases and capacity planning.
Monitoring performance of databases and tuning the databases as necessary.
Analyzing tables and indexes to assist the CBO and to validate structure to check if index rebuild is necessary.
Developing shell scripts for monitoring database servers.
Conduction of DRS drills every quarter;
ENVIRONMENT: Oracle 9i, Window 2000, Sun Solaris 9 & 10, Apache Web server, Tomcat & IBM Websphere.
PUNJAB NATIONAL BANK, NEW DELHI, INDIA DEC’01 – JAN’05
SYSTEM & DATABASE ADMINISTRATOR IN DATA CENTER
RESPONSIBILITIES:
System and Database administration in the Data Center (24X 7 supports); where around 12000 branches are working in centralized Banking Solution (CBS).
System administration for 10 No. of Production servers and 6 Nos. of Development / Test Servers on UNIX platform (Sun Solaris 5.9).
Database administration for 5 production databases and more than 10 databases in test/development server. The size of one production database was more than 1.3 TB.
Supporting 17 Zonal Training Centers in installation/ maintenance of Core Banking application (Finacle - Infosys), Government Business Module (GBM - Telesis) application and databases in their training servers.
Designing & implementing Database backup solution - Host free & LAN free backup solution;
Conduction of DRS drills every quarter;
OS hardening and compliance Data Center Audit report;
Configuration & Designing of the SAN volumes for Production databases;
Environment: Oracle 9i, Window 2000, Sun Solaris 9, Apache Web server, Tomcat & IBM Websphere.
ALLAHABAD BANK, INDIA OCT’98 – NOV’01
IT OFFICER
RESPONSIBILITIES:
Mechanization of branches with Nelito & Viramati software.
Monitoring / supervision of computerized branches.
Development of software for RO, Dibrugarh.
Looking after EDP functions of Regional Office, Dibrugarh
ENVIRONMENT: Oracle 7.x, Microsoft Window 98, Sco UNIX, Visual Basic 6.0, Developer 2000 (Forms 6i & Reports 6i )
M/S MICRO WORLD COMPUTERS, KOHIMA JUN’98 – SEP’98
SR. INSTRUCTOR
RESPONSIBILITIES:
Teaching Diploma/Certificate Course students.
Contact this candidate