Justin Ames

QUALIFICATIONS PROFILE
Solutions-oriented Database Administrator with a proven track record of effective systems operations demonstrated through hands on experience in the design, development, and implementation of quality, performance-based databases that reduce fragmentations and minimize failures, as well as increase overall system performance.
 Broad technical knowledge with proficiency in Microsoft SQL Server 2000 database administration and development.
 Excellent project management and diagnostic skills; able to identify problems during initial stages and offer effective solutions to ensure on time completion.
 Successfully produce quality products; rapidly discern and incorporate specific requirements to ensure optimal performance.
 Strong background in collaborating with team members and clients; outstanding communication and interpersonal abilities.
 Skilled team leader; able to direct multiple tasks effectively and define efficient procedures which assure reliability and quality.
CORE COMPETENCIES:
* Process Improvement * Cross-functional Team Leadership * Problem Resolution
* Project Management * Database Development & Deployment * Procedure Development
* Detailed Documentation * Functionality Testing & Defect Analysis * Systems Implementation
TECHNICAL BACKGROUND
Platforms: All Windows, including Windows 2000 Advanced Server
Tools: SQL Server 2000/2005, Veritas Backup Exec, Cognos DecisionStream, SQL Compare, Visual Studio 2003, Visual FoxPro, Visio, Microsoft Word, Excel, Internal Web-based Software
SQL Skills: Database Design, T-SQL, Stored Procedures, Indexing, Replication (Transactional and Snapshot), DTS, Datawarehousing, ETL, Backup Strategies, Log Shipping
Languages: T-SQL, Visual FoxPro

PROFESSIONAL EXPERIENCE
A large, International Marketing Agency, Irvine, California March, 2005- Present
Data Architect / Database Administrator
Assist project teams and system development; accountable for ensuring stability and development of production databases. Collaborate with team members comprised of software engineers, quality control, and IT Director; tasked with defining advantages/disadvantages of procedures. Producing, optimizing, and releasing stored procedures, triggers, and DTS packages. Train and mentor Data Steward.
Key Achievements:
 Assisted in managing more than 60 databases on 3 servers.
 Significantly Increased overall system performance and minimum failures by designing effective, quality database objects for various in-house applications.
 Optimized and maintained production databases utilizing SQL Profiler, Database Maintenance Plans, SQL Compare, and custom-built agents.
 Assisted in the design and documentation of several critical components including database object naming conventions and Best SQL Practices for in-house developers.
 Assisted in the design, implementation, and maintenance of a new data warehouse using Cognos DecisionStream
 Optimized and stabilized pre-existing poor-performing Stored Procedures, resulting in a 20% increase in overall site speed and a 94% drop in SQL Timeouts.


PROTOCOL DIRECT MARKETING, Foothill Ranch, California 1998 - March, 2005
Lead Database Administrator
Lead project teams and system development including coordinating and directing all phases of multi-faceted projects; accountable for ensuring stability of production, development, and QA databases. Collaborate with team members comprised of software engineers, network engineers, quality control, and IT Director; tasked with defining advantages/disadvantages of procedures and conducting product testing to ensure reliability and quality. Produce, optimize, and maintain all stored procedures, triggers, replication, and DTS procedures. Supervise, train, and mentor Junior Database Administrator.
Key Achievements:
 Successfully managed more than 50 databases on 5 servers; upgraded main in-house applications VFP7 databases to SQL Server 2000.
 Increased overall system performance and reduced fragmentations and minimum failures by designing effective, quality databases for various in-house applications.
 Developed suite of VFP/SQL utilities for in-house developers in order to streamline operations.
 Optimized and maintained production databases utilizing SQL Profiler, Database Maintenance Plans, Veritas Backup Exec and custom-built agents.
 Designed and documented several critical components including database and database object naming conventions and Best SQL Practices for in-house developers.
 Wrote, maintained, and optimized several modules of VFP application.
 Released weekly updates to both the VFP application and the SQL Server databases.
PROFESSIONAL TRAINING
Administering a Microsoft SQL Server 2000 Database (MS MCDBA, Course 2072)
Cognos DecisionStream

California - Southern

English

Code Optimization
Database Administration
Database Architecture Design