Sql Server Engineer

.

Dave

HamiltonSr. Database Administrator

Dave Hamilton

**** * ***** #**

Tucson, Arizona 85712

Mobile: 360-***-****

***************@*******.***

SUMMARY:

Dave Hamilton is a Database Administrator and skilled data integration engineering technical lead with over 2 decades of experience with IBM Mainframe and over six years of experience as a Client-Server DBA with SQL Server. At his most recent position As design engineer in a confidential warehousing environment Dave provided maintenance documentation as well as Technical support for ETL of data on many diverse platforms to integrate with the Coplink SQL Data warehouse.

In a prior role at Premera Blue Cross as a senior technical DBA and lead, Dave created and maintained change management documentation for internal database systems. IMS/DB2 and SQL Additionally, he mentored other DBA associates in problem/change management, disciplines/processes, performance management reporting and technical strategies. Dave was responsible for developing in-house standards for data management with MS Windows operating systems and others on the mainframe using IMS, DB2 and SQL. He has worked over 5 years with MS SQL Server 2000/2005 SSIS, most recently using 2008. Dave has experience with SQL Server backup/recovery strategies; distributed databases; data migration; security and error handling using third party software like Embarcadero and IDERA as well as Microsoft tools for Extract Transfer and Loading of data.

TECHNICAL SKILLS: 30+ years working in IT 20+ years with DB2 15-18 years performing DB2 DBA application functions working with DB2 utilities (IBM or BMC) (reorg, image copy, etc) 3 years working with version 8 of mainframe DB2 software 25 years database design experience, working on mainframe Use Omegamon and T-mon for monitoring DB2 threads 6-8 years of tuning SQL 15+ Years IMS DB and DC Some experience with MQ series

TRAINING/SKILLS:

COBOL, BAL, RPG and T-SQL programming

Advanced MSSQL Server skills using Windows 2003 and Enterprise operating systems. Transcripts available on request

Formal training from SQLSOFT in (Bellevue)

Mainframe IMS and DB2 analysis and design

Oracle DB administration class I & II

MS - 2559 introduction to visual basic .net

MS - 2071 T - SQL programming

MS - 2072 administering SQL server 2000

MS - 2073 SQL Server 2000 Database

EXPERIENCE:

Knowledge Computing Corp(KCC) I2 April 2009 to Oct 2009

Design Engineer for the Coplink Warehouse

Using ETL of DB2 SQL 2005/2008 and AS/400 Oracle data housing Police File and Homeland Security Information Integration. Confidential

CPSA Healthcare billing Tucson, AZ (contract) OCT 2008 to NOV 2008

Sr. SQL DBA

My most recent CONTRACT experience TEK Systems; client CPSA Healthcare billing In Tucson, AZ

General Description:

Responsible for configuration and maintenance of SQL servers including development and production, monitors and optimizes databases, and insures integrity of the system in a virtual environment. CPSA is one of the more than 15,000 customers that rely on NetApp iSCSI solutions. Holding 1.2 tera bytes of Transaction log and Databases for recovery in a disaster. Using SQL SnapMgr and Snap Clone technology when possible. Responsible for the planning, maintenance and development of enterprise databases supporting core business applications, With Hipaa and SOX compliance in mind with audits and tracking systems focus for the future reporting needs. Support of data warehouse using SQL Server database management system. (Also responsible for database security, performance tuning, data integrity, backup /recovery.) Qualifications: Administrator of complex databases supporting core business applications and a data warehouse experience in supporting healthcare business and clinical systems in the capacity of a database administrator. Knowledge of SQL Reporting Services SQL 2000 and 2005.

Duties:

Configures and maintains databases in the production and build environments. Monitors and optimizes databases. Manages database security. Defines physical and logical data architecture design. Creates data services by using Transact-SQL. Tunes SQL and establishes database standards. Manages and maintains database integrity, database synchronization and replication of local and remote databases. Monitors database performance, implements performance tuning, and database capacity planning. Manages DTS packages and moved them to 2005. Configures and maintains logical and physical disk layouts. Generates SQL Server metrics reports. Backup and recovery of databases Storage and capacity planning. Data import and export.

Microsoft, WA (contract) AUG 2008 to SEP 2008

SQL DBA AMOPS group(AntiMalware) Confidential

SQL Server Database Administrator Job Description

A database administrator was expected to have a strong working knowledge of SQL Server 200* and T-SQL Which I have. I feel comfortable performing both routine and urgent database maintenance across multiple environments, writing T-SQL code, and evaluating the performance of databases. I built 4 servers for the malware section while on assignment. Running the SCOM 2007 (MOM) Operation Center. Some common tasks that I performed are: Create and maintain databases on a wide array of servers running SQL Server 200* ( mostly 2005 )Troubleshoot database problems such as failing jobs, poor query performance, and data integrity issues (Daily ).Create, debug, and maintain T-SQL code. Wrote tools and utilities to assist the operations and development teams. Investigated Database Mirroring SQL 2008 for deployment on SAN.Performed Differential Log backups.

Insurance Company of Canada, Vancouver, WA (contract) Feb 2008 to May 2008

IMS DBA Perform health check on all IMS databases and prepare recommendation reports. Responsible for implementation of tuning and performance findings resulting in highly tuned and responsive databases reducing risk of unplanned database outages. Position the databases for future enhancement and safe growth by performing online reorganization implementation - provide 7x24 availability to update IMS databases and serve the customer for longer hours by reducing the maintenance window. Researched new/current database technologies for online reorganization and produced implementation plans where feasible. Provided maintenance documentation as necessary Streamlined the Automated Operations (OG) Interface with IMS Commands Made recommendations for a more intuitive interface including changes to and documentation of the use and maintenance of interfaces. This allowed for easier support and maintainability - shortened the learning curve for other DBA staff resulting in faster problem resolution time. Standardized and documented IMS Database Utilities (Maintenance jobs) allowing for easier support and maintainability and shortening the learning curve for other DBAs

Highline School District (contract) Oct 2007

Data Integration Engineer Installed, configured, deployed and supported SSIS SQL 2005 package and SQL 2000/2005 Databases. Utilized Business Enterprise Visual Studio 8 to support Converted Data Transformation Services (DTS) 2000 Packages to SSIS 2005 in a production and testing environment in preparation for a migration to Oracle database package

Sabbatical Aug 2006 to Oct 2007

Training Exposure to Microsoft SQL 2008 and IBM Websphere Replication Server and IBM Tivoli Application management solutions. Comfortable that I can support an employer that needs 24x365 support with high availability, high transaction, e-commerce web enabled processes from any platform.

Premera Blue Cross, Mountlake Terrace, WA Oct 1999 to Aug 2006

Senior IMS/DB2 SQL Oracle Database Administrator

IMS/DB2/SQL JOB FUNCTIONS Hired for Y2K support in Production IMS. Provided backfilled DB2 DBA support for the year. Responsible for various databases including IMS, DB2 and SQL servers using LiteSpeed from Quest Software for log shipping of Backup files to restore SQL Server data. SQL Server Backup and Recovery Tool for Log shipping to Spokane at the backup site was Litespeed, IDERA software and others for 'SOX Sarbanes Oxley monitoring of 12 terra bytes of information. Physical database design and performance tuning with trouble shooting; error handling; hardware planning using DBCC for SQL IMS/DB2 using BMC tools; and SQL 2000 Reporting Services. Consultation service provided to project teams, assisting with the application design where appropriate. Our DBA Team identified and set out to resolve all application operational related issues ranging from Web Server, SQL Server, Operating Systems, Network issues etc. In IMS the night batch process for adjudication of claims was taking 5-7 min per claim - restructured database to run 700 claims per minute. Identified and evaluated the impact to the customer's applications by all relevant security hot fixes and patches for SQL, DB2 and IMS with Programmer support. Communicate with programmers that write code and become effective at problem resolution. Familiar with all aspects of the Governmental regulations and helped fit them in to the legacy system in a timely manner. He knows how, when and to whom to escalate issues for assistance any time of night or day. Created and maintained automated processes for SQL queries connected to various available DB2 and SQL databases using DB2 connect to gather and manipulate the required data.

SQL JOB FUNCTIONS Created and maintained automated processes using IDERA products, with MS SQL to gather and present data with SQL reporting services. Analyzed data before and after processes to critically determine weaknesses and errors in processes. Troubleshooted servers based on a baseline setup using IDERA and DBCC scripts and other profile gathering data that can be replaced by IBM Tivoli. Manager approval to implement change in IMS processes to increase performance. Experience in installing, configuring, managing, monitoring and troubleshooting 96 SQL Server databases with over 30 instances in a mix of 2000 & 2005 SQL using the instances to consolidate servers for best performance and best practices. Isolating dictionary and binary databases for Test and Production consolidation and usage. Experience in developing and monitoring DTS in SQL 2000 and using SSIS for the SQL 2005 converting DTS packages to SSIS using Business Integration Services when needed. Extensive use of BMC products both on the Mainframe and use of KM agents for SQL2000 where provided.

ORACLE JOB FUNCTIONS Responsible for introduction of Oracle 9i and 10g to testing environment. Wrote queries, setup initial data structures, ran jobs and utilized tools for SQL reporting services.

Viasoft Inc. Phoenix, Arizona Jan 1997 to Oct 1999

SE and Customer Support Engineer IMS DB2 DBA Installed software with Training classes and Supporting Cobol maintenance products for the Software vendor in prep for customer Y2K issues.

Motorola Inc., Phoenix, AZ, United States July 1990 to Jan 1997

IMS DBA Responsible for all IMS database maintenance backup and recovery world wide using BMC utilities. Managed 18 logical IMS systems running 30+ databases mirror's of production within one Physical IMS system. Implemented training course for new hires on the logical database structures and working with the Application DBA in each division. All IMS related changes went thru Dave's desk before implementing them in production. Peer level with another DB2 DBA and controlled the entire Bill of Material Databases from Sand to Wafer for Motorola in Phoenix. Heavily involved in the moving of the Data center to Phoenix from Schaumburg, IL. (Phoenix is now closed)

Mattel Toys, Torrance, CA Mar 1987 to May 1990

Senior IMS/DB2 DBA Designed databases from Conceptual design to Physical implementation. Designed and maintained DB2 Adding Tables Views, Columns Security when applicable for DB2. IMS Database primary responsibility doing all of the DBD/PSB gen's and responsible for back-up and recovery of all Production and Test data.

American Honda, Gardena, CA Mar 1980 to Feb 1987

IMS DBA Created Segments SB's and DBD's with the IBM Data Dictionary. Maintained and tuned the new parts system databases in test and production (4 year project) Coordinated testing databases and implemented the production structures with standards and operational procedures for backup and recovery of all data supporting 60 contractors. Created and implemented methodologies to capture data elements in the IMS Data Dictionary that has 5 logical databases.

Your Email

Email Address Required.

Email Message

Required

Send To

Your Email

Message

These items will be permanently deleted and cannot be recovered. Are you sure?

Contact this candidate