Data Sql Server
Resume:
RUSSELL YOUNG
Trophy Club, Texas 76262 C 214-***-****
*********@*****.***
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