SUMMARY:

• Worked as Senior/Primary Oracle DBA in Federal Financials, Tolling and Cloud Computing.
• Oracle Certified Professional, with extensive experience in Oracle RDBMS as DBA and analyst, Over 20 years of experience in Oracle Application environments supporting Client Server, Web, ERP, Knowledge of CRM etc.
• Experience in ETL, Oracle tools, SQL Server, CM Tools, Warehousing, Financials, Federal Financials, Reporting tools, Web tools etc.
• Highly Solutions - minded, versatile, time-sensitive with excellent analytical, problem solving, communication and inter-personal skills to Manage and interact with individuals at all levels.

TECHNICAL EXPERTISE:

Databases: Oracle Cloud, 12.2 onwards 12c,11g,11gr2,10g,9i,8i, Sql Server 7,200,2005,2008,2012,2014,2016,2017, Access, Apache Cassandra.

Operating Systems: Linux, Oracle Linux, AIX, Solaris, LINUX, HP Unix, vms, Mainframe, Windows Servers, IOS.

App Servers: Exadata, Oracle Application Server

Oracle Tools: Sql Plus, Sql Loader, Import, Export, Database Pump, Oracle Enterprise manager, User Manager, Session Manager, Backup Manager, RMAN, Oracle streams replication, Standby Database, Distributed database

Oracle High Availability: RAC, Data Guard, Physical and Logical standby, RMAN, Golden gate, streams, etc.

Oracle suites: Oracle Portal, Oracle Developer, Collaboration suite

Oracle ERP: Oracle Applications 12.2, 11i, 10.7, Oracle Financials

Apps Modules: GL, AP, PO, HZ, INV, FA, AR, WMS, WIP, HR etc

Data Warehouse: Oracle Warehouse Builder, SQL Server Integration Services, Oracle Discoverer, Business Objects, Analytical workspace manager

CM Tools: Clear case, Clear quest, Build Forge, Mercury Kintana

Storage Tools: Exadata Cells, EMC, Veritas Net backup with RMAN, PVCS

DBA Tools: OEM, SQL Navigator, TOAD, Qdba

Case Tools: Oracle Designer, Erwin, ER/Studio

Scripting: UNIX Shell, VBA Script, Swift

Web: HTML, XML, CSS, DHTML, PHP, Perl, Maya, 3Ds Max, Blender

Prog. Languages: PL/SQL, Visual Basic, VBA, VC++, Unix Shell Programming, COBOL, Java, T-SQL, Swift

Reporting Tools: Oracle Reports, Crystal Reports

Interface Tools: Oracle Forms, VB, Dot Net, Access

Other Tools: MS Office, Open Office suites

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Analyst

Responsibilities:

• Logical and Physical database Design and management, Security Management, User management
• Cloud Computing, Data modeling, OLAP, OLTP design, deployment and Tuning.
• Configuration Management support for newly developed Scripts.
• Upgrading, Patching, System Performance Tuning and Troubleshooting activities for the Oracle12c, 11g and 10g Database system installations.
• Performed Data Migration of 4 Systems with multiple databases from Legacy to Oracle and SQL server.
• Automated database health check, backup maintenance and reports using UNIX scripts.
• Supported CVO Federal projects at over 100s of Database sites (Commercial Vehicles Operation). Federal Financials.
• Developed and deployed Unix Scripts for email for Processes, email Notification, cron jobs, Automatic Backups, Log file Cleanup, disk free space maintenance and critical state management.
• Ongoing design and Development Support as well as Production Support with support for level 1 and Level 2.
• Supported EZPass and Tolling Systems and databases for MD, New Jersey, New York, South Carolina, North Carolina, Los Angeles, Texas, Florida etc.
• Tools used were, Oracle 12c,11g 11gr2,10g, Oracle Streams replication, Oracle 11i ERP, Toad, Clear case, Clear quest, RMAN, OEM, Sql*Plus, Sql*Loader, Import/Export, Database Pump, Solaris, Linux, vmware, Windows XP Servers, UNIX Scripting, Session management, user management etc.
• Oracle High Availability features like RAC, data guard, logical and physical Standby database, Hot, cold Backups, RMAN and recovery management.
• Tuning and monitoring the database for optimum performance.
• Tuning SQL for optimization and contention reduction.
• Upgraded multiple oracle systems from 9i to 10g RAC oracle systems with data guard and UNIX file system to ASM file systems and from RDB and 10g systems to 11g Oracle systems with ASM, data guard and RAC
• Participated extensively in troubleshooting and Problem solving activities for Severity 1, 2 Problems
• Helped developers to develop Simplified Oracle SQL code by converting complex logic using Oracle Analytics and Alternate Methods.
• Performance tuned the systems by analyzing system workload, SQL tuning, Indexes, AWR, ADDM, Explain Plan, Hints and alternate design suggestions etc.

Confidential, Gaithersbug, MD

DBA/Analyst

Responsibilities:

• Data modeling, OLAP, OLTP design, deployment and Tuning
• Maintained Code using clear case /Clear Quest code version control and configuration management.
• Backup and recovery, export, Import and Oracle Data Pump and RMAN based replications with Federal Financials.

Confidential, Reston, VA

Oracle Operations DBA/Architect

Responsibilities:

• Logical and Physical relational database Design and management, Data warehousing, Security Management, User management.
• Documenting ongoing Development using Reverse Engineering of the development streams.
• Maintained Enterprise Data Dictionary with Confidential specific rules.
• Data modeling, OLAP, OLTP design, deployment and Tuning
• Maintained Code using clear case /Clear Quest code version control and configuration management.
• Backup and recovery, export, Import and Oracle Data Pump and RMAN based replications.
• Developed and deployed Unix Scripts for email for running processes in the back ground, email Notification, Backups, table space size maintenance etc.
• Ongoing design and Development Support as well as 24/7 Production Support with Pager for the Operations Projects.
• Automated backup, maintenance, database health check and reports using UNIX scripts
• Tools and technologies used were, Oracle 11g,10g, Rac, Rman, Data Guard, Univeral Installer, Opatch, Toad, ER/Studio, Clear case, Clear quest, OEM, OWB, Analytical workspace manager, Sql*Plus, Sql*Loader, Unix Scripts, Import/Export, Database Pump, Solaris, Linux, Session management, user management, Oracle Security etc.
• Database performance tuning and monitoring the database for optimum performance.
• Performance tuning for the oracle systems by analyzing system workload, SQL tuning, Indexes, AWR Report Generation, ADDM Based Reports, Explain Plan, Hints and alternate design suggestions etc.

Confidential, MD

Oracle DBA

Responsibilities:

• Logical and Physical database Design and management, Security Management, User management
• Data modeling, OLAP, OLTP design ETL Conversion, deployment and Tuning.
• Configuration Management support for Newly developed Scripts.
• Maintenance and Support of Oracle Applications GL, AR, AP Modules for Finacial Customer information through Peoplesoft gateway with Customer relationship Management for Los Angeles transit System.
• Upgrading, Patching, System Performance Tuning and Troubleshooting activities for the Oracle 11g and 10g Database system installations.
• Automated database health check, backup maintenance and reports using UNIX scripts
• Developed and deployed Unix Scripts for email for Processes, email Notification, cron jobs, Automatic Backups, Log file Cleanup, disk free space maintenance and critical state management.
• Ongoing design and Development Support as well as Production Support with support for level 1 and Level 2.
• Supported Raytheon EZPass Systems and databases at Fullerton, CA remotely.
• Tools used were, Oracle 11g,10g, Oracle Streams replication, Oracle RDB, Oracle 11i ERP, Toad,Clear case, Clear quest, Build Forge, RMAN, OWB, Analytical workspace manager, OEM, Sql*Plus, Sql*Loader, Import/Export, Database Pump, Solaris, Linux, vmware, Windows XP Servers, UNIX Scripting, pearl scripting, Session management, user management etc.
• Oracle HA, logical and physical Standby database, Hot, cold Backup and recovery management
• Tuning and monitoring the database for optimum performance.
• Upgraded multiple oracle systems from 9i to 10g RAC oracle systems with data guard and UNIX file system to ASM file systems and from RDB and 10g systems to 11g Oracle systems with ASM, data guard and RAC
• Participated extensively in troubleshooting and Problem solving activities for Severity 1, 2 Problems
• Helped developers to develop Simplified Oracle SQL code by converting complex logic using Oracle Analytics and Alternate Methods.
• Performance tuned the systems by analyzing system workload, SQL tuning, Indexes, AWR, ADDM, Explain Plan, Hints and alternate design suggestions etc.

Confidential

Oracle Architect DBA/ Build Manager/ Build Validator

Responsibilities:

• Configuration Management of Builds created by Developers for the Ongoing development, to promote the Code from the Development, Transition and QA Streams to the Production for each new Medicare Insurance Company into Confidential System.
• Played critical roles intrinsic to the Project to ensure successful completion of Simulation testing, User acceptance of the First few stages of the implementation and Go Live of the System.
• Installed, configured, maintained and Upgraded Applimation (EDM) Enterprise Data Manager tools like Applimation integra, Applimation Informia Archive, Informia Compliance Archive, Informia Subset and Reporting Tools
• Created Oracle archive sets for Oracle 11i Components using Applimation Informia Archive, Generated Test Instance Data sets using Applimation Subset for testing and QA Purposes. Mapped custom tables for Comparison Workbench reporting, Generated report definitions for periodic and custom reports.
• Managing and coordinating the efforts of other DBAs for synchronizing the Configuration aspects or the system for Patching and Builds and upgrades using tools like Clear case, clear quest, Build Forge, Kintana etc. Participated in Cloning, Upgrade, Patching, System Performance Tuning and Troubleshooting activities for the Oracle 11i System and Database installations.
• Migrated multiple legacy mainframe AR systems to Oracle AR using ETL and Scripts.
• Upgraded Oracle Database from 9i to 10g using RAC, data guard and ASM file systems for testing and to AIX file systems.
• Implementation support for 10g RAC clusters with Data Guard in the Production and Test environments
• Backup and recovery, Veritas net backup with RMAN integration, standby database implementation for disaster recovery scenarios.
• Coordinated the efforts and participated in the development of Unix Scripts and Perl Scripts for Build Validation automations along with integration of the scripts with clear case tools and Oracle environment.
• Ongoing design and Development Support as well as Production Support with support for Severity1 level.
• Tools used were, Oracle 9i,10g, 9iAs, 10g AS,11i ERP, Clear case, Clear quest, Build Forge, RMAN, OEM, Sql*Plus, Sql*Loader, Import/Export, Database Pump, Solaris, AIX, Windows 2000, Session management, user management etc
• Oracle HA, logical and physical Standby database, Hot, cold Backup and recovery management
• Performance tuning and Monitoring the large 4TB databases for optimum performance.
• Developed and maintained Unix Scripts for day to day Unix level database activities, like Startup, shutdown, process monitoring, Installation maintenance, backup recovery and self help utilities
• Also extensively worked in DBA roles for the CM Database.
• Participated extensively in troubleshooting and Problem solving activities for Severity 1,2 Problems
• Sep' 01 Oct' 2004 Aspen Systems, MD (Now Lockheed Martin) Sr. Architect/Analyst
• Worked as DBA supporting Production environments of Oracle 11i Applications with Oracle 9i, Oracle 8i, Oracle 9iAS on Solaris 7/8/9, Working with a significant role as Primary DBA. Implemented high availability solutions using Oracle Standby, Data Guard and Replication technologies. Implemented RMAN, OEM across the enterprise Standardizing security and audit measures. Also involved in System administration activities of Solaris, Linux, HP UNIX and NT systems
• Installed Oracle applications and upgraded from earlier versions 10.x to 11.5.9, along with components like Reports, Forms, JRE, JDK and J-Initiator of the technology stack.
• Also worked in a Financial Loans Database for Clients Confidential
• Installation, configuration, migration and upgrades of 8i/9i/10g enterprise edition databases, Erwin, OEM 2 and Oracle Application Server (9iAS) on Solaris 2.6/ 7/ 8/9, Linux, and NT/2000.
• Installation and configuration of RH Linux 7.x/8.x for Oracle configuration
• Installation, upgrade and Maintenance of Oracle Warehouse Builder, Cube objects, tuning for performance using Transportable Table space etc.
• Performance tuning of Oracle 11i Installations for optimal performance and throughput.
• Performance and Tuning complex SQL Queries involving user defined types, nested tables, and collections for day-to-day business enhancements. Tuning of reports in Oracle Discoverer. Interfacing the design team requirement to the Oracle Designer environment.
• Oracle partitioning implementation with management for huge tables of size 200 million rows.
• Implementation and performance Tuning of Oracle under RAC using Linux clusters with Java based web applications and Oracle Application server.
• Administered Real Application Clusters Environments with SRVCTL, GSDCTL, OEM, TOAD and PFSCTL.
• Tuned and maintained Oracle Financials, Human Resources, Oracle Accounts Receivables, Invoices and other modules (GL, AP, PO, HZ, INV, FA, AR, WMS, WIP, HR etc).
• Integrated and implemented the Oracle 9iAS with Oracle Applications with R11i E-Business Suite.
• Implementation and testing of High availability Solutions like Oracle Data guard and Oracle Standby databases using RAC and multi node Oracle Applications 11i systems.
• Developing and Tuning SQL, PL/SQL Triggers and Stored procedures for Business process customizations, data automation and ETL process and mentoring developers in development activities with latest features implementation. Scripting in UNIX and PL/SQL for batch processing and Job Scheduling.
• Custom PL/SQL routines development for data transformation and loading from legacy data.
• Backup and Recovery Implementation Using SQL, Perl and Shell Scripts. Setting up standards and procedures for disaster recovery for critical databases.
• Network management using Names, Net8, SQL*Net and Network Manager.
• Performance Tuning, De-fragmentation of data bases for efficient DML activity using OEM, Scripts with MTS configurations under OFA.
• Supporting 24X7 web based Java applications and databases using Oracle 9iAS.
• Design and Development of Nested tables, Informatica Interface functions automation using Sql*ldr. Job Scheduling using Enterprise Manager, Cron tab, Custom scripts.
• Tuned and managed Concurrent Processes request sets and system resources, created Data Blocks for custom applications.
• Used Oracle Apps utilities like adaimgr, adpatch, adadmin, adctrl, adident, adsplice, licmgr.sh, adrelink
• Provided technical assistance to development and testers to troubleshoot and resolve application issues.
• Performance Tuning, De-fragmentation of HR databases for optimal performance.
• Optimized the existing Oracle Discoverer work sheets for performance and printing.
• Tuned the Reports server in Reports 6i and 9i AS Portal reports.

Confidential, MD

DBA/System Designer

Responsibilities:

• Installed and upgraded Oracle applications and tuned modules like Oracle Financials from 10SC to 11i consisting of and Human Resources, Oracle Accounts Receivables, General Ledger (GL, AP, AR, HR)
• Installed and Configured Concurrent Processing Server for Oracle ERP
• Involved in the design of multidimensional Logical and Physical Data Modeling as Oracle Architect. Integrated Confidential system which replaced the Mainframe HC System with Client/Server System
• Applied the relevant Patches on Solaris 7 to enable Oracle Migration using UNIX tools. Migrated the Confidential Production system from Oracle 805 to Oracle 8i. Performed tuning and created Backup Scripts Using OEM, SQL and Unix Scripts. Integrated the DSG system into Confidential system using Oracle Security features
• Developed the Confidential Security System in Visual Basic for integration with Confidential modules Interface. Implemented security in Oracle, Unix and Windows environments for user authentication.
• Involved in the design of multidimensional Logical and Physical Data Modeling for DSG as Oracle Architect
• Built a Star Schema using Oracle Warehouse Builder and migrated mainframe legacy data to a new Data Warehouse.
• Created the Fact tables, dimensions, relationships based on Snowflake Schema design
• Created ER diagram for DSG System, Converted the ER Diagrams to Data tables, Populated all the Lookup Tables and Supervised SQL Code in Visual Basic Modules

Confidential, MD

Apps DBA/Oracle DBA

Responsibilities:

• Installation and configuration of Oracle Applications 10.7/11 supporting Apps Sys admin
• Prepared and migrated Oracle 10SC to Oracle 11i.
• Periodically fine - tuned and optimized the database performance, Developed Triggers and Stored Procedures for data integrity.
• Migrated the Oracle ERP Production Data Base system from Oracle 7.x to Oracle 8
• Used descriptive flex fields extensively to capture additional information in standard as well as customized forms. Extensively used Forms/Reports 6i to customize 11i Forms and Reports then attach it to the 11i Application.
• Created various customized reports using Reports 6i. Used OFA/FSG to build GL Reports.
• Wrote SQL Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Customization of interfaces and conversions Oracle Financials and Human Resources, Oracle Accounts Receivables (GL, AP, AR)
• Involved in re-engineering of a multiple non-relational databases and merging them into a single relational database and Implemented security in Oracle, Unix, Windows and Access environments for user authentication. Organized and planned data migration steps, normalization and conversion of the mainframe database into Oracle
• Co-operated with the Visual Basic Developers for designing screens in 3-Tier architecture Commercial interface environment was provided for the Contractors to look into the Geographical Information System through Spatial Database Maps Using Visual Basic.