Objective

• Seeking an opportunity where I can utilize my 10 years of experience as a SQL Developer/Architect and 8 years as a SQL DBA in complex, large scale, high availability environments.
• Eager to apply my broad skills and thrive within a growing organization on a long term basis.
• Experience in high availability environments up to 500GB with over 400 tables and large transaction counts.
• Ability to work in a collaborative, dynamic team environment and interact at all levels to ensure reliability, availability, scalability, and performance of database applications.
• Modeled, Designed, Built and Deployed numerous databases using ErWin and ER/Studio.

TECHNICAL SKILLS

• SQL Server 6.5, 7.0,2000,2005 & 2008, R2 2012
• SSRS
• OraclePLSQL (familiar)
• C#.NET(familiar)
• ErWin & ER/Studio
• Visual Studio (BIDS)
• VBScript
• Windows 2000 NT, XP,2003 and 2008 Server
• Microsoft Access 97 thru 2007
• MS SQL Server Integration Services (SSIS)

PROFESSIONAL EXPERIENCE

Confidential - Denver, CO

Senior Consultant/BI Developer/SQL Server Lead

Responsibilities:

• Developing dashboards and revising TSQL code
• Utilizing a variety of reporting platforms to report final results and delivered internally through SSIS packages.
• Working in several projects as a SQL developer.
• SSIS, SSRS development and documentation of work.
• Support of ongoing projects and quick integration into current objectives is paramount .
• Modifying exisiting code and documenting the adjustments and ongoing risks is required.
• Unit testing, performance testing and user acceptance testing.

Confidential - Rocky Hill, CT

Senior SQL BI Developer/SQL Server Lead

Responsibilities:

• In charge of program verification reporting via SSRS and automating periodic statutory reports.
• Utilizing a variety of reporting platforms to report final results and delivered internally through SSIS packages.
• Utilizing my skills in both sql server business intelligence as well as finance and insurance to further along the report automation for the program portion of the Property/Casualty initiative.
• SSIS, SSRS development and maintenance.
• Support of infrastructure environments and data warehouses.
• Adhere to usability, design and development standards.
• Unit testing, performance testing and user acceptance testing.

Confidential -Centennial, CO

Senior SQL DBA/Developer/SQL Server Lead

Responsibilities:

• Provided DBA support for the IT organization including backup/recovery automation.
• Team level support as a DBA.
• SQL object creation support and development, code reviews, best practices summaries, assisted in disaster recovery documentation.
• Advanced SSIS development and TSQL mentoring.
• Worked for the senior staff on projects concerning new initiatives, series and integrating Legacy systems.
• Acted as SSIS developer and DBA for marketing campaigns.

Confidential - Denver, CO

Senior SQL DBA/Developer/SQL Server Lead

Responsibilities:

• Lead source for SQL Server Administration and T-SQL Programming.
• Large scale database design and development on the Microsoft SQL Server platforms including normalization techniques, writing stored procedures, security and performance tuning.
• SQL Server application scalability, performance, backup/recoverability, and maintainability.
• SSIS development and maintenance.
• Supportof infrastructure environments and data warehouses.
• Adhere to usability, design and development standards.
• Unit testing, performance testing and user acceptance testing.
• Mentor and conduct code reviews of SQL developers.
• Support (DBA) an Azure SQL platform for cloud computing.
• Oversee ETL initiatives utilizing Azure and documenting their progress.

Confidential - Denver, CO

Senior SQL DBA/Developer

Responsibilities:

• General Administration responsibilities; log shipping, backups, restores.
• Implemented SSIS Packages.
• Created T-SQL scripts.
• Wrote stored procedures and functions for the organization.
• Migrated to four platforms supporting enterprise wide applications.
• Tuned databases for optimum performance.
• Supervised standard database maintenance including patching and service packs of all production servers.
• Created and monitored maintenance plans and data migrations.
• Mentored junior DBA’s/Developersin T-SQL development and testing.

Confidential -Denver, CO

SQL Developer

Responsibilities:

• Developed program and client location functionality for rapid market deployments utilizing SQL Server 2005 and templates.
• Contributed to database architecture planning.
• Supervised T-SQL programmers to acclimate them to the development process and versioning.

Confidential -Denver, CO

SQL DBA

Responsibilities:

• Performed all DBA tasks for the operation including migrations administration and development.
• Handled code reviews and deployed scripts.

Confidential -Golden, CO

DBA/ReportWriter

Responsibilities:

• Performed all of the tasks involved in both development and administration for the business and its operating companies.
• New development and maintenance of existing code.
• Database administration.
• Transferred old reports to the new SSRS environment.
• Mentored others in SQL development
• Prepared the legacy system for a migration to the new platform.

Confidential -Denver, CO

Database Architect

Responsibilities:

• Designed a Data Dictionary to provide critical data schema for the medical registries.
• Created reports, DTS packages, deployment plans and SQLObjects.
• Worked with physicians, administrators and IT personnel to develop procedure and programming guidelines to develop coding standards and conventions for the ongoing database development.
• Assisted in interviewing full time and contractor SQL developers.

Confidential -Colorado Springs, CO

Database Administrator and Developer

Responsibilities:

• Provided data for UAT testing and assisting in the deployment efforts of a massive enhancement to the Compassion product Web2Compass.
• Wrote and modified stored procedures,
• Ran versioning of all of the SQL objects being deployed.
• Automated a large portion of payment processing withCompassion International’s partner; Wausau Financial.
• Directed data extraction and DTS packages to move the data between environments.
• Assisted in a 'Proof of Concept' development project to demonstrate product functionality.

Confidential - Colorado Springs and Denver

Database Administrator and Developer

Responsibilities:

• Database administration.
• Data mining.
• Reported data (Crystal and some SRS)
• Designed databases.
• Database development, integration, maintenance and tuning.
• Data migrations involving Microsoft Access as well as utilizing Oracle’s PL/SQL to modify SQL data prior to a data migration into SQL Server.

Confidential - Colorado Springs, CO

Senior Database Administrator and Developer

Responsibilities:

• Created and maintained databases for a very large brokerage group.
• Administration including backups and recovery, data migration, SQL Jobs, re-indexing of the databases, performance tuning and load balancing of the servers.
• Analyzed, designed,developed and tested new and existing databases for optimum performance.