SUMMARY

• More than 15 years of experience of system and database management and programming languages. Strong team player and be able to work alone. Highly self - motivated and able to adapt and learn new technologies quickly.
• Oracle Database Administration, HP UNIX Administration, Oracle apps DBA experience with specialization in ERP, Clinical Data Management System, telecom inventory system (Cramer), Fare Collection and Insurance
• Implemented ASM in Unix and Linux
• Experience in installation, configuration, partition implementation, performance & tuning.
• Experience with RMAN, Oracle Enterprise Manager (OEM), Grid control. Installation and Configuration of Oracle 11g, 12c and 19c Real Application Clusters (RAC)
• Implemented Physical (Data Guard) and Logical for RAC and non RAC. Cloning of Database, Backup and Recovery strategy using RMAN and User Managed.
• Created and implemented project and resource planning databases migration from 11g to 12c and 12c to 19c RAC and non RAC databases in Linux environment.
• Experience in database security strategies by creating database Implemented & monitored daily, weekly and monthly batch jobs.
• Experience in setup DR sites.
• Identify areas of improvement in current applications and come with a roadmap to address them. Get business approval, and work with vendor management.
• Executed end to end activities from knowledge transition to moving into steady state.
• Configured and supported Guidewire products (BC & PC)
• Implemented Oracle Security (Auditing, TDE,DATA Masking and ACL )
• Golden Gate implemented to replicate production data to report server
• Hands-on experiences and outstanding troubleshooting skills to setup, configure, monitor and maintain Oracle 11g /12c /19c RAC/ASM/Data Guard environments.
• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold/hot backup, full/incremental backup.

TECHNICAL SKILLS

RDBMS: 11g/12c Oracle RAC.

Operating Systems: Redhat LINUX, HP-UNIX, Sun Solaris.

Storage: ASM,EMC, NFS

Oracle DB Tools & Monitoring: OEM, Golden Gate

Monitoring: OEM 13c

Data Replication: Oracle GoldenGate and logical standby database

Other Tools: VISIO, TFS,VSS,JIRA, Shell scripting, Jenkins, GitHub

Big Data: Hive, Sqoop, Spark, Python

Cloud: Knowledge AWS

PROFESSIONAL EXPERIENCE

Confidential, CA

Solution Architect

Responsibilities:

• Perform complex design, maintenance, enhancement, testing, implementation.
• Analyzed and solution provided for 19c upgrade process.
• Implemented automation for deployments for the applications and databases.
• On complex projects, act as the solution architect with responsibility for delivering the Architectural recommendations and the high-level design.
• Contributes to the definition of Confidential IT technology direction, standards and roadmaps across one or more business or technical domains.
• Consult with the business where opportunities arise/are found.
• Provide design guidance across a range of system and application technologies, ensuring solutions are aligned with the enterprise architecture vision and meet with technical standards.
• Reviewed TDD and provided solution.

Confidential

DBA Manager

Responsibilities:

• As a senior member of Oracle Advanced Technical support group, provide advanced technical support to enterprise DBA team on Oracle database related technologies such as Golden Gate, Streams, RAC, upgrades, migration, Performance Tuning, Backup and Recovery, RMAN, Partitioning, Oracle Enterprise Manager, SQL, PL/SQL, Code review and optimization, Materialized views, Flashback, troubleshooting, Data pump, RDBMS security, VLDB, optimize server resource utilization etc.
• Mainly work on Performance tuning. Working with primary DBAs in the DB support team, support the mission critical databases and Data Warehouse production databases. Working as one key member of the technical resources pool to support the Front-Line Support On-Call team according emergence requirements and issues.
• Participated in analysis and designing of Oracle database Server for infrastructure and related projects. Assisted in integration of Guide Ware applications into current IT actionable events and solutions.
• Primary technical resources in SQL tuning in Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Software and firmware maintenance of the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support.
• Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 12c RAC environments .
• Implemented Oracle GoldenGate 12c in mission-critical production environments.
• Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Maintenance of production database and development database which includes table space management, user creation, and privileges, roles. Support RMAN backup and recovery including physical backups and logical backups by using data pump (Export/Import) tool. Extensively develop and maintain Bash shell scripts.
• Implemented automate refresh, deployments scripts using shell
• Analyzed and applied PSU patches
• Upgraded databases from 11g to 12c.
• Implemented Oracle Security (Auditing, TDE,DATA Masking and ACL )
• Involved in licensing activities, capacity planning and recommendations for database software and architecture including infrastructure optimization
• Worked on Sev1, Sev2 issues and providing 24x7 On-Call Support and provided on-call and day-to-day support.
• Analyzing the technical risks to move databases and applications into AWS
• Working on estimations to move databases into AWS
• Working on POC to move into AWS.

Confidential, Atlanta, GA

Senior Oracle DBA

Responsibilities:

• Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting.
• Architecting, planning, designing, developing, deploying and supporting Oracle 10g/11g R2 RAC/ASM environment.
• Installing & configuring Oracle 11g Cluster ware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of Clusterware).
• Worked with customer for different RAC related issue: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on. Troubleshoot performance issues for the RAC instances (GC events).
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle Cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking and flash recovery area.
• Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning. Implement Production Control and Change Management.
• Provide expertise and make recommendations for physical database design, architecture, testing, performance tuning, and implementation of Oracle database.
• Handle daily database operation performance issues (track and trend overall database performance and database area, index, and drive performance). Recommending application code changes (processing strategies, queries, use of Oracle10g/11g new features).
• Analyzed and applied PSU patches
• Plan and Design Backup/Recovery solutions using shell scripts and RMAN. Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.