SUMMARY

• Work as a highly motivated Oracle DBA with team skills, problem solving skills and communication skills maintaining high customer satisfaction and increasing productivity of the company.

TECHNICAL SKILLS

Tools: Oracle 9i/10g/11g, RAC, Data guard, Streams, ASM, RMAN, EM Grid 9i/10g/11g, expdp, impdp SQL loader, SQL developer, TOAD, SQL, PLSQL, AWR, ADDM, TSM/TDP

Operating Systems: Linux, Unix, AIX, Sun Solaris, Windows 2003

Databases: Oracle 9i, 10g, 11g, SQL Server 2005/2008 R2

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Columbus, OH

Responsibilities:

• Administer multiple Oracle databases including versions 9i, 10gR2, 11gR2
• Administer Oracle 11g Grid control.
• Build Oracle databases, apply patches on regular basis.
• Build SQL server cluster databases.
• Provide day - to-day support to Oracle databases and SQL server 2005/2008 R2.
• Provide support to different application teams.
• Refresh data from production to non-production databases
• Provide support to backup and recovery of databases using RMAN with TSM/TDP.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

• Provide production support for multiple databases non-RAC, RAC, Streams and Grid11g.
• Support database versions 10gR2, 11R2 on Linux servers.
• Do ETL of data from non-oracle sources to oracle tables using SQL loader and automate the process using windows scripts, triggers and transform data using procedures.
• Provide support to end-users from different teams like development, business etc.
• Provide admin support to APEX applications.
• Provide support for security vulnerabilities for the databases.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

• Provide 24/7 on-call support for multi-terabyte databases version 9i, 10g and 11g through Grid10g.
• Provide production support for multiple databases non-RAC, RAC, ASM, Data Guard and Streams.
• Provide support to applications like Retek, WMS, SOA.
• Ensure data and media recoverability by doing RMAN backups on recovery.
• Convert non-ASM to ASM databases and vice-versa.
• Clone Production databases to Development, QA and Training databases based on requests.
• Coordinate with different customers like business users, developers, managers etc for business reasons.
• Load and unload data using data pump, export and import into partition tables.
• Install, configure and maintain Oracle database and Oracle client as business requirement.
• Set up procedure to audit database regularly to comply with the PCI standards.
• Upgrade and apply Critical Patch Updates to databases and oracle software for security reasons.
• Handle databases on multiple operating systems like AIX, Sun Solaris, Unix, Linux, Windows 2003
• Monitor and tune the database using AWR, ADDM, SQL Tuning Advisor for optimum performance
• Write shell scripts and cron jobs against the databases for business reasons.
• Create objects based on customer requirements for project enhancement.
• Partition tables based on business needs for a better performance.
• Worked on complete project/software life cycle and co-ordinate with different teams to complete projects.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

• Doing Oracle DBA Production Support, to make sure the database is available 24/7
• Backup Production, Development, QA and Training databases everyday using RMAN and NetVault.
• Cloning production databases for Development, QA testing and Training based on requests.
• Upgrade database to versions which is compatible for the patch updates.
• Apply CPU to databases of all different versions for security requirements.
• Monitor the database using EM Grid10g.
• Do data pump, export and import for data loading and unloading.
• Trouble shooting any issues and make sure database was available to the developers 24/7.
• Troubleshoot any backup failures and fix the issues and do database recovery when necessary.
• Coordinate with developers and users determine their requirements.
• Work with different team to assist with different projects and cross-functional projects.
• Restore any database based on the requirement of the IT team.
• Create roles, db links, privileges based on the business needs and assign them to the users.
• Do any database installs as well as forms/reports installs as and when required.
• Manage and Administer Business Objects accounts for developers.
• Work on data dictionaries and schemas.
• Document all troubleshooting steps for future reference.