TECHNICAL SKILLS:

DB Platforms: MS SQL Server 6.5, 7.0 and SQL 2000 and 2000 on Clustered Environment, SQL2005 and SQL 2008

Server Applications: PeopleSoft HRMS 9, Peoplesoft HRMS 8.9, PeopleSoft FIN 8.4, PeopleSoft HRMS 7.5, PeopleSoft HRMS 7.51, Peopletools, iPlanet 4.1 and 6, IIS 3 - 6, Apache with Tomcat, Weblogic webserver 5 thru 8.

Hardware: Compaq Proliant 7000, HP K480, HP K580, HP RP7400, HP RP7410's, SUN Netra T1, SUN Netra T120, SUN Enterprise 220, SUN Enterprise 240, SUN SunFire V480, SUN SunFire V880's, IBM X330 & 350's, Dell PowerEdge

O/S: HPUX 10.20, HPUX 11.00, HPUX 11.11, SunSolaris 2.6, SunSolaris 8, MS NT Server 4, MS Win2K Advance Server, Windows server 2003, Windows server 2005, Windows server 2008

PROFESSIONAL EXPERIENCE:

Confidential, Dallas

Responsibilities:

• MSSQL DBA SQL 2000, SQL 2005, SQL 2008
• Converted SQL 2000 DTS packages to SSIS packages
• Refreshing of NON production databases with production data
• Migrated Windows 2003 server with MSSQL 2005 to Windows 2008 with MSSQL 2005
• Established maintenance plans to update statistics, rebuild required indexes and to retain more than 1 day’s worth of database backups on system.
• Compile test and production versions of work group software using Visual Safe Source for version control and Visual Basic 6 to compile.
• Desktop Support for all departmental computers
• Provide production support to 2 teams within the department.
• Established working lines of communication with multiple business units to support most IT requirements
• SharePoint Administrator for department

Confidential

Responsibilities:

• Windows Administrator (SA) providing hardware and software support including monthly Microsoft patches for 30+ servers
• Microsoft System Center Configuration Manager (SCCM 2007) administrator consisting of security, base images establishment, deployment of monthly Microsoft OS patches and Microsoft application(s) patches to 175+ servers
• Microsoft MSSQL DBA on 17 servers with MSSQL2000, MSSQL2005, MSSQL2008. Implemented enterprise monitoring using scripts. Created daily, weekly and monthly backup and maintenance jobs
• Architected MSSQL2008 cluster on Windows 2008 and Dell MD3000 attached storage
• Migrated and corrected stored procedures and DTS packages from SQL2000 to SQL2008
• Established policies and procedures for future DB requirements for end user to include space and security requirements
• Established non production db environments for end users. Used also for migrating to MSSQL2008
• Production Support 24hr rotational on call

Confidential

Responsibilities:

• PeopleSoft Administrator (PSA) and Oracle Application DBA (ORA) supporting 8 HCM environments maintained on HPUX 11 and Oracle 10g. PeopleSoft Internet Architecture (PIA) including UNIX file systems, application servers, web servers and batch servers.
• Migration of all PeopleSoft projects / enhancements / fixes / tax updates to DEV / TST / UAT / PROD environments using Quest STAT
• Quest STAT v5.2 administrator maintaining current and new environments requirements for developers
• Creation and or modification of interfaces between PeopleSoft and internal / external customers
• Direct contact with customer in troubleshooting and resolving issues.
• Production Support 24hr rotational on call
• Support in house developed applications and vendor applications such as CENTRA on Windows 2003, MSSQL2000 and IIS.
• Modified and modified stored procedures and DTS packages for in house db applications
• Infrastructure and application documentation for all HR applications to include disaster recovery.

Confidential

Responsibilities:

• PeopleSoft Administrator (PSA) supporting FIN Billing / AP / GL, HRMS development and production PeopleSoft Internet Infrastructure (PIA) 8.4.
• Implementation of PeopleSoft (PIA) and MSSQL 2000 cluster servers with EMC SAN in overseas (UK) datacenter.
• MSSQL DBA supporting PeopleSoft, Kronos and other in house applications.
• Created and or modified stored procedures and DTS packages to support applications
• Microsoft Windows Administrator (SA) for 35+ servers and fiber attached storage to include hardware and software troubleshooting and patches.
• Direct contact with internal customer to troubleshoot and resolve process issues in PeopleSoft Financials.
• Divided 180g Billing database into file groups, implemented new indexing and archiving process.
• Developed scripts for data extraction from UK databases and maintenance for imports into local production databases.
• Outlined network requirements for UK and US applications interface.
• Developed disaster recovery using Veritas Net Backup and database backups. Quarterly restore tests done.
• Effective communication with business owners and support teams to ensure stability of applications
• Citrix Administrator providing security and application support for PeopleSoft nVision and various other applications.
• Managed 3 server farm of Citrix servers setting up security, creating new ICA clients, used domain security
• Created new server farm in UK data center to centralized nVision and financial spreadsheets.
• Production Support 24h non rotation for systems, databases and applications.

Confidential

Responsibilities:

• PeopleSoft Administrator (PSA) supporting FIN, HRMS, SCM, EPM and CRM development and production PeopleSoft Internet Infrastructure (PIA) 8.4.
• MSSQL DBA managing (2) sets of SQL clusters using IBM FastT700 SAN environment using Tivoli Storage Manager. 32 PeopleSoft databases
• Created and or modified stored procedures and DTS packages to support applications
• Re-architected PIA to allow for multiple system failures
• Supported local end users as well as global end users in troubleshooting and resolving issues.
• Performance tuning using PeopleSoft tools to validate indexing schema and data validity to include archiving data from core tables.
• Implemented and documented a complete disaster recovery of all components for off site restores.
• Worked with onsite PeopleSoft consultants to implement interface with LDAP security.
• Implemented Sarbanes Oxley (SOX) requirements at database and file systems levels.
• Implemented weekly team status meetings and created distribution lists for all PeopleSoft groups
• Implemented policies and procedures for end users and consultant access requirements.
• Quest Foglight administrator for PeopleSoft PIA environments.
• Mentored 3 in troubleshooting, code review and customer response.

Confidential, Seattle, WA

Responsibilities:

• PeopleSoft Administrator v7.6 (PSA) supporting 12 HCM environments maintained on HPUX 11 and Oracle 9i. PeopleSoft Architecture (PA) including UNIX file systems, application servers, web servers and batch servers.
• Implemented PeopleSoft HrOnline web solution on PeopleSoft 7.6 for 60,000 employee base.
• Implemented PeopleSoft Internet Architecture (PIA) on HPUX 11 and Sun OS 8 incorporating high availability for migration from PeopleSoft v7.6 to v8.1
• MSSQL DBA for HR 3rd party benefits package to interface with PeopleSoft.
• Created and or modified stored procedures and DTS packages to support applications
• Developed DTS packages for interface into Oracle PeopleSoft databases
• Migration of all PeopleSoft projects / enhancements / fixes / tax updates to DEV / TST / UAT / PROD environments using Quest STAT and Quest Toad.
• Creation and or modification of interfaces between PeopleSoft and internal / external customers
• Direct contact with customer in troubleshooting and resolving issues.
• Production Support 24hr rotational on call
• Infrastructure and application documentation for all HR applications to include disaster recovery.
• Team lead for implementation of CA unicenter on HR systems.

Confidential, Dallas, TX

Responsibilities:

• MSSQL DBA v6.5 / 7.0 in support of PeopleSoft HRMS
• PeopleSoft Administrator (PSA) v.7.51 for HRMS
• Responsible for all 2 tier and 3 tier client setups on HRMS and FIN to include Crystal Reports.
• Key member in the deployment of web based Employee Self Service.
• Team lead on implementation of Bluebird ODOC document imaging systems for PeopleSoft.
• Managed systems security and PeopleSoft security for HRMS and FIN.
• Created and or modified stored procedures and DTS packages to support applications
• Supported local end users in troubleshooting and resolving issues.
• Managed Citrix server to support PeopleSoft financials team. Setup applications and security.
• Performance tuning using PeopleSoft tools to validate indexing schema and data.
• Researched, designed, purchased and installed a Windows NT 4.0 Server-based network with a total of 94 nodes.
• Performed Wide Area Network configuration providing connectivity between main facility and 4 remote sites using primary domain controllers and backup domain controllers.
• Trained and supervised desktop implementation team which performed organization wide migration to NT 4.0 workstations and Office 97 on 70 workstations
• Developed and conducted end user for use in NT 4 workstations and Office 97.
• Supported over 30 off the shelf and navy developed databases.
• Other jobs performed for the US Navy: Facilities Logistics Management Coordinator, Surface Depot Level Repairable Manager (DLR), Warehouse Supervisor, Shipping / Receiving Supervisor