SUMMARY

• Having 14 Years of experience as an expert AWS RDS/Aurora PostgreSQL/MySQL and Confidential RAC on Linux Red Hat and Windows supporting Confidential Databases on RAC and non RAC versions from 11gR2, 10g, 9i, 8i.
• Hands - on experience in architecting and data modeling for AWS Redshift, AWS Confidential RDS, AWS PostgreSQL and AWS Aurora and Good understanding and hands on experience with AWS S3 and EC2.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL in production and developer environments on Linux CentOS flavor.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Installed and configured PostgreSQL on Linux and Windows environments.
• Managing/Troubleshooting PostgreSQL in production and development environments on Linux CentOS flavor.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing PostgreSQL config changes, multiple instances and by upgrading hardware.
• Installing Confidential Application Server AS10g Single-Sign-On/OID/LDAP and configuring with Confidential Applications E-Business Suite 11i & R12 Release 12.0.3
• Excellent working experience in administrating Confidential 8i/9i/10g/11g databases, which includes database designing, creation, configuration, development, security and backup/recovery.
• Installed and supported Confidential Applications ERP servers on Single and Multi-node
• Configured and supported Confidential 9i, 10g, 11g and Real Applications Clusters (RAC) on Linux (RH-3,4,5)
• Experience with setup and configuration of Confidential Data Guard / logical Standby and physical Standby databases with Confidential Applications 11.5.10 & R12
• Monitored and optimized the Performance of the database, Tuning Management, capacity planning, created new technologies and SQL tuning using utilities/tools like explain Plan, TKPROF, Auto trace, AWR reports, STATSPACK,OEM and SQLTXPLAIN.
• Database upgrade and migration experience on various versions of Confidential Database (from 8i to 9i & 9i to 10g & 10g to 11g)
• Experience with Confidential applications upgrade from 11.5.8 to 11.5.10.2 and to R12.1.3
• Confidential Server Installations/Upgrades, Space Management, Capacity Planning, Backup & Recovery using Manual and RMAN, Disaster Recovery, Database Performance Tuning, Memory Tuning, Security Administration, Data Architecting, normalization/de-normalization, Data Warehousing, Multithread Servers, Distributed Databases for Confidential 8i/9i Databases, table partitioning and Confidential Standby Server.
• Experience in many systems development lifecycles (SDLC), from requirement development, architecture design, testing, and post implementation revisions.
• Install/setup/configure Confidential Enterprise Manager (OEM) tools for monitoring of Confidential Database & Confidential Applications 11i & R12.
• Proficient with monitoring tools, Grid Control, third party software and Confidential Application Manager (OAM), HOTSOS.
• Creating users, roles and profiles, granting and revoking privileges and access for database object proactively using events and fixit jobs from OEM to monitor database high water marks.
• Working skills in managing with features like Confidential Managed Files (OMF), Auto Space / Undo Management, Managing tables, indices, views, tablespaces, redo logs, etc using sqlplus, OEM.
• Knowledge in Implementation, installation, Cloning, maintaining concurrent manager processes, Patching related to Confidential Applications.
• Proficient in PL/SQL and Shell Scripting, SQL query tuning, Database performance tuning and Ebiz performance tuning
• Worked extensively on patching using KINTANA & HP PPM and applying patches manually of Confidential Applications 11i & R12 EBS Systems
• Expert in maintenance routines using ADADMIN (recompile Apps Schema, Generate ENV files, Generate JAR files, take APPL TOP snapshots etc.)
• Hands on experience with cloning (using Rapid Clone) and managing Confidential instances.
• Expert in packages Confidential Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, Schema Manager. Working in environments constituting IAS, Confidential Self Service Web Applications, XML, Discoverer 10g.
• Working pro-actively with UNIX Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion.
• Worked On-call providing 24*7 365 days Support for production databases across organization.
• Worked with Off shore team as level 3 support and mentored them with training an knowledge transfer, was responsible for any escalations for the off shore team
• Dedicated, hard working individual with the interpersonal communications skills to work at all levels of the organization.
• Exceptional analytical and problem-solving skills. Work efficiently as a team or individually to achieve goals and objectives.

TECHNICAL SKILLS

RDBMS: Confidential 8i, 9i, 10g, 11g, and 10g/11g RAC Sql server 2017/2016/2012/2014/2008 R2, MySQL 5.0/5.5, PostgreSQL 9.2.24.Database, MS Access

RDBMS Tools: Confidential Enterprise Manager (OEM), SQL*Loader, Confidential Schema Manager, RMAN, Space Manager, Net 8, SQL Trace, TKPROF, Stats Pack, TOAD, SQL Navigator, Golden Gate

Applications: Confidential E-Business Suite 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2) / R12 Confidential Application server 9iAS, 10gAS, SSO, OID, LDAP,GRC

Operating System: IBM AIX 5.2, 5.3, Sun Solaris 2.8, Solaris 10, HP-UX, Windows NT4.0/2000, Citrix, Linux RH3.0, Linux RH4.0 Enterprise Addition

Hardware: IBM p595 Pseries Power Servers, Sun Sparc v880, v440, vE6500, HP9000, Compaq, EMC San

Languages: SQL*Plus, PL/SQL, C, Pro*C, Cron Processes, Unix Shell Scripting, csh, ksh, HTML, XML

Software Tools: Apache, IAS, 9iAS, Confidential Portal,, Developer 2000 (Forms6i, Report6i), TOAD, Discoverer (4i, 10g), 10g Grid Control, Confidential (8i, 9i,10g), Confidential Applications 11i, Confidential Portal, Confidential Enterprise Manager, Other Confidential products, HP-PPM/Kintana

Technologies: Real Application Clusters (RAC), Dataguard (Standby Database), Replication, Confidential Applications Shared APPL TOP, Single-Sign-On SSO, Confidential 10g Application Server, Confidential discoverer, OID, LDAP, Secured Socket

PROFESSIONAL EXPERIENCE

Confidential - Irvine, CA

AWS Cloud DBA

Responsibilities:

• Monitoring Security Groups with Amazon Cloud Watch Events.
• Launching Amazon EC2 Cloud Instances using Amazon Web Services (Linux/ Window) and Configuring launched instances with respect to specific applications.
• Create, configure and implement Virtual Private Cloud (VPC), Security Groups, Network Access Control List (NACL), Elastic Compute Cloud (EC2 instances), Elastic Block Store (EBS), Simple Storage Service (S3), Elastic Load Balancer (ELB), RDS MySQL, Subnets, Snapshots, Auto-Scaling Groups, Route 53 DNS, Glacier, Elastic File System (EFS), CloudFront, CloudWatch, and CloudTrail.
• Assign Roles and Policies to Users, Security Groups by using Identity and Access Management (IAM)
• Design and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service.
• Setup and build AWS infrastructure various resources, VPC EC2, S3, IAM, EBS, Security Group, Auto Scaling, and RDS in Cloud Formation JSON templates.
• Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Worked with the application team to implement new design systems of databases used by the company.
• Performance Tuning activities for preventing issues and providing capacity planning using MySQL Enterprise Monitor using MySQL Profiler.
• Involved in Archival of huge tables.
• Troubleshooting Tungsten replication issues and switching from Primary to DR

Confidential, Redwood shore, CA

DBA Administrator

Responsibilities:

• Responsible for installing Confidential Applications R12/11i in single node & multimode
• Cloning Confidential Applications instances both R12 and 11i instances
• Platform migrations from Sun OS to SUN SUPER CLUSTER for R12 applications and 11g databases.
• Confidential application upgrades from 11.5.10.2 to R12.1.3 .
• Working Closely with System administrators, developers, technology Stack team and Server Tech team
• Creating documentation during project planning, project execution and project maintenance phases
• Installed RAC 11g and integrated with existing ERP instances.
• Extensively worked on ASCP & Configurator instances administration and support area.
• Monitoring users activity using sign-on audit reports
• Capacity Planning/Management (space/machine load/network)
• Resolving system errors, disk space problems
• Creating Project Plans for managing major E-Biz downtime
• Auditing apps databases
• Monitoring tablespace usages
• Strong Knowledge in Confidential Grid control 11g
• Worked on RMAN Backup Strategy
• Installation and configuration of OEM Grid Control 12c.
• Customizing autoconfig templates according to the environment requirements
• Installed Sun-JRE plugin in 11i applications in place of Jinitiator
• Tuning Concurrent Managers, Defining Work Shifts, configuring specialization rules, Defining primary & secondary nodes for PCP setup
• Using the AD utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink, adsplice)
• Day to day troubleshooting of the environments (part of team maintains 30+ Apps instances - version of Confidential R12 in all flavors of Unix, having all versions of databases- 9i/10g/11g, size of which ranging from 20Gb to 1TB’s) which includes fixing all the issues coming in them and supporting the various components of Confidential Applications - Forms, Apache, Concurrent Manager,, BPEL services, DB, Listener
• Cloning Confidential Applications
• Weekly Refreshing environments from source environments
• Developing Backup strategies (Snapshot, Hot, Cold) for weekend backups of important environments
• Extensive Unix Shell Scripting to automate maintenance and configuration of tech stack components, Cron jobs to automate the backups, monitoring Alerts
• Securing Confidential Applications by periodically changing Apps and schema passwords
• Compiling forms/pll’s, DB invalids, creating DB links
• Monitoring Production database using Pre-defined Tools like EM, CRM ONDEMAND, Dash board, ITAS Queue etc
• Database parallel upgrades for 11g R2 and 11203 etc.
• Configuring Standby for RAC Databases and setting up Listeners
• Working on special projects for upgrades, server migrations, standby configurations etc.
• Support for Confidential production (GSIAP Instance ).
• Creating and working with Bug Support Teams for new bugs.
• Working with FUSION Database Instances
• Creating DR Setup for production databases and testing the switchovers .
• Responsible for regular interactions with the UNIX teams to troubleshoot OS/Hardware issues
• Checking backup status to ensure validity
• Cleaning the udump, cdump, bdump directories of large core files, user dumps
• Responsible for Creating Setting Up Users and Assigning Responsibility in various Operating Units
• Interacted with users and solving their issues on priority basis.
• 24x7 support on environments
• Giving training to other team members and create knowledge base/document

Environment: Confidential 11G/10G/9i/8i, OEM 10g Grid Control, RMAN, RAC, ASM, Data Guard, Streams, Patchset, Upgrade,Migration, Confidential ApplicationExpress (APEX), Exp/Imp, Mongo, Mark logic Golden Gate(12C/11G/10G), Performance tuning, Shell/Perl Scripting, PL/SQL, SQL*Plus, AIX, Linux, UNIX Server.

Confidential, Tampa, Florida

Database Administrator

Responsibilities:

• Involved in Real Application Cluster (RAC) administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking Confidential errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Confidential databases using Recovery Manager (RMAN), also setup Recovery Manager Catalog for the same and hot and cold backups.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.
• Sizing the SGA, sizing the database buffers, shared SQL area, log buffer based on the requirements.
• Confidential Export, Import, SQL*Loader and data pump utilities.
• Installing & configuring Confidential 10g, 10g RAC, 9i on Linux & RHEL.
• SQL issues and Tuning Considerations for Different Applications.
• Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for the DBA Group including installing/upgrading Confidential, creating databases, DBA tools, administration and monitoring, naming standards.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS and SQL server integration services (SSIS) in the SQL server 2000 and 2005.

Environment: Confidential 10g/11g, RHEL 5.1, IBM AIX 6.1, TOAD, SQL Developer, DBArtisan, SQL*PLUS, UNIX Shell, RMAN, 11g RAC, GoldenGate, ASM, 12c OEM, Data Guard, Putty, Secure CRT