SUMMARY:

• AWS Cloud expertise in administration, migration, automation and enterprise configuration
• 12 years of experience in Oracle Database administration and Oracle EBusiness suite
• Oracle Applications upgrade specialist with 15 end to end successful implementations
• Wide experience with Oracle Hyperion suite Administration and Support
• Clone automation expert for fast and faultless EBS R12 environment refresh
• Possess exceptional analytical & problem solving skills, excellent communication and interpersonal skills, worked independently as well as in team environments

TECHNICAL SKILLS:

• AWS Cloud:
• Architect AWS instances to migrate on - premise application to cloud
• Design architecture diagram for different application
• Create IAM roles, Security group, S3 buckets for applications
• Create EC2 instance, S3, EMR, RDS, LAMBDA scripting
• AWS CLI and python scripting to automate all AWS business cycle
• Expertise in using Jenkins, Zabbix, Control-M, Ansible, Cloudformation JSON/YAML
• Created EMR managed Hadoop for Spark
• Oracle 9i/10g/11g/12C database:
• Database upgrade, patching, platform migration and data center migration
• Oracle Standby databases and Oracle DataGuard setups
• Real Application Clusters (RAC) and ASM
• Database cloning using Active DB Duplicate
• Hot and cold backup plans using Oracle Recovery Manager(RMAN)
• Database performance tuning, Maximum Availability Architecture(MAA) best practices
• Huge page setting for Oracle Database on 64-bit machine
• Setting up services in RAC database
• 11gR1 Oracle Clusterware, 11gR2/12c OEM, Grid Infrastructure installation & administration
• Setup Golden Gate unidirectional replication and administration
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc.
• Proficient in using features like Data pump, Flash-Back Recovery, Reusable Table space Management, Log Miner, Transportable Table space, Recycle bin
• Oracle 11i/R12 EBusiness Suite:
• Installation, configuration, migration, administration, patching, and cloning for 11.5.8, 11.5.9, 11.5.10.2, 12.0.6, 12.1.1, 12.1.2, 12.1.3,12.1.2
• Workflow components and mailer configuration
• Oracle 10g/11g BI Discoverer integration with EBS
• Profile Options settings and user management
• Parallel concurrent processing (PCP) and load balancer settings
• DMZ and SSL configuration
• AD Utilities, 10g AS administration
• Demantra 7.3, OBIEE, JDeveloper
• Fusion middleware: WebLogic Server, Metadata Repository, Identity Management(IDM), WebCenter, Business Intelligence Discoverer, Portal, Reports, Forms Services, SOA Suite, HTTP Server, Web Cache, Web Services, Delegated Administration Services (DAS), Enterprise Content Management Suite
• Integrating Oracle 12.1 EBusiness suite with SSO, OID
• NLS or language, family packs, maintenance packs patch installation
• Application performance tuning
• Oracle Hyperion/Enterprise Performance Management(EPM) 11.1.2.4
• Multi-node Installation, configuration, patching of EPM 11.1.2.4 on Windows and Linux
• Configure MS-AD to provide LDAP-based corporate user directories
• Create users and groups and assigned security
• Essbase ASO and BSO cube performance tuning
• Essbase database backup using MaxL command automation
• Integrated Oracle ERP Applications using FDM to integrate data related
• Migrating artifacts to different environments using LCM
• GoldenGate configuration for unidirectional replication
• Production support and Oracle Support coordination on service requests
• Scripting: Python, Perl, Shell, PLSQL
• Platforms: Linux-x86, Linux-x86-64bit, AIX, HP-UX, Windows 7, XP, 2000.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior Systems Engineer

Responsibilities:

• AWS administration for multiple applications
• Architected cloud instance for Financial Application across VPC
• Oracle EPM Administration and migration to AWS Cloud
• Automate AWS Maintenance using Python and Unix scripting
• Created complete automation of AWS instance refresh
• Expertise in Python scripting and Boto 3 SDK
• Expertise in Windows PowerShell, Unix Shell scripting and Perl
• Standalone Spark and Scala Implementation in AWS EC2
• Implemented EMR managed Hadoop application for Spark Scala
• OBIEE administration and RPD deployment
• Oracle SQL/PLSQL query to create reports
• Documentation of setup and maintenance activities and SOP activities

Project/Client: Oracle EPM Installation 11.1.2.4/ Smiths Medical

Senior Oracle DBA

Responsibilities:

• Installed 11.2.0.4 Database for Oracle Hyperion
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Designed GOLDEN GATE data bases to meet business uses
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA
• Oracle EPM and Database implementation, support and maintenance of products Planning, Report and Analysis, FDMEE and Essbase
• Troubleshoot R12 and EPM instance
• Documentation of setup and maintenance activities and SOP activities

Senior Oracle Apps DBA

Responsibilities:

• Hardware sizing, installation and upgrade for GRC suite 8.6.4.8 to 8.6.5.8
• Create AWS Machine Images for OEL and Installed EBS R12.2
• Setup GRC suite (AACG), GRCI and Fusion Middleware 11g
• Troubleshoot R12.2 and GRC instance
• Documentation of installation and upgrade activities and SOP activities

Senior Oracle Apps DBA

Responsibilities:

• Installed 11.2.0.4 Database for Oracle GRC Suite
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Monitoring of DB locks, long running transactions and blocking sessions on Production environment.
• Installed, configured and maintained databases on high availability systems like Data Guard
• Setup GRC suite (AACG/CCG) and DR setup support
• Automated cloning step using Perl and Shell Script
• Troubleshooting EBS and GRC instances
• Support and maintenance of EBS and GRC instances
• Documentation of installation and upgrade activities and SOP activities

Senior DBA Lead

Responsibilities:

• Install and upgrade of Oracle database 11g and 12C
• Analyze performance issues. Verify and tune SQL plans, queries as needed
• Upgrading 12C Oracle Enterprise manager (OEM) to 13C
• Setup Golden Gate replication from production application database to data warehouse database
• Code review for performance check and Oracle standards and perform periodic migration
• Apply Patches, Oracle installations, Perform database upgrades.
• Complete support of Application, Database and OS maintenance for 11i and R12 instances
• Automated cloning, backup and monitoring scripts
• Coordinate Weekly and Daily meetings with client for project forecast and support activities

Project/Client: Petrofac Support/ Petrofac Information Service Limited

DBA Lead

Responsibilities:

• R12 support and re-design of production instance architecture to meet the business needs.
• Hyperion integration with EBS datasource
• Converted NON-RAC Production and UAT database to two node RAC database
• Involved in cloning RAC database to RAC and non-RAC instances
• Setup standby database and performed DR rehearsal
• Support and maintenance of EBS and EPM instances
• Implementation and support of Oracle GoldenGate
• Automation of application backup, cloning and instances monitoring
• Implemented disaster recovery along with process to perform rehearsal periodically
• Facilitated the team with detailed documentation on SOP's

Oracle Apps DBA

Responsibilities:

• Planning for various test iteration till final release. For example, build up various upgrade scenarios with different techstack components and also to plan the hardware and storage resource requirements for each project
• Worked with ADS (Applications Demo System) to successfully restore their cold backup vision Apps database for the new Apps Vision release
• Upgrading the Apps database and the middle tire (IAS and tools Oracle Home) to the latest release
• Exporting the upgraded vision database to other platform teams (Solaris, AIX, etc)
• Upgrading EBS instance to the new release and deliver the autobuild template to the internal Apps division for the QA testing and enhancements (every cycle) through cloning
• Tracking all the failed jobs during the upgrade process through bugs/tickets and interacted with the product teams to get the fixes before the next cycle
• Expertise in troubleshooting techniques helped to resolve issues related to Autoconfig, Middle tier/DB upgrade issues and Oracle Apps upgrade issues
• Packaging the Apps product and testing/fixing the Rapid Install issues
• Reviewing the install and upgrade process mentioned in the documents for the customer
• Worked on the following Oracle Applications releases R12, R12.1, R12.1.X roll-outs