SUMMARY

• Over 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• Over 8 yrs of experience as an Oracle DBA on production / stage /development environments
• Provided end to end administrative support on applications which involves Oracle databases.
• Involved in different scenarios of OLTP as well as ( DSS )Data warehouse databases.
• Configured & Worked on Oracle GoldenGate for replication of databases
• Worked with a team to provide 24x7 on - call production database support.
• Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g and 11g in UNIX/LINUX and Windows environment.
• Installation, patching, updates, configuration maintenance of Oracle 10g RAC, 11g RAC, Standby Databases (DataGuard).
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Management of schemas, objects & Partitioning the tables & indexes.
• Development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and OEM Grid Monitoring.
• Experienced in using Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Experience in Converting 32 bit database to 64 bit.
• Experience in cloning the oracle homes and upgrades
• Working experience on database 10g, 11g upgrades.
• Excellent knowledge in user management, roles, profiles
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases
• Excellent knowledge in Backups and Recovery and Cloning of databases using RMAN.
• Extensive performance tuning experience, SQL Tuning, Database/Instance Tuning.
• Planned and implemented Disaster Recovery & high availability solutions using Oracle Standby Database
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Statspack, SQL Trace, AWR, ADDM, OEM Grid Control custom scripts troubleshooting Oracle databases using SQL trace utilities.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, buffer cache, redo mechanisms.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Experience in replication using RMAN and experience in using OEM, TOAD, Database Migrations using transportable tablespaces, transportable database, benchmarking using load testing tools
• Experienced in database migration across platforms using transportable tablespaces and RMAN.
• Expertise in maintaining Database Security using security compliance auditing (SOX), expertise in loading data from flat files using external tables, SQL*LOADER.
• Worked on different types of storage structures (SAN/NAS).
• Good written and verbal communication skills with a customer service oriented attitude.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Java, Unix Shell Scripting.

Tuning Tools: TKPROF, Explain Plan, Statspack, AWR, ADDM, Grid Control Tuning advisors

Databases: Oracle 8i/9i/10g/11g, Oracle 10g RAC, Oracle 11g RAC

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 2.5/2.6/8/9/10 , AIX 5.1/5.2/5.3/6.1 , Red Hat Linux RHEL 2.1/3.x/4.x/5.x, OEL, MS Windows 95/98/ME/NT/2000/XP/ 2003/2005/2008

Monitoring & Administration: Oracle Grid Control, OEM, Spotlight, OGG

Development Tools: TOAD, SQL Plus, SQL Developer, RMAN, SQL*Loader, EXP, IMP, DataPump (expdp,impdp), VMware, Informatica, Putty

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Providing end to end ( DB) support for the UCM based websites including external and Internal website of IBM.
• Oracle production DBA functions
• Handling high availability (24/7) database on FTS
• Providing standby physical data guard support
• Handling Oracle 11g real application clusters ( 11G RAC -2 node)
• Supporting replication Databases using Oracle GoldenGate
• Handling Performance issues at application level and database level
• Applying regular CPU patches
• Upgrading the databases from 10g to 11g
• Converting 32bit oracle to 64 bit.
• Monitoring the databases using EMGC
• Trouble shooting the user issues
• Handling Service requests
• Cloning databases for testing and development environments using RMAN & Hot backups
• Taking care of regular database activities like space management, gathering statistics, rebuilding indexes, transaction management
• Ensuring database security and auditing
• Configuring RMAN backups
• Tuning Oracle databases at different levels after analyzing statspack report, AWR & ADDM reports

Environment: Sun Solaris 10, AIX 5.3, Oracle 10g, 11g

Confidential, Montvale, NJ

Oracle Data warehousing Performance tuning analyst & DBA

Responsibilities:

• Handling Oracle performance related issues at instance level and SQL level for enterprise data warehouse of 5TB.
• Tuning the Oracle instance, SGA components, DB files etc.
• Tuning the PL/SQL code.
• Tuning at the object level including tables, indexes, views etc.
• Generating AWR report and analyzing the top events and other
• Generating ADDM reports
• Taking the StatsPack reports
• Analyzing the trace files using TKPROF
• Tuning the SQLs with different optimizers ( 9i,10g,11g )
• Training the developers on effective SQL writing
• Scheduling the ETL jobs legitimately on Unix machines.
• Providing on-call support during the crucial periods like ( Yr End etc)
• Co-ordinating with the Unix team, developer, application support team.
• Setting up & managing standby databases (Data guard)
• Working on Data Integration & Replication tools like Oracle Golden Gate
• Configuring Oracle RAC and administering cluster databases and ASM storage
• Monitoring and Managing Oracle databases through Oracle Grid control & OEM
• Addressing day to day DBA activities like adding space to tablespaces, re-org databases, rebuilding indexes, moving tables, taking care of backup & recovery, maintaining archive destinations and gathering statics
• Co-ordinating with Oracle support(meta link) for resolving critical database issues like bug fixing
• Upgrading and Patching Oracle databases
• Cloning Oracle instances for Development & Testing purpose
• Ensuring database security through compliance auditing

Environment: Sun Solaris 10, RHEL 5.4, Oracle 9i, 10g, 11g

Confidential, Rochester, NY

Oracle Database administrator lead

Responsibilities:

• Handling high availability (24/7) database in onshore-offsite model
• Handling Performance issues at application level and database level
• Applying regular quarterly CPU patches and keeping the databases upto date with the Oracle security updates
• Providing support to 10g RAC databases.
• Rolling patching and upgrdades of 10gRAC databases.
• Upgrading the databases from 9i to 10g.
• Cloning the Oracle home and upgrades.
• Creating health monitoring Unix shell scripts
• Scheduling the health scripts using cron tab, mailx.
• Trouble shooting the user access issues.
• Creating User profiles, roles
• Handling Service requests using ITIL tools.
• Working closely with the application teams on scheduling the patching windows.
• Cloning the databases regularly for the reporting databases and stage environments.
• Tuning the database level performance issues.
• Taking AWR reports and analyzing them periodically for better performance.
• Participating in SOX audits and providing the justifications to the corporate.
• Creating SOX level auditing scripts and making the validations and changes as required.
• Creating Backup schedules and taking periodic backups both offline and online using RMAN
• Participating in corporate DR drills and ensuring the data protection.
• Trouble shooting the application server issues.
• Defragmentation of the tables using exp/imp, reorg,shrink
• Working with Oracle on critical database bug/issues.
• Creating process documents for the DBA activities and making sure that team adhere to the process outlined.
• Creating shift schedules
• Maintaining stringent response / resolution SLAs.
• Taking the client requirements and working closely with the business teams on their requirements and providing the solutions
• Creating partitions for partitioned tables periodically
• Managing materialized views and refreshes
• Creating DB links to heterogeneous environments for the data warehouse
• Periodic index management, index rebuilding.
• Training Junior DBAs on DBA activities

Environment: Sun Solaris, Oracle 10g, 9i, 8i

Confidential

Consultant Oracle DBA

Responsibilities:

• Involved in Database Installation, preparing backup strategies, performance monitoring and capacity planning of the database.
• Upgraded database from 9i/10g on Sun Solaris using Database Upgrade Assistance (DBUA) and manual upgrade method.
• Writing UNIX shell scripts to automate daily routine tasks like performing backups, monitoring memory usage, CPU usage, tablespace usage etc.
• Performed hot backup and cold backup, also developed backup strategies using incremental and cumulative backup methods using RMAN.
• Developed scripts to monitor the space usage, fragmentation of data and auditing database logins.
• Performed logical database imports/exports using the exp/imp, Datapump utilities and also loading data from external sources into oracle database using SQL Loader.
• Extensively used Explain Plan with SQL trace and TKPROF to identify and tune the poorly performing query.
• Performed database migration from oracle 9i to 10g.
• Extensively used Crontab and DBMS JOB to automate the monitoring jobs.
• Performance tuning by doing Partitions of large table and Created Indexes by analyzing and rebuilding of Indexes for better performance.
• Expertise in UNIX environment and shell scripting with excellent knowledge in batch Jobs using UNIX CRON, Shell Script (csh, bash, ksh)
• Used STATSPACK for database tuning and database performance.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.
• Provided troubleshooting and problem solving support to ETL developers with Informatica tool.

Environment: Oracle 10g/9i, Red Hat Linux 4, Sun Solaris 9

Confidential

Jr. Oracle DBA

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used Statspack, Perfstat, TKPROF, AWR, and ADDM utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: ORACLE 9i, UNIX AIX 5.1