Resume

Sign in

Support Oracle

Location:
Posted:
April 29, 2020

Contact this candidate

Resume:

Senior DBA with **+ years extensive experience on Oracle Rac, Performance Tuning, Data guard, Exadata and Golden Gate on Oracle 19c/18c/12c/11g .

PROFESSIONAL SUMMARY

Over 12+ years of strong IT and Oracle experience in the field of Analysis, Design, Development and Database administration

Extensive experience on Oracle Database Administration on Oracle 18c/12c/11G on various Unix platform hosted On-premises and on cloud.

Leading team of 15 DBA with multiple RDBMS (Oracle, MongodB, MySQL, PostgreSQL and MS Sql Server).

Prepare and execute databases for Peak support (Thanksgiving, Black Friday and Cyber Monday)

Experience in installation, Design, maintenance, upgrade and patching of Oracle 18c/12c/11g RAC.

Experience with Oracle engineered system (EXADATA) machines and its patching.

Migration experience from On-Prem to cloud (OCI, ExaCS and ExaCC)

Have efficient experience in troubleshooting and fixing performance issues of Database during design and production support

Supporting design, implementations, support for ECOM and Store related applications.

Working knowledge of SPM & SQL profiles and diagnosing underlying issues with efficient use of AWR, ASH, ADDM and real time monitoring in 13c OEM.

RMAN backup setup/configuration for production environments, database backup and recovery using RMAN.

Migrated 30TB+ database from 12c to Oracle Autonomous Data Warehouse (ADW) 19C.

Working knowledge of Oracle Golden Gate implementation and support.

Expertise in DR (Physical standby/Active/Snap-Shot Data guard setup including DGMGRL).

Providing on-call 24*7 support for mission critical production databases.

Have been working extensively on 18c/12c multitenant container/pluggable environments

Database cloning using RMAN, database refresh using logical backup (expdp & impdp utilities) as well as RMAN.

Applied PSU, CPU, Patch set and one-off patches to RAC, ASM and databases. Applied rolling patches on grid and RAC homes.

Experience configuring and managing Oracle Enterprise Manager (OEM 13c) for database monitoring and maintenance.

Supporting huge production environment having 100s of databases up to multiple TBs in size.

Experience handling very large databases (30 TB+) in both RDBMS and N0Sql.

Perform Database Failover and Switchover using DG Broker in 11gR2.

Having good hands on experience of ITIL processes like Incident Management, Change Management etc .

Team management, escalation handling, work assignment, support schedule.

Exposure to Microsoft Azure and Amazon Web Services.

RCA preparation, reports preparations like utilization work summary.

A team player with strong communication, team leadership, organizational and relationship management skills, expertise in interfacing with international project teams.

Have been working extensively on 12c/18c multitenant container/pluggable environments.

RMAN backup setup/configuration for production environments, database recovery using RMAN

Upgrade of databases to newer releases.

Installation and Database creation on RAC and non – RAC.

Hands on experience on applying database PSU and one-off patches.

Automation of routine DBA task using shell and python scripts.

Experience of on BCP (Business Continuity Planning) zero/minimal downtime database migrations and upgrades using latest methodologies.

Troubleshoot Golden Gate related error and upgrade of Golden Gate.

Highest Education:

MCA (Master of Computer Application) from Rajiv Gandhi technical University, India – 2007

Certification: OCP, Oracle Certified Golden Gate 12c Implementation Specialist, Oracle Autonomous Database

Cloud 2019 Specialist .

Professional Experience

Gap Global Database Support June’19 to March’ 2020

DBA Team Lead Client Location Pleasanton, CA

Project consists of 500+ production databases running on Oracle 18c/12c/11g environment using Multi tenancy, RAC and Standalone database on Linux and Unix OS. Databases are hosted both on Gap Inc On-prem data center and on Oracle Cloud Infrastructure. These databases are used to support business critical application for both ECOM and store sales and other business functions like procurement, inventory, Analytics etc. Our team provide complete lifecycle support for anything related to database technologies from installation to production deployments .We also plan and support very critical Peak sales during days of Thanksgiving, Black Friday and Cyber Monday .We also use Exadata machines for our critical applications .These Database are using Golden gate for replication purpose and Dataguard for Disaster Recovery using primary and standby database management. As a primary DBA and database SME I need to support 100+ Database and need to perform day to day DBA activities and provide support for critical dollar impact issues like performance or outages. I also provide capacity planning and data modeling input for existing and new application on boarding Along with this we also support various monthly and quarterly release for our application for which I do planning and coordination with all stakeholders.

Database team work on Service Now ticketing created through various monitoring tools (OEM, Nagios etc.) and also user created tickets and change request. Also lead performance benchmarking, chaos testing, failover – switchover activities related to PEAK support

Contribution / Highlights:

DBA Team lead for Gap Inc database support team.

Handling Gap Inc foot print of database technologies that includes Oracle, MS SQL Server, My Sql, Mongo DB and PostgreSQL .

16x7 production database support.

Planning, Support and management of Most important peak season for database technologies.

Handling escalation and performing RCA for critical issues, preparing shift roaster etc.

Attending various regular meeting with leadership team and various application teams.

Extensive Database Migration from On-Prem to OCI.

Good experience on 12c multitenant environments and Active data guard.

Excellent working experience of Goldengate handling various critical Extract and replicate issues.

Setting up and maintaining Oracle Golden Gate replication.

Backup/recovery setup/administration using RMAN

Database upgrade to newer version.

Database cloning/refresh using RMAN/logical methods

Database performance tuning for better application performance

Creation of SOP’s for new and existing database project.

Representing DBA team during any infrastructure outage or critical application issue.

Assigning resources for various Change Requests and coordination for down time and other team for the Change

Managing Physical and Active Standby Databases in Data Guard infrastructure.

Creation of new databases and configuration.

Environment: Oracle RAC 19c/18c/12c/11gR2 Multitenancy, OCI Oracle ADW 19c, Exadata CC, OEM 13C

Active/Snapshot data Guard, Linux, AIX.

Wells Fargo EDM-Production Support Feb’ 12 to May’ 2019

DBA Team Lead Client Location Charlotte, NC

Wells Fargo & Company is a diversified financial services company providing banking, insurance, investments,

mortgage, and consumer and commercial finance through more than 9,000 stores and 12,000 ATMs. EDM group

provide database technologies support for 1000+ Wells Fargo’s critical financial applications. I was Primary DBA for

Capitals Market application and oversee end to end database lifecycle support from planning, installation, release,

Support and maintenance. Provide performance tuning and other critical support. Our team also provide 16*7

production on call support for Lending Line of Business. We use Oracle 12c/11G RAC on Exadata and Non

Exadata machines with replication using Golden Gate and DR using Oracle Active Data Guard. These are dollar

Value critical applications and database size goes up to 30 TB +.

Contribution / Highlights:

Working as part of DBA team to provide support for mission critical database

Handling Responsibility of Team lead for the Lending DBA team.

Handling escalation and performing RCA for critical issues, preparing shift roaster etc.

Attending various regular status meetings and also meeting with On- shore team leads and leadership team.

16x7 production database support

Good experience on 12c multitenant environments and Active data guard.

Excellent working experience of Goldengate handling various critical Extract and replicate issues.

Backup/recovery setup/administration using RMAN.

Oracle Vault for database security.

Oracle Transparent Data Encryption for audit and compliance .

Oracle 11g/12c Grid setup/Administration.

Database upgrade to 12c/11gR2 from lower version

Database cloning/refresh using RMAN/logical methods

Database tuning for better application performance

Proactive SQL tuning for better performance

Creation of SOP’s for new and existing Oracle Tools

Representing DBA team during any infrastructure outage or critical application issue.

Assigning resources for various Change Requests and coordination for down time and other team for the Change

Managing Physical and Active Standby Databases in Data Guard infrastructure.

Creation of new databases and configuration.

Supporting various projects like migration of databases to new hardware, OVD etc.

Environment: Oracle RAC 12c/11gR2, Exadata CC, Active Data Guard, Golden Gate 12.1, RHEL Linux/AIX

Johnson & Johnson DBA Support Feb’11 to Feb’12

Senior DBA Bangalore, India

Johnson & Johnson engages and world leader in the research and development, manufacture, and sale of various products in the health care field worldwide. We provide the support for Database administration engagement for their Databases world over. Our team supported 1000+ databases hosted on Linux, AIX and Solaris both RAC and standalone. Also we provided DR through Oracle Physical standby on Oracle 11g and 10G. I was involve in installation, upgrade, patching, failover and 24*7 On call support of databases for North America region.

Contribution / Highlights:

Providing 24*7 support for more than 3500 Oracle databases around the world.

Monitoring availability of databases.

Installation and Configuration of Oracle Database on Unix and Windows Platforms.

Managing Oracle Users through user creation, privileges and profiles.

Managing Oracle Tablespaces for database growth.

Backup and Recovery of Database using User Managed and by using RMAN.

Maintenance of Backup schedules.

Participation in DR drills.

Managing Physical and logical Standby Databases in Data Guard infrastructure.

Creation of new databases and configuration.

As a shift lead responsible for whole shift and escalations

Preparing various reports with respect to SLA, ticket inflows, classification of tickets

Attaining various status and schedule meeting with customer and the team.

Responsibility for incident manager.

Responsible for documenting / contributing the SOPs and technical- processes for the support team to refer.

Environment: Oracle 10g, RAC 11g/R2, Physical Data guard, RHEL/AIX/Solaris, OEM

Fluke DBA Support May’ 07 to Feb’11

Oracle DBA Pune, India

Client is one of the world’s leading Test and measurement manufacturer, which includes Network and Biomedical

equipment’s. Our team provided 24*7 database support for Oracle 11g/10g databases hosted on various unix platforms. We also provided various change request execution for installation, patch and upgrade of oracle databases. Also provide DR capabilities using Oracle physical data guard.

Contribution / Highlights:

Installation and Configuration of Oracle Database on LINUX and Windows Platforms.

Managing user accounts, administering DB objects like table, views, indexes

Maintaining several DB instances.

Maintaining several DB instances

Backup and Recovery of Database using User Managed and by using RMAN.

Maintenance of Backup schedules.

Managing and monitoring tablespaces, datafiles growth and storage unit

Database & Schema Refresh of Test & Dev database from Production DB.

Writing new shell scripts for maintaining databases

Database refresh/cloning from Production

Providing 24*7 support

Continuous interaction with end users and different onsite and offshore teams.

Responsible for documenting / contributing the SOPs and technical- processes for the support personnel to refer.

Responsible for training the new team members.

Awards/Recognition

Wells Fargo Annual Conclave Award 2013, held at Bangkok (Highest honour for team members in a year)

Wells Fargo Gold Coin Award (Highest level of excellence in a quarter)

Wells Fargo Champion Q-1 2018

Achieving excellence level – III (Quarter II-2013, Quarter IV - 2014)

Best Support award, Fluke ODC



Contact this candidate