SUMMARY

• Over 7 years of experience as a Database Administrator in various fields like communications, finance, banking on different flavors of UNIX (Solaris, HP - UX) with Oracle (9i, 10g, 11g).
• Install configure and deployment of Oracle 11g database and Real Application Cluster (RAC) on different nodes with ASM (Automatic Storage Management) on RHEL and HP-UX.
• Exposure to Oracle 12c Database.
• Good experience in Installation and configuration of Oracle CDC.
• Good experience in SQL, Shell Scripting, Data modelling, Logical and Physical Database design, Backup and Recovery procedures.
• Experience in using various administration tools like OEM, TOAD, Putty, SQL Developer and performing data migrations using Export/Import utility.
• Migrating NON-ASM databases to ASM using RMAN.
• Excellent knowledge in Hot, Cold and RMAN backup. Recovery and cloning of databases using RMAN.
• Experience in using 10g/11g DATAPUMP, AWR (Automatic Workload Repository), ASM (Automatic Storage Management), ADDM (Automatic Database Diagnostic Monitor) Grid Monitoring.
• Performed In-place and Out-place patch set upgrades.
• Database Refresh from Production to Development and from Development to Test environments.
• Replication of tables to cross platform and creating Materialized views.
• Good experience in managing troubleshooting skills of Data Replicator.
• Almost 3 years of experience in capacity management.
• Experience in User Management by Granting, Revoking, Privileges according to requirement and Space Management by monitoring and managing Tablespaces.
• Managing Table/Index segments, Rollback Segments, Undo Segments and Constraints.
• Performance tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Keeping the database up to date by applying latest CPU and PSU using OPATCH utility.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Proficient in RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion.
• Configured network components like TNSNAMES, Names Server, Connection Manager etc. For easy and effective management of Oracle networking.
• Documentation of Oracle database operations and training of backup personnel.
• Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Worked as a Team member to provide 24x7 on-call production database support.
• Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently.

TECHNICAL SKILLS

RDMS: Oracle 12 c, 11gR2, 10gR2, 10gR1 and Oracle 9i

Tuning Tools: TKPROF, EXPLAIN PLAN, STATPACK, AWR, ADDM

Packages: E-Business Suite Oracle Applications R12.06, 11i (9i, 10g, 11.5.5-11.5.10.2 )

Oracle Tools and Utilities: Oracle CDC, Capacity Management, Data Replicator, RMAN, EXP/IMP, SQL * Loader, DBVERIFY, STATPACK, AWR, ASH, ADDM, ODM, CELCLI, TOAD, Patch Management, Data Pump, Data Guard.

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Operating System: HP-UX, Intel Xeon, OEL 6, Red Hat Linux, AIX

Personal Skills: Good Analytical Skills and Problem Solving, Goals Oriented.

PROFESSIONAL EXPERIENCE

Confidential, Prussia, PA

Oracle DBA

Responsibilities:

• Migrated databases to Oracle Exadata Database Machine (X3-2) using Data pump, Golden gate, Standby switchover.
• Supported 10g/11g RAC 3 node and 4 node clusters.
• Installed, configured and maintained Oracle CDC.
• Installed, configured and maintained Oracle 12c (12.1.0.2) container and pluggable databases and 11g standalone/RAC databases.
• Periodically refreshed development databases for testing purpose with production data through RMAN and datapump.
• Setting up and configuring Oracle GoldenGate replication on both source and target for zero-downtime migrations.
• Performing Initial load,Online change synchronization,table replication from source to target.
• Configuring Data pump, Extract and Replicate Groups for database migrations and schema migrations.
• Built standby databases using RMAN and 12c cloud control and configured data guard broker.
• Experience in handling the capacity management to ensure that IT resources are right sized to meet current and future business requirements in cost effective manner.
• Experience in handling large database up to 14TB in size with 4 nodes cluster on AIX and Oracle Linux.
• Created and administered ASM instances. Managed ASM disks and diskgroups like adding additional luns for ASM storage, adding disks to ASMdiskgroups.
• Extensively used Oracle Enterprise Manager OEM 12c for grid control for maintaining,monitoring databases and creation of backup jobs.
• Migrated and configured the RMAN backups to Data Domain from tape.
• Performed switchover of databases for DR testing.
• Monitored backups success or failures and corrected issues.
• Performed Database Duplication for both file based and ASM based database using RMAN
• Responsible for identifying performance problems in production databases by identifying issues using AWR, ASH and ADDM reports.
• Applied CPU security patches and PSU in both RAC and standalone systems in ASM environment.
• Database monitoring and performance tuning using OEM 12c cloud control.Worked on database parameters and memory tuning.
• Granted permissions to end users according to their level of access to database objects
• Installed, configured and supported uni-directional and bi-directional replicatedenvironments utilizing Golden Gate 10.x and 11.x software and created manager, extract, replicate trail files. Tested data is flowing fromheterogeneoussource systems to oracle database
• Configured/Upgraded/Migrated/Maintained Exadataenvironment.
• Setting and Monitoring Exadata using 12c
• Excellent experience in maintaining and troubleshooting ExadataCell/Storage an DB Compute node performance issues.
• As per SECURITY MANAGEMENT Worked in claims database on 11gR2 with 2 node Data guard and Tested Switchover and Failover. Resolved system file corruption
• Familiar with different Backup and Recovery strategies, Cloning (using Recovery Manager - RMAN), creating RMAN scripts, VERITAS Net Backup, Export/Import, Data Pump, TTS, and Hot and Cold back-ups and experience with other oracle features like Flash-Back Recovery, ASM, ASH, AWR, ADDM, ASSM, AMM, ASMM, Automatic Undo management.
• Performed cloning using RMAN to set up development and test databases from Production database and Automated the nightly RMAN backups for the Production and some development Databases in Crontab.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Reduced production outages by implementing best practices of patch management, purge/archival, code optimization and applied rolling patches like PSU and CPU on RAC/Non RAC after testing on DEV, QA and UAT.
• Experienced with Oracle Support (raising SR) processes for technical requests through MetaLink Tracked record with documentation of Oracle database operations
• Experienced in BCP (Business continuity process), in identifying Issues and finding out root cause/Analysis/Fix and documenting the procedures for the business units.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Implemented the resizing the online redo logs in production and in standby database.
• Worked on SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace and tuned long running query’s by creating B-Tree and BITMAP indexes.
• Install Oracle administrative tools like OS Watcher and CHM to assist in administration of the Oracle database and its environment.
• Managed and Administrated the SQL Server 2008 production and Non-production servers.
• Configured and worked on SSIS tool to develop data integration and workflow solutions
• Worked on UDB/DB2 databases and worked extensively on creating users, assigning roles, space management and moving code from development to production databases on SOLARIS Servers.
• Worked on (ETL)DATASTAGE and ABINITIO by creating new projects, users, assigning privileges for users on projects, implementing common project settings, moving code by importing and compiling data and worked on unlocking the users and jobs and troubleshooting job design issues.

Environment: AIX 6.1/7.1, Oracle linux, Oracle 10g,11gR2,12c 10g/11g RAC, OEM grid 11g/12c cloud control, TOAD 10.1.

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• Performed upgrade/migrations of databases 10g to 11g.
• Installed and implemented Backup and Recovery procedures, Implemented Hot, Cold, Logical backup.
• Extensive Performance Tuning, Memory (SGA) tuning, Net backup, EMC (Time finder and SRDF), Raw Devices.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Upgraded Oracle Golden gate from 11.1.1.0 to 11.2.1.0.1.
• Used SQL server for ecommerce apps.
• Worked in Automatic Storage Management (ASM) with EMC storage for managing data in SAN.
• Monitoring and Troubleshooting of Database Replication issues with Shareplex and Golden gate dealt with conflict resolution and performance issues.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, Health Check od Databases, analyzing of Tables and Rebuilding of Indexes.
• Load balancing, Database/Schema/Table Re-Organization for faster performance using export/import and Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Data modelling, Database Design and creation usingER-Win, Visio.
• Daily Health Checkup of the database using STATSPACK, AWR, ADDM, TKPOROF.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disasterrecovery, high availability and data protection.
• Creating and dropping of users, granting and revoking rights as when required.
• Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Downsizing and defragmenting very Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Implemented database auditing, data security Remediate high-risk violation in production environment and gathering schema stats and monitoring and index usage.
• Researching errors/issues/bugs which are impacting to performance of the database and recommend permanent solution without losing the performance.

Environment: Oracle 11g, Red Hat Linux 5.X, Solaris 10, Oracle 11g RAC/10g, Toad, SQL-navigator, PL/SQL, SQL*Loader,Oracle 10g, Oracle RAC, Grid Control, Streams, and Data guard, Shareplex.

Confidential

Senior System Engineer/ Database Administrator

Responsibilities:

• Worked as an Oracle DBA (Database Administrator) for the client Astra-Zeneca.
• Six months of rigorous training on Relational Database Management System (SQL, PL/SQL) and Oracle Database Architecture.
• Knowledge of Database Build, Database Migration, Cluster Upgrade, Database Upgrade, CPU Oracle patching.
• Supporting 1200 SQL and Oracle Databases 24X7 including Production.
• Installation of the Oracle and SQL Server to meet client requirements.
• Promoted to the role of Senior Systems Engineer for my outstanding performance and contribution to the Organization.
• Creating and presenting weekly status report to the client.
• Knowledge in Oracle Backup & Recovery, Export/Import, Datapump.
• Conducted Knowledge Transfer sessions for Oracle 12C and enabled a team of 10.