SUMMARY

• Oracle certified Professional with over 10 years of experience as a Database Administrator Oracle and seeks to achieve the zenith in my career by working with innovative professional skills with equal dedication and positive attitude, assuring high standards of efficiency with the best of abilities in a challenging environment.
• Extensive experience on 7X24 Production environments for large databases using database solutions such as OEM, RMAN, data guard and Oracle Goldengate.
• Area of expertise include high availability, space management, capacity planning, backup & recovery, disaster recovery, database performance tuning, memory tuning, PL/SQL objects tuning, security administration, table partitioning and Oracle standby server.
• Deployment, installing, maintaining and upgrading Oracle Goldengate (Single and Bi - directional).
• Analyzing, solving and creating solutions for challenging performance tuning situations. All standard database administrative tasks, such as: proactive performance tuning, load testing, monitoring and profiling, trouble-shooting, back-up and recovery, partitioning, replication, installations, capacity planning and configurations on an as needed basis as well as applying patches and upgrades.
• Implemented Oracle database tuning and administration including security management, table space utilization, schema object management, database capacity planning, bottlenecks and offensive SQL activity monitoring and resolution.
• Consulted with senior management to determine production infrastructure requirements, boundaries and priorities of new projects, and to discuss system capacity and equipment acquisitions.
• Oracle implementation, planning, designing, installing and maintaining Databases (11g, 10g, 9i) on multiple nodes (RAC and clustering) on Sun solaris, Linux, HP.
• Experience with Oracle automatic storage management (ASM), dataGuard, and oracle upgrade 9i to 10g / 9i to 11g.
• Full life cycle experience on software projects with a strong process oriented approach.
• Applied family and critical patch update (CPU), and individual patchsets software upgrade for Oracle database servers and application servers.
• Enhanced and improved performance by tuning includes indexing, compression, drive distribution, load-balancing, replication, setup and maintain accounts, access levels, and security.
• Evaluated and recommended new database software, utilities, and tools and set the strategy for implementing new technologies.
• Designed logical and physical databases for data warehouse and OLTP systems.

TECHNICAL SKILLS

Languages: Oracle 8i/9i/10g/11g, Unix scripting (ksh, tcsh, sh, perl), Oracle PL/SQL

Databases: Oracle 11g, 10g, 9i, 8i, Oracle RAC, Teradata, Oracle Timesten, Windows NT, Essbase 9.3.1/11.1.1.3

Oracle Tools: Oracle Enterprise Manager (OEM), Oracle Universal Installer,Database Configuration Assistant (DBCA), RMAN, TOAD, SQL developer, Exceed On demand, Precise, Statspack, Export/ImportVeritas NetBackup, Oracle Goldengate, Clarify, Foglight, Nagios.

Microsoft Tools: MS Office Suite MS Visio, MS Excel, MS Word, CSV files

Specialization: High Availability, Standby Databases, Clustering, Automatic Storage Management (ASM) and Configuration, Disaster Recovery, Oracle Goldengate

Environment: UNIX, Sun Solaris, MS-DOS, Linux Itanium, Linux 64-bit, HP-UX, Windows

PROFESSIONAL EXPERIENCE

Confidential, PA

Lead Oracle Database Administrator

Responsibilities:

• Setting up of Oracle 11g databases with RAC and non-RAC.
• Installation of Oracle RAC 11g.
• Maintaining and configuring Oracle RAC databases.
• Maintained, configuring and implementing ASM diskgroups.
• Developing and implementing disaster recovery (DR) plan.
• Deploying latest CPU release patchset to the oracle database.
• Configuring Oracle Goldengate for databases with RAC/non-RAC.
• Configuring disaster recovery environment for production databases through GolgenGate.
• Implemented Oracle Goldengate monitoring to perform regular checks on the lag and checkpoint.
• Upgrading Oracle Goldengate to the latest version.
• Configuration of daily monitoring scripts required in the maintaining Oracle databases.
• Implementing flash recovery area for RMAN backup and archivelogs for Oracle cooked file-system and ASM disks
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN and VERITAS Netbackup.
• Performing daily and incremental level of backup through RMAN.
• Implementing automated logical backups for the schemas available in the databases using export and datapump utility.
• Scheduling and maintaining Oracle and application jobs.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Performance tuning for CRM product.
• Unix shell scripts for major dba activities.
• Supporting UAT for development and testing purposes.
• Providing 24*7 Supports.
• Suggesting the best practices like Index rebuilding, gathering statistics etc for improved performance.
• Creating various users and maintaining system level security including controlling the access to the database.
• Calculated current growth and planned future growth with the changes in the database system.
• Assisted report writers in query performance tuning as requested and helped in identify inefficient queries and suggest alternatives.

Confidential, TX

Lead Oracle Database Administrator/Infrastructure Administrator

Responsibilities:

• Worked as an application as well as production database administrator.
• Performance tuning involves AWR reports, tkprof, precise tool.
• Experience in partitioning objects.
• Worked on creating Unix shell scripting.
• Expertise in managing database jobs and implementing them.
• Experience in troubleshooting and managing the jobs failures
• Performing backup and recovery through RMAN and BCV.
• Providing 24*7 Support for critical databases
• Production upgrade for Oracle Database from Oracle 9i to oracle 11g.
• Application Patch upgrade for CRM and other products.
• Identified the high CPU utilization, long running and offensive queries and advised development team to modify the queries accordingly.
• Training and mentoring other team members on Oracle and other database administration skills.
• Proven ability to work well in a crisis and under pressure.
• Develop documentation and other materials to support ongoing database development, change control, production maintenances and DBA tasks.
• Coordinate testing with other development groups and operations. Identify appropriate level of testing and ensure that testing is complete before signing off.
• Improved performance tuning using statspack, explain plan, sql trace,tkprof,awr, and addm reports..

Confidential, IL

Senior Oracle Database Administrator

Responsibilities:

• Creating and implementing database backup and recovery procedures (RMAN).
• Determining the Oracle RAC architecture
• Choosing the RAC servers and hardware
• Configuring the ASM devices for the databases
• Installing and maintaining the Oracle RAC databases
• Worked on Oracle parallel servers
• Automated Oracle daily jobs with the unix shell scripting

Confidential, Hoffman Estates IL

Senior Oracle Database Administrator

Responsibilities:

• Creating and Implementing database backup and recovery procedures (RMAN).
• Determining the Oracle RAC architecture
• Choosing the RAC servers and hardware
• Configuring the ASM devices for the databases
• Installing and maintaining the Oracle RAC databases
• Worked on Oracle parallel servers
• Automated Oracle daily jobs with the unix shell scripting
• Creating and updating the Metalink support service requests with the ongoing Oracle issues.
• Implemented and supported a multi-byte data warehouse database
• Supported Oracle developers with the PL/SQL performance
• Created database alerts scripts, monitoring scripts
• Gathering statistics and creating unix scripts to compress
• Implemented role bases security procedures.
• Full life cycle experience on software projects with a strong process oriented approach.
• Implemented Oracle database tuning and administration including security management, table space utilization, schema object management, database capacity planning, bottlenecks and offensive sql activity monitoring and resolution.

Confidential, PA

Senior Oracle Database Administrator

Responsibilities:

• Manage and support production environment, Oracle 8i, 9i.
• Database creation, setup, configuration and maintenance.
• Creation of LMT and DMT tablespace on production server.
• Performing the re-organization of the database objects.
• Performing the re-organization of the tablespaces on the production environment.
• Oracle data guard and standby databases experience.
• Creating, maintaining and monitoring physical and logical Standby databases.
• Rebuilding indexes.
• Managing cron-tab file.
• Restoring the archive logs as required for diagnostics.
• Performed de-fragmentation.
• Creating and implementing database backup and recovery procedures (RMAN).
• Creating and implementing database hot back-up using RMAN and disk-based backup.
• Generating log-mining reports according to the requirements.
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Managing users, privileges and granting Roles to them for the application requirement.
• Managing rollback segments.
• Cloning/Restore the databases for the various applications as and when required.
• Patch upgrade.
• Proactively monitored the database's health and taking preventive or corrective action as required.
• Recommend changes to increase efficiency, or improve accuracy and timeliness of application systems.
• Developed some Unix shell scripts to automate database operation and database monitoring for all the production databases.
• Monitor and tune database performance including SQL tuning.
• Knowledge Oracle’s Enterprise Manager (OEM), stats pack reports, explain plans, and sql Trace.
• Perform tuning Confidential the instance level via adjustment of init.ora parameters, sizing of the SGA and other appropriate measures.
• Lock monitoring.
• Query optimization.
• Creation of Unix scripts for daily basis production database monitoring.
• Maintaining databases in archive and no archive log mode.
• Providing 24*7 Support for critical databases.
• Interacting with Oracle Support.
• Weekly Status call with entire team (Onsite and offshore team).
• Daily updates via emails.

Confidential, Richmond, Virginia

Senior Oracle Database Administrator

Responsibilities:

• Creating and updating the Metalink support service requests with the ongoing Oracle issues.
• Implemented and supported a multi-byte data warehouse database
• Used Teradata technologies like fatsload, multiload, tpump to load the data.
• Supported Oracle developers with the PL/SQL performance
• Created database alerts scripts, monitoring scripts
• Gathering statistics and creating unix scripts to compress
• Implemented role bases security procedures

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Involved in designing the production architecture for the Confidential .
• Installing Oracle Client and Software.
• Creating, implementing the Timesten databases.
• Experience in Unix Shell Scripting.
• Creating Oracle Database, designing various schemas.
• Experience in Oracle RAC upgrades.
• Routine Major Dba activities and providing the automation strategies.
• Configuring backups and verification.
• Maintaining oracle databases with Raw Devices/file systems.
• Knowledge of FR/RB in Timesten database.
• Performance Tuning Confidential various levels (involving Statspack, AWR, Tkprof).
• Supporting the UAT for the development/testing teams.
• RAC Configurations and implementation.
• Providing 24*7 Support for critical databases.
• Experience in partitioning.(Range, hash partitioning of Index organized tables).