SUMMARY:

• 12 years of IT experience in which9 years of DBAexperience includes (Oracle 12c, 11g, 10g 9i and SQL SERVER DBA 2012 and Postgres DBA) inSAP, 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 with ITIL Processes - Incident Management,Change Management etc
• Security Compliance Experience
• Experience inPerformance Tuningusing 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 Scriptingfor automating the DBA tasks
• Experience in implementation of OEMtools 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 softwareBMC 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 knowledge

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, Princeton, 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

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 the user profiles.
• Familiar with database valut
• Backup and restore as per requirement
• Support to development team
• Performance of SQL queries
• Designing of new schemas in BI environment

Confidential, Mills MN

Lead DBA

Responsibilities:

• Design and architecting the backup policies using BRBACKUP, BRARCHIVE
• Integration of RMAN using Brtools
• Testing all backup/restore scenario. to the 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 with 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

Confidential

Team member

Responsibilities:

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

Confidential

Lead DBA

Responsibilities:

• 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 the 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
• Security Management
• Capacity planning.
• Quarterly Patching.
• Ad-hoc SAP Refresh the systems.
• DBA on call support.
• Writing Technical Documentation.
• OPL (One Point lesson), Dbrief of the Projects including regular technical documents.
• Cross Platform Database Migration from UNIX to LINUX REHL with ASM.
• Installation of Grid Infrastructure for ASM.
• Installation of Oracle 11.2.0.3
• Migration of databases using EXPDP and Transportable tablespace feature.
• Enabling RMAN backup for all the setup.
• Enabling Flashback for all the databases.

Environment: Unix, Linux, Oracle 11.2.0.3, oracle 10.2.0.5

Confidential, Boston MA

Oracle DBA

Responsibilities:

• Performance Tuning - Query tuning
• SQL Plan Management- baseline
• Refresh the databases from Prod to DEV /UAT as and when required.
• Monitoring Space Management and resolving the same by adding space, removing defragmentation and rebuilding the indexes.
• Environment build for BJ’s Peoplesoft Application Upgrade
• Database Monitoring and consultancy for Conversion Process.
• Performance Tuning/testing code for 11g
• SQL Tuning using hints/AWR Reports/(SPM) SQL Plan Management
• Patching the Database
• Managing Security Compliance - at database, user, and data level by granting appropriate privileges to user, data dictionaries, creating roles.
• Setting up password policies and managing the user profiles.
• RaisingTAR for Critical issues.
• Rebuilding of Indexes
• Sanity check

Environment: Oracle 11g on AIX.

Confidential

System analyst

Responsibilities:

• Regular DBA activities and support for production and development team.
• Installation of Oracle 10g Server/client
• Installation of MUREX Server/Client
• Configuration of UAT/Production environment for different applications
• Installation of Oracle, Creation of database, schema.
• Backups
• Maintaining stand by database
• Space Management

Confidential

Team Leader

Responsibilities:

• Scheduling the shifts, Resource balancing across regions Mumbai, Banglore etc., Resource capacity evaluation against the current and future workload.
• Monitoring the SLAs andthe team performance against SLA’s
• DB Upgrade / Patching (Schedule Activity)
• Database administration and Maintenance.
• Database Creation/Copy.
• Database Migration.
• Databases reorganization.
• Monitoring of databases.
• Monitor DB down
• Managing the Schedule Activity (e.g. Mass Upgradation)
• Client facing, interaction for weekly/daily status update, handling high severity issues PR (Problem Record) and resolution after root cause analysis.
• Identify requirements or new skills requirements for team members and plan their
• Production support for the SAP clients on different databases includes:

Environment: Oracle on unix, windows, SQL server.

Confidential

DBA Support

Responsibilities:

• DBA support to all the databases placed in Confidential
• Database administration and Maintenance.
• Database Creation/Copy.
• Database Migration.
• Administration and production follow-up (capacity planning, rebuild of index, analysis.)
• Monitoring of databases.
• Support of the application development teams, related to database.
• Automation of DBA activities.
• Co-ordination of database administration tasks among team.
• Co-ordination with Oracle Support for some critical issues in database, which cannot be fixed locally.
• Interaction with the client as well as world wide DBAs through T-con.

Environment: Oracle 10.2.0.5 on unix

Confidential

Responsibilities:

• Designing Methodology for the project.
• Implemented complex business logic
• Writing procedures to find out the violation of constraints according to new database
• Writing scripts for insertion of corrected data
• Testing for migration
• Making final Documentation & Reports
• Client Interaction for implementation of corrected data.

Environment: Oracle 9i on unix

Confidential

Team Leader

Responsibilities:

• Marketing Research on Women in Engineering:

Environment: Programming in FOXPRO 2.6.

Confidential

Team Leader

Responsibilities:

• Enhancement, Maintenance and Support of CNG Database in the existing Application.

Environment: Programming in FOXPRO 2.6.