SUMMARY

• Confidential who has been working as a Senior Cloud Oracle DBA, Senior Oracle DBA, Oracle DBA during the past 20 years. During this time,
• Confidential has been involved in the Database Administration and Implementation of Container Databases Migrations, 18c Upgrades, Amazon Cloud, OLTP, OLAP data warehouses, data mining systems along with extensive Shareplex/GoldenGate Replication.
• Confidential also offers over 7 years of experience with Oracle RAC (10g,11gr2, 12c)
• Excellent Oracle 10G,11g, 12c Administration skills Oracle 9i, 10G,11g, 12c RAC experience
• PeopleSoft and SAP Oracle DBA Extensive Experience as a Sarbanes Oxley (SOX) Oracle DBA at Calpine Energy
• Experience in very dynamic gas and electricity energy trading operation at Calpine Energy (Nucleus and NMarket) and Enron (Enron Online)
• Oracle 9i Application Server (9iAS) administration experience (Calpine Energy and Enron)
• Oracle 10G Application Server (10gAS) administration experience (Calpine Energy)
• RMAN backups, recoveries and cloning of databases Standby Database
• Peoplesoft, Primavera Oracle DBA Experience Identified tuning opportunities for new and existing Oracle applications
• Extensive Quest Shareplex experience in versions 8.6.5, 7.5.2, 6.0.1 and all versions in between
• Strong Data Warehousing skills as the DBA for a terabyte data warehouse in HP (2 - 2002 - 4-2005)
• Extensive Experience in Large Database Environments managing terabyte + databases
• Extensive RMAN Experience (Backup, duplicate, recovery, restore)

PROFESSIONAL EXPERIENCE

Confidential

Senior Cloud Oracle DBA

Responsibilities:

• Senior Oracle DBA supporting around 350 Production and overall around 1500 databases, of all kinds and sizes, container PDBs (Single Tenant as well as MultiTenant) on Private as well as Cloud DBA on Amazon AWS Public Cloud, as well as OEM 13c Administration
• OEM 13c Administrator including OEM 13c Patching, Reports, Monitoring Setup and Admin, Targets Setup and Administration, OEM upgrades etc
• Currently working on ugrading all databases to Oracle 18c and 19C Containers and also for apps that don’t support 18c and 19c, doing 12201 upgrades from 12c
• Auditors Support (Both SOX and non-SOX)
• Project Lead, Designer, Implementor And Administrator for Oracle Database Scans to push and pull various Metadata for all our 1500 Oracle databases like Audit, DB Size, Memory, CPU, Inventory, UserId Maintenance etc
• Informatica Oracle DBA Support (Oracle 19c, 18c, 12201, 12c)
• Patching Databases Grid Control 13c Performance Tuning
• Supporting large database environments (Terabyte +),
• Monitoring And On-Call Support
• Data Guard Standby Database administration, installation, setup, and administration of Oracle 12c Data Guard databases including Containers Data Guard
• Backing up, restoring and recovering databases using RMAN
• Providing Oracle 18c, 12cd,11g database administration, Kernel Tuning, and AWR and ASH Setup and administration
• Performing SQL and PL/SQL stored procedure development
• Involved in requirements gathering and implementation of database design and development Involved in Production DBA support databases and troubleshooting and backup and recovery
• Involved in tuning SQL queries, Capacity Planning for new server additions and database growth, Production Database Support

Hardware: Amazon Cloud, Private Cloud, Oracle Linux and Windows

Software: Oracle 18C, 12201, 12c, 11g

OS: AWS Red Hat Linux, Red Hat Linux, Windows

Languages: PL/SQL, UNIX Shell Scripts, Perl

Tools: Quest Toad (Database Tuning and Monitoring), Oracle Grid Control, Quest

Confidential

Senior Oracle DBA

Responsibilities:

• Senior Oracle DBA supporting around 175 productions and overall around 400 databases, of all kinds and sizes
• Peoplesoft DBA Support (Oracle 12c)
• Primavera DBA Support (Oracle 12c)
• SPM (Smart Plant Material) DBA Support
• Supporting large database environments (Terabyte +),
• Installation, setup, administration, maintenance of Quest Shareplex (versions 8.6.5, 7.5.2 and versions in between)
• Oracle Database Replication, architecture (Includes Storage (ASM), Unix, Network Architecture),
• Setup, administration, and maintenance of Oracle RAC
• Setup, administration, and maintenance of Oracle Data Guard
• Upgrade of Oracle RAC
• Installation, administration, and setup of 12c OEM Grid Control, RAC and Data Guard Disaster Recovery
• Data Guard Standby Database administration, installation, setup, and administration of Oracle 10g,11g, 12c Data Guard databases
• Backing up, restoring and recovering databases using RMAN
• Providing Oracle 10G, 11g, 12c database administration, 10G,11g, 12c RAC administration, Kernel Tuning, and AWR Setup and administration
• Upgraded Oracle databases to 11g, 12c etc.
• Performed SQL and PL/SQL stored procedure development
• Involved in requirements gathering and implementation of database design and development Involved in Production DBA support databases and troubleshooting and backup and recovery
• Involved in tuning SQL queries, Capacity Planning for new server additions and database growth, Production Database Support

Hardware: IBM AIX, Linux and Windows

Software: Oracle 10g, Oracle 11g, 12C

OS: IBM AIX (UNIX), Linux, Windows

Languages: PL/SQL, UNIX Shell Scripts, Perl

Tools: Quest Toad (Database Tuning and Monitoring), Oracle Grid Control, Quest

Confidential

Senior Oracle Database Administrator

Responsibilities:

• More than 7 years working for a Cloud Multitenant Database As A Service Provider at CGI which is the Top Tier 1 Cloud Service provider for US Federal Govt Databases As a Service
• Senior Cloud Oracle DBA and Senior Oracle DBA supporting the IT systems of many extremely dynamic clients including Federal Gov. departments, both Cloud and non-Cloud
• Supporting large database environments (Terabyte +),
• Supporting Cloud Infrastructure Databases
• Installation, setup, administration, maintenance of Quest Shareplex (versions 6.0.1, 7.5.2 and versions in between)
• Installation, setup, administration, and maintenance of Oracle Golden Gate (versions 11.20.1.1, 11.2.0.1.7 and versions in between)
• Oracle Database Replication, architecture (Includes Storage (ASM), Unix, Network Architecture), Oracle Golden Gate Database Replication (Version 11.2.0.1.1, 11.2.0.1.5) Installation, setup, administration, and maintenance of Oracle 10g and 11g RAC, Cloud DBs
• Setup, administration, and maintenance of Oracle 10g and 11g Data Guard
• Upgrade of Oracle RAC from 10g to 11g and from 11g (version 2.0.1) to 11g (version 2.0.2)
• Installation, administration, and setup of 10g and 11g OEM Grid Control, RAC and Data Guard Disaster Recovery
• Data Guard Standby Database administration, installation, setup, and administration of Oracle 10g and 11g Data Guard databases
• Backing up, restoring and recovering databases using RMAN
• Providing Oracle 10G and 11g database administration, 10G and 11g RAC administration, Kernel Tuning, and AWR Setup and administration
• Upgraded Oracle databases from 10g to 11g and from 11gr201 to 11gr202
• Performed SQL and PL/SQL stored procedure development
• Involved in requirements gathering and implementation of database design and development Involved in Production DBA support for both Cloud and Non-Cloud Databases and troubleshooting and backup and recovery
• Involved in tuning SQL queries, Capacity Planning for new server additions and database growth, Production Database Support, SQL Server, MySQL DBA Support

Technical Environment: Hardware: IBM AIX, Linux and Windows 2000

Software: Oracle 10.2.0.4 and Oracle 11g (11.2.0.1 and 11.2.0.2)

OS: IBM AIX (UNIX), Linux, Windows

Languages: PL/SQL, UNIX Shell Scripts, Perl

Tools: Quest Toad (Database Tuning and Monitoring), Oracle Grid Control, Quest

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Senior Oracle DBA whose responsibilities included managing day to day DBA activities
• Supported an extremely dynamic Energy Trading System called Nucleus
• Supported a dynamic Energy Pricing system called NMarket,
• Acted as SARBANES-OXLEY (SOX) Oracle DBA for Calpine Energy
• Administration of Oracle 10g Standby database environment
• Administration and setup using 10g OEM Grid Control, Oracle 10G Application Server Administration (10gAS)
• Oracle DBA of an energy data warehousing system called EMS (Energy Management System), PeopleSoft Oracle DBA, Disaster Recovery and Standby Database Administration
• Backed up, restored and recovered databases using RMAN
• Oracle 9i, 10G and 8i administration, 9i and 10G RAC administration, Oracle 9i Application Server Administration (10gAS), Oracle 10G Application Server Administration (10gAS)
• Kernel Tuning, Statspack Setup and Administration, Oracle 9i RAC setup and administration, Upgraded Oracle databases from 9.2.0.3 to 9.2.0.6
• Migrated Oracle from 8i to 9.2.0.6
• Database Refresh and Recovery, Oracle 8i, 9i and 10g database administration, Data modeling and design, SQL and PL/SQL stored procedures development
• Involved in requirements gathering and implementation of the database design and development
• Involved in Production DBA support and troubleshooting and backups and recovery,
• Involved in tuning SQL queries, Capacity Planning for new server additions and database growth

Technical Environment: Hardware: Sun Solaris and Windows 2000

Tools: Embarcadero DB*Artisan (Database Tuning and Monitoring), OEM, Designer, ERWIN, Quest Tools (Database Tuning and Monitoring)

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Senior Oracle DBA who provided centralized DBA support to over 500 projects using Windows 2000, HP-UX and Tru 64 platforms
• Tuned the database by monitoring and tweaking various memory parameters to provide well-oiled performance
• Provided SQL Tuning, Kernel Tuning, SQL and PL/SQL stored procedures development Involved in requirements gathering and implementation of the database design and development
• Provided Production DBA support and troubleshooting and backups and recovery
• Involved in tuning SQL queries, Capacity Planning for new server additions and database growth
• Performed data modeling and design and data warehouse reports development using PL/SQL, Supported Epiphany IP CRM databases, data warehouse experience, Epiphany Analytics Support for data warehouse reports and loads
• Supported Epiphany AP data warehouse databases
• Extensive data warehousing experience in dimension table design, ETL loads and support
• Supported large terabyte loads into AP data warehouse, Oracle 8i and 9i database administration, SAP BW/SAP R3 Data Warehouse/OLTP database administration, Data modeling and design
• Involved in database administration, database architecture, database design, database development and database modeling of a new project called Application Integrated Messaging Services (AIMS)
• Data Warehouse Design and Development and support, SQL and PL/SQL stored procedures development

TECHNICAL SKILLS

Hardware: Windows XP, 2000, NT, IBM AIX, HP-UX and Tru 64

Software: Oracle 8.1.7.2 and Oracle 9i and Oracle 7.3.4

OS: Windows XP, 2000, Tru 64, AIX and HP-UX

Languages: PL/SQL, UNIX Shell Scripts

Tools: OEM (Database Tuning and Monitoring), Designer, Quest Tools (Database Tuning and Monitoring), Toad, Embarcadero DBArtisan, ERWIN