Data Manager

Satya Veeravilli

Cell# 516-***-****

Email: ***************@*****.***

Charlotte, North Carolina 28262

PROFESSIONAL SUMMARY

Accomplished Oracle DBA with 5+ years of professional experience in large-scale production environments across multiple platforms. Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery. Competent to work as an individual and also as a team player. Learn new technology evolving over day to day and meets Organization standards.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g/11g RAC environment.

Experienced in Real Application Clusters (RAC) setup, configuration, and cluster interconnection with Automatic Storage Management (ASM), configured user logon load balancing and failover on RAC database for high availability

Experience in upgrading databases on Exadata clusters (12c to 19c, 11g R2 to 12c, 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).

Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 19c, 12c, 11g and 10g RAC .

Strong experience in design, deployment and administration of large Data warehouse and Data mart Databases.

Data replication, transformation and delivery of database transaction using Golden Gate replication tool but not limited to extract, pump and replicate processes.

Expertise in performance tuning from a system level perspective were identifying the CPU, memory, usage and data files, I/O and waits

Strong experience in Hot/Cold Backups and Point-in-time Recovery procedures using RMAN.

Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.

Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.

TECHNICAL SKILLS

RDBMS

Oracle 8i, 9i, and Oracle 10g RAC, 11g, 12c Performance Tuning, Backup and Recovery using Cold, Hot and RMAN and Other Utilities

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Red Hat Linux (RHEL) 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005, Windows 98/ME/NT/2000/XP

Languages

C, C++, Java, VB, PHP, XSLT, XML, SQL, PL/SQL, UNIX Shell Scripting

Oracle Tools and Utilities

RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, Golden Gate, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, ASH.

Education

B.E in Electrical and Computer Science Engineering Annamalai University, India

Master of Science in Electrical and Electronics Engineering University of Texas at Tyler, Texas

PROFESSIONAL EXPERIENCE

Client: Wells Fargo & Co, Charlotte NC Dec 2019 – Till date

Role: Sr. Oracle DBA

Responsibilities:

Performance tuning of Critical application / SQL’s to obtain Business SLA’s

Extensive DB support for performance analysis using tuning tools but not limited to OEM 13C, Toad, SQL Developer.

DB deployments in lower environments for test and PROD deployment review for app performance.

Primary support DBA for Heavy reporting applications with TB’s of data in Prod and Lower environments.

Efficient in handling Multi-Tenancy and Single-Tenancy in Exadata, CDB/PDB Set up

Semi-Annual Data-Center re-point / Switchovers as part of Business Continuity Planning simulations checks.

19c Upgrade support and perform discrepancy checks prior to Upgrade and work with Vendor to resolve any issues.

Develop SQL and PL/SQL stored procedures, database packages, and triggers to handle DB jobs automation / User specific requirement

Golden Gate Support for various businesses groups and maintains 100% replication for heterogeneous platforms.

24*7 production database support with Global partners as part of On-call support for 100% database availability.

Client: AIG Capital Services, Inc. Woodland Hills, CA June 2019 – Nov 2019

Role: Senior Database Analyst

Responsibilities:

Worked on DevOps DB deployment Automation using GitHub, Jenkins pipelines.

Experienced handling Automation issues and troubleshooting Deployments errors as part of DevOps DB automation.

Experienced in Handling ExaCC migration from on-premise AIX servers to ExaCC Cloud at customer.

Hands on experience on handling 8 node full RAC clusters.

Good hands-on experience handling multiple database instances including 2 and 3 node RAC databases along with troubleshooting and fine-tuning of databases for performance issues.

Monitoring daily backups and working on any failed backups to verify the error from alert log and to re-backup of the DB when needed to have a copy of database for application team.

Monitoring RMAN backups and fine tune RMAN parameters to improve the backup timings efficiency.

Backup and restore PDB’s to perform point in time recovery (PITR) using the RMAN full backup per application on-demand.

Disaster Recovery setup and testing the replication functionality of the Data Guard.

Day-to-day application support starting Dev through Prod.

Client: Wells Fargo & Co, Charlotte NC Nov 17 – June 19

Role: Senior Database Analyst

Responsibilities:

Handling databases installed in Exadata machines containing 8 node RAC Exadata Clusters managing both Multi-tenant and non-multi-tenant databases.

Efficiently delivered project requirements on time for business needs and full-filled the DBA support engaged at all times to support the project development.

24/7 Project coordination with Enterprise Global Solutions counter parts to process the business needs and delivering project needs.

Installed Oracle DB 12c, 11g RDBMS, RAC on ASM, Applied Oracle critical patch updates, Implemented and Managed Data Guard, Replication, Backup and Recovery support and performance tuning

Grid Installation on new Linux Servers for 2 node and 3 node RAC and failover environments and Oracle Grid Control 12g Installation.

Create 12c shell database and pluggable databases required as per the business requirement and maintenance replication databases (data guard) on two different data centers.

Handle multiple database instances including 2 and 3 node RAC databases along with troubleshooting and fine-tuning of databases for performance issues.

OEM 12C grid monitoring targets like listeners, hosts, databases in oracle environment and adding newly created databases and their parameters to the OEM.

Hands on Experience in performing FLASHBACK database to a point in time recovery co-coordinating with the application team if in case any issues during huge upgrades.

Environment: Oracle 11g, 12c Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Database Control, TOAD, OEM 12c, ASM, AIX, Golden gate, Tivoli.

Client: Wells Fargo & Co, Charlotte NC Nov 15 –May 2017

Role: Databases Analyst

Installed Oracle DB 12c, 11g RDBMS, RAC on ASM, Applied Oracle critical patch updates, Implemented and Managed Data Guard, Replication, Backup and Recovery support and performance tuning

Installed grid Infrastructure software on new Linux Servers for 2 node and 3 node RAC and failover environments and Oracle Grid Control 12g Installation.

Well experienced in creating 12c shell database and pluggable databases required as per the business requirement and maintaining them with replication databases on two different data centers.

Handling multiple database / instances but not limited to 2 and 3 node RAC databases and troubleshoot and fine-tuning of performance issues.

Monitoring daily backups and resolve any reported failures from the logs.

Well experienced in setting up the RAC environment along with Data Guard to replicate the copy of primary database.

Experienced in testing the newly built RAC and Data Guard setup by performing switch over and failover for high availability of the database.

Experienced in creating Users and providing required level of grants to USER in pluggable database to avoid any excess access to users and to safeguard the database.

Worked on OEM 12C grid for monitoring the listeners present in the oracle environment and adding newly created databases and their parameters to the OEM.

Handling SQL / PLSQL language to identify the objects both schema level and database level to perform and identify any DDL’s changes.

Experienced in setting up the Oracle GG for unidirectional replication and bidirectional replication.

Migrated databases from 11g to 12g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.

Hands on Experience in performing FLASHBACK database to a point in time recovery co-coordinating with the application team if in case any issues during huge upgrades.

Environment: Oracle 11g, 12c Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Database Control, TOAD, OEM 12c, ASM, AIX, Golden gate, Tivoli.

Contact this candidate