PROFESSIONAL SUMMARY:

• Over 8 years of IT experience and 7 plus years of Oracle RAC DBA experience
• Build, Managed and Administered 11g and 12c RAC.
• Worked as a lead in Data Center Consolidation on large database systems.
• Mentors the team on technology concepts and ensures team compliance to best practices for design
• Participates in code and design reviews to ensure quality and conformance to product standards
• Helps motivate team members to get the best out of team.
• Worked as a Primary support for database related issues with clients.
• Worked on multiple projects in parallel to daily DBA activities.
• Worked extensively on ASM Builds and management of ASM Filesystem.
• Implemented Disaster Recover Site with Data Guard, and maintained Active Data Guard.
• Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Worked on Oracle Materialize Views, Oracle Golden Gate and Oracle Active Data Guard.
• Build 12c OEM Cloud Control and managed OMS and OMR.
• Configure 11g Active Data Guard.
• Managed databases on Exadata.
• Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
• Build and administer SQL Server 2005 and 2008 standalone and cluster databases.
• Provided analysis to other teams and keep them informed for better resource management.
• Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
• Build, configured and managed 8i to 12c databases.
• SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management and Database replay
• Table compression enhancement,
• Worked with Network team for SCAN listener
• Build and managed container and pluggable 12c databases.
• Worked on Upgrade projects.
• Worked on Migration projects.
• Participated in design, document and deployment of database/
• Provides technical assistance for a number of platforms, during issues and/or outages. Areas include but are not limited to Oracle, Peoplesoft, homegrown monitoring applications, operating systems, hardware components and the network infrastructure.

TECHNICAL SKILLS:

RAC: Upgrades (10g 11g and 11g 12c)

Dictionary Tables: SQL Server

Data Guard: Migrations

Dynamic Views: Log shipping

ASM: 12c Database Administration

Performance Tuning: Linux, OEL, RHEL, CentOS

Silent Install: Backup and Recovery

SQL Tuning: Windows, AIX, Solaris

RMAN: Storage Management

Instance Tuning: VMware, Oracle Virtual Box

RAT: Oracle GoldenGate

Rolling Upgrades: Table Partitioning

Exadata: 12c Cloud Control

Shell Scripting: Export Import, Data Pump

ASH Report: Baselines, Outlines, SQL Profiles

AWR report: ADDM Reports

SQL Advisor: RAC OneNode

SQL Plan Management: Table Compression

Replication: Materialize Views

Exadata: OMA, OMS, OMR

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. Oracle DBA

Environment: 12c, RAC, Data Guard, GoldenGate, SQL Server

Responsibilities:

• Upgrade to 12c
• Build New Servers
• Migration of database to new Data Center
• Get requirements from App/Dev team and coordinate migration efforts with various teams
• Migrate databases from non - ASM to ASM.
• Migrate database from VMware into 12c multitenant as pluggable databases.
• Build 2-node RAC cluster.
• Build new 13c OEM.
• Setup oracle GoldenGate and migrated databases using Oracle GoldenGate.

Confidential, IL

Lead Oracle DBA

Environment: e-commerce, Oracle RDBMS, RHEL

Responsibilities:

• Managed Sabre Database along with day to day RDBMS support.
• Installed Oracle 12c and managed container / pluggable databases.
• Manage Oracle 10g, 11g and 12c RAC and non-RAC databases
• Resolve various CRS, ASM, and Cache Fusion related issues in RAC databases
• Build GoldenGate replication for migration project.
• Used oracle dictionaries to resolve various performance related issues.
• Handling of Database technical escalations and telephonic support / remote support.
• Installed ASM instance and migrated from non-ASM to ACFS file system
• Configuration of Oracle Data Guard
• Build 12c OEM Cloud Control and managed OMA, OMS and OMR
• Build ASM Configuration
• Worked on Migration project.
• Configuration and testing of RMAN backups
• Subject Matter expert for 12c Cloud Control
• Provided analysis and technical assessment document facilitating the migration of data center.
• Provided test plan documentation for Oracle 10g to Oracle 11g.
• Build multiple 2-node11g RAC Cluster
• Build Data Guard and Active Guard.
• Use of ASH and AWR reports to diagnose performance issues.
• Provided Automated Storage Management (ASM) technical assessment document.
• Provided architecture document for the ASM including for
• Worked with storage team to build ASM
• Upgrade of ASM from Oracle 11.2.0.2 to Oracle 11.2.0.3
• Configuration and installation of VM Ware in Oracle 10g and Oracle 11gR2 environment.
• Configuration of VMWare and installed Oracle and SQL Server databases.
• Installation and configuration of Oracle 11R2 client and database
• Worked with Offshore team
• Worked with Materialize Views.
• Worked on many performance issues.
• Performed SQL and Instance Tuning.
• Performed Various RMAN restores and recoveries.
• Performed refreshes using export import and data pump.
• All work completely documented.
• Perform daily database administration as required.
• Solving problems related to extent allocation and database connectivity.
• Support client with on-call rotation.
• Applied CPU / PSU patches
• Installed 12c Databases
• Upgrade database from 10g to 11g to 12c.
• Written shell scripts to automate jobs.
• Support databases on VMWare

Confidential, IL

Sr. Oracle Lead DBA / Sr. Systems Engineer

Environment: e-commerce Oracle, MSSQL, MYSQL Databases on RHEL4 U5, Windows.

Responsibilities:

• Managed a team of 4 DBAs while working on all other regular DBA and project activities. These activities include managing and troubleshooting High Availability multi node Real Application Cluster, SQL Server Administration, Microsoft system engineering with other day to day Database Administration tasks like analyzing current structure, proposing new DB architecture/structure, refreshing DB/schema/tables from production to non-production databases, suggesting and applying one off/CPU patches.
• Build 2 and 4-node 11g R2 Real Application Cluster on RHEL 5.
• Upgraded 10gR2 to 11g R1 to 11g R2 on standalone and RAC.
• Troubleshoot RAC issues with SCAN listener, olsnode, crs stat, crs register, crs unregister, crsctl check crs, crsctl check cssd, crsctl check crsd, crsctl check evmd, crstctl stop, crsctl stop, srvctl nodeapps, crsctl status, ocrconfig, etc.
• Installed 10g databases and Clients on RHEL and other win/*nix platform.
• Configure ASM packages on Linux.
• Installed ASM disks.
• Manage ASM diskgroups via ASMCMD and database control.
• Managed multi (2, 4, and 5) nodes RAC cluster.
• Multiplex OCR and Voting Disk to different location for higher availability.
• Add and delete node in RAC environment.
• Reconfiguring Services via srvctl utility
• Set up and administered Oracle GoldenGate uni/bi-directional replication.
• Worked with Oracle to solve multiple RAC issues.
• Troubleshoot connectivity issues and solved listener configuration.
• Worked on various Unix Administrators tasks to troubleshoot new 2 Node RAC cluster.
• Configure and installed Database Control.
• Managed Agents for Database Control monitoring tool.
• Troubleshoot OEM repository
• Worked on sysman credentials to troubleshoot OEM connection issues.
• Manage security and grants for database users.
• Created Materialize Views on a remote host to refresh multiples times in a day.
• Responsible for writing shell scripts to automate tasks.
• Responsible for managing daily full backups.
• Recovered corrupted blocks from backups.
• Use of Opatch for quarterly security patches and other patches for database.
• Created profiles from grants and privileges.
• Export / Import using DataPump.
• Refreshing tables/schemas/databases from production to non-production. on a regular basis.
• Upgraded 8i to 9i, 8i to 10g R1 to 10g R2.
• Use AWR and ASH reports to pinpoint the wait events
• Used statspack reports to compare snapshots with good response time with bad response time.