Sr. Technical Analyst

----------------------------------------------------------------------

RESUME - Harvey Wigfall

----------------------------------------------------------------------

Harvey L. Wigfall
PH (972) 874-1646
Cell (214) 684-9915
email - sircisco@hotmail.com



EDUCATION
Computer Science Major – DeVry Technical Institute, Irving, TX

Training:
• SQL Server 2008R2-2012 Optimization training – Microsoft, Irving TX (2012)
• SQL Server 2008 Database Admin training – NewHorizons, Dallas, TX (2010)
• SQl Server2005 SSIS training – NewHorizons, Houston, TX. (2009)
• Windows Server 2003(AactiveDirectory, Networking, Clustering
- TechSkills, Dallas Texas (2008)
• PHP Programming Language online training – Theitwizard.com (2007)
• Windows Server 2000(IIS, WSUS) – TechSkills, Dallas Texas (2006)
• Oracle/ Java/ Sun Solaris – TechSkills, Dallas TX (2003)
• SQL Server 2000/ MCDBA – TechSkills, Dallas TX (2002)
• SCO/UNIX System Administration – RHIC, Dallas, TX (2002)
• Certificate HTML/ XML Programming – New Horizons, Dallas, TX (2001)
• Visual Basic Programming – American Research Group, Fort Worth, TX (1998)
• Certificate PERL Programming – American Research Group, Fort Worth, TX (1997)
• AIX User/Utilities – IBM training facility, Irving, TX (1996)


PROFESSIONAL ACHIEVEMENTS

Celanese International Corporation
October 2007 – Present
Sr. Technical Analyst/SQL Server DBA
Provide hardware/software solutions and best practices to clients; Insure access to HA SQL clusters and standalone servers.
•Manage and supported production servers and databases in clustered environments.
• Participate in on-call rotation.
• Perform SQL Server 2005, 2008, 2008R2 server installs and configuration.
• Research and Perform SQL Server Patches.
• Design, Create/optimize databases and objects as required.
• Participate in and take ownership of special projects(SQL Server Disaster Recovery plan and
DressRehearsal (12/02-06/2012).
• Investigate, resolve, or escalate SQL Server, Windows, Network, Application related issues.
• Manage and Support SQL Server SSIS, SSAS, and SSRS services.
• Support VM, Citrix, BI and Share Point platforms and development.
• Import, export, trouble shoot DTS packages.
• Manage SQL Server access and security.
• Assist/consult/collaborate with users, groups and departments to achieve individual and project goals.
• Identify Active Directory issues affecting user and application access to Server/Database environments.
• Participate in Maintenance-Day planning and activities.
• SQL Server subject matter expert.


Capital One Auto Finance
December 2006 – July 2007 (Contract)
SQL Server DBA
Provide hardware/software solutions to clients using programming, UNIX shell scripting, ORACLE, and SQL Server 2000, 2005 database techniques on windows
2000/2003/WAN/LAN platforms in a high volume/transaction intense environment.
• Manage and supported production servers and databases in clustered environments.
• Participate in on-call rotation.
• Perform server configuration.
• Create/test databases and objects as required.
• Participate in and take ownership of special projects.
• Use Data Transformation Services to load/extract/copy/move objects from production to Data Warehouse platforms.
• Assist users/developers with database issues.
• Investigate/resolve/escalate database/server/network issues.
• Review T-SQL code for breaks/fixes and improvements as required.
• Represent group in strategy/planning discussions/meetings.
• Track database/server disk space and load performance for capacity planning.
• Configure/performance tune servers and databases to meet requirements.
• Address PHP, PERL, ASP, IIS and Data warehouse developer database access requirements/issues.


Capital Group
December 2005 – December 2006 (Contract)

Sr. System Architect/Consultant
Provided hardware/software solutions to clients using programming, UNIX shell scripting, and Sybase, Oracle, and SQL Server 2000 database techniques on Windows 2000/XP/NT/NOVELL platforms.
• Provided initial startup of CSS team for NOVA compliance project.
• Attended NOVA project meetings representing the CSS team to establish CSS guidelines for project.
• Took ownership/leadership of Project Management assignments.
• Organized and directed PCI process testing for platforms including UNIX, Database, Windows, Weblogic, Lotus Notes, and Power Center.
• Created/maintained Excel spreadsheets for documentation and tracking.
• Documented, provided status tracking/reporting of PCI testing.
• Used Autosys utillty/PCI process to unlock/lock databases and other platforms for production implementations; worked with teams to create or correct Autosys job execution issues.
• Analyzed, created, performed SQL queries and implementations on Oracle and Sybase databases.
• Used shell scripting, FTP and copy utilities to move SQL script files from desktop to UNIX servers and executed bcp utility to execute queries on Oracle and Sybase databases.
• Used ECMS and SHARP tools to document, tract, and report PCI services performed.
• Coordinated implementation strategies and target time with developers, database Administrators, and CSS team.
• Manages production and data warehouse servers.
• Provides Production Support functions including data loads, backups, restores, database access control, database copy/migration, disk space management, disaster recovery procedures.
• Monitor/control processes.
• Participate in group and personal projects.







Millennium Development Group LLC
August 2004 – August 2005 (Contract)

Consultant/DBA/Developer
• Provided vision and led development initiatives for new company startup. Developed company goals, strategies, product line, customer target, growth/expansion plan. Designed company information management system: Win 2003, SQL Server 2000 platform.
• Design company information management system: Win 2003, SQL Server 2000 platform.
• Install and manage MS IIS.
• Evaluate all hardware and software technologies for business.
• Lead testing and implementation of Microsoft operation system, application software, and security architecture.
• Investigate and resolve system issues.
• Responsible for development of process automation, system performance monitoring, and remote system support.


Heartland Payment Systems
October 2003 – August 2004 (Contract)

Database Administrator
• Provided hardware and software solutions to clients using Oracle / SQL Server 2000 database techniques on Windows 2003/ XP / NT 4.0 platforms.
• Controlled database access/permissions to ensure data security for 3 TB MS Server environment with Active/Passive front-end and Active/Active back-end.
• Supported Actuate, Delphi, ASP.NET development groups.
• Works with various groups to perform database object migrations as required.
• Designs, develops, creates, and maintains databases and tables to meet client’s specifications.
• Creates/maintains and supports DTS packages, stored procedures, and triggers using T-SQL, Enterprise Manager and other tools as required.
• Performs data mining tasks to generate reports including (financial, growth forecast, equipment tracking/sales/lease/rental, etc.) for President, CEO, and CFO as required.
• Normalizes/de-normalizes databases as needed to maximize performance.
• Performs database backups, restores, loads, and object replication as required.
• Addressed outages that impacted CMS call volume updates to database.
• Supported Appache Web Server database access.
• Monitors and maintains databases to ensure optimal performance; performs database tuning as required.
• Evaluates and performs performance optimization on objects including table, queries, views, and stored procedures.
• Monitor application processes to stay abreast of possible problems.
• Provides system, user, and on-call support for a 24 X 7 production environment.
• Writes ad -hoc queries to generate database information in report format as required.
• Assists in training and mentoring IT staff, users, and clients.
• Analyzes, designs, and develops databases and objects; performs database capacity planning.
• Responsible for database performance tuning including use of replication to insure clustered databases were in synch.
• Works with database connectivity/access techniques including ODBC, and OLE DB.
• Performs application version releases and documentation; evaluate application queries prior to implementation.
• Provides team project leadership - serves as lead when required.
• Creates SQL/programs, test and work with various groups to perform database migrations.
• Performs application related database upgrades.
• Writes, automates, and supports PERL scripts, reports, forms, and utilities to improve business process.
• Manages short-term and long-term database capacity planning.
• Establishes database archiving and logging setup for database backup/recovery.
• Supports database access issues relating to SAN(Storage Area Network).
• Documents database problems and resolution.
• Seeks/recommends continuous improvements to existing development, support, capacity planning, and documentation techniques.
• Automates processes and present results data through email and web access.
• Monitors database growth; performs database resize/expand as required.
• Manages disk space and configure database partitions/instances.
• Creates processes that acquire data from external sources, manipulate data, load data, and report on data.
• Maintains data model and data dictionary content for databases totaling 500 GB.
• Analyze development design specifications and makes recommendations.
• Works with database connectivity/ access techniques including ODBC and OLE DB.
• Creates SQL/programs, testes, and works with various groups to perform database migrations.
• Conducted database performance tuning.
• Selected, evaluated, and tested database engine upgrades.
• Worked with System Administration to install/support database software releases.
• Upgraded database instances to new versions of database engine(s).
• Managed disk space and configure database partitions/instances.
• Performed application related database upgrades.
• Wrote/ automated/ supported PERL scripts, reports, forms, and utilities to improve business process.
• Managed short-term and long-term database capacity planning.
• Established database archiving and logging setup for database backup/recovery.
• Selected, evaluated, installed, tuned, and upgraded database administration tools.
• Interfaced with various departments to resolve production issues.
• Documented database problems and resolution.
• Sought/ recommended continuous improvements to existing development, support, capacity planning, and documentation techniques.


ONPOINT CRM/ TeleService Resources/ SABRE
January 1990 – September 2002

Informix DBA and SQL Server DBA (July 1996 – September 2002)
• Investigated and resolved hardware and software issues on an AIX-RSC6000/SP2 complex involving PERL programs and SQL Server 2000, Informix database. Reported findings and made recommendations to management staff.
• Supported clients including American Airlines, Fannie Mae, US Postal Service, AT&T, and Nissan Motors.
• Supported Informix, SQL Server and MS Access databases totaling 1 TB with Active/Active processes.
• Performed data acquisitions from Call Management System into SQL Server Database for tracking billable call volume.
• Provided system, user, and on-call support for a 24x7 production environment.
• Analyzed, designed, coded, tested, and implemented PERL scripts, reports and utility programs.
• Wrote programs and embedded SQL statements to acquire data from databases.
• Created and maintained email, FTP/EDI, and error alert batch/cron programs.
• Participated in system, database, and software migrations.
• Consulted and assisted IT personnel and users, resulting in best techniques to access/utilize system/database resources.
• Participated in group/individual project planning and tasks. Achieved expected results and timelines.
• Participated in migration of: DEC-VAX to IBM AIX platform, DB2 to Informix, MUMPS to PERL, and Visual Basic.
• Interviewed clients, users in information gathering to establish database design /capacity planning strategies.
• Planned, designed, developed, created, and modified databases and tables. Achieved client database requirements.
• Monitored database instances and conducted performance tuning/ maintenance. Improved database response.
• Controlled all database permissions and access for database security.
• Provided on-call coverage for databases and servers.
• Performed database backups, loads, restores, schema creation, extent sizing, and instance recoveries.
• Monitored and controlled disk-space allocation to maintain efficient disk-space usage.
• Replicated/ exported/ imported databases and tables across databases and servers using DTS and other tools. Effectively and efficiently moved data.
• Supported Appache Web Server database access.
• Supported and assisted Web Development/Visual Basic database requirements.
• Wrote/performed database queries to create, extract, insert into, delete from, and update tables, rows, and columns using SQL, T-SQL, Wizard, and other tools.
• Maintained two UNIX fax servers. Investigated and resolved server outages, and performed C/C++ coding as required. Maintained Active/Active database clustering process for Nissan Motor Corporation.
• Managed American Express data transfer process.
• Provided support for Disaster Recovery Plan. Participated in offsite system disaster recovery exercises.
• Documented processes and procedures, stayed abreast of new technology developments.
• Consulted and assisted IT personnel and users concerning techniques to access/utilize system/database resources.
• Participated in group/individual project planning and tasks.
• Planned, designed, developed, created, and modified databases and tables per client specifications.
• Performed database maintenance tasks to insure server response and availability met or exceeded performance standards.
• Ensured completion of full and incremental database backups. Resolved database integrity issues.
• Supported a Cyborg HR/Payroll system running MicroFocus COBOL applications. Wrote report, utility scripts, and ad hoc queries to generate/manipulate employee information as required.
• Controlled all database permissions and access for database security.
• Provided on-call coverage for databases and servers.
• Performed database loads, restores, schema creation, extent sizing, and instance recoveries.
• Provided database/table replication across database instances.
• Provided database support to Web/ VB/ PERL/ PHP developers.
• Wrote SQL statements and performed database queries to create, extract, insert into, delete from, and update tables, rows, and columns.

Programmer Analyst (January 1990 – July 1996)
• Delivered support for two UNIX fax servers. Investigated and resolved server outages, and performed C/C++ program coding to modify or create fax software. Modified/ upgraded BIOS as required.
• Analyzed, designed, coded, tested, and implemented PERL report and utility programs utilizing embedded SQL, email, system calls, FTP, and forms to provide users and clients with required data, user interfaces, data transfer to remote systems, and processes automation.
• Created and maintained email, FTP/EDI, and error alert batch/cron programs.
• Wrote ad hoc queries to generate database information as required.
• Wrote/ maintained scripts to update major airlines/hotel reservation/cargo systems.
• Provided support for Disaster Recovery Plan. Participated in offsite system disaster recovery exercises.
• Utilized/ promoted/ supported source code control system and change management.
• Documented processes and procedures, stayed abreast of new technology developments.


TECHNICAL SUMMARY
Languages: Perl, PHP, UNIX, HTML, XML, SQL, C/C++, MUMPS, Visual Age Basic, COBOL, JCL, DCL, Assembler
Software: Informix, DB2, Novell Netware, SQL Server 2K/2005/2008/2008R2, Visual Basic 5, TCP/IP, Telnet, FTP, NFS
Hardware: IBM SP2/RSC6000/ System 360/370, DEC-VAX-6610/8650/ 785/ 750, HP-9000, Novell LAN/WAN, VM/Hyper-V
Operating Systems: DOS, CMS, VMS, MVS, MVX, AIX/ UNIX, Windows 95/98/NT/2000/XP/2003/2005/2008/2008R2/2012