RUSSELL YOUNG

** ****** * 817-***-****

Trophy Club, Texas 76262 C 214-***-****

acoozy@r.postjobfree.com

http://www.linkedin.com/in/rwyoung04

SQL Database Administrator

IT professional experienced with 5 years of experience as a SQL

Server DBA and 28 years' experience in the IT industry working on multiple

platforms. A focused and results-oriented information technology

professional with wide-ranging expertise in database design, data

migration, systems analysis and engineering, programming and applications

development as well as computer operations.

Computer Skills

SQL SERVER DBA, SSRS, SSIS, TDE, REPLICATION, MIRRORING, CLUSTERING,

SAS, SQL, DB2, TERADATA, EXCEL, WORD, POWERSHELL, TOAD, MS OFFICE,

WINDOWS, ACCESS, QUEST LITESPEED and SPOTLIGHT

Experience

FTSI

Fort Worth, Texas

SQL Server DBA June 2011 - March 2015

Responsible for the maintaining and monitoring of 200+ SQL Server databases

on 7 VM's and 4 physical clusters on a 24 X 7 basis. Resolve database

performance and capacity issues. Develop and design database objects, such

as tables, stored procedures, functions, etc. Manage Database Backups and

Database Maintenance plans across multiple servers. Database tuning, query

optimization, database backups and restore, data migration tools, database

design, and data analysis. Database design, performance tuning, query

optimization, indexes, data migration tools, and data analysis. Extensive

knowledge of T-SQL; Writing stored procedures, triggers and functions, and

creation of indexes, tables etc.

. Worked with the application development team to design a database to

track the testing of high pressure iron. Designed and built tables,

views, indexes, triggers and stored procedures. Built several SSIS and

SSDT packages to import outside vendor data.

. Developed several Power Shell programs to gather data from multiple

servers for SSRS reports and to pull data from Exchange and AD to be

used in management reports

. Developed a PowerShell process that would remote to a SQL server to

uninstall SQL and reinstall SQL with a different version.

. Developed several SSIS packages to gather data from multiple SQL

servers to load into SAP.

. Trained several report writers to be JR DBA's

. Install and configured Spotlight and Litespeed for all SQL servers

. Setup Mirroring on 200+ databases to migrate from VMWare servers to 4

physical clusters

. Built and install SQL Server on 4 physical clusters on 2008R2 and 2012

and 32 servers running on VMWare.

. Converted all SSRS report server from HTTP to HTTPS and redirected all

old URL's to the new URL.

. Built an alert process for SQL server that where having mini dumps

. Built an alert process to monitor when a SQL Server had stop receiving

data from an outside source.

. Developed a process to migrate all 2005 SSRS report to 2008

. Applied TDE to SQL databases

. Responsible to applying all service packs.

. Worked with the Hosting team on how to build SQL Servers

. Worked with the Hosting and Network team to determine the root cause

of I/O latency issues

Responsible for Production and Development Support

DayStar

Bedford, Texas January 2010 - June 2011

Programmer Analyst/DBA

Responsible for Reports, Application Support, SSRS, SSIS and SQL Server

DBA.

. Use SQL Report Builder for reports. All reports use Stored Procedure.

Responsible for tuning Stored Procedures

. Use TSQL for data analysis and database support.

. Maintained 8 SQL Server databases that used 2005, 2008 and 2008 R2.

. Designed and maintained Data Warehouse using transaction replication.

. Write SSIS projects for loading data into production.

. Planning and designing database backups using Litespeed.

. Operational Monitoring, Diagnostics, Administration and Tuning for SQL

Server.

. Monitor Windows servers for performance and disk spaces.

. SQL and Windows monitoring with SQL alarms and Spotlight.

AT&T

San Antonio, Texas Aug 2009 - Dec 2009

Contract Programmer Analyst

* Develop marketing leads for customers in AT&T EDW environment

supported by a Teradata database.

* Technologys include Teradata Assist, Business Objects, SAS,

Access, Excel, and TSO/MVS

PEPSICO

Plano, Texas

2000 - 2008

SR PROGRAMMER ANALYST

Recruited to work with management teams to enhance and maintain Frito-

Lay's Annual Operation Plan. Later on I assumed leadership and primary

support of several other applications.

Annual Operating Plan

* Team lead and primary developer for a team of 2 to 4 programmers.

* Responsible for gathering business requirements from management team

and developing required programs and reports.

* Ensured delivery of 20,000,000 records of data to general ledger and

associated systems.

* SAS was used to extract, transform and load into various tables,

reports and files.

* Was responsible for reducing run time from 12 hours a night to 1.5

hours

* Technology was primarily SAS (520 programs & reports) and DB2 with

COBOL, IMS, UNIX,

Kornshells and Business Objects

Inventory Systems

* Team lead and primary developer for a team of 2 to 4 programmers

responsible for tracking actual and standard cost of products from

manufacturing to final sales destination.

* Responsible for gathering business requirements from management team

and developing required programs and reports.

* SAS was used to extract, transform and load into various tables,

reports and files.

* Developed programs to be used in data mining systems to track product

cost.

* Technology was primarily SAS (306 programs & reports) and DB2 with

COBOL, Business Objects, and FOCUS

Accounts Payable Datamart

* Team Lead and primary developer for a team of 3 to 4 onshore and

offshore programmers that consolidate all Accounts Payable data from

four accounting packages into one common database covering 15 years.

* Worked with management team to develop requirements used in the

designer of the common data model that would be accessible through

Business Objects

* Reduced wait time for answering legal question from one month to one

day.

* Technologies included Easy-trieve, PL/SQL, DB2, Oracle, UNIX, SAS and

Business Objects.

Profit and Loss Statements

* Worked with management team to gather requirements for converting P&L

developed in Infomatica to SAS which could be run on a daily basis as

a tool for the AOP

* Incorporated features that allowed users to define layout without

program changes

* Preliminary P&L statements had not been available until the planning

season had been finalized.

* Technology was primarily SAS and DB2.

Burlington Northern Santa Fe Railroad

Fort Worth, Texas

1998 - 2000

Contract Programmer/Analyst

* Developed new data warehouse applications to download DB2 data to

TERADATA for enhanced user accessibility.

* Responsible for Y2K compliant program conversion for COBOL, SAS, REXX,

DB2, TSO, ISPF, VSAM and TERADATA. All programs where tested in a

standalone environment with production data to make program changes

did not alter original data.

* Worked with client to fix SAS program that ran for 3 day to complete

in 3 hours.

UNION PACIFIC RESOURCES

Fort Worth, Texas

1996 - 1998

Contract Programmer/Analyst

* Developed and converted Paradox applications to PowerBuilder.

* New application significantly improved efficiency and accessibility.

* Technology was Paradox and Oracle running on NT Servers.

FSI

Grapevine, Texas 1991 - 2002

Contractor Programmer/Analyst

. Maintained a DOS/DbaseIII accounting system and converted to

Client/Server accounting system written in Powerbuilder running on an

NT server using SQL server.

. Technology included Dbase, SQL Server 7, NT server

FOXMEYER

Carrollton, Texas

1995 - 1996

Contract Team Lead /Analyst

* Team Lead and primary developer for four programmers in the designing

and development of a system for archiving and recovering expired DB2

data.

* Technology included COBOL, DB2, TSO, ISPF, FOCUS and FOXPRO.

* Process reduced the size of the application by 50% which improved

online response time.

MOBIL CORPORATION

Dallas, Texas

1984 - 1995

Lead Analyst/Developer

* Responsible for installation, maintenance and support of various

products, including FOCUS (REL 6.8), Jobscan, Docutex, COBOL,

MHTran and IBM Info Management.

* Maintained and enhanced database for tracking Abends and problem

resolution written in REXX, Clist, Dialog Manager, TSO, ISPF and

COBOL.

* Maintained and enhanced ACF/2, TSO security application containing 90

COBOL programs, 30 CA7 job streams and 70 VSAM files.

* Maintained and enhanced the online applications for the Data Center

that provided the interface for all Mobil users' utilities. Programs

where written in Dialogue Manager supported by COBOL, REXX, TSO, ISPF

and SAS.

* Lead a team of 10 programmers responsible for 31 new applications and

maintained and enhanced 15 existing applications. Responsibility for

project resource scheduling, time line management and workflow

analysis. Directed naming conventions, standardization of tools and

code walk-through for projects.

* Team Lead and primary developer of a team of 4 programmers responsible

for writing IMS transaction to extract DB2 data used in PC online

screens.

* Developed of several VM/FOCUS applications including Gas Nomination,

Gas Pricing and Gas Measurement.

Accounting Career, 1973 - 1984 Held various accounting position including

auditor, inventory accountant and cost accountant in Oil Field related

businesses.

Education

TEXAS A&M UNIVERSITY, College Station, Texas, B.B.A. in Accounting 1973

Contact this candidate