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, 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 9i RAC (Rel - 2), Oracle 10G Grid OEM
• Oracle 9i/10g Application Server
• ORACLE 11,10g /9i / 8.1.7/ 8.1.6, PL/SQL,SQL, Oracle 10g Developer/ 6.0, RMAN
• SQLServer / 2000
• Weblogic 10.3/ 9.1 / 8.1 / 7.2 /6.1
• Webcenter 11
• 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 SKILLS:

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 SuiteOracle 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 2008/2005/2000, MS-Office, MS Access, Apache, IIS, Documentum 5.2, Tomcat, PVCS, CVS, DBCA, Reflections, OCFS,SAPDBA, SAP 4.6, Quest Spotlight,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:

Sr Oracle/SQL DBA/Middleware

Confidential, Irving, TX

Responsibilities:

• 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

Sr Oracle/SQL DBA

Confidential, Fort Worth, TX

Responsibilities:

• 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

Sr Systems Engineer

Confidential, Fort Worth, TX

Responsibilities:

• 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 Confidential ’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

Oracle Applications DBA/Sys admin

Confidential, NRH, TX

Responsibilities:

• 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.

Manager Applications/Infrastructure

Confidential, Irving, TX

Responsibilities:

• J2EE and Oracle applications from WLS 6.1 to 8.1 and 9ias to 10gas for Server Consolidation project.
• 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 Periodic maintenance.
• 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 s.
• Responsible for maintaining and administrating PVCS/CVS version control software and building build scripts.
• Responsible for documentation, knowledge transition and of DBA support role to Confidential
• 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.

Environment: Oracle 10g/ 9i RAC Rel 2 / 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

IS Specialist/Enterprise DBA

Confidential, Irving,TX

Responsibilities:

• 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 SoftwareSeries 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.

Programmer Analyst/ Jr. Oracle DBA

Confidential, Irving, TX

Responsibilities:

• Confidential in-sourced their operational systems from Confidential 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 Confidential 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 Confidential 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 Confidential .

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, Confidential Custom Front End, Confidential EDI, NPS New pricing system, LINK production planning system

Programmer Analyst

Confidential, Irving, TX

Responsibilities:

• 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.
• I was responsible for maintenance and development of Confidential applications for our Operations\Systems department. These systems assist them in the scheduling of food for the following airlines, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential .
• I successfully re-platformed the Confidential 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.
• 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.
• 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
• 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