SUMMARY:

• An Oracle DBA with 7 years of IT experience in Oracle (11gR2, 10gR2) 11gRAC, 10gRAC, 12c installation, upgrade, designing, backup, recovery, migration
• Performance tuning, streams, data guard, golden gate etc. in a variety of environments like UNIX (Solaris, HP - UX, AIX), LINUX & Windows NT 4.0/2000/2003 in production, test as well as development databases. Oracle DBA Lead (2 Years)
• Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality Assurance phase, development and production support activities.
• Been a Team Lead on two projects: Upgrade(12c) and Dataguard configuration
• Performed FLASHBACK features to handle efficient database recovery.
• Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.
• Adept at installation of OEM Database Control, 12c OEM grid control and Deploying Agents
• Having hands on experience in Hot/Cold Backup, Recovery of databases using RMAN with VERITAS Net Backup.
• Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top SQL Sessions and tuning them.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and ANALYZE command.
• In - depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.
• Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.
• Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.
• Configure non-CDB database into pluggable container database.
• Experienced in performing ROLLING UPGRADE in a 12c environment using the DBMS ROLLING package.
• Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.
• Successfully developed and implemented Client/Server applications on multiple platforms. Actively involved in software development, implementation, software maintenance, software support, troubleshooting, documentation, training.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks
• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and Automatic Segment Space Management (ASSM).
• Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, pinning objects.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
• Bulk loads and data migrations (using SQL*Loader, data pump import/export) in a 12c multitenant environment.
• Unix shell scripting (Korn shell) and Windows command prompt (.bat & .cmd)
• Expert in RMAN backups including full, incremental and cumulative.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Experienced in loading data from flat files using SQL Loader and External Tables.
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Monitoring & Reorganizing Tablespaces/Tables/Indexes.
• Skilled in using tools such as SQL Developer and TOAD.
• Replication (materialized views, Data Guard(snapshot), Golden Gate)
• Experienced with Red Hat enterprise Linux.
• Experience with Oracle E-Business suite R12 application.

Databases: Oracle 9i, 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, NETCA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy, Oracle GoldenGate, Oracle RAC installation

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Oracle DBA/ System security

Responsibilities:

• Performed Installation of Oracle DB software for grid infrastructure and single instance on 12c in a Virtual Environment on RedHat Enterprise Linux Platforms and Created Oracle Container and pluggable Databases on these servers.
• Providing all round DBA support to resolve Application and DB outage on prod, dev, test and staging environment across the globe.
• Configured and managed OEM 12c for the Oracle Database Servers.
• Support application and professional services to manage data ranging from GB to TB in oracle databases, solving of space problem, data loading problem.
• Worked on project to build and managed 3 and 2 Node RAC and ASM to ensure high availability and business continuity.
• Performed system security by preventing direct access to data(TDE), auditing database activities, controlling SQL Input (audit vault and database firewall) and Masking sensitive data. Authenticating and authorizing both local and common user in 12c multitenant environment
• Replicate and refresh data from one database or OS to another by using RMAN, Oracle Golden Gate, Oracle Data Guard, Data pump, DB link, Database cloning.
• Worked on installing and managing Data Guard on RAC database for disaster recovery, reducing down time, reducing data loss and setup the data guard broker.
• Use RMAN to perform Database backup, PITR, Flashback, full recovery ..
• Performing day to day database administration tasks like table/FRA space usage, checking alert log, trace files, monitoring disk usage, table/index analyze jobs, database backup, applying patches and perform DB upgrade. Rebuilding invalid indexes and recompiling invalid PL/SQL codes in 11g and 12c Databases.
• Database turning proactively and reactively reclaiming table space, generate STAT, generate explain plans, AWR for long running queries, creating indexes, address lock issues ect in 12c multitenant environment.

Confidential, Schaumbury, IL

Senior Oracle Database Administrator

Responsibilities:

• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Used DBUA to upgrade from 11.2.0.3 to 12.1.0.1
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech - Test in Needs Assessment
• Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance, assessment and evaluation
• Managed a Team of 5 DBAs for the configuration of Dataguard
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in applications in creating Packages, Functions, Procedures, Triggers and Indexes.
• Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX Database sizes range from 4GB to 2TB (in ODS & EDW environments).
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases ( 10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11)
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 11g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Application of Oracle software patches when/where necessary.
• Backup/Recovery monitoring and reporting using Oracle RMAN
• Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.

Environment: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLANCap

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP - UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 11.2.0.2 and 11.2.0.3, 11.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Environment: Oracle 11.2.0.1, HP-UX 11, Sun Solaris 11.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Junior Oracle DBA

Responsibilities:

• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Configured DATA GUARD, DGMGRL and Recovery catalog.
• Create oracle databases ( single instance ) on configured servers using both the DBCA & Database creation scripts.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 11g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

Environment: Oracle 10.2.0.1, Oracle 11g, RMAN, Datapump, SQL