SUMMARY:

• 9+ years of extensive experience as Oracle 11g/10g/9i Database Administrator.
• Experience in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Oracle Enterprise Manager Grid Control.
• Database Design, XML, System Design, Object - Based Design, Data Modeling, PL/SQL, C, C++, UNIX, Windows NT, JAVA, Shell Scripting.
• Extensive experience with Auditing and Security in Oracle and SQLSERVER.
• Expert level experience in installing and Configuring RAC (Real Application Clusters), Data guard, OEM, Oracle Grid Control on various Platforms including Red Hat Linux, Oracle Linux, HP-UX AIX, Solaris and Windows Servers.
• Extensive experience in Performance Tuning (Instance Tuning, Application Tuning, Database tuning), understanding proven techniques for Oracle health checks, optimizing SQL and optimize the SGA.
• Experience in installing and configuring ASM for Multiple Node RAC and Standalone Databases.
• Experience with implementation/upgrade/support of Oracle EBS R12 and Oracle Database 11g environments
• Experience in Migrating Sql Server 2000/2005/2008 to Oracle Using OMWB, Sql Developer.
• Experience as a Production/Development/Engineering/Data Warehouse DBA with Multi-Terabyte 24x7/large databases.
• Expert level knowledge in PL/SQL Programming (Writing stored procedures for Packages, Implementing functions, triggers, collections).
• Excellent knowledge in working with Physical & Relational models of the database in a development environment/multiple environments.
• Experience with implementing Oracle security features such as encryption and VPD- virtual private database
• Expert level experience in Database backups, user-managed backup/RMAN-managed backup with or without catalog, Cold and Hot backup.
• Experience in cloning the databases from production to DEV and UAT environments
• Experience working with Oracle Performance tuning tools like Statspack, AWR, ADDM, ASH, Explain Plan, SQL*Trace, Tkprof, indexing correctly.
• Experience in applying CPU, interim patches on standalone & RAC Environments.
• Experience with Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.
• Experience with STREAMS AND GOLDENGATE Configuration and replication.
• Performed database tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning.
• Experience in Data Loading using SQL * Loader, External Tables and Exp & IMP.
• Experience in latest features like Data Pump, Flash-Back Recovery, Recycle Bin and Transportable Table spaces.
• Experience with setting up Oracle on Virtual machines with both Oracle Linux as well as Red Hat Linux.
• Experience in ORACLE Database administration including Partitioning large tables, capacity planning, space management, Rollback segments and Undo segments, User Management, Password Management
• Experience with Java in all Health care and Insurance applications.
• Experience in shell scripting and scheduling jobs using cron, DBMS JOBS, DBMS SCHEDULER.
• Impressive Experience in Health care, Insurance, Banking and Workforce management sectors.
• Good communication skills with the great demonstration skills, team player and highly professional, with a commitment towards excellence.

TECHNICAL SKILLS:

Database Admin: Oracle 12c/11g/10g/9i/8i; SQL Server 2008/2005; Oracle TimesTen

Backup: RMAN, Symantec NetBackup, Exagrid, Datapump

High Availability: Data Guard, RAC, ASM, Grid Control, Database Mirroring, Log Shipping

Replication: Data Guard, Streams, Transportable Tablespace, Materialized views

Diagnostic & Monitoring: Oracle Grid Control 12c Rel3/11gR2, DB Control, Idera Diagnostic Tool

Benchmarking: NeoLoad, Swingbench

Data Modeling: Erwin Data Modeling, Toad Data Modeler, SQL Developer Data Modeler

OS: Linux - Red Hat, Oracle; Unix- IBM AIX, Solaris, HP-Unix

Hardware: IBM Power Machines, Dell Servers, EMC machines, Windows Server, SAN storages, RAID controller (PERC)

Virtualization: VMware ESX 3.5, VSphere 4 and Oracle Virtual Box

Languages: Oracle SQL, PL/SQL, Transact SQL, PRO*C, Shell Scripting, Java

Development: Oracle Forms and Reports, PRO*C, Servlets and JSP

Application: Telecommunication - Billing, Quality Management - Trackwise, Analytics Marketing - Catalog Management System, Health Insurance - Pulse, HIPAA Financial - OTCNET

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle Database Administrator

Responsibilities:

• Involved in 24x7 support for production database with on-call pager .
• Successfully implemented oracle 10g grid control in different environments.
• Experienced in handling database issues using OEM as well as command prompt.
• Up-gradation and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Successfully implemented 10g RAC on nodes for high availability.
• Experience in Working with RAC Databases.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.
• Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.
• Experience in maintaining with high available databases.
• Loads databases, reorganizes as necessary, and assists in monitoring database performance
• Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.
• I along with team implemented physical standy database using Datagaurd.
• Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Maintaining security of databases and users.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Installation and configuration of Oracle Client software and Tools.
• Written SQL scripts to monitor tablespace and extent growth.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints

Environment: Red Hat Linux, HP -UX 11.31, Solaris, MYSQL,Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0,SQL DEVELOPER

Confidential, Wilmington, DE

Sr. Oracle Database Administrator

Responsibilities:

• Primary Database administrator for several retail application customers.
• Worked as team member to provide 24/7 on call production database support.
• Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Physical Standby Database Replication. Refresh of Database or schema and applications for development and testing purpose.
• Created Wallet on RAC databases.
• Created stored procedures and packages to in corporate business rules for prepaid and postpaid billing.
• Physical design and Capacity planning of key customer databases.
• Mentoring junior Oracle DBAs and offshore coordination experience.
• Documenting the installation, switchover, and failover procedures for Data Guard and Knowledge transfer to offshore DBAs
• Upgraded from 10g to 11gR2 with Golden Gate as the downtime is very less, also configured extract and replicate features.
• In the process of switching the database from primary to standby, Golden Gate Replication should also be migrated from primary to standby.
• Installation and support of Production databases on 11gR2 with ASM and RAC on Red Hat Linux
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• Experience in Data Modelling concepts like Data Vault and also in Advance security like DB Auditing, Labeling.
• Installation of Oracle Grid Control 11g on Red Hat Linux.
• In the process of switching the database from primary to standby, Golden Gate Replication should also be migrated from primary to standby.
• Installation and configuration of Golden Gate
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Implementation of Oracle Data Guard solution for creation of physical standby database on ASM for all production instances in Kievstar.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Setup Golden Gate parameter files for extraction and replication.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Physical design and Capacity planning of key customer databases.
• Performance tuning of Data warehouse reporting application thru creation of materialized views and partitioning of some of the customer tables.
• Installation of Oracle Grid Control 11g on Red Hat Linux.
• Upgrade of some key production databases from 10g to 11g.
• Moving of key production databases to new servers on SAN storage.
• Developed shell and RMAN scripts for level 0, level 1 and archive log backups for customer VOX (part of French Telecom)
• Troubleshooting issues in live customer databases and finding root cause analysis.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• Performed Export/Import through Data Pump.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management

Environment: Red Hat Linux 5.6, Oracle 10g/11g, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2008, Toad and SQL Developer, VNC server, NETAPP Manager, RMAN, ORACLE Streams, Golden Gate and Data Guard.

Confidential, MI

Oracle/SQL Server DBA

Responsibilities:

• Implementing RMAN incremental update backup.
• Refresh of model and development databases from production using RMAN cloning.
• Recovering client production database from data block corruption.
• Implementation of Oracle Data Guard solution for creation of physical standby database for all production instances.
• Tuning database and resolution of performance issues using ADDM, AWR, ASH reports, SQL tuning and access advisors, tkprof traces and explain plans.
• Supporting production releases and builds.
• Installation of PSU 10.2.0.4.3 which includes Oracle Jan2010 CPU update in production environment.
• Daily support for production issues and tuning and production rollout changes.
• Primary Oncall support for production databases in 10g and 11g.
• Supporting Oracle databases on Lawson in 11g.
• Configured Verities Net Backup R3.2 is to automate the physical Backup of the Database.
• Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
• Checking the Alert Logs of production Databases for any errors reported by Oracle.
• Creating maintenance plan for SQL server databases.
• Restoring development database data from production in SQL server
• Creation of reporting databases using log shipping.
• Deployment of change control in both oracle and sql server databases.
• Installation of SQL Server 2008 R2 on Windows Server 2008R2 64 bit.
• Optimization of queries using execution plans, tuning advisors and tracing,
• Implementation of Disaster recovery using database mirroring and log shipping.
• Implementation of maintenance plans for backup for all production and development databases.

Confidential, Dallas, TX

Oracle/SQL Server DBA

Responsibilities:

• Installing Oracle10g for production in Red Hat Linux machines.
• Coding shell scripts for optimizer statistics collection, RMAN and export backup in Red Hat linux environment.
• Implementing RMAN incremental update backup.
• Refresh of model and development databases from production using RMAN cloning.
• Recovering client production database from data block corruption.
• Migrating application databases from Windows 2003 to Red Hat Linux environment using RMAN CONVERT Database.
• Migrating database from windows 32-bit to 64-bit environment.
• Implementation of Oracle Data Guard solution for creation of physical standby database for all production instances.
• Replication of data from Production to Model using Oracle Streams
• Tuning database and resolution of performance issues using ADDM, AWR, ASH reports, SQL tuning and access advisors, tkprof traces and explain plans.
• Supporting production releases and builds.
• Rebuilding entire linux server in a very important production environment after file corruptions, including installation of OS, creating logical volumes using Red Hat Linux LVM, installation of Oracle software, application of patchset 10.2.0.3 and recreation of all application databases from tape backups, completed within 24 hours.
• Daily support for production issues and tuning and production rollout changes.
• Primary Oncall support for production databases.
• Partitioning key production databases for easy manageability, space saving and performance enhancement.
• Tuning queries for application using index compression, partitioning and indexed views.
• Implementation of maintenance plans for backup for all production and development databases.
• Supporting all production and development databases.

Confidential, NJ

Oracle DBA

Responsibilities:

• Prepared SQL and PLSQL scripts to set up business data as per requirement for BDAP application.
• Stress testing database packages and procedures for evaluation of performance in MODEL environment.
• Taking initiative in meeting development team on weekly basis, helping in troubleshooting performance issues, reviewing PLSQL package codes, tracing the code to detect waits and bottlenecks.
• Involved in tuning Oracle database packages and SQL statements using explain plan and tkprof utilities. Benchmarking top DB time/buffer gets consuming SQLs in Performance environment.
• Deployed database changes in staging, UAT and Production environments.
• Troubleshooting database performance using AWR and ADDM reports.
• Restoring Dev/QA databases from Production environment data using Oracle Data Pump.
• Perform migrations of programs and database changes between Development, QA and production environments and supporting change controls.

Confidential, NJ

Oracle DBA/ Developer

Responsibilities:

• Creation of database schema and setting up of database security.
• Tuning of Oracle database packages and stored procedures with autotrace, explain Plan and tkprof utility in conjunction with SQL tuning and SQL access Advisory utilities of ADDM.
• Actively involved in data modeling aspects of different subject areas of application projects.
• Installation of 10g databases in production on IBM machine
• Installation and configuration of Oracle 10g on Red Hat 3.0 ES in MODEL environment.
• Creation of databases and templates using DBCA and SQL scripts and related parameter file configuration.
• Administering and configuring Oracle network environment using Oracle Net, Net Configuration Assistant and lsnrctl utility.
• Planning and implementing Backup and Recovery of the production database using RMAN.
• Restoring Dev/QA databases from Production environment data using RMAN.
• Assists with impact analysis of any changes made to the database objects.
• Proactive Database monitoring using ADDM.
• Installation and configuration of Quest Foglight on UNIX system.
• Coding database triggers and database packages in PLSQL for auto precertification and authorizations for back end validations and in corporation of business rules and constraints. Wrote the entire database package in PL/SQL, over 5000 lines coded. Also coded the database package in PL/SQL for notification of admission.
• Programmed various adhoc reports for maintenance and quality management in Oracle SQL, PL/SQL and PRO*C. The clients are NY Attorney general and CT Department of Health. Extensively coded many Batch jobs in Korn Shell. Scripting. Documented the release definitions in Lotus Notes along with the Program Request Changes (PCR) whenever required.
• Main Coder/application DBA in carewise Project for 24/7 Oxford On-call Replacement. Coded 10 forms (On-Call Entry, On-Call Review, admin, etc) in Oracle Forms 6i. Coded 7 reports (Fax Summary report, Open Action Report, etc) in Oracle Report 6i and coded batch reports (On-Call Extract, Women health call extract) in K-shell and Oracle SQL.
• Coded various PLSQL scripts for extracting data (~ 5 million) for data warehouse load
• Coded Java applications in JSP and Servlets using Iplanet Application Web Server for HIPAA.
• Programmed several utility, business and data action classes in Java for Shared Service in HIPAA. Main developer for building 10 response pages in JSP for pre-certification, referral and notification of admission authorizations.
• Programmed the Open Action and End of Day Reports in PRO*C.