Kimberly Killian

New Hudson, MI / 248-***-**** / adcg08@r.postjobfree.com

https://www.linkedin.com/in/kimberlykillian/

With over 24 years of total IT experience, 18 of which I spent with Microsoft SQL Server, I have a very diverse background. I have worked in positions as a programmer, architect, DB Engineer, DBA, ETL developer as well as Senior Level Technical Consultant. I have worked for two of the “big 5” IT consulting firms as well as all of the “big 3” automotive companies and a few tier 1 automotive suppliers. My most recent experience has been working as a Sr. Database Administrator. I have built, migrated and developed databases as well as maintained, migrated and administered them. I also specialize in monitoring and reporting for SQL Server health. In addition to this, I am an author with 11 published technical articles on SQL Server topics.

Publications

October 4, 2017 – “How to Automatically refresh a SQL Server Database” on www.sqlshack.com/automatically-refresh-sql-server-database/

December 29, 2016 - “How to Split a Comma Separated Value (CSV) file into SQL Server Columns” on

www.sqlshack.com/how-to-split-a-comma-separated-value-csv-file-into-sql-server-columns/

December 29, 2016 - “SQL Server Index vs Statistics a consultant’s woes…or rants” on

www.sqlshack.com/sql-server-index-vs-statistics-consultants-woesor-rants/

February 3, 2016 – “What is Causing Database Slowdowns” on

www.sqlshack.com/what-is-causing-database-slowdowns/

January 25, 2016 – “Simple SQL Server Automated User Auditing” on

www.sqlshack.com/simple-sql-server-automated-user-auditing/

July 23, 2013 – “What’s going on, on my Server Right Now?”

www.sqlservercentral.com/articles/SQL+Monitoring/100615/

August 18, 2011 - “When Did Merge Replication Subscribers Last Sync” on www.sqlservercentral.com/articles/Merge+Replication/74294/

September 12, 2011 – “Are remote databases fragmented? Let's Defrag.” on www.sqlservercentral.com/articles/Indexing/74297/

October 17, 2011 – “Centrally collect replication conflicts and send an alert” on www.sqlservercentral.com/articles/Replication/75190/

October 24, 2011 – “Update multiple servers in a single bound” on www.sqlservercentral.com/articles/Replication/75221/

June 6, 2012 – “When did this DB property Change?” on

www.sqlservercentral.com/articles/Database+properties/89921/

Education

Central Michigan University – Master of Science - Software Engineering Administration 1999

Eastern Michigan University – Bachelor of Business Administration 1994

oMajor: Computer Information Systems Minor: Communications

Graduate of EDS Systems Engineering Development (SED) program 1997

Professional Experience

MergeIT September 2019 - Current

Assigned to Dell Computer – SQL Server Consulting Practice

Assigned to United Airlines

Sr. Database Administrator/Consultant

Providing consultation and technical assistance to United Airlines for a Disaster Recovery Data Center Solution.

oParticipated in Scrum Meetings

oBuilt and configured SQL Servers in a disaster recovery environment to match servers in the current production environment. All servers built were clusters.

oProvided technical recommendations to United Airlines for discovered issues.

oTeam lead over offshore team of 3 people

Technical Environment: Windows 10/Server 2008-2016/Azure, SQL Server 2005-2019, Skype/Zoom

DataLink Software – Temple Terrace, FL (remote) January 2019 – August 2019

Sr. Cloud Database Administrator and SQL Developer

Administer Azure SQL Server

oBuilt and configured SQL Server Managed Instances for both Dev and Prod

oConfigured Azure Storage Accounts

oConfigured Data Factory

oBackup/Restore using Blob storage between SQL Server Managed Instances

oTransfer data from on-premises databases to Azure

Created SSIS packages and row batch scripts for data transfers

oDeveloping SSIS packages for data movement from on Premises databases to Azure SQL Managed Instances.

oMigrated data to Azure SQL Managed Instances via SQL Scripts

oMigrated data to Azure SQL Managed Instances via Backup/Restore using Blob Storage

Technical Environment: Windows 10/Server 2016/Azure, SQL Server 2016-2017, Slack

Pratt & Miller Engineering – New Hudson, MI May 2011 – December 2018

Independent Consultant March 2019-Present (remote)

Sr. Database Administrator/Developer and SharePoint Administrator/Developer/Architect

SQL Server database administrator supporting MS SQL Server 2008 R2 with merge replication.

oDatabase administration including backup/restore and overall database maintenance.

oResponsible for creation of development and production databases.

oCreation of SSIS packages for monitoring and data movement.

oCreation of daily “morning reports” for database monitoring and overall health.

oCreation and maintenance of maintenance jobs and data cleanups

oSupport of Merge replication for 30 subscribers and 3 publishers including installs of SQL Server, maintenance and administration including propriety software applications and database support

oMonitor, troubleshoot and resolve SQL Server and database errors and performance issues

oDesign, implement and monitor standard maintenance and disaster recovery processes such as database backups, optimizations and integrity checks

oSetup, maintain and monitor database and server security

oSupport and coordinate database application upgrades

oMake recommendations for improved procedures and practices

oConfigure applications for on- and off-network functionality

oAssist with setup and maintenance of test environments

oCreation of governance documents for Database Standards and Disaster Recovery

oSupport of the VES and Sync Manager applications for Race Operations users

oInstall and configure SQL Server on Race Operations user laptops

SharePoint 2013 Architect, Administrator and Developer

oAdministration of the SharePoint environment

oDesign and development of SharePoint environment

oDesign and develop sites, forms and workflows

oInstalling, configuring, maintaining, upgrading and managing a SharePoint Server Farm.

oConfiguring all service applications like Search, Metadata, User Profile, Synchronization etc.

oAssignment of proper permission levels for all users of the site using both Active Directory and direct access.

oConfiguring timer jobs depending on business requirements. Timer jobs are very important in SharePoint.

oUse of PowerShell for updating Server Farm. Use of PowerShell for exporting data.

oTraining and supporting the business users in their day to day involvement in SharePoint sites. Generated user training course.

oSolid understanding of IIS, Active Directory and Mail Configuration.

oConfigured and setup OWA

Technical Environment: Windows 7/10/Server 2008-16, SQL Server 2008 R2-2016, SharePoint 2013-2016

Got Code assigned to Carite.com Madison Heights, MI (Remote) August 2016 – Present

Sr. SQL DBA and SQL Developer

SQL Developer

oCreated/Developed SSIS packages for data movement from flat file import into data warehouse

Developed storage archiving and renaming of flat files using SSIS

oCreated/Developed SSIS packages for data movement from external (Linked Servers) from DB2

oCreated/Developed SSIS packages for data movement from FTP sites

oETL Development

SQL Server database administrator supporting MS SQL Server 2014-16 including Snapshot replication.

oDatabase administration including backup/restore and overall database maintenance.

oResponsible for creation of development and production databases.

oCreation of SSIS packages for monitoring and data movement.

oCreation of daily “morning reports” for database monitoring and overall health.

oCreation and maintenance of maintenance jobs and data cleanups

oMonitor, troubleshoot and resolve SQL Server and database errors and performance issues

oSupport and coordinate database application upgrades

Technical Environment: Windows /10/Server 2014 on AWS VM, SQL Server 2014

Wolverine Tech Assigned to Dantom – Wixom, Michigan (Remote) November 2010 – October 2013

Sr. DBA

Part-time/Remote Consultant DBA supporting MS SQL Server 2008 R2.

oDatabase administration including backup/restore, query optimization and overall database maintenance.

oResponsible for database migrations from SQL Server 2000 and 2005 to 2008.

oCreation of daily “morning reports” for database monitoring and overall health.

oCreation and maintenance of maintenance jobs and data cleanups.

oCreation of real-time reports for SQL event logs and CPU monitoring.

Technical Environment: Windows 7/Server 2003/2008, SQL Server 2005-2008-R2

MicroMax

Assigned to Burroughs/Unisys Corporation – Plymouth, Michigan May 09 – April 11

Sr. Database Engineer and Web Developer

Responsible for the definition, creation and development of the SmartSource Intelligence (SSI) application dashboard.

oDesign and development of database architecture, including database physical layout, develop queries, functions and stored procedures used by the SmartSource Intelligence Application.

oDatabase administration including backup/restore, query optimization and overall database maintenance.

oAnalyze, test and implement database designs.

oParticipate as a team member in all phases of project development lifecycle.

oDesign and development of the SSI user interface using Ruby on Rails, PostgreSQL and JavaScript, JQuery and Apache Web Server

oCreation of Technical Design Documents, Flow Diagrams, Admin Guides and Online user help.

oRun application performance tests using Wapt

Technical Environment: Windows XP/Server 2003/2008/Vista, Postgres, Visio, Ruby on Rails, Apache, Wapt, Git

Ciber

Assigned to ThyssenKrupp Rolls Royce Project March 09 – May 09

SQL Server Developer

Responsible for the definition, creation and development of the 3PL Data System for the Rolls Royce ThyssenKrupp Account.

oSQL Developer using TSQL, SSIS and DTS including modification of ETL processes using DTS, SSIS and Stored Procedures.

oCreation of Technical Design Documents, Flow Diagrams and Test Cases.

Technical Environment: Windows XP/2003 Server, MS SQL Server 2000/2005, Visio

La-Z-Boy Corporate – Independent Contractor October 08 – February 09 and

SQL Server DBA Independent Consultant May 07- August 07

Responsible for the definition, creation and maintenance of the enterprise data model.

oDesign and configure database architecture, including hardware and physical layout.

oPlanned, installed and maintained SQL Server databases

oAnalyzed, tested and implemented database designs supporting various business applications.

oMonitor/tune database resources using Profiler, logs, SpotLite, custom designed SSIS packages and jobs

oCreated backup and maintenance jobs using SSIS and LiteSpeed for compressed backups

oResponsible for logical and physical database design, backup and recovery strategy including disaster recovery, load strategy design and implementation, security, and change management

oFacilitate application development and customer problem resolution with optimum speed and efficiency.

oCreation of daily “morning reports” for database monitoring and overall health.

Technical Environment: Windows XP/2003 Server, MS SQL Server 2000/2005, VMWare, LiteSpeed

DPM Consulting Assigned to Ford Motor Company August 07- September 08

Application Technology Management Senior / Database Engineer

Engineer Microsoft SQL Server database solutions as per Ford requirements

oWorked with infrastructure owners to develop engineered solutions

oEngineered with team members SQL Server 2005 Shared Farm Environment

oProvided governance on the usage of DBMS as per defined strategy

oDeveloped run books and database usage guidelines for database environment

oPerformed Failure Mode and Effects Analysis (FMEA) testing, testing and validation of critical patches, hot fixes and proof of concept of new releases for database environment

oSingle point of contact for audit

oDesigned solutions and coordinated efforts for the SQL Server 2000 to SQL Server 2005 migrations

oConducted Engineering Reviews for new/existing applications going into SQL Server 2005 environment

oDesigned FTP solution for legacy applications migrating to SQL Server 2005 from Oracle

oEngineered Password vault solution to protect Service Account and System Administrator passwords using PAR product

oDeveloped Team site using SharePoint Team Connects with custom forms with derived fields and calculations

oManaged large-scale projects to ensure on time and within budget.

Technical Environment: Windows XP/2003 Server, MS SQL Server 2005

HTC Global Services Assigned to Cooper-Standard Automotive September 06 – August 07

Consultant / SQL Server DBA / ETL Developer

Responsible for support, design and development of data warehouse solutions that used SQL Server 2000, Data Transformations Services (DTS) for ETL and ProClarity for reporting.

oPerformed data modeling to document source systems.

oScheduled/Created jobs to run DTS packages

oCreated/Modified DTS packages, stored procedures and views to load data into tables via text files, ftp’d data, tables and flat files

oRan and generated SQL scripts to correct/update data in tables (insert/update/delete/select)

oReverse engineered code to create documentation

oRefreshed development and test server environments to synchronize with production and cleanse server environment

oCreated Stored procedures, views, functions and SQL queries to perform data manipulation and imports

oCreated ProClarity 6.1 reports for user verification of data

Technical Environment: Windows XP/2003 Server, MS SQL Server 2000, ProClarity 6.1, SharePoint

Sogeti USA, LLC - Microsoft Practice – Farmington Hills, MI December 05 – September 06

Principal Consultant SQL Server

Assigned to Taubman Company – Bloomfield Hills, MI

oModified the MRI/Intuit Leaseflow application.

oDeveloped new workflows and updating existing workflows.

oDeveloped new reports and updating existing reports.

oUsed SQL Server 2000 Enterprise Manager and tools to verify/modify tables, data, write queries, stored procedures, views and functions used by application.

Assigned to Umicore Automotive Catalyst – Auburn Hills, MI

oImplemented a database for logging test data using Access 2003.

oDeveloped database including tables, relationships and logical and physical data models.

oDeveloped front-end application including menus, forms, reports, queries and macros for general application usage and functionality.

oDesigned and developed complex application functionality using VBA.

oCreated technical documentation.

Technical Environment: Windows XP, Microsoft Access 2003, VB 6.3, MS SQL Server 2000, Intuit/MRI

Publicis – Troy, Michigan June 04 - November 05

Architect / SQL Server DBA

Responsible for support, design and development of data warehouse solutions that used SQL Server 2000, Data Transformations Services (DTS), ETL, Reporting Services and Sharepoint.

oPlanned, installed and maintained SQL Server databases

oPerformed data modeling to document source systems.

oMonitored/tuned database resources using Profiler, logs, BMC Patrol

oUsed PeopleSoft DataMover to migrate data from multiple environments.

oBuilt web server for SQL Reporting Services and user portal using ASP, HTML, SharePoint and IIS

Built user portal on SharePoint with links to reports on Reporting Services. Site features included web parts and SQL Server 2000 database connectivity

Used FrontPage to integrate web changes

Used SharePoint backup and restore to move site to new servers

oSupported SQL Reporting Services

Maintain reports, Upload RDL files, Administer web server and Reporting Services Server

oSupported developers with release management, troubleshooting and overall database maintenance

oInstalled and configured SQL Server 2000 and services patches in both clustered and non-clustered environments

oDesigned & Implemented policies and processes related to password security, configuration management, enhancements and SOX initiatives.

Technical Environment: Windows XP/2000/2003, MS SQL Server 2000

GDI Info Systems – Troy, Michigan Assigned to Delphi Automotive Systems October 02 – June 04

SQL Server DBA / SQL Developer

Provided first-level application support as DBA on SQL Server 2000 and Sybase in a 24x7 environment.

oMonitor/tune database resources using Profiler and logs

oETL Development using DTS packages and Agent Jobs for importing SAP data into Tax Department databases.

Technical Project Lead for FDC system enhancements. Provide technical assistance to developers, gather requirements, create test plans, reporting, test and support application users.

oAdministrator of MicroStrategy Data Warehouse.

Developed reports using MicroStrategy - Created meta-data, metrics, attributes and formulas

Primary maintenance, administration and support of the Tax Department systems: CORPTax/CORPTax Int’l, eComply, eRoom and SharePoint.

oDesign and code VB Scripts used to prepare data for upload into tax web applications.

oCreate process flows of applications using Visio.

oInstalled tax software upgrades into client and server environments

oeRoom Administrator – Design and maintain databases, user access administration

oSharePoint Administrator – Design, maintenance, setup, user access administration

oDesigned and Implemented policies and processes related to password security, configuration management and enhancements as well as SOX initiatives.

Technical Environment: Windows XP/2000, MS SQL Server 2000, MicroStrategy, eRoom, Sharepoint

Strategic Staffing Solutions Assigned to BCBSM – Detroit, Michigan September 01 – October 02

SQL Server DBA / Web Developer

Designed, developed and implemented inter-department web site using Microsoft FrontPage 2000, HTML, DHTML, JavaScript, ASP, IIS and imbedded database queries connecting to MS SQL Server 2000 and MS Access.

SQL Server 2000 Administration: Installed and configured MS SQL Server 2000, migrated MS Access databases and MS SQL 6.5 databases, created databases, tables and queries.

Evaluated Disk Monitoring, Performance Monitoring and Security Applications to highlight features, cost and benefits for management evaluation and tool purchase.

Project Management:

oCoordinated efforts between the Engineering Department and project requests

oHIPPA Implementations

oDefined resource gaps for systems operations based on the implementation of HIPAA requirements.

Technical Environment: Windows 2000, MS SQL Server 2000

EBSG/Conects – Detroit, Michigan Assigned to DaimlerChrysler Corporation February 01 - June 01

Application Architect

Provided technical assistance to DaimlerChrysler (DCX) with the deployment of security solutions and the integration of Netegrity SiteMinder and IT security solutions.

Technical Environment: Windows 2000, UNIX, OS/390, Netegrity SiteMinder 4.5.1, NDS

Tivoli / IBM – Troy, Michigan January 00 to January 01

Advising IT Architect Specialist

Provided technical assistance to General Motors, EDS and vendors, with the installation, customization and deployment of Tivoli SecureWay Products.

Technical Environment: LDAP, Tivoli SecureWay Product Suite, IBM/Transarc DCE, NDS, HTTP Web Server, Apache, Domino, Windows NT, Unix, RSA Security, GSO

CDI Information Services – Auburn Hills, Michigan

Assigned to DaimlerChrysler Corporation August 98 - December 99

Senior Software Engineer

Primary maintenance, development and customer support on a Client/Server system called CORPS. Designed and Developed application using MFC/Visual C++, Visual Basic Macros within MS Word for reporting.

Technical Environment: Windows 95/NT, MFC/Visual C++, Visual Basic, ODBC, Visual SourceSafe

EDS – Troy, Michigan Assigned to General Motors Corporation January 95 - August 98

System Engineer

Worked on multiple releases of a Client/Server Global Purchasing System (GPS) with development on both the client and server sides of the application using MFC/Visual C++.

Graduate of EDS Technical Training - System Engineer Development Program.

Technical Environment: Windows 95/NT, MFC/Visual C++, Visual SourceSafe, PVCS, ODBC, SQL

Contact this candidate