Summary

• Information Technology professional with 20 years of full software development life cycle experience. Involved in many Project Planning / Scoping, Analysis, Design, Architecture, Specifications, Development, Team Coordination, Documentation, Implementation, Maintenance, User Training, Quality Assurance and end user interaction. Experience in various roles such as Applications DBA, Manager Applications/Infrastructure, Oracle DBA, Programmer Analyst in Linux/Unix, Windows environments. I have very strong analytical and problem solving skills and excellent interpersonal communication skills and easy to work with.
• Oracle 11.2/ 10g / 9i / 8.1.7/ 8.1.6
• Oracle 9i RAC Rel-2 , Cloud Control, Grid Control, OEM PL/SQL,SQL, Oracle 10g Developer/ 6.0, RMAN MS SQL Server 2012/ 2008 / 2005 / 2000 , MOM,SCOM
• Oracle 9i/10g Application Server
• Webcenter 11, Weblogic Server 10.3/ 9.1 / 8.1 / 7.2 /6.1
• RedHat Linux AS 3.0, 4.5,5.0 SUN Solaris 10,8/7 DELL PowerEdge 6650, 2650,1850,1750, HP A,N,L class UNIX Shell scripts, Veritas Net Backup, Omniback 4

Technical Environment:

• HARDWARE: DELL PowerEdge 6650, PE 1850, PE 1650, HP A,L,N class, SUN FIRE 280R, SUN
• SPARC Station, IBM AS400, SYSTEM /38, PC's, Netscaler, Dec Alpha, HP DL385, HP 585
• OPERATING: RHEL Linux AS/ES 3,4.0, HPUX 11.i, 11.0, SUN Solaris 8/9,
• Win NT 4.0, WIN XP/2003
• /2000/98/NT/SYSTEM, HITACHI SAN Cluster, EMC Clarion CX700, EMC Symmetric, Tru64, Suse Linux,AIX
• SOFTWARE:
• EBS 11.5.10.2, ORACLE 9i RAC Rel-2 , Oracle 11G Grid OEM, Oracle 10g Developer Suite,
• Oracle 6i,9i/10g Application Servers, Oracle 11g,10g,9i, 8.1.7.4 / 8.1.6, Webcenter 11, UCM,WeLogic 10.3/9.2/8.1/7.2/6.1, Oracle Developer 10g/2000/6.0, Oracle Forms 10g/6i/4.5,Reports 10g/6i/3.5, Designer 2000, ERWIN 4.0, PL/SQL, SQL Loader, TKPROF, SQL Server 2012/2008/2005/2000, 2008 Windows Failover Cluster Services, MS-Office, MS Access, Apache, IIS, Documentum 5.2, Tomcat, PVCS, CVS, DBCA, Reflections, OCFS,SAPDBA, SAP 4.6, Quest Spotlight,Foglight, SQL Plus,PL/SQL and TSQL
• TOOLS:Oracle 11/10 Grid, 9i OEM, Toad, Oracle Enterprise Manager 2.2, RMAN, Secured Shell, Veritas Netbackup, HP OmniBack II, Tivoli, NetWorker

Professional Experience

Confidential

• For Cash America assigned to PMO project initiatives, development team break-fix/build initiatives and day to day operational support for application databases in production/non-production environments. Member of Architecture Review Board ARB and backup member for Change Advisory Board CAB representing database team/technologies.
• Duties included DBA on-call rotation, Backup/Recovery, DR testing post failover, environment refreshes, performance tuning, troubleshooting, root cause analysis, capacity planning, software installation, configuration, working with in house teams /external vendors on packaged application upgrades of Tivoli SmartCloud, ReConnect, ImageNow, TaxSolver in addition to custom Oracle and SQL database deployments.
• ARB, project planning phase review of architecture for standards and/or bringing awareness to any company/vendor standards, policies or industry best practices applicable.
• CAB duties review approve/reject production changes where risk of unscheduled outages or unexpected results are not mitigated through lifecycle process or reasonable testing completed with expected results..
• Provided guidance and assistance to less experienced team members in Oracle Linux/Unix environments.
• Responsible for SSIS packages supporting interfaces to/from Lawson. Responsible for SSIS packages supporting interfaces to/from Lawson.

Production

Confidential

• Working at Verizon provided build and run support for Corporate applications in multi tiered - multi data center environments for both production and non-production Duties included application builds/deployments, performance tuning, troubleshooting, root cause analysis, requirements gathering installation and configuration of all middleware components, backfilling database administrator role for SQL Server and coordination of efforts for Oracle databases as needed, established backbone monitoring and associated charting/reporting in Gomez to establish metrics for baseline performance of geographic load balancing through Alkami.
• Provided guidance and assistance to less experienced team members.
• Using SQL Developer/Toad assisted development teams with troubleshooting/tuning PL/SQL packages.
• I consolidated stored procedures into PL/SQL packages by application functional areas.
• Coordination of efforts with off-shore resources
• Documented application deployments and start/stop procedures.
• Successful remediation of security and vulnerability scan deficiencies.
• Successful move of production clustered SQLServer databases to new datacenter.
• Resolved technical issues associated with implementing Netbackup for SQLServer.
• Wrote many bash shell scripts for automating repetitive tasks / processes.
• Wrote bash shell script to move all log files off root file system associated with
• Apache, Siteminder WebAgent, wls plugin and apache rewrite logs.
• Installed and assisted with Six-Sigma implementation.
• Tech:
• Oracle UCM 10.3, Webcenter 11, Siteminder, Apache, Apache rewrite, IBR, OBIEE, Linux,Windows 2008 R2, SQLServer 2005, SQLServer 2008 Webcenter 11, Alkami, Gomez, Http Watch, NetMon, Oracle 11.2, Oracle RAC 11.2, ASM, SCAN . , Linux, Windows 2008 R2, OVM, PL/SQL

Confidential

• Working at DynCorp as Sr. Oracle DBA duties included Solaris 10 System administration in addition to DB, supporting storage consolidation from EMC CX400 to Left Hand, successfully demonstrated performance gains in OLTP environment using SAME which was adopted as standard for OLTP deployments. Changed physical DB file layout taking advantage of SSD, replaced HBA's and updated packages and firmware to supported levels. I resolved lingering DR test recovery failures for Oracle DB's. Diagnosed performance impact of recycling bin being enabled on dictionary views disabled recycling bin removed backup images. updated analyze jobs to include system objects. Removed parallel processing all together improving stability
• for mixed OLAP/OLTP usage improving month-end close processing.
• Performance tuning Cost Point application, assisted development team in re-writing custom PL/SQL modules post upgrade of financial applications.
• Utilized Solaris 10 SPARC, Windows 2008 R2, Oracle RDBMS 11.2, 10.2 ,Grid 11.2

Confidential

• As Sr Systems Engineer supporting corporate applications my responsibilities encompassed hardware, web server tiers, application server tiers and Oracle and SQLServer database tiers. Duties included operating system patching, backup and recovery, patch analysis and application, capacity planning, performance tuning, DR documentation and acting as liaison between infrastructure and applications.
• I successfully planned, documented and executed the application of an Oracle CPU and upgraded two of the four databases across dev, qa and production environments from version 9.2 to 10.2 that support the IMANY software stack supporting pricing and contract compliance. Utilizing Oracle on AIX, SQLServer 2005, Weblogic 8, IIS, Power builder, AIX, Control-M, MQ, vmware
• I successfully deployed Strohls software for disaster recovery / business continuity project which was a requirement of the hosting provider for pre production change validation. SQLServer,IIS,Tivoli
• Nominated and accepted to Alcon's Oracle center of Excellence team.
• I successfully sized and procured hardware to support Essbase upgrade and installed all vendor software in development and production. Utilized Essbase 11, SQLServer 2005, AD, Cisco ACE,VMWare.
• Technical lead on project implementing global application adding workflow to AP purchase orders and invoices for JDE One World. I Worked with vendor, applications team and various infrastructure resources to successfully deploy solution. Utilized SQLServer, IIS, Citrix, Vmware, Cisco ACE load balancer, Control-M,Tivoli, Quest Spotlight .
• Technical lead for the production upgrade of the Certus application used for SOX compliance. By taking ownership of the project I was able to resolve many technical issues in-house allowing the project to be delivered on time and under budget. Utilized Weblogic, SQLServer, Vmware,Tivoli

Confidential

• As Oracle Applications DBA/Sysadmin for Corporate IT was responsible for the day to day operations and health of our Oracle E-business suite application and all related infrastructure approx 30 servers . Duties include operating system patching, backup and recovery, patch analysis and application, capacity planning, performance tuning, metric gathering and reporting, DR documentation and providing input to Business Analysts and development teams.
• To address capacity, performance issues and HA requirements researched architected and implemented a shared APPL TOP, shared application tier file system , moved DB storage to SAN and implemented load balancing at both the HTTP and Jserv layers additionally implemented SSL offloading. The changes made addressed performance issues, reduced downtime associated with patching and alleviated capacity issues for an improved end user experience. Required coordination and troubleshooting with infrastructure resources.
• Replaced Cold backups with RMAN hot backups increasing application availability.
• Successfully recovered Oracle EBS during 24 hour recovery window.
• Maintain Oracle Grid control environment, including Discoverer for reporting.
• Responsible for production implementations from both internal and contracted developers and maintaining version control across promotion model.
• I have successfully upgraded EBS database tier in development, patch and QA to 10.2.0.3 from 9.2.0.7, planning Prod in fourth quarter 2008.
• Provided user community and technical staff current patching levels across all environments, researched and applied patches and module upgrades as required.
• In addition to the above I was the Linux system administrator for all EBS servers.

Confidential

• As Manager Applications/Infrastructure I was responsible for the day to day operations and health of our Oracle stack, BEA environments and coordination with our infrastructure provider, Other duties and prior project work include capacity planning, server consolidation, instance Consolidation, designing Application Integration process, scoping, estimation, setup, migration, implementation, configuration and maintenance of entire Oracle Enterprise Application Databases, Application servers, Webservers. Activities: - I recently upgraded our 10g Grid Control from 10.1.0.2 to 10.1.0.5. - Replaced Cisco content switches used for application load balancing with Netscaler HA pair for Oracle and J2EE environments. - As LSG Sky Chefs Applications Technical lead working with Dell Professional Services on installation and configuration of Dell/Oracle Deployment, primary contact for Accenture project team upgrading

• J2EE and Oracle applications from WLS 6.1 to 8.1 and 9ias to 10gas for Server Consolidation project.
• Team successfully planned upgraded and migrated entire Americas LSG Sky Chefs applications databases from expensive and aged hardware to Linux based hardware architecture using Red-Hat

• Linux AS 3.0, Oracle 9i RAC, 9i/10g Application servers and 10G Grid OEM. Around 15 different
• Enterprise applications were migrated to new hardware and software platform as part of this server
• consolidation project. - Assumed support and maintenance responsibilities for I2 applications hosted by EDS for a sister
• company. - Setup, Upgraded, Migrated and managing 4 critical OLTP application databases to Oracle 9i RAC Rel.2
• HA environment - Installed, configured Oracle 10G Grid Control for managing and monitoring Oracle databases and
• Application servers - Installed, configured, troubleshoot and administer application server software,Weblogic, Tomcat, Oracle
• 10G application server. - Deploying J2EE applications, Managing, Troubleshooting and Monitoring WebLogic 8.1/7.2 application
• and servers running on Sun, Linux and W2K. - Managing various production oracle databases and 10g Application servers with 24x7 support along with
• several active projects. - Documented procedures for building and configuring webservers, set up sudo and permissions and
• Samba for W2k common shared server. - Database partition management, Archiving, Online Tuning, SQL Tuning, Perfstat and Periodicmaintenance. - Performed various Backup/Recovery using RMAN hot backups, RMAN Cloning, Regular Hot/Cold backups using shell scripts - Performed various Export/Import techniques and Database refresh methods. - Automated and setup various custom monitor Shell scripts for managing database environments and
• Web Logic processes. - Maintenance and change process are followed by strict change management procedures and version management. - Experience working cases with software vendors opening problem tickets,
• Oracle/BEA/Documentum/Cognos. - Planning to setup development, testing and QA environments for Oracle 10g database migration for our critical applications. - Engage and support developers during the SDLC and Working with programming teams developing
• Internet applications - Installation, Maintenance of Apache web server configurations, procuring and installing SSL certificates. - Responsible for maintaining and administrating PVCS/CVS version control software and building build scripts. - Responsible for documentation, knowledge transition and training of DBA support role to Accenture
• DBA's. - Worked with BEA on implementation of Weblogic Portal/Integration. - Change Control Manager responsible for QA for any infrastructure/Application changes to production. - Installed ESSBASE analytics/application server in development environment for ESSBASE development team. The applications include Kronos Time and Attendance application, Lawson HR/Payroll, CODA Finance, LINK Airline Catering application, Concur Expense, ARIS payment process application, I2 Procurement applications, Global Financial applications and various Global applications for our parent company Lufthansa, Germany. - Environment:
• Oracle 10g/ 9i RAC Rel2 / 8.1.7.4/8.1.6, Oracle 10G OEM Grid, Oracle 9i/10g Application Servers, RMAN, Oracle PL/SQL, SQL Loader, Unix Shell scripts,WebLogic 8.1/6.1/7.2,Redhar Linux AS/ES 3.0, DELL PowerEdge 6650,2650,1850,1750, HP A,L,N class, Sun Solaris 5.8, EMC Storage device SAN ,VERITAS NetBackup, Toad 8.6 for Oracle, I-planet, Netscaler, Oracle Portal

Confidential

• The LSG Sky Chefs internal IT department was outsourced to Accenture and I re-joined as an IS Specialist. I transferred to DBA group as Enterprise Database Administrator in February, responsible for capacity planning, designing, scoping, estimation, setup, migration, implementation, tuning and maintenance of various applications. I was Involved in many database migration processes, tuning process, Installation of various version Oracle database software, applying various patch sets and setup process. Worked with multiple software vendors to implementing their products into the LSG environment. Documenting installation, configuration and setup for team. Working on various development projects simultaneously with support responsibilities, designing the database and integration with other applications. Activities: - Involved in SAP R3 4.6 implementation working with SAP Consultant, Provided Oracle expertise for implementation and ongoing run support. - Successfully configured and implemented SAP R3/Omniback/Oracle integration and tested DR recovery
• scenarios. - Assisted SAP project team with HP MC Service Guard configuration for SAP HA environment. - Performed light Basis work, primary Oracle DBA maintaining DBA calendar and using SAPDBA to
• perform maintenance. - Participated on project team that moved entire data center from Arlington location to Infomart in Dallas. - Responsible for maintenance, sizing, installation and configuration of all Oracle databases and Oracle
• software. - Documented and transitioned LSG Sky Chefs DBA support role to Accenture DBA's providing support during transition. - Extensive work with applications development and support teams assisting with deployments and troubleshooting. - Implemented shell scripts for hot backups on servers not supporting HP OmniBack integration. - Worked with Payroll team to upgrade Lawson Payroll system 7.3 to 8.0 which included DB migration from 8.1.7 to 9.2.0 - Deployed multiple J2EE applications on Weblogic 6.1 and 7.2 in standalone, managed and cluster
• configurations. - Participated in on-call rotation for applications support and Oracle DBA. - Design and Create Database objects and help project teams with their Design and Development. - Setup various custom monitor Shell scripts and OEM to monitor the production databases and batch jobs
• status - Setup various Interface scripts on application and database server using Unix shell scripts, PL/SQL,
• SQLLoader. - Documented installation, build processes, support procedures for Oracle database creation ongoing maintenance. - 24/7 maintenance support of all Production databases. - Upgraded multiple databases from 8.0.6/8.1.6 to 8.1.7 using export/import. - Oracle software installation, Setup, Patch updates in HPUX, SUN and W2K environments. - Capacity planning for all new and existing application databases. - Technical lead on Concur Expense Implementation, working with business users and vendors. - Database Partition management, Archiving, Online Tuning, SQL Tuning, Perfstat and Periodic maintenances. - Working with Navigator Systems, installed, configured and upgraded Documentum eContent Server from
• 4.2 to 5.1 and supporting applications webtop,da,wp,wcm, wdk to support marketing department. - Working with Cognos, Responsible for Installation, configuration, administration of Cognos Software,
• Series 7 BI suite and report net, Implemented backups scripts for environment. - Supported data warehouse environment for our Marketing department.
• - Responsible for SQLServer backup integration with Omniback and maintenance plans for exports. - Responsible for OEM monitoring/ job scheduling for Oracle environment. - Worked on Kronos upgrade team. Environment:
• Oracle 9i / 8.1.7.4 / 8.1.6 / 8.0.6, PL/SQL, SQL Loader, Unix,Shell scripts, Apache,IIS, W2K,XP,W98,W95, NT 4.0, OEM 2.2,SQLServer,2000/7.0,Documentum 5.2,Cognos Series 7/Report Net SAP R3, SAP DBA, MS Office, Concur Expense,BEA WLS Express for W2K, Solaris 6.1, 7.2, Tomcat The applications include Kronos Time and Attendance application, Lawson HR/Payroll, LINK Airline Catering application, EATEC purchasing, ARIS payment processing application, Global Financial applications and various Global applications for our parent company Lufthansa, Germany.

Confidential

• LSG Sky Chefs in-sourced their operational systems from Andersen Consulting and I was recruited and re-joined the company to work on the project to reduce costs by re-platforming the operational system ASPIC running on expensive mainframe servers to Oracle client/server environment. Provided 24/7 support. Successfully re-platformed TAPS application used for American Airlines scheduling by converting PL1 program logic and flow into PLSQL/SQL forms/reports using Designer 2000. Converted multiple modules as assigned for interfaces including load provisioning, passenger count/special meal feeds. Responsible for monitoring, maintenance and health of Oracle databases, production migrations, backups. Responsible for Oracle development environment refreshes from production using export/import. Responsible for establishing documenting and executing data archiving strategy. Provided 24/7 end-user support for CFE applications. Documented and trained operations staff on how to run backups and nightly maintenance procedures. Responsible for EDI system to receive pricing/schedule interfaces for Delta Airlines.
• Environment: Oracle 8.0.5 / ORACLE 7.3.4, Developer 6.0/2000 Forms 6.0/4.5, REPORTS 6.0/4.5 , PL-SQL 2.3, Designer 2000, Unix Shell scripts, Dec Alpha 8400,WINDOWS-NT 4.0, STATSPACK, Toad
• TAPS, Total Airline Provisioning System, CFE Custom Front End, Delta EDI, NPS New pricing system, LINK production planning system

Confidential

• As Programmer Analyst I participated in 24/7 on-call rotation and provided support, applications maintenance, development, upgrades for various administrative and operational systems applications. Application Development/Maintenance:
• Marketing Operations: I was responsible for maintenance and development of CFE applications for our Operations Systems department. These systems assist them in the scheduling of food for the following airlines, USAir, Delta, Continental,United, America West, Alaska and Midwest Express. I successfully re-platformed the CFE application running on AS 400 to Oracle client server environment, Consolidated separate applications running on the AS 400 into a single application using Designer 2000 creating logical and physical data models to converted business logic from RPG/CL into PLSQL/SQL packages, stored procedures, forms, reports. Payroll/Human Resources: I wrote various programs for extracting information to feed various systems. Upgraded Payroll software from 7.2 to 7.3 Assumed support of Kronos application for Caterair locations. Accounting: I have written and modified programs relating to data conversions, interfaces, billing and made modifications to vendor software. These applications were Software 2000 AP.AR,GL,PY,PE and custom billing applications. General Ledger upgrade from version 7.0 to 8.0
• Finance: I was technical lead for the integration of the Caterair kitchens into our budgeting system. My responsibilities included coordination with our finance department on requirements and data mapping, hardware procurement, capacity planning, software distribution and application enhancements. This project utilized ORACLE 6.0, SQL/Forms 3.0, SQL/MENU 5.0, PCSupport400, Unix and Excel. Environment/Software: RPG 400,RPG , CL, Query/400, SDA, SEU, DFU, DBU,RJE,PCS400, RUMBA, Software 2000 AP,GL,PY,PE,AM , KRONOS, UNIX, Expidite Manager, Windows 3.1/95, Office 97, DOS, Oracle 6.0, 7.3 and 8.04, Designer 2000 2.1, Developer 2000, SQL,PL/SQL, Enterprise Manager,SQL LOADER