SUMMARY:

• 7+ years of experience as Oracle DBA on 10g, 11gR2 database servers with high availability.
• Has extensive experience working as an Oracle DBA which includes experience in 10g, 11g, ASM, Data Guard and RAC. Combined with large database/dataset and oracle database security.
• Build RAC Clusters from scratch.
• Worked on fresh Oracle 10g and 11g R2 database server installs.
• An accomplished Database Architect with Control to Cloud Control 12c for reduced downtime and better Performance Set up alert notification for space issues thru OEM Cloud Control 12c Administer, manage and configure various database versions such as 9i, 10g, 11g via OEM Cloud Control 12c environment.
• Upgrading 10g Grid Control to Oracle Enterprise Manager 12c
• Deploying the 12c Management Agent on Windows using the 12c Cloud Control
• Installed and Configured Oracle Enterprise manager OEM 12C and 11g Grid Control.
• Possess strong Linux skills.
• Used with Grid Control, DBConsole and scripts for monitoring database and database servers.
• Used RMAN and user managed backups for Backups/Restores.
• Used RMAN Duplicate database to clone.
• Used Export Import / Data Pump, DBLinks for data movement.
• Experience in writing Shell and SQL Scripts.
• Experience in setting up cronjob.
• Created and managed role - based security to restrict or permit users according to their database usage.
• Oracle RAC Good knowledge of Flashback technology in Oracle 10g.
• Experience with Oracle Data Pump restoring and managing databases across multiple environments.
• Installation, upgrade, configuration, administration and maintenance of very large Oracle data bases on most flavors of Unix namely Sun Solaris, AIX, HP-UX, Linux and also on Windows 2000/NT/XP servers.
• Performed Database Migrations.
• Performed Database Upgrades.
• Worked with Storage Admins for carving out partitions for datafile systems.
• Worked with SAN, NAS for ASM disks.
• Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.
• Involvement with physical and logical design of database.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Experienced in Database Security Administration using roles/grants.
• Familiar with Fine Grain Access Control.
• Created Data Guard for RAC and standby servers.
• DBA support for databases with a large number of users located all over the world.
• Planning, Testing, Performing and Monitoring Database Backup and Recovery, RMAN.
• Experience with Materialize Views.
• Strong experience in OEM (Oracle Enterprise Manager) and TOAD.
• Understanding of UNIX Shell scripts to automate business process and daily backup.
• Hardworking, result oriented, enthusiastic, good interpersonal and communication skills.
• Worked with Developers during Deployments.
• Worked on instance tuning as per the best practices.
• Identified root cause of performance issue using ASH, AWR, ADDM, SQL Advisor, tkprof, execution plan etc.

TECHNICAL SKILLS:

Operating Systems: RHEL, HP-UX, Windows, Sun Solaris.

RDBMS: Oracle 10g R2, 11g R1/R2.

High Availability: RAC, Data Guard.

Languages: SQL, Java, C, PERL, UNIX Shell, T-SQL

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, DBMS, Stats.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Oracle DBA

Responsibilities:

• Responsible for new Installations of Oracle RAC, ASM, OEM on 10g, 11gR2 under SLES 11 (SUSE Linux Enterprise Server), Windows, RH Linux,
• Performed Installation, Configuration and Monitoring of Oracle 12C, on AIX, Linux, UNIX and Windows environments.
• Deployment of 12c Cloud control OEM.
• Upgraded and patched existing Oracle homes.
• Plan for new Servers/RAC Databases to host databases that are as big as 3 Terabytes in size.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Implementation of Oracle Golden Gate from Oracle 10g database to 11g database
• Responsible for installing and configuring Golden Gate for Oracle using 11g R2.
• Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary - Managed Tablespaces, and Temporary Tablespaces.
• Used exp/imp, data pump and dblinks to move the data
• Worked on standard and enterprise edition of the Oracle RDBMS.
• Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.
• Worked on schema Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases
• Installed, Migrated, configured and tested Oracle 9i databases in various environments
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design).
• Hands on experience with setup and configuration of Weblogic 12c and EM 12c.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases
• Migration of system and applications from Oracle 9i to 10g.
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.
• Worked on setup and configuration of Fusion Middleware components Oracle SOA, WebLogic 12c, IDM and EM 12c.
• Experience in cross platform Golden Gate Replication (Oracle to Teradata, Oracle to MS SQL SERVER).
• Involved in SQL programming language by using Pro*C.
• Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
• Experience with System Administration of RMS.
• Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Worked on setting up Physical Standby Data Guard environment for Prod & non-prod databases.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Automating the backup processes using shell scripts.
• Hands on experience with Lotus Notes application deployments, upgrades, and changes.
• Build clusters and added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Export and Import of User, Tables and Database using exp/imp and Data Pump.

Environment: SQL, SQL*Plus, Oracle 9i, 10g, 9iAS; Sun Solaris Unix, Linux Windows XP, Oracle Forms 10g, Oracle Streams Oracle Reports 10g, Oracle Developer, OGG (Oracle Golden Gate).

Confidential, South Rockwood, MI

Oracle DBA

Responsibilities:

• Interfaced with client on daily basis.
• Used specific relational database management system structure and technology to create and maintain physical databases. Worked with Oracle 9i and 10G databases.
• Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
• Installed and configured database management system software.
• Developed and implemented backup and recovery strategies.
• Implemented capacity planning for databases.
• Served in an administrative role regarding database privileges, security, and migration.
• Developed policies and procedures for system operations to better serve clients.
• Presented database management solutions to internal clients
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Responsible for quarterly patching and bug fixes.
• Installing, Monitoring, Upgrading Oracle 9i/10g/11g.
• Created Physical standby Data Guard.
• Configured Data Broker Configuration for Data Guard database.
• Practiced switched over and failover for Disaster Recovery.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production
• Supported multiple accounts on versions 9i to 11g
• Installation of Oracle 11g, 10g, 9i under Windows, RH Linux, Sun Solaris and Upgrading to new versions and applying patches as required.
• Install, tune and configure complex clustered database environments. Creating Database, Tablespaces, Rollback Segments etc.
• Create and maintain users, roles and privileges.
• Installed and configured Oracle Grid control.
• Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
• Performed Online/Offline database backups.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Involved in DB Security, Audit and Risk Management of DB systems.
• Implemented backup strategies, which involved taking an incremental backup and enabled the block change - tracking feature.
• Involved in monitoring the lock and latches processes, releasing locks in case of resource blockage and gathering statistics.

Environment: SQL, SQL*Plus, Oracle 8i, 9i, 10g, 11g; RHEL, AIX, Windows NT/2000, HP UX, TOAD, Grid Control, OEM, SQL Developer

Confidential, Schaumburg, IL

Oracle DBA

Responsibilities:

• Supported and maintained Oracle 9i/10g & SQL server 2000/2005 databases.
• Created databases for Production, Development and ITG environments.
• Installed OEM agents on several databases
• Configured databases and monitored of all the databases using
• Oracle Enterprise Manager (OEM) 10g grid control.
• Production support for Oracle databases 9i/10g and SQL Server 2000/2005.
• Designed and implemented DTS packages in SQL server
• Created scripts for the daily regular monitoring of the databases
• Created shell scripts to automate different database jobs
• Worked on Alloy Tickets to troubleshoot Oracle database related issues and also TSS upload & download issues
• Upgrading and patching the 9i/10g databases.
• Performed logical backup using export/import and data pump utilities
• Configured the RMAN backup
• Carried out hot backup, cold backup and RMAN backup
• Creation and configuration of Standby Database (Data Guard)
• Loaded the different formats of data into Oracle using SQL Loader.
• Supported data cleansing project which cleaned up all invalid country codes in production databases
• Supported upload/download application, which involves export of some tables from corporate database to show site databases and once business process completes at show site database, data would be imported back to corporate database.
• Troubleshoot listener.ora, tnsnames.ora and SQL*net issues between corporate & show site databases.
• Performance Turing via OEM, IGINITE, STATSPACK/AWR for 9i/10g
• SQL Tuning using Explain Plan, TKProof with SQL trace, SQL Tuning Advisor I/O tuning Via OEM, STATSPACK
• Supported development teams on design and implement different database objects
• Provided full technical support to various application teams before the databases go to production.
• Restored & recovered some of the show site databases when they got corrupted.
• Perform Backups and Recovery, maintain 24 hours uptime for the database

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql*Loader, Import & Export, Data pump, Data guard, RMAN, AWR, ADDM, Stats pack, ASM, TOAD, Shell scripting, AIX etc.