SUMMARY

• 12+ years of experience in Information Technology industry with10+ years of experience as Oracle DBA,, Oracle Form /Report, Oracle EBS, Software Development Life Cycle and extensive experience
• Oracle Linux/Solaris/Windows OS Oracle RDBMS & and SQL Server databases
• Oracle RAC 11g/12C grid Infrastructure one node, multi node installation and configuration
• Oracle Web Services for Fusion Middleware (Oracle WebLogic Server 10.3.6 in Oracle Fusion Middleware 11gR1
• Installation, configuration, cloning, maintaining user management issues and space management, Patching database, backups (logical and physical)
• Large Oracle Database Migration across different OS platforms.
• Oracle RAC 11g/12C grid Infrastructure one node, multi node installation and configuration
• Schema updates, data migrations, tech upgrades, user maintenance, troubleshooting, backup management, performance tuning, data recovery, and disaster recovery planning.
• AWS Infrastructure setup for Oracle Database and applications.
• Deployment of Oracle Database 12c Enterprise Edition on AWS with high availability (RAC)
• Oracle Golden Gate 11g/12c installation, Configuration on Oracle Exadata.
• Oracle Golden Gate replication to migrate data.
• Assisted in management and database administration of Oracle database applications on Oracle Exadata platforms.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Oracle E - business suite extensions for Endeca and oracle Endeca information discovery with FMW HOME and WebLogic server 10.3
• Change Management in Production and non-Production instances through ITG Kintana applications
• Documentation, software development methodology, version control, testing, and migration standards.
• Performance Tuning of SQL statements and Database using tools like AWR, Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Oracle Active Dataguard for high availability/disaster recovery setup (implement and test DR plan)
• Replication, Performance Tuning, RMAN, ASM, RAC, OEM
• Handled more than 400 databases with max size of 15TB.
• Data Pump and Exp/Imp utilities, replication of tables to cross platform and Creating Materialized Views, PL/SQL and stored procedures and SQL scripting,
• PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages, creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Oracle E-Business Suite 11.5.10, 12.2.5 installation, configuration, Patching, Cloning, Upgrade.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Diagnosis and troubleshooting typical SQL, PL/SQL Tuning issues
• Data modeling, Table restructuring, data loading with external tables in oracle database
• Disaster Recovery Strategies, testing & implementation
• Support and manage Onsite-Offshore model for Production in 24/7 systems, Development and Test instances and Oracle Applications environments of varied complexity.
• Installation and Administration of Oracle products such as Oracle Application server and non-Oracle products such as Kintana (ITG), Neotix
• Create Endeca Discoverer applications to do analysis of Data.
• Installation and configuration of Sun Solaris 10
• Installation and configuration of Sun Storage T3 and T4
• Development of application using Oracle Form 6i, 11g Developer.
• Financial Application development using Microsoft Visual Basic, MSSQL Server
• Installation and administration of Microsoft SQL Server 2000

TECHNICAL SKILLS

Platforms: Linux, HP-UX, Oracle Exadata, Oracle Solaris SPARC 8/9/10, Windows (NT2008R2), RHEL 5/6

Database: Oracle 12C, 11gR1/R2 (11.1.0.7/11.2.0.3/11.2.0.4 ), Oracle 10g, Oracle 9i/8i, MS-SQL Server (7,2000) 11gR2 active dataguard

ERP Applications: Oracle eBusiness Applications 11i (11.5.4, 11.5.9/ 11.5.10.2 ), R12 (12.1.3/ R12.2.5)

Languages: PLSQL, UNIX Shell Scripts, Java, Visual Basic,C,C++,Oracle Forms 6i/11g

Third Party applications: HP Kintana Applications (ITG for deploying scripts, forms, reports, objects), OBIEE, ebusiness Endeca applications, Share point, NOETIX,Excel4apps

Tools: & Utilities: Oracle Enterprise Manager (OEM),Oracle Golden Gate, SQL Developer, Endeca, Oracle Hyperion, Toad, VNC, Hadoop Cluster, Secret Server (Enterprise Password Management), NetApp Backup, Cassandra NoSQL database,MATLAB

PROFESSIONAL EXPERIENCE

Confidential, Columbia SC

Senior Oracle DBA

Responsibilities:

• End to end Support and implementation for more than 100s 11g and 12C Production, UAT and Development database.
• Oracle Database db fresh, schema refresh, creation of new database for DEV, TEST, UAT environment.
• Installation, Configuration, deployment of Oracle Grid infrastructure Cluster, RAC 3 node, 2 node environment for Production databases.
• Installation, configuration, deployment of Oracle Enterprise Manager (OEM 11g, 12c) and OEM agent deployment for Production, UAT and DEV environment.
• Daily database monitoring activity which includes oncall DBA, responding to Production database alerts, warnings and try to meet SLA for Severity 1 issues.
• Installation, configuration of Oracle Data guard (Disaster -Recovery).
• Deployment and testing of RMAN database backup and recovery strategies.
• Performs tuning of the databases and helping developer team to tune SQL and PL-SQL.
• Apply Oracle database patches (opatch) Critical Patch Update (CPU), Patch Set Updates (PSU), Security Patch Update (SPU)
• Enable audit for schema/tables and password management, SOX audit, extensively used profile based users.
• Assisted in management and database administration of Oracle database applications on Oracle Exadata platforms.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Installation, configuration and deployment of unidirectional Oracle Golden Gate setup.
• Migration of large data from external Client database like Text/CSV files, MS Access, MS SQL Server to Oracle Database.
• Migration and configuration of Oracle Database from internal infrastructure to AWS Cloud.
• Manage sharing of resources among applications and Multiple Standby Database setup for Critical databases.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures and creating new instances when require.
• Attending daily scrum, Kanban meeting with different stake holder including Business Analyst, Developer, Testing Team and other DBA Teams.
• Create, update and maintaining of User Stories (US) as per user requirements in JIRA, Rally agile Software.
• Design and deployment for MATLAB software for Machine Learning Technic to analyze System, Database and application log files to make prediction and analysis of system overall performance.

Environment: Oracle RDBMS 12C/11gR1/11gR2/, RMAN, Oracle Linux 6, OEM11g/12c, Oracle Golden Gate Share point, MS SQL Server 2015,Rally, JIRA, KANBAN, MATLAB

Confidential, St. Louis MO

Senior Oracle DBA

Responsibilities:

• End to end Support and implementation for Oracle 11g/ Dev/Test/Production instances for multiple applications.
• Daily backups and db refresh from production database to Dev/Test
• Migration of the databases and applications between different file systems on different filers.
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database
• 11gR2 active dataguard and DR drill (once in 6 months)
• Plans and implements backup and recovery of the Oracle database.
• Installation and configuration of Oracle Developer Suite 11g (Forms, Reports)
• Installation and configuration of Oracle WebLogic Server 10.1.3
• Create users and provide access to developer team with required privileges
• Apply Oracle database patches (opatch) Critical Patch Update (CPU), Patch Set Updates (PSU), Security Patch Update (SPU)
• Installation and configuration of Oracle Form 11g,Reports,Toad,WebLogic 10.3
• Help BA and Development team to Tune the Business Rules, Tune the Data Design, Tune the Application Design
• Frequently checking if require changes to the data design and additional creation of indexes to increase performance of application
• Help to Development team to understand Oracle's query processing mechanism to write effective SQL statements.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.

Environment: Oracle RDBMS 12C/11gR1/11gR2/ RMAN, Oracle Linux 6, EM11g/12c,Oracle Form 11g,Report, Web logic Server 10.1.3, Share point

Confidential, O’Fallon IL

Principle Oracle DBA

Responsibilities:

• End to end Support and implementation for 11g and 12C Production instances.
• Daily backups and daily refresh instances.
• Oracle patching on DEV, UAT and Productions.
• Supported Kintana database upgrades from 10g to 11g and agile upgrade
• Migration of the databases and applications between different file systems on different filers.
• 11gR2 active dataguard and DR drill (once in 6 months)
• Oracle Database Cloning on Linux.
• Installation, configuration and maintenance of Hyperion EPM 11.1.2.3
• Assists with impact analysis of any changes made to the database objects.
• Closely works with system administration, Network and Linux teams
• Performs tuning of the databases and Performs the capacity planning to create & maintain the databases
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database
• Plans and implements backup and recovery of the Oracle database.
• Apply Oracle database patches (opatch) Critical Patch Update (CPU), Patch Set Updates (PSU), Security Patch Update (SPU)
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views
• Enable audit for schema/tables and password management, SOX audit, extensively used profile based users.
• Installed and configured golden gate on Exadata. Implemented broadcasting and bi-directional replication.
• Resolved replication issues in Golden gate. Automating tasks using cron for GG restart
• Configured Golden Gate to achieve unidirectional and bidirectional replication.
• Prepare Golden Gate parameter files for Extraction and Replication
• Performs database re-orgs as required to assist performance and ensure maximum uptime of the database.
• Provides technical support to application development teams
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures and creating new instances when required
• Manage sharing of resources amongst applications and Multiple Standby Database setup for Critical databases.
• Closely work with Onsite-Offshore DBA and Development Team.
• Support 24x7 operations for Production/Dev/UAT databases in Onsite/Offshore working model and ensure 100% uptime of IT Infrastructure for Clients.

Environment: Oracle RDBMS 12C/11gR1/11gR2/10g/9i, RMAN, Oracle Linux 6, OBIEE, OEM11g/12c, Hyperion EPM 11.1.2.3,Share point, Secret Server (Enterprise Password Management), Oracle EBS 11i

Confidential, O’Fallon IL

Senior Oracle DBA

Responsibilities:

• Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Oracle Development and Test Instance.
• End to end Support and implementation for Oracle 11g all Pre-production instances.
• Co-ordination between Development and DBA team
• Discussion with Customer for future project implementations.
• Installation, Monitoring and Administration of SUN SOLARIS Server.
• Installation and configuration of different third party tools.
• Closely works with Network teams
• Performs tuning of the databases and Performs the capacity planning to create & maintain the databases
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database
• Installation, configuration and maintenance of Hyperion EPM Release 9.3.3

Environment: Oracle RDBMS 11gR1/11gR2/10g, RMAN, Oracle Solaris, Share point, Hyperion EPM Release 9.3.3, Oracle EBS 11i

Confidential, St. Louis, MO

Oracle DBA

Responsibilities:

• Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Oracle EBS 11i Development, Test, UAT and PROD Instance
• End to end Support and implementation for EBS 11i Production instances.
• 11gR2 active dataguard and DR drill (once in 3 months)
• Cloning of Dev,Test and UAT instances from Production
• Patch analysis, Patch application on DEV UAT PROD using Kintana Package
• Discussion with Customer for future project implementations.
• Installation and configuration of different third party tools.
• Closely work with Onsite-Offshore DBA and Development Team.
• Plans and implements backup and recovery of the Oracle database using NetApp Backup.
• Installation and configuration of Neotix, kintana tools

Environment:, Oracle RDBMS 11gR1/10g, RMAN, Oracle Solaris, Share point,Kintana, Neotix

Confidential

Oracle DBA and MSSQL Server DBA

Responsibilities:

• Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Finance application Development, Test, UAT and PROD Instance
• Patch analysis, Patch application, Cloning.
• Regularly Checking Alert log, Implementing Backup strategy. Monitoring Users, Concurrent Managers using Sysadmin, Pro-Active Checks up on the Database
• Installation, configuration and Implementing Backup strategy of MS SQL Server 2000.

Environment: Oracle RDBMS 10g/9i, RMAN, HP -UX, MSSQL 2000

Confidential

Software Developer and MSSQL Server DBA

Responsibilities:

• Successfully analyzed all business rules for Voucher Transaction module.
• Explored some features to implement these business rules available in Oracle 8i.
• Declared prototypes of functions used in this module, defined Oracle Form Screen interface, formatted different financial report required in system in Reports
• Implemented user interface screen for above-mentioned modules.
• Successfully installed application at client side and gave client side support for the product.

Environment: Visual Basic 6.0,MSSQL Server 7/2000, Crystal Report 7, Oracle form 6i, Oracle RDBMS 8i, Visual Source Safe, MS office 2000