SUMMARY

• Oracle Certified Associate in Oralce 9i Developer (sql, plsql)
• Oracle Certified Associate in Oracle 10g (DBA)
• Around 9 years of hands on experience on Oracle RDBMS
• ITIL Foundation Certified in IT service management
• Around 2 years experience on design, documentation and development on Oracle - 9i database (plsql)
• Around 7 years experience on Oracle 10g, Oracle 11g Database Administration
• More than 6.5 years of hands on experience on Production support(24x7x365) for mission critical database environments (oracle 9i, oracle 10g, oracle 11g)
• Handling database environments under SOX compliance
• Strong experience on Oracle RAC 10g, oracle 11g (Grid Infrastructure) and ASM
• RMAN backup and recovery, Oracle Data Guard (Physical Standby), Data Pump, Export/Import, AWR Report, Sql performance Tuning, Database instance performance tuning, Oracle database patching, oracle clusterware patching, database upgrade, OEM, strong in sql query, plsql(oracle 9i)
• Troubleshooting production issues within SLA and worked on rotational shifts 24x7x365 environment
• Worked as Single point of contact for Database Tower and provided technical solutions from client location in Singapore (1 year).
• Provide Monitoring solutions and configure threshold monitoring settings
• Work with Oracle support for internal errors and implement recommendations
• Knowledge on Oracle golden gate and oracle Exadata

TECHNICAL SKILLS

Operating Systems: Windows XP, Solaris 10, Suse Linux, Redhat Linux, HP-UX

OS Clusters: Solaris Cluster, HP-UX cluster, Linux cluster, Veritas Cluster

Programming Languages/Technologies: SQL, PL/SQL, C, C++

Development Tools/Utilities: TOAD, XMLSpy, WIN-CVS, VSS, Putty

RDBMS: Oracle 9i, 10g, 11g

Monitoring Tools: HP DBSPI

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator (SME)

Responsibilities:

• Production support on 24x7x365 environment with oracle 10.2, oracle 11.1 and oracle 11.2 database versions
• Install oracle grid control agent and configure the database in Grid Control
• Configure RMAN backup in Grid Control through netbackup
• Implement oracle dataguard (physical standby), fix the out of sync issues and re-sync standby database
• Sql performance tuning using sql tuning advisor and manual tuning
• Install oracle Clusterware software, oracle database and create new database on unix servers
• Allocating storage to ASM disk group by coordinating with storage and unix team
• Capacity planning for the database and growth trend analysis
• Troubleshooting ASM issues
• Restore database from backup during asm disk corruption and recover database
• Fix block corruption issues in the database
• Upgrade oracle RAC database and applying oracle security patches on both database and clusterware
• Work with oracle support for internal errors and bug fixes
• Providing technical solution for the new project requirements
• Estimating, Planning and executing the new projects
• Troubleshooting the long pending outstanding issues in oracle database tower
• Stabilize the environment and built the customer confidence
• Mentor team members and provide solutions in technical as well as process area
• Performance tuning on the retail Jobs and oracle cluster load balance issues
• Co-ordinate with unix team and fix the veritas cluster issues
• Represent the team in the weekly call with Customer Technical Manager and reporting about the progress of action items, setting the deadline for the requirements and propose the approach for the new requirements
• OS Level Clusters - Veritas cluster, solaris cluster

Confidential

Database Administrator (Team Lead)

Responsibilities:

• Responsible for the GMNA database servers which includes 46 Production and 52 Pre-production/test database environments including oracle RAC
• Manage the projects by coordinating between the technical team and the customer management for the new requirements
• Building new database servers with Oracle RAC, Oracle RAConeNode and standalone database by closely working with Unix team, Network team and Storage team
• Convert the oracle database from single instance (Non ASM) to oracle RAC (ASM) in multi-version database environment (10.2, 11.1 & 11.2)
• Migration of databases across cross platforms (Solaris to Linux, HP-UX to Linux)
• Configure the physical standby database (Data Guard), troubleshoot the log file gaps and sync up the physical standby database with primary database
• Contribute the designing on new projects for database and provide suggestion
• Responsible for Database Backup strategy, RMAN backup configuration through Networker backup and troubleshooting backup issues
• Analyzing the performance of the database servers and providing solutions for the performance improvement on the database
• Responsible for maintaining the Database environments under SOX compliance and attend the SOX audit once in a year with all the evidences
• Apply the oracle security patches (CPU patch / PSU patch) on standalone database, Oracle RAC and clusterware (oracle 11g - Grid Infrastructure)
• Providing Level 3 operational support for the database tower
• Supported oracle database on Solaris Cluster, HP-UX Cluster environments
• OS Clusters - HP-UX cluster, linux cluster, solaris cluster

Confidential

Database Administrator

Responsibilities:

• Responsible for monitoring and doing health check for 18 databases including production, UAT and SIT environments
• Upgrade the database from Oracle 9i to 10g
• Supporting oracle 10g RAC database and physical standby database
• Sql Query tuning and providing tuning suggestions to the developers
• Database instance tuning to provide the maximum performance of the database environment
• Manual oracle database Cloning and renaming
• Designing the best approach for purging the old data from the database
• Scheduling the logical backups through scripts and enable email alerts
• Creating the security level in the database using triggers for restricting the DB user accounts to access the database.
• Coordinating with oracle support for any outstanding issues and oracle internal errors. Implementing the solution based on the response from Oracle support including applying one off patch.
• Trouble shooting the connectivity issues to the oracle database
• OS Cluster - Veritas cluster

Confidential

Oracle Developer (SQL, PLSQL Developer)

Responsibilities:

• Writing complex sql query and plsql codes (oracle 9i) for Trial Data Extract
• Responsible for the client customization of the product Confidential .
• Analysis & Development of various forms and background processes.
• Prepared and tested the unit test plan and functional testing for the forms and processes.
• Technical assistance to team members and Played a key role in trouble-shooting at critical stages.