Experience

Tinker Federal Credit Union

• Financial Services
• 300 - 400 Employee

• Sr Databse Administrator

  • Nov 2022 - Present



AT&T

• United States
• Telecommunications
• 700 & Above Employee

• SR SQL Server DBA

  • Oct 2009 - Nov 2021

  AT&T, Dallas 10/2009 – Present • MSSQL DBA SQL 2000, SQL 2005, SQL 2008, SQL 2014 • 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 and also Windows 2008 with MSSQL 2008. Currently using MSSQL 2014 on Windows 2012 • Established maintenance plans to update statistics, rebuild required indexes and to retain more than 1 day’s worth of database backups on system. • Established event driven notifications for deadlocks • 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. • Support a team of 9 developers for departmental applications • Established working lines of communication with multiple business units to support most IT requirements • Mentored Jr DBA’s in two departments • SharePoint Administrator for department • Vice President of AT&T DFW Chapter of Veterans – 600 members Show less



The University of Texas at Arlington

• United States
• Higher Education
• 700 & Above Employee

• SOFTWARE SYS SPEC II

  • Oct 2008 - Apr 2009

  • 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 Show less



AT&T

• United States
• Telecommunications
• 700 & Above Employee

• PeopleSoft Administrator

  • Jan 2006 - Mar 2008

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



Regus

• Luxembourg
• Facilities Services
• 700 & Above Employee

• PeopleSoft Administrator / MSSQL DBA

  • Sep 2004 - Jul 2006

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



Ensco plc

• United Kingdom
• Oil and Gas
• 700 & Above Employee

• PeopleSoft Administrator / MSSQL DBA

  • Dec 2003 - Sep 2004

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



Washington Mutual

• PeopleSoft Administrator

  • 2000 - 2003

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



Dave & Buster's Inc.

• United States
• Restaurants
• 700 & Above Employee

• PeopleSoft Administrator / MSSQL DBA

  • 1998 - 2000

  • 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. Lotus Notes developer for internal IT applications. Most notable for tracking PeopleSoft fixes. Show less