Database Administrator Customer Support

Mina Desai

609-***-**** ***********@*****.***

Summary

• 18+ years of professional experience in Oracle DBA (12C/11g/10g/9i/8i) having administration, production rollout, installation, configuration, upgrades, CPU patches, OS patches, cloning, migration, tech refreshes, capacity planning, shell scripting in UNIX, Sun Solaris, Windows 2000/NT.

• Experienced with MS SQL on managing database objects, install and configuration, DR testing on cluster Environments, support database deployments and configure Shareplex replication

• Experienced in Installing and configuring ASM, 12c pluggable multi-tenant RAC for high availability databases

• Troubleshoot Database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), SQL TRACE, TKPROF and Explain Plan.

• Goldengate installation, configuration and administration on oracle RAC 11g and 12c. Configured Shareplex bi-directional replication among three data center

• Supported disaster recovery testing using switchover, failover and snapshot physical standby and supported RMAN backup with or without recovery catalog

• Experienced in Database design including creation, modification, and re-org of tablespaces, data-files, and user maintenance.

• Responsible for day-to-day activities involving database monitoring, user management, user’s ad hoc requests, space management, Cronjob email-alert checks, and Rman backup log checks. Technical Skills

• Oracle 11g RAC Database installation, administration and upgrade

• Oracle 12c Database installation and administration

• Oracle 19c Database installation on ODA and administration

• ASM management

• Database and SQL performance tuning

• SQL SERVER installation, configuration of maintenance tasks

• Capacity monitoring

• Oracle Goldengate installation, configuration and maintenance

• Oracle goldengate replication installation and maintenance

• Dataguard Replication

• Disaster recovery

• DB Visit

• Solarwind

• Multi-site database management

• Linux, Windows and Solaris systems

Certification:

• Oracle certified professional

Professional Experience

Lloyds Banking Group Sep 2020 - Present

• Oracle 19C/12c/11g Installation, Configuration of Oracle on UNIX (Sun/Linux/AIX), Windows 2003/2008/2012 and ODA.

• Security Patching of Oracle and MSSQL Databases, Oracle Business Intelligence and Oracle data Integrator.

• Provide Linux/ODA SA support.

• Day-to-day Incident management and support of the company Database and BAU activities and perform after hours support for EOD process.

• Adhere to established SLAs in responding to and completing service tickets, including providing a high level of customer support, detailed root cause analysis, and trouble reports for system outages.

• Build Test databases, release fixes and make necessary modifications to development, QA environments and follow change control the process.

• Create and test scripts to automate all database related backup jobs and monitoring of the databases.

• Develops and implements system, processes and security standards. Larsen and Toubro Infotech May 2018 - Aug 2020

• Support Day-to-day Database administration tasks include health checks, monitoring, tuning, capacity planning

• Support in quarterly Security patch installation, OS patch installation

• Involved in disaster recover testing every six months

• support in database refresh

• Oracle Goldengate installation, configuration and maintenance

• SQL SERVER installation, setup, configuration and maintenance tasks

• Database migration from 11g to 12C

Shadow Financial Systems Inc. Piscataway, NJ Jan 2017 – Mar 2018 Database Administrator

• Responsible for all aspects of planning, implementation, configuration, support, usage monitoring and tuning.

• Responsible for internal SaaS (Software as a service) databases and providing support for Shadow's client's databases.

• Implement backup and recovery procedures.

• Maintain system documentation and assist in troubleshooting and diagnosing production problems.

• Plan and perform disaster recover testing.

• Install and upgrade oracle patches.

• Capacity monitoring and Capacity planning.

• Coordinate Archive/purge data as per retention. Tablespace reorg to Maintain database size Environment: Windows, Oracle 11g/12c databases, Oracle Recovery Manager (RMAN), Solarwind, Flashback, Data Pump, and Windows batch scripting, Shareplex replication, DBvisit Federal Reserve Bank of New York East Rutherford, NJ Feb 2016 – Dec 2016 Oracle Database Administrator

• Responsible for Oracle 11g and oracle 12c database administration

• Supported on Oracle 12c DR testing using SNAPSHOT STANDBY

• Involved in Support of failover PDB to second cluster node

• Responsible for Refreshing data to PDB from 11g during cutover to 12c

• Involved in Build 12c standby database.

• Resolved JIRA tickets as assigned

• Applying 12c database patching and documentation

• Created Wallet setup on 12c database servers

• Involved in Pluggable database creation

• configured and administration of Oracle Goldengate replication Environment: Linux, Oracle 11g, Oracle 12c Multitenant Database with ASM RAC, Dataguard, DRtesting, Jira Verizon Wireless, Warren, NJ Jan 1998 – Dec 2015

Sr. Oracle Database Administrator

• Responsible for administration of the Oracle databases (100GB-12TB), planning and scheduling security patches, and upgrading databases on various UNIX environments.

• Reviewed daily automated AWR reports (high buffer get, full Tablescan, DB time, and CPU time) and tuned problematic SQLs.

• Managed several tech refresh projects including RAC installations, grid installations, ASM disk group configurations, database creations, data exports/imports, and Cronjob monitoring scripts.

• Worked extensively on Shareplex replication installations, setups, upgrades, license key requests, configurations (with Mviews) and tested three way replications across data centers in various geographic locations to enable high availability.

• Created step-by-step technical documentation for each production release, tech refresh, RAC installation, node addition, Oracle patch, SharePlex setup and data center migration.

• Implemented and maintained standby databases and coordinated yearly disaster recovery testing and quarterly standby switchover testing.

• Performed monthly maintenance to purge 1 Terabyte of data in timely manner in each of 3 datacenters leading to better performance, reduced time for Rman backup, and improved user experience.

• Mentored and trained junior DBAs on various database administration maintenance activities.

• Led activities to help business critical applications meet compliance with Verizon standards through creating database monitoring alerts, creating Rman backups and enabling database archiving.

• Sent daily database health checks reports to DBA team and leadership.

• Instrumental role in supporting flagship new cellular service features such as Usage Control, One Bill Eligible, SaveCart, Network Extender, Family Share Portout, 3D secure payments, Digital Voice, Friends and Family Tribe, Verizon Hub, Basic Visual Voice, 4G LTE, Droid Incredible launch, Quick Access prepaid, and iPhone launches.

• Led a project to reduce a reporting database size and as a result reclaimed 900GB of disk space. Periodically ran reports on all databases to find obsolete objects, redundant data, and large segments. Worked with the application team to purge redundant data, drop obsolete objects and enable drop-partitions automated jobs.

• Performed SQL tuning on mission critical applications which significantly enhanced the Customer’s experience by reducing the application response time from 2 seconds to milliseconds and improving CPU usage.

• Successfully prepared and executed detailed implementation plans and back out procedures for weekly database releases.

• Provided support on load testing prior to major production releases (e.g. iPhone launches) and monthly Enterprise releases.

• Responsible for maintaining environment consistency by applying & validating database and SharePlex changes in Dev, QA, Test, UAT and Pre-Production.

• Worked on data center migrations and added third node RAC on existing two-node RAC for load balancing.

• Converted a large non-partition bill history data table into a partition table by date, which resulted in a reduction in time for customers to retrieve a 12 Month Bill PDF from several minutes to a few seconds.

• Engaged in cross-functional communication with developers, project managers and system administrators to carry out day-to-day activities.

• Supported the First iconic iPhone launch in Verizon’s history.

• Involved in in the Y2K project

Environment: Sunsolaris, Linux, Oracle 11g/12c databases, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager 12c, OracleRAC11/12C, ASM, Flashback, Data Pump, Unix Shell Programming, Shareplex replication, DBvisit

Accomplishments & Awards

• Awarded for successfully supporting highly complex initial release of iPhone

• Customer first integrity for completion of Data center migration and implementation of a new site

• Awarded by project managers for extended support in off peak hours for the 4G LTE project

• Awarded for quality and innovation for executing an effective rollback plan for a major vendor application

• Outstanding performance and contribution to ‘MY Verizon’ project

• Recognized for providing outstanding commitment for BOGO redesign and SaveCart projects

• Recognized by Director as the first DBA in the company to successfully setup SharePlex replication on ASM RAC

Education & Training

• DBA workshops: SQL performance tuning, Oracle DBA Administration, Dataguard Administration

• Technical training from CompULearn, Edison, NJ

• Associate degree in Accounting and Economics in Gujarat University, India

Contact this candidate