SQL Server DBA & developer Resume

Title
SQL Server DBA & developer

Primary Skills
SQL Server 2000, 2005, T-SQL, Delphi

Location
US-NJ- (will consider relocating)

Posted
Feb-03-09


OBJECTIVE
SQL Server 2000 & 2005 DBA with Developer experience. Currently seeking substantial experience in SQL Server 2008, .Net development and Analysis Services.

I have an EAD and conditional permanent residency, and am allowed to work in the United States without restrictions.


EXPERIENCE
----------
APRIL 2008 - PRESENT SpaFinder Inc New York, NY
SQL SERVER DBA & DEVELOPER
• Sole SQL Server DBA and developer
• Migrated databases from SQL Server 2000 to 2005 with multiple data refreshes in the SQL 2005 environment
• Performing substantial data cleanup, restructuring and reporting.
• Major responsibilities: administer database servers where necessary, perform or approve all database development, clean up existing database design, develop and maintain data extracts using SSIS, create reports on existing data.
• Secondary responsibilities: implement reporting platform using Analysis Services and Reporting Services 2005.
• Reason for leaving: my wife has been offered a position in Gaithersburg, MD

NOVEMBER 2007 -- MARCH 2008 Travel and major life changes South Africa and USA
• Honeymoon in South Africa before getting married
• Moved from the United Kingdom to the United States to get married.
• Received authorized to work in the United States in March 2008.

MARCH 2005 - OCTOBER 2007 Hays Specialist Recruitment Plc London, UK
SENIOR SQL SERVER DBA
• Sole SQL Server DBA for more than 80 SQL Server instances including mission-critical back-office servers
• Performed all administration tasks including backups, availability monitoring, disk space management, performance management, data archiving
• Identified critical hardware and software upgrades required and worked with technical & business personnel from proposal to implementation.
• Developed database management strategy, identified the resources required to bring 80 instances under proper management.
• Recruited replacement senior DBA, allowing at least 6 weeks for full handover.
• Reason for leaving: moved to the USA to get married.
SQL SERVER DEVELOPER / DBA
• Sole SQL Server developer / DBA for web & intranet team.
• Design & implement database schema for Hays web site, including stored procedures, SQL Server jobs, ad hoc scripting, data migration, ETL.
• Set up source control for database schema.
• All SQL Server administration for web and intranet site database servers, backups, maintenance schedules, server monitoring, implementing enhanced availability techniques (manual server-to-server failover processes).
• Guiding junior developers on database design and development.
• DBA work for other departments including mission-critical payroll system.
• Promoted to company-wide SQL Server DBA (above).

SEP 2004 -- MARCH 2005 AKQA London, UK
SQL SERVER DBA / DEVELOPER
• AKQA is a leading new media agency and Microsoft partner
• Sole DBA responsible for database of > 1TB, > 300 million rows, with 24x7 input
• Daily administration, space management, optimizing queries including data warehousing extracts.
• Liaised with Microsoft on bugs found in SQL Server
• Implemented backup process using extremely limited resources (backups were 300GB after compression).
• Implemented archiving process for data sets > 100 million rows.

MARCH 2002 -- JUNE 2004 Mr. Price Group (Pty) Ltd Durban, South Africa
SQL SERVER 2000 DEVELOPER/DBA
• The Mr. Price Group is a large clothing retail group in Southern Africa with 750 stores.
• Implemented a complex stock management application with 500 GB database on 1TB storage, including tables of 100+ million rows. Largest table was 500 million rows. Database developer team consisted of 1 lead DBA / developer and 1 other database developer.
• Implemented complex business logic in stored procedures and triggers (at least 50% of overall back-end processing resided within the database). Both new development and ongoing maintenance & enhancements.
• Designed and implemented schema changes including changes to very large, mission-critical tables.
• Created ad-hoc SQL scripts for reporting, identifying and resolving problems with input data or processes, data validation, and data imports and exports.
• Other database administration including SQL Server jobs, backup & restore processes, and disk usage & allocation management, and SQL Server performance management.
• Migrated database during (complicated) server upgrades.
• Delphi development on internal support applications where pure SQL scripts were inefficient.

JAN 2001 -- FEB 2002 IT Intellect Training Durban, South Africa
FULL-TIME STUDY: MULTIPLE MICROSOFT CERTIFICATION
• MCSE (Windows 2000)
• MCSD (Visual Basic 6.0)
• MCDBA (SQL Server 7.0)

JULY 1998 -- DEC 2000 Seattle Solutions (Pty) Ltd Durban, South Africa
DELPHI DEVELOPER
• Team-based development using Delphi 3 & 5, SQL Server 6.5 & 7.0 in a team of between 2 and 6 developers.
• Designed & implemented new version of an existing application (complete redesign) including replacing Microsoft Access database with Microsoft SQL Server
• Installed database & application in client environments
• Discovery & requirements analysis with clients.
• Optimized & redesigned database schema & logic on SQL Server 7.0 to improve performance and resolve locking issues.
• Implemented source code control for database schemas using Microsoft Visual SourceSafe 6.0.


EDUCATION
FEB 1994 -- JUNE 1998 University of Natal (Durban) Durban, South Africa
B.SC. (COMP. SCI.)
• Minor in Mathematics
FEB 2001 -- OCT 2001 IT Intellect Training Durban, South Africa
MICROSOFT CERTIFICATION
• MCSE, MCSD, MCDBA

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

| Resumes in New Jersey

View other SQL Server DBA & developer resumes, Database Administrator resumes