EXPERIENCE SUMMARY:

• 6+ years of experience as Oracle DBA, providing 24*7 support of development and production 12c/11g/10g multi terabyte databases on Various Platforms.
• Expert in high availability technologies such as Oracle 9i/10g/11g/12c RAC, ASM, and Data Guard/Standby Database.
• Excellent experience in Installation and configuration of Oracle 12c, 10g, 11g in UNIX/LINUX and Windows environment.
• Implemented strategy for partitioning and management of historical data tables.
• Proficient in performing day to day DBA activities like creating schemas, users and table spaces management, performing export and Import, Loading flat file data using SQL loader, Creating DB links, Materialized view creation, index creation and fine - tune queries.
• Planned and implemented DR & high availability solutions using Oracle Data Guard, Golden Gate and RAC.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC.
• Designed and implemented Oracle Real Application Clusters (RAC) on Linux for an OLTP application with Transparent Application Failover.
• Experience in Installation, configuration of Oracle RAC, implemented 2 node RAC environments for a 1TB database.
• Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Planned and implemented high availability solutions using Oracle 10g and 11g RAC, Standby Database using Oracle Data Guard (Physical as well as Logical).
• Proficient in using Oracle Enterprise Manager (OEM), Quest TOAD and Oracle SQL Developer.
• Backup of Databases (Creating Backup Schedules based upon Business Strategy: Daily Backup, weekly Backup, merged backups etc.)
• • Created and tested some features of Oracle 12c multitenant database
• Create and manage Physical Backup/Restore using RMAN with various backup tools like TSM, DDBoost and Avamar
• Fine-tuned the database objects and server to ensure efficient data retrieval.
• Performed Flashback technologies like Flashback Database, Flashback Query and Flashback Table
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, buffer Pool hit-ratios
• Captured long running SQL/runaway queries using AWR, ADDM and advise for restricting of SQL.
• Performed Switchover/Failover Testing for New Build Oracle RAC and Oracle Data guard Clusters
• Configured Oracle Secured LOB and Partitioning of Tables like range, hash and list
• Upgraded the database from Oracle 10g to 11g using DBUA, Manual and Silent Upgrade methods
• Worked and large scale database's transactions and done drill trough and drilldown reports using OEM 12c reporting services like Information publisher reports and BI reports
• Dealt withIncident/Problem management with third party tools like Remedy, Infra and Service Manager
• Developed Server Build, DB Instance check Scripts, Automated Checklist for New Instance/DB, Migration and Upgrade
• Supported Data Modelers for reviewing table structures
• Managing Storage using Oracle ASM by creating/dropping Diskgroups using asmca, asmcmd and sql syntax for ASM
• Migrated/UpgradedTB size levelsdatabases.
• Database Migrations and Table compressions along with its automation.
• Sharing knowledge and extending help and suggestions for various issues faced by team members.
• Designing and loading Oracle Inventory.Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top Sqls/Sessions and Tuning.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and ANALYZE command.
• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• 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.
• 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 (snapshots/materialized views)
• Bulk loads and data migrations (using SQL*Loader, data pump import/export)
• Unix shell scripting (Korn shell) and Windows command prompt (.bat & .cmd)
• Expert in RMAN backups including full, incremental and cumulative.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g

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, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

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, Chicago, IL

Oracle Database Administrator

Responsibilities:

• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• 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).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Application of Oracle software patches when/where necessary.
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Backup/Recovery monitoring and reporting using Oracle RMAN
• Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
• 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).
• Tested and qualified 11g new features for setting up 11g standards for database creation and configuration. Qualified installed procedures for 11g.
• Designed and implemented database backups and Recovery strategies using RMAN, Datapump Export/Import, Cold, Hot backups
• Used SQL*Loader to map and load large amount of data into Oracle Data warehouse from legacy systems. Responsible for data scrubbing, cleansing and data integrity.
• Perform technical reviews for logical and physical database designs. Used Erwin for creating logical and physical data models.
• Frame standards and security guidelines for the database implementations as part of Infrastructure DBA group.
• 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).
• 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.

Tools: Used: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Chicago IL

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Performance Troubleshooting using different oracle tools AWR, ASH, ADDM and SQL Tuning Advisor, SPM and SQLT etc...
• Troubleshooting operational issues and documenting detailed resolution steps in ticketing system.
• Diagnosing database server performance issue using commands like top, sar, iostat, prstat, mpstat, vmstat and OSWATCHER.
• Optimizer statistics collection using DBMS STATS package and Optimizer tuning using relevant init.ora parameters, Hints, SQL Profiles and SQL PLAN MANAGEMENT (SPM).
• Tuning SQL statements using Explain Plan, Execution Plan and SQLT tool.
• Successfully performed migrations from Oracle 10g to 11gR2 RAC (Real Application) Database.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption (TDE) for compliance related databases.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• 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 10.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.
• Performance Troubleshooting using different oracle tools AWR, ASH, ADDM and SQL Tuning Advisor, SPM and SQLT etc...
• Troubleshooting operational issues and documenting detailed resolution steps in ticketing system.
• Utilized 11g new features like Real Application Testing (RAT) and Database Replay (DB Replay) to validate database performance on new Hardware.
• Diagnosing database server performance issue using commands like top, sar, iostat, prstat, mpstat, vmstat and OSWATCHER.
• Optimizer statistics collection using DBMS STATS package and Optimizer tuning using relevant init.ora parameters, Hints, SQL Profiles and SQL PLAN MANAGEMENT (SPM).
• Tuning SQL statements using Explain Plan, Execution Plan and SQLT tool.
• 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.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, PA

Oracle Junior 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.
• 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 10g 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.

Tools: Used: Oracle 10.2.0.1, Oracle 11g, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN