Quality Assurance Sql Server
Resume:
Jason Price
***** ****** ****, **********, ******** 60544
*************@*****.***
Summary
Database Administrator with 10 years of experience. Proficient in
database administration and software development.
Computer skills
Languages
Proficient in:
. T-SQL
. Visual Basic
. C
. C++
. VBScript
. DOS
. DCL
Familiar with:
. Perl
. ASP
. Gawk
. JavaScript
. HTML
Software
Database:
. Sybase Adaptive Server Enterprise - 6+ years
. Microsoft SQL Server 2000 - 3 year
. Microsoft SQL Server 2005 - 5 year
. Microsoft Access - 1 year
Platforms:
. Microsoft Windows 95\98\XP\2003\2008
. Alpha Server 4000 OpenVMS
Experience
Senior Database Administrator
2011 - Present
Insurance Auto Auctions
. Database Administration\Development
o Same as below including added responsibilities of managing
others on the team and representing the team within the
organization
o Recent Projects:
Created an automated process to refresh a Staging Environment
that matches the production environment as well as Auditing
procedures
Managed and designed the approach to migrating from 32-Bit SQL
Server 2005 SP3 Windows Server 2003 to 64-Bit SQL Server 2005
SP3 Windows Server 2008 R2
Managed a project to migrate all DTS to SSIS
Created design strategies to upgrade to SQL Server 2008 R2
Database Administrator
2007 - Present
Insurance Auto Auctions
.
. Database Administration\Development
o Manage 20+ Database Clusters in a Production Environment
including OLTP and OLAP databases ranging in size from 100MB to
10TB
o Manage 100+ Database Servers between the Production,
Development, Quality Assurance, User Acceptance, and Disaster
Recovery Environments
o Database Performance Tuning
o Troubleshoot Performance issues in all environments
o Review T-SQL code to verify it meet standards for both
performance and error handling
o Review and Approve new Database Design
o Create/manage/fix replication
o Maintain/document procedures
o Manage database growth and free space
o Maintain and write stored procedures for applications and
database maintenance
o Collect performance metrics
o Perform Backup Audits
o Monitor all DDL changes in production environment
o Supply support on nights and weekends for both production issues
as well as maintenance
o Manage/create DTS and SSIS packages
o Review SSIS Packages for configuration and best practices
o Migrate databases from server to server
o Support/research production issues involving the database
servers
o Manage problem tickets with 3rd party vendors
o Install and configure SQL 2005 instances
o Review and apply Hot-fixes in Production databases
o Manage security
o Manage backups
o Manage maintenance of all databases (reindexing/database
consistency/statistics)
o Monitor and investigate DataWarehouse performance
o Created custom log-shipping to manage Disaster Recovery and
Production Support restores
o Created a Replication Latency Monitor
o Upgraded SQL 2000 to SQL 2005 (Side-by-side and In-Place)
o Developed a Database Partitioning Strategy
o Developed SSIS deployment strategy
System Administrator
2000
- 2007
Envirotest Illinois Inc.
. Database Administration\Development
o Create\Update User privileges
o Backups\Disaster Recovery
. Write stored procedures
. Create tables and indexes
. Performance tuning of database
. Create and automate reports using T-SQL
. Migrated Sybase Database on OpenVMS system to Sybase on Windows
Server 2003
. Maintain Production Server Documentation
. Supplied Data to external customers
. Audit Data
. Software Design and Development
o Project Management
o Translate business requirements into technical solutions
. Create software development timeline
. Manage outside Consultants
. Write\Design\implement software for state customer
. Perform tests for state customer
. Analyze, procure, and integrate 3rd party software
. Maintain source code using Visual Source Safe
. Administer Production
o Schedule Production
o Monitor\modify Production Runs
. Update security on Production Server
. Apply Software Patches\Updates to Production Server
. Manage Disk Space on Production Server
. Monitor\fix hardware problems on Production Server
. Manage\train Computer Operator
. Provide Technical Support
Station Manager
1996 - 2000
Envirotest Illinois Inc.
. Managed Emissions Testing Station
o Maintained budget
o Scheduled employees
. Conducted Employee Performance Reviews
. Handled customer complaints
. Trained Lane Inspectors
. Performed audits on Lane Inspectors
. Interacted with State Partner to insure quality assurance
. Provided moral support for employees
. Oversaw testing of vehicles
Assistant Manager
1994 - 1996
Envirotest Illinois Inc.
. Assisted manager in duties
Lane Operator
1991 - 1994
Envirotest Illinois Inc.
. Performed emissions tests on vehicles
Education
Solid Quality Mentors 2010
Westchester, Illinois
SQL Server 2008 Performance Tuning
Global Knowledge 2006
Schaumburg, Illinois
. SQL Server 2005 for Developers
Sybase 2003
Rosemont, Illinois
. Performance and Tuning: Configuring ASE
. System and Database Administration: ASE 12.5
Learning Tree 2002
Schaumburg, Illinois
. Hands-on C Programming Course
University of Saint Francis 1996 - 2001
Joliet, Illinois
. Tech Management Major
Zenger/Miller 1996
Elk Grove, Illinois
. Management Training
Moraine Valley Community College 1992 - 1996
Palos Hills, Illinois
. Associates in Science
References
Upon Request
[pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic]
[pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic]
[pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic]
[pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic]
Contact this candidate