SUMMARY:

A skilled technical consultant with over twenty four years of experience as Team Lead, Senior Application DBA, Unix system administrator, VMware administration. Expert level skills in migration and administration of databases. Re - engineering of Business Processes including applications functional and technical design.

TECHNICAL SKILLS:

Database: Oracle 8i,9i, 10g, 11g, 11gR2, 12C, DB2, SQL Server2008, SQL Server 2012 and 2014.

Server OS: Sun Solaris7,8,9,10, Linux, MVS, VM, DOS-ESA, Windows NT, Windows Server 2003,2008,2012R2, 2016, VMWare Esx3.5, VMWare Esx5.1, AWS.

Software/Tools: Oracle 10g Grid Control, Oracle Enterprise Manager 12c Cloud Control, Oracle Application server, Oracle RAC, OEM, ASM, AWROracle Discoverer, Oracle Advanced Security, ADDM, Oracle MAA, Oracle StreamsOracle Replication, Oracle GoldenGate, Oracle Workflow, Rman, Dataguard, Oracle Capacity Planner, Oracle Performance Manager, Erwin, Toad, pl/sql, PeoplesoftBusiness Object, Crystal Reports9, Java, XML, HTML, CVS, Subversion, Samba, VSSSiebel 8.1, Netapp ONTAP 7.1, VSC, Snapdrive, Vcenter, Tivoli TSM backupVeritas Netbackup.

Hardware: Sun T200, Sun blade T6300, Sun E4500, Sun Fire V440, Sun Fire V240, Sun Fire V880, AIX, RedHat Linux servers, HP Itanium servers, Dell Xenon Servers, HP BL490, Netapp FAS3220

EXPERIENCE:

Confidential

Senior System Architect

Software/Tools: Oracle 12c, Mongo DB, MySQL, MS SQL Server, Java8, NodeJS, Apache Kafka, Dockers, Linux, AWS

Responsibilities:

• Design system and database for a highly scalable pharmacy data acquisition system.
• Architect Microservices based software using CQRS architectural pattern.

Confidential, Washington, DC

Senior Application DBA

Software/Tools: Oracle 11g, Oracle12c, Oracle12c EM Cloud Control, VMWare ESX5.1RMAN, SQL Server 2008, SQL Server 2012, Microsoft IISCOMMVault, Microsoft SCOM

Hardware: Dell E550, Dell 5160, HP Blade BL490

Responsibilities:

• Upgrade all Oracle databases including Steps SMART cables database from 11gR2 to Oracle 12c.
• Install and configure Oracle Enterprise Manger Cloud Control 12c.
• Deploy and configure Oracle management agent to monitor all Oracle databases.
• Upgrade SQL server databases from 2008 to 2012.

Confidential, Washington, DC

Senior Application DBA

Software/Tools: Oracle 11gR2, Oracle Discoverer 11.1.1.7, SAP Business ObjectsRedHat Linux, VMWare ESX5.1, RMAN, Data Guard, Grid control.

Hardware: Dell E550, Dell 5160, Netapp FAS3220, HP Blade BL490

Responsibilities:

• Involved in upgrading BMC Remedy 7.5 to Remedy 8.1
• Involved in installing and configuring Oracle 11gR2 database for test, stage, training and production databases.
• Involved in installing and configuration standby databases.
• Assist to convert single instance databases to RAC.
• Develop Java plugins using Java Authentication and Authorization service for Remedy users to do a Single sign on using the users Kerberos tickets from windows AD.

Confidential, Pittsburgh, PA

Application DBA

Software/Tools: Oracle 11g, 12C, Oracle EBS R12, Oracle Discoverer 11.1.1.7 Oracle ExadataRedHat Linux, Oracle VM, Oracle RAC, RMAN, Data Guard, Grid control

Hardware: Oracle Exadata Machine X2-2, Oracle Sun ZFS 7100 Storage Appliance.

Responsibilities:

• Involved in upgrading Oracle E-Business Suite (OEBS) from version 12.0.6 to R12.2.4 used by Naval Nuclear Reactor facility at Confidential and Knolls,
• Involved in hardening OEBS per security guidelines
• Involved in setting up RAC database for testing EBS upgrade.
• Involved in upgrading database to Oracle 12c.
• Enabled HTTPS to all Fusion middleware components
• Involved in documenting run book for upgrading Oracle E-Busin

Confidential

Senior Application DBA

Software/Tools: Oracle 9i, 10g, 11g, 12c, Oracle RAC, RMAN, Data Guard, Grid controlOracle Advanced Secuiry (ASO), Oracle Wallet, OMS, ASM, AWR, ADDMOracle Application Server, Oracle OID, Oracle Reports, Business ObjectIBM DataStage ISI Server, IBM Websphere, VM Ware ESX 3.5, ESX5.1, Netapp ONTAP7.1, VSC, Snapdrive, Siebel 8.1, Tivoli TSM backupVeritas Netbackup, CVS, Subversion.

Hardware: Dell E550, Dell 5160, Netapp FAS3220, HP Blade BL490.

Responsibilities:

• Involved in supporting all DS/CTO databases and Oracle Application servers.
• Migrated databases to ESOC datacenter. Upgrade database from Oracle 9i to Oracle 11g and converted to Oracle RAC database.
• Migrated Database ASM storage from fiber attached LUN to iSCSI LUN.
• Converted character set of databases to Multi byte Unicode character. Implement Oracle TDE for tablespace encryption. Procedure document to configure and recover TDE tablespaces.
• Migrate Oracle VM from old development network to new VMWare hosts.
• Install and Configure IBM ISI in test servers.
• Install and configure Oracle 12c Cloud control in openNet.
• Install and upgrade Oracle Rman repository database to Oracle 11gR2. Configure Rman backup to Tivoli tape backup.

Confidential

Senior Oracle DBA

Software/Tools: Oracle 9i, 10g, Oracle RAC, RMAN, Designer, Oracle Application Server, TOAD

Hardware: IBM Linux Z OS, VM Ware, Windows Server 2003

Responsibilities:

• Deploy oracle pl/sql code to development, SAT, CAT and production Systems
• Help troubleshoot production performance issues.
• Provide recommendation to tune 5TB SASP application database.
• Provide recommendation for all oracle related issues.

Confidential, Fairlakes, VA

Senior Oracle DBA

Software/Tools: Oracle 9i, 10g, 11g, Oracle RAC, RMAN, Data Guard, Grid control, Oracle Advanced Security (ASO), Oracle Wallet, OMS, ASM, AWR, ADDM, Sun SolarisOracle Multi Master Replication. Discoverer, Designer, Oracle Application Server

Hardware: Sun T2000, Sun blade T6300, Sun T5140, Sun 240, Sun Fire V440 Sun Fire V880

Responsibilities:

• Involved in supporting all Infrastructure Support Module (ISM) and Range Facility Management System (RFMS) test and production databases.
• Involved in migrating production Infrastructure Support Module(ISM) Database to new hardware.
• Upgraded all database from Oracle 10g to Oracle 11g.
• Upgraded Oracle Discoverer Repository database from Oracle 10g to 11g
• Involved in upgrading ISM production database from a replicated database to Physical standby database.
• Involved in installing Oracle Security patches to all databases.
• Configured ASO, Installed https listener and updated certificates in Oracle wallet.
• Installed Oracle Grid control 10g to manage all test and production database.
• Monitor OPMN and Http logs to resolve Oracle containers and Http server issues.
• Actively involved in performance tuning of ISM database. Provided recommendation to tune application based on AWR and ADDM reports.
• Fix security violations and vulnerabilities (SRR) in ISM databases that were detected by APPDetective scans.

Confidential, Mclean, VA

Senior Enterprise Oracle DBA

Software/Tools: Oracle 9i, 10g, 11g, Oracle RAC, RMAN, DataGuard, Grid controlOMS, ASM, AWR, ADDM, TOAD, Veritas, Netapp, Netapp SMONetworker, Sun Solaris, Remedy, Linux. SQL Server

Hardware: Sun T2000, Sun blade T6300, Sun 240, Sun Fire V440 Sun Fire V880, AIXRedHat Linux.

Responsibilities:

• Involved in maintaining production databases.
• Involved in migrating Database from Miami to hosted TECC center
• Actively monitored a 6 node RAC, DG configuration database. Used RAC views extensively to monitor the RAC databases.
• Installed and tested Netapp to backup and restore databases.
• Configured ASM instance. Configured and Installed Oracle RAC using ASM disk groups.
• Provide performance improvement recommendation based on AWR and ADDM reports on a daily basis.
• Involved in installing Oracle CPU patches to the databases.

Confidential, Mclean, VA

Senior Oracle and Peoplesoft Database Consultant

Software/Tools: Oracle 8i, 9i, 10g, Oracle Application server 10g, Oracle Workflow, Oracle RACRMAN, DataGuard, Grid control, OMS, ASM, AWR, ADDM, TOADPeoplesoft FMS8.8, Veritas, Netbackup, Sun Solaris, Informatica, Crystal ReportsLinux, VSS, SQL Server.

Hardware: Sun T2000, Sun blade T6300, Sun 240, Sun Fire V440 Sun Fire V880, RedHat linux.

Responsibilities:

• Involved in maintaining FEC production and testing databases disclosure, budget, peoplesoft, clearquest, calendar, Comprizon, Rational Portfolio Manger and public disclosure.
• Migrate all FEC databases from Oracle 9i to Oracle 10g.
• Upgrade Peoplesoft database to Oracle 8.1
• Converted single node databases to 4 node DataGuard databases. Per Service level agreement converted 2 nodes to physical standby reporting databases.
• Installed Oracle 10g databases, installed oracle workflow, installed Oracle 10g Grid control and Oracle Application server 10g.
• Installed and configured Oracle Data Guard databases with primary and physical standby databases for maximum availability.
• Configured Oracle Maximum Available Architecture (MAA) using Fast Application Notification (FAN) for all JDBC client types.
• Configured ASM. Installed and test Oracle RAC in sun fire blade servers.
• Monitor OPMN and HTTP logs to resolve Oracle Application and Web server issues.
• Played an active role to documented disaster recovery procedures for all FEC databases.
• Clone and refresh database instances for development and testing purposes.
• Created replication to replicate disclosure database to remote database server hosted in Boston .
• Created hot, cold backup and rman shell scripts to backup all production databases. Created cron jobs and coded UNIX shell scripts to automatically replicate data to external map application databases.
• Wrote shell scripts to parse xml files, create html electioneering data, automatically transfer files to Informatica used by map application, shell scripts for general database monitoring and tuning.
• Perform routine database tuning and administration activity.
• Provided recommendation to tune application based on AWR and ADDM reports.

Confidential, Pittsburgh, PA

Oracle DBA

Software/Tools: Oracle 8i, 9i, Oracle Express Server, Svrmgr, Sql*net, Rman, OEM, SQL Server 7Veritas, TOAD, Sun Solaris7, 8, Crystal Reports, Jdk1.2.2, XML, HTML, CVSSamba, ATG Dynamo.

Hardware: Sun E250, AIX, Sun Ultra 510, Compaq 4 processors Pentium servers.

Responsibilities:

• Installed and maintained Oracle OLTP and report system running on Solaris and NT servers.
• Oracle installations (OFA compliant), creation of new databases, performance monitoring and tuning, networking, backup and recovery.
• Formulation, Design, Testing and documentation of Backup and Recovery strategies for point in time recovery.
• Upgrade the database and O/S architecture from 2 tier to N tier failover redundant architecture.
• Did an extensive Evaluation and case study on OLAP oracle express for united way report system.
• Architect and developed homegrown oracle report system. Wrote pl/sql scripts, stored procedure to extract, transform and load data from sql server to Oracle database. Used extensively by more than 160 Pittsburgh based corporations.
• Tuned and troubleshoot performance issues.
• In depth knowledge of Oracle Architecture to track application bottlenecks by using dynamic performance v$ views and x$ tables, tuning init parameters to optimize instances for delivering peak performance.
• Created import process to load Information Retrieval data and Help connections data to OLTP database.
• Moved data files from EMC disk group to local disk group to reduce recurring monthly cost.
• Export the invoice information from online application using Oracle 8i to backend sql server database.
• Executed statspack and provided daily recommendation to tune query and improve performance of databases.
• Technical assistance and troubleshoot ATG application server and Apache Http server logs.
• Application design and implementation, Business process Re-engineering, Design and Implementation of Interfaces with backend Systems on local and remote machines for critical business processes.

Confidential, Pittsburgh, PA

Oracle DBA and support Unix system administration

Software/Tools: Sun Solaris 2.6, Oracle 7.3, 8i, Svrmgr, Sql*net, Rman, OEM, CVS, Samba, Weblogic, IPlanet, ATG Dynamo, WebSphere3.5.

Hardware: Sun Netra 1400, Sun Netra 1405, Sun E250,HP Window servers.

Responsibilities:

• Maintained all production databases and also worked with development team to maintain development and deploy production applications related to Bank of America, Wells Fargo, Federal Home Loan Bank and Confidential projects.
• Created oracle databases and schemas for use by different development teams.
• Performed Database upgrades and migration.
• Installed Weblogic server and deployed java application
• Technical assistance and troubleshoot Weblogic server and Http server logs.
• Designed, implement and maintain redundant system architecture for hosting web site in sun solaris servers.
• Involved in server consolidation, capacity planning etc.
• Involved in designing and implementing Information and Referral Database, Epledge process.
• Installed production Oracle 8i databases, OEM, ATG Dynamo Application server, and Iplanet web servers in production and staging servers.
• Application and database performance and troubleshooting.
• PL/SQL, sql procedure and Unix scripting for BOFA application and internal use.
• Setup and maintain oracle connectivity through SQL*Net and JDBC.
• Process and procedure documentation.

Confidential, Pittsburgh, PA

Lead Oracle Data Analyst

Software/Tools: Oracle 7, MVS, Cobol-II, CICS, VSAM, DB2, Easytrieve, Viasoft, Fileaid.

Responsibilities:

• Supported and administer Oracle database for Tenncare data entry system.
• Created Test and Production data load process to load VSAM, ISAM, flat files to Oracle.
• Design tables to import flat files to Oracle database, Assisted in data load and data manipulation processes.
• Produced ad-hoc pl/sql reports for recipient system as requested by state employees.

Confidential, Elyria, OH

Software/Tools: DOS/ESA, Cobol-85, Oracle 7, CICS, VSAM, Easytrieve.

Responsibilities:

• Involved in migration of application data from IBM Mainframe DOS/VSE to oracle database.
• Created test flat files for testing load process. Wrote sql scripts to test the output data in the new system.
• Responsible in test, analysis of pl/sql scripts, converting production VSAM files for unit and system testing.
• Was also involved in Data migration for Order Processing, Financial, Marketing and Manufacturing applications.