SUMMARY

• 12 years of IT experience in which 9 years of DBA experience includes (Oracle 12c, 11g, 10g 9i and SQL SERVER DBA 2012 and Postgres DBA) in SAP, Banking, Pharma, Insurance and FMCG domain.
• 3 years experience in SAP platform for oracledatabase using Brtools for backup, brachive, rebuilding indexes and other support for databases on SAP.
• Experience in Oracle Installation, Oracle Upgrade, Cross platform Migration, Database configuration and Administration, Backup and Recovery, Tuning, Stand by database/data guard setup, and troubleshooting of various Oracle Products/versions on different platforms covering Redhat Linux, HP - Server and Sun Solaris.
• Experience in DBA Lead- Poject Lead for various Technical Projects on SAP Platform
• Familiar wif ITIL Processes - Incident Management,Change Management etc
• Security Compliance Experience
• Experience in Performance Tuning using AWR and ADDM.
• Oracle Enterprise Manager
• Experience in performing database upgrades from 11g to 12c, 10g to 11g and applying latest patches & releases.
• 11g features like Data pump, Flash-Back Recovery & Recycle Bin.
• Oracle 11g, 10g Installation, Configuration and Creation of Oracle databases.
• Experience in Oracle DR - Standby database creation
• Experience in Oracle Data Guard (11g) configuration & management
• Experience in RMAN backup design and implementation
• Managing Database Structures, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges and Database Auditing.
• Database design including creations, modification, and deletions of table spaces, data-files, rollback segments and schema's, Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and users).
• Administer Microsoft SQL 2005, 2008 and 2012 database environments
• Experience on Always on database administration
• Windows patching in cluster environment
• Familiar in Oracle Data Warehouse environment.
• Unix Shell Scripting for automating teh DBA tasks
• Experience in implementation of OEM tools for database administration and monitoring.
• Hands on experience in oracle 10gFLASHBACK to provide fast and easy recovery at database, table, row and transaction level.
• Knowledge of asset, Incident and change management software BMC remedy.
• Hands-on experiences in Oracle 11G enhance features such as Flashback Data Archive, RMAN Data Recovery Advisor, and 11g DATAPUMP.
• Installation of SQL Server 2005,2008 & 2012 in cluster and non-cluster environment
• Oracle Enterprise Manager (OEM) for configuration and monitoring multiple instances.
• 10gFLASHBACK to provide fast and easy recovery at database, table, row and transaction level.
• Oracle 9i Certified Professional OCP-DBA
• Oracle Golden gate noledge

TECHNICAL SKILLS

Operating systems: Sun Solaris-8,9,10, HP - UX 10.x/11i, Redhat Linux, AIX, Windows

Databases: Oracle 12c/11g/10g/9i, MS Sql server 2000,2012

Case Tools: Sql * Loader, OEM, Toad, Golden Gate, PL SQL Developer

Hardware: HP-UX, Intel PC, Sun Ultra Sparc, IBM - AIX

Tools: & Utilities: SAP BRTOOLSExport/Import, Sql * loader, Server manager, OEM, Sql*net, quest toad, RMAN, RAC 11g, DGMGRL SRVCTL, CRSCTL, AWR, top, sar, tkprof, strace

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Responsibilities:

• Database upgrade from 11.2g to 12c
• Database refresh from prod to UAT, ST and other environments
• Database monitoring for space management, growth and archive logs
• Deployments for applications break fix, new build/releases
• Implementing DCRs
• Resolving alerts
• Managing application - creating users, granting privileges.
• Consulting to Application team for issues, database design, implementing new features..

Confidential, Rochester, MI

Lead DBA

Responsibilities:

• Maintaining existing 11.2.0.3 databases
• Managing Security Compliance - at database, user, and data level by granting appropriate privileges to user, data dictionaries, creating roles, data masking and encryption.
• Setting up password policies and managing teh user profiles.
• Familiar wif database valut
• Backup and restore as per requirement
• Support to development team
• Performance of SQL queries
• Designing of new schemas in BI environment

Confidential, MN

Lead DBA

Responsibilities:

• Design and architecting teh backup policies using BRBACKUP, BRARCHIVE
• Integration of RMAN using Brtools
• Testing all backup/restore scenario.
• Training to teh team for RMAN usage on SAP
• Writing RMAN scripts for automation of jobs.
• Flashback Implementation.

Confidential

Oracle DBA - Lead

Responsibilities:

• Define strategies
• Planning
• Execution
• Documentation
• Risk analysis
• Post upgrade Issues Resolution
• Coordination wif Oracle support and SAP support for any issues or help.

Confidential

Team Member

Responsibilities:

• Creation of standby database using rman
• Configuration of data guard - setup
• Testing of standby database
• Documention
• Training

Confidential

Team member

Responsibilities:

• Installation of Grid Infrastructure
• Oracle Installation
• PSU Patching on RAC systems
• Database Creation
• OEM Configuration

Confidential

Lead DBA

Responsibilties:

• Managing Security & Compliance - at database, user, and data level by granting appropriate privileges to user, data dictionaries, creating roles, data masking and encryption.
• Setting up password policies and managing teh user profiles.
• Existing system study for performance issues
• Monitoring Performance for specific reports using AWR and DBMS advisors
• Debugging slow running jobs and suggesting performance improvement creating/rebuilding proper index
• Regular server monitoring using top, sar,iostat
• SQL query tuning using hints, advisors, execution plans and wait events.
• Presentation on Performance to developers community