Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Tirupathi Gade

Celina,TX

Summary

Oracle Certified Database Administrator (DBA) with over 14 years experience in Information Technology. Possess extensive knowledge and proficiency in Oracle cloud infrastructure, Database design, monitoring & tuning, security implementation and risk analysis, as well as backup and recovery. Extensive experience managing large-scale, complex databases. Strong understanding of database design and data modeling with excellent troubleshooting skills and committed to staying up-to-date with new technologies and advancements.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Senior Database Administrator

Deloitte Consulting
2020.07 - Current
  • Defining cloud migration strategy from on premises to Oracle Cloud infrastructure.
  • Integrate with IDCS, design and implement Oracle Cloud infrastructure network using internet gateway, DRG and Fastconnect and VPN.
  • Ensured compliance with regulatory requirements by incorporating appropriate controls within design of Oracle Cloud solutions.
  • Streamlined Oracle Cloud implementations by effectively assessing client requirements and identifying areas for process improvement.
  • Secured data integrity by implementing robust security measures in accordance with industry standards and best practices.
  • Strengthened client relationships by maintaining igh level of professionalism, responsiveness, and expertise throughout all interactions.
  • Collaborated with cross-functional teams to ensure seamless integration of Oracle Cloud solutions into existing IT environments.
  • Maximized system efficiency through regular review of application performance metrics and adjustment of configurations as needed.
  • Facilitated smooth transitions to post-implementation support, ensuring clients received prompt assistance with any issues or concerns that arose after golive.
  • Optimized system performance for clients with thorough testing and troubleshooting of Oracle Cloud applications.
  • Expedited resolution of complex issues by collaborating closely with Oracle Support staff to identify root causes and implement effective solutions.
  • Continually expanded knowledge of emerging Oracle Cloud technologies, ensuring clients received most up-to-date guidance and solutions available.
  • Participated in disaster recovery exercises, testing contingency plans to ensure minimal impact on business operations during emergency situations.
  • Providing administrative support and maintenance on Oracle 12c,19c installations, database creation, database security, database optimization and tuning on Onpremises.
  • Managing Database Structure, Storage allocation, Table partitioning, Table/Index segments, and rollback segments, Constraints, Database Access, Roles and Privileges
  • Installed and configured Golden gate Active-Active Replication.
  • Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Reports and performance issues.
  • Experience in handling multi-terabyte database migrations and consolidations with minimum/no downtime .
  • Implemented Automated database refresh with data from production on regular basis.
  • Implementing Code by using Oracle PL/SQL and SQL to create triggers, stored procedures, oracle jobs, functions and Managing execution thorough CI/CD pipelines.
  • Participating in 24/7 on-call DBA rotation schedule.

Oracle Database Administrator

Sterling5 INC (Deloitte)
Pittsburgh , PA
2009.03 - 2020.07
  • Augmented system efficiency through proper design, installation, configuration and management of databases from Oracle versions 11g through 12c and 19c.
  • Planned and implemented backup and recovery strategies using RMAN, datapump import and export to NFS mount point and tape.
  • Performed Automated Data Refresh/Cloning across different database environments for oracle databases.
  • Upgraded oracle databases from versions 12c to 19c Applied Database (RDBMS) Patches, PSU patches and one-off patches for bug resolution using opatch utility in both non-rolling and rolling fashion.
  • Guaranteed consistent 99% uptime for business by setting up proper monitoring, proactive mindset in problem identification and resolution as well as maintaining high availability for tier 1 databases.
  • Planned and implemented Disaster Recovery and High Availability solutions like Data Guard.
  • Experience in maintaining DataGuard to provide high availability by implementing Physical Standby,Snapshot Standby and Logical Standby databases.
  • Provided instance level performance monitoring and tuning for Event Waits, Blocking Sessions, Physical and Logical I/O and Memory Usage.
  • Supported application teams, vendors and stores by answering their questions and resolving issues they are facing such as load or connection issues.
  • Configures OEM and deployed OEM agents 11g/12c/13c to oracle databases which are newly configured and old databases for monitoring.
  • Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
  • Managed user accounts and support systems within complex Oracle database and cloud systems.
  • Provided documentation on how to manage, implement technologies and resolve database errors.
  • Established working relationships across various departments to understand existing and emerging IT requirements.
  • Participating in 24/7 on-call DBA rotation schedule

Education

Master of Science -

University of New Haven
West Haven, CT
03.2009

Bachelor of Engineering -

Anna University
Chennai- India
06.2006

Skills

  • Oracle Cloud Infrastructure (OCI)
  • Oracle Cloud Engineering
  • Infrastructure Architectures
  • Oracle Backup and Recovery
  • Database Security
  • Database Upgrade, Patching and Migration/Conversion
  • Oracle Performance Tuning
  • Oracle Data Guard
  • Oracle Golden Gate
  • Oracle Enterprise Manager
  • Oracle RAC
  • Oracle Gateway
  • Oracle Flashback
  • Oracle Data Encryption
  • Oracle TDE
  • EDB Postgres Plus Advanced Server

Certification

  • Oracle Certified: Oracle Database Administrator Associate
  • Microsoft Certified: Azure Fundamentals
  • Microsoft Certified: Azure Database Administrator Associate

Timeline

Senior Database Administrator

Deloitte Consulting
2020.07 - Current

Oracle Database Administrator

Sterling5 INC (Deloitte)
2009.03 - 2020.07

Master of Science -

University of New Haven

Bachelor of Engineering -

Anna University
  • Oracle Certified: Oracle Database Administrator Associate
  • Microsoft Certified: Azure Fundamentals
  • Microsoft Certified: Azure Database Administrator Associate

Similar Profiles

  • Aastha Nagpal

    Aastha NagpalAastha Nagpal

    Consultant at Deloitte ConsultingConsultant at Deloitte Consulting

    View Profile
  • Manav

    Manav Manav null

    SAP ABAP Consultant at DELOITTE ConsultingSAP ABAP Consultant at DELOITTE Consulting

    View Profile
  • Rishabh Khare

    Rishabh KhareRishabh Khare

    Associate Analyst at Deloitte ConsultingAssociate Analyst at Deloitte Consulting

    View Profile
Tirupathi Gade