Candidates About

• Over 7 years of IT experience managing oracle databases on Linux, Solaris and Windows
• Hands on experience in Oracle 10g,  11g, 12c, RAC, OEM, 12c cloud control, Data Guard, Exadata, partitioning, RMAN Skilled in setting up/Installation
• Strong physical and logical Data Guard skills.
• Upgrade databases from 11g to 12c.
• Experience with new features of 11g R2 which includes SQL Access Advisor, SQL Performance Analyzer, SQL Plan Manager, Table compression enhancement, Active Data Guard, Query Result Caching, and Invisible Indexes etc.
• Managed database on Exadata
• Migrated databases to half rack Exadata machine.
• Worked on SQL Server 2008 and SQL Server 2012.
• Administered and worked on 11g grid control and 12c cloud control
• Installed Data Guard from scratch
• Implemented hot backups and recovery procedures using RMAN.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Created and managed role-based security to restrict or permit users according to their database usage
• Applied one off, CPU and PSU patches.
• Installed RAC from scratch on Linux.
• Build and maintained on Data Guard and ASM
• Experienced in maintaining large databases
• Experience in installing, configuring and maintaining Standalone and RAC databases
• Supported 24/7 mission critical huge databases.
• Worked extensively on Oracle Upgrades, Migrations and Patching.
• Experience in migrating from SQL to Oracle, Replications, and Clustering.
• Experience with installing and maintaining Oracle Grid Control.
• Installed and configured 11g RAC on LINUX platform with ASM disks for storage.
• Experienced in RAID, storage technologies and backup solutions
• Experience on Oracle Support processes for technical requests through Metalink.
• Supported the system 24x7. Ability to work beyond regular hours.
• Implementation and using of Oracle 11g new features like Data Pump, ASM, Flash Back Technology, Transportable Table spaces and Automatic Workload Repository.
• Implementation ADM disk, Data Guard, and RAC.
• Worked on 12c Database Migration.
• Cloned databases using RMAN Duplicate
• Refreshes database objects using export/import and Data Pump.

SAC Communication - Seattle, WA                                               

Jan 2015 to Present

Production Support Database Administrator

Responsibilities:

·         24x7x365 administrative support staff.

·         Refreshes Database / schemas using Data Pump.

·         Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.

·         Responsible for installing and configuring Golden Gate on Oracle Servers.

·         Database migration from 11g to 12c.

·         Designed, configured and maintained backup/recovery policies including RMAN backups.

·         Written shell scripts to monitor databases.

·         Involved in 24x7 support for production RAC databases with on-call pager

·         Supported production, development and testing databases of Multi Terabytes DB sizes.

·         Maintain and Administer SQL Server Databases on Windows Server VM

·         Applied Patch’s to Oracle 11g, 11g tested.

·         Upgraded Oracle 11g (10.2.0.4) to 11g R2(11.2.0.3)

·         Moved Oracle Databases between two HP-UX Servers using the Cold Backup.

·         Installed Oracle Enterprise Manager Grid Control 10.2.0.5 on Windows Server and configured the same with the other Oracle Databases.

·         Created and configured Oracle Enterprise Manager Grid Control Repository Database.

·         Monitoring Oracle Databases and SQL Server Databases using Oracle Enterprise Manager and SQL

·         Experienced with SRVCTL, OCR and Voting Disk of 11g RAC

·         Strong physical and logical Data Guard skills.

·         Handled RAC Node hangs and node eviction issues.

·         Maintaining schemas and partitioning tables.

·         Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.

·         Configure and manage tablespaces, tables, and users for custom applications.

·         Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area

·         Creating and dropping of users, granting and revoking permissions to users/roles as and when required.

·         Worked on Space Management and Security.

·         Rebuilding of Indexes for better performance and maintenance of Oracle Database.

Groupon - Minneapolis, MN

April 2012 to December 2015

Oracle DBA

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 11g and 11g clients/databases on Solaris and Linux.
• Complete Build of 4-node 11g RAC Cluster on RHEL 4 from scratch.
• Migrated 11g database to 11g R2.
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Migration of Databases and applying patches whenever required.
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Implemented the Security using Oracle Database Vault
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Experienced with Space Management and Security.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Installed, Migrated, configured and tested Oracle 11g databases in various environments.
• Worked on Active-Active Data Guard.
• Managed Standby with Data Broker.
• Install and configure Oracle GoldenGate
• Configuration, troubleshooting GoldenGate issues

Medtronic Inc. - Minneapolis, MN

Jan 2010 to March 2012

Oracle DBA

Responsibilities:

• Planning, Implementing and validating various versions of Oracle Databases to 11g Release 2 (10.2.0.1, 10.2.0.2, 10.2.0.3 and 10.2.0.4) & 11g Release 1(11.1.0.6, 11.1.0.7) upgrades on all the environments.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Worked as part of a team and provided 24/7 support when required.
• Maintenance of installed Oracle database and supporting multiple production, development and test instances of varied complexity including Multiple Tier and RAC environments.
• Worked on the RAC environment for the high availability managed by ASM.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and 'rewind' entire database to a particular time respectively.
• Handled database migration from Solaris to Linux.
• Installed, configured and performed the maintenance of SQL Server. 
• Implemented Replication using Streams and Proficient in using TOAD and Oracle Enterprise Manager (OEM).
• Expertise in database installation, configuration, development, security implementation, back-up and recovery (Oracle import / export utility, SQL* Loader) and performance tuning by using SQL Trace / TKPROF / Explain Plan.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN, recover and test the backups regularly.
• Created Unix Shell scripts to automate database operation.

Bachelor in Computer Science,

Ambedkar University