Database Administrator resume Burlington, VT - Hire IT People

TECHNICAL SKILLS:

Languages: T - SQL, HTML, SAS, JavaScript, VBScript, VB, VBA, XML, ASP, ASP .NET, WSH, ADO

OS: Windows NT/ 2000/2003/2008 Server

RDBMS: SQL Server 7.0, 2000, 2005, 2008 & MySQL

Coupling Outlook to SQL Server

Second runner-up award in the 2005 SQL Server Magazine Innovators Awards program

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, VT

Job Title: Database Administrator/ System Administrator

Job Description:

Define and execute backup, security, and indexing strategies for SQL Server corporate databases.
Design and implement all SQL Server corporate databases for internal and external applications.
Create and maintain standby server and SQL Server Log Shipping.
Program stored procedures, maintenance scripts, design DTS and SSIS packages, and utilize BCP.
Developed web based reports with ASP .NET, XML,Crystal Reports, and SQL Report Server.
Run performance moitoring, troubleshot, and apply solutions on all SQL Servers
Consult, assist, and mentor application developer with database programming.
Interact with internal and external customers to define requirements, develop, and deploy applications.
Install, implement, and maintain new software testing bug-tracking system (Bugzilla & MySQL) on Linux server.
Upgrade, monitor, and administer MOSS 2007 instance.

Confidential, Berlin, VT

Job Title: Database Administrator / Application Developer

Job Description:

Developed and implemented web-based data delivery applications with Transact-SQL, HTML, ASP, VBScript, JavaScript, ADO, Crystal Reports, IIS, Visual Studio and SQL Server.
Create and administer various internal and external web sites using IIS, Windows NT and 2000 servers.
Designed, developed and populated SQL Server databases for corporate data warehouse.
Conducted logical and physical database design using ER/Studio
Migrate legacy system data (AS/400) to SQL Server utilizing DTS and BCP.
Conducted performance monitoring, maintenance, and tuning of SQL Servers.

Job Title: Database Analyst Job Description:

Responsible for maintenance of the SAS data warehouse.
Performed monthly updates, back-ups and data verifications.
Administered access privileges and corrections of data inconsistencies.
Met with internal and external customers to define data needs, business rules, and reporting requirements.
Developed reports, data extracts and data marts using data warehouse.

9 Job Title: Data Systems Analyst

Job Description:

Developed reports, data extracts, and data marts using SAS.
Created data model of SAS data warehouse using ER/Studio.
Constructed and maintained internal corporate website for use by senior level management.
Prepared reporting and analysis to large groups on a quarterly basis using SAS.

Confidential, San Diego, CA

Job Title: Contracts and Rebates Coordinator Job Description:

Responsible for the operations and integrity of all department databases, which integrate end user customers, group purchasing organizations, distributor’s customer account numbers, contracts, rebates and sales data.
Processed and ensured accuracy of monthly quotas, commissions and rankings.
Defined requirements for development of new application, performed primary testing, and trained employees on system use and procedures.
Oversaw full and part-time employees’ daily activities and use of all operational systems.
Department liason with consulting company hired to create data warehouse; explained data structures, usage, consulted on data warehouse structure.