Imaginea de profil a utilizatorului sitedataview
@sitedataview
Steagul United States New Hudson, United States
Membru din 17 aprilie 2011
0 Recomandări

sitedataview

Conectat Deconectat
Kimberly Killian New Hudson, MI 48165 With over 23 years of total IT experience, 16 of which I spent in the automotive industry, 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 as well as suppliers. My most recent experience has been working as a Database Administrator. I have built migrated and developed databases as well as maintained and administered them. I also specialize in monitoring and reporting for SQL Server health. Over the last 3 years, I have also become an author with 9 articles published on [login to view URL] and SQLShack.com.
$95 USD/hr
1 părere
0.0
  • N/AProiecte finalizate
  • N/AConform bugetului
  • N/ALa timp
  • N/ARata de angajare repetată

Portfoliu

Păreri Recente

Experiență

Various

Jan 1993 - Sep 2014 (21 years)

Pratt & Miller Engineering May 2011 – Present Database Administrator Technical Environment: Windows 7/Server 2008, SQL Server 2008 R2-2012, SharePoint 2010/2013 Wolverine Tech Assigned to Dantom Systems/RevSpring November 2010 – October 2013 Sr. DBA Technical Environment: Windows 7/Server 2003/2008, SQL Server 2005-2008-R2 MicroMax Assigned to Burroughs/Unisys Corporation May 09 – April 11 Sr. Database Engineer and Web Developer 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 Technical Environment: Windows XP/2003 Server, MS SQL Server 2000/2005, Visio La-Z-Boy Corporate October 08 – February 09 and May 07- August 07 SQL Server DBA Independent Consultant echnical 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 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 Technical Environment: Windows XP/2003 Server, MS SQL Server 2000, ProClarity 6.1, SharePoint Sogeti USA, LLC - Microsoft Practice December 05 – September 06 Principal Consultant SQL Server Technical Environment: Windows XP, Microsoft Access 2003, VB 6.3, MS SQL Server 2000, Intuit/MRI Publicis June 04 - November 05 Architect / SQL Server DBA Technical Environment: Windows XP/2000/2003, MS SQL Server 2000 GDI Info Systems Assigned to Delphi Automotive Systems October 02 – June 04 SQL Server DBA / SQL Developer Technical Environment: Windows XP/2000, MS SQL Server 2000, MicroStrategy, eRoom, Sharepoint Strategic Staffing Solutions Assigned to Blue Cross Blue Shield of Michigan September 01 – October 02 SQL Server DBA / Web Developer Technical Environment: Windows 2000, MS SQL Server 2000 EBSG/Conects Assigned to DaimlerChrysler Corporation February 01 - June 01 Application Architect Technical Environment: Windows 2000, UNIX, OS/390, Netegrity SiteMinder 4.5.1, NDS Tivoli / IBM January 00 to January 01 Advising IT Architect Specialist 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 Assigned to DaimlerChrysler Corporation August 98 - December 99 Senior Software Engineer Technical Environment: Windows 95/NT, MFC/Visual C++, Visual Basic, ODBC, Visual SourceSafe Electronic Data Systems Assigned to General Motors Corporation January 95 - August 98 System Engineer Technical Environment: Windows 95/NT, MFC/Visual C++, Visual SourceSafe, PVCS, ODBC, SQL

My Resume

Jan 1993

Professional Experience Pratt & Miller Engineering May 2011 – Present Database Administrator • SQL Server database administrator supporting MS SQL Server 2008 R2 with merge replication. o Database administration including backup/restore and overall database maintenance. o Responsible for creation of development databases. o Creation of SSIS packages for monitoring and data movement. o Creation of daily “morning reports” for database monitoring and overall health. o Creation and maintenance of maintenance jobs and data cleanups o Support of Merge replication for 20 subscribers and 3 publishers including installs of SQL Server, maintenance and administration including VES application and database support o Monitor, troubleshoot and resolve SQL Server and database errors and performance issues o Design, implement and monitor standard maintenance and disaster recovery processes such as database backups, optimizations and integrity checks o Setup, maintain and monitor database and server security o Support and coordinate database application upgrades o Make recommendations for improved procedures and practices o Configure applications for on- and off-network functionality o Assist with database development by writing scripts, stored procedures, etc. o Assist with setup and maintenance of test environments o Creation of governance documents for Database Standards and Disaster Recovery • SharePoint Administrator and Developer o Administration of the SharePoint environment o Design and development of SharePoint environment o Design and develop forms and workflows Technical Environment: Windows 7/Server 2008, SQL Server 2008 R2-2012, SharePoint 2010/2013 Wolverine Tech Assigned to Dantom Systems/RevSpring November 2010 – October 2013 Sr. DBA • Part-time/Remote Consultant DBA supporting MS SQL Server 2008 R2. o Database administration including backup/restore, query optimization and overall database maintenance. o Responsible for database migrations from SQL Server 2000 and 2005 to 2008. o Creation of daily “morning reports” for database monitoring and overall health. o Creation and maintenance of maintenance jobs and data cleanups. o Creation 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 May 09 – April 11 Sr. Database Engineer and Web Developer • Responsible for the definition, creation and development of the SmartSource Intelligence (SSI) application dashboard. o Design and development of database architecture, including database physical layout, develop queries, functions and stored procedures used by the SmartSource Intelligence Application. o Database administration including backup/restore, query optimization and overall database maintenance. o Analyze, test and implement database designs. o Participate as a team member in all phases of project development lifecycle. o Design and development of the SSI user interface using Ruby on Rails, PostgreSQL and JavaScript, JQuery and Apache Web Server o Creation of Technical Design Documents, Flow Diagrams, Admin Guides and Online user help. o Run 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. o SQL Developer using TSQL, SSIS and DTS including modification of ETL processes using DTS, SSIS and Stored Procedures. o Creation 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 October 08 – February 09 and May 07- August 07 SQL Server DBA Independent Consultant • Responsible for the definition, creation and maintenance of the enterprise data model. o Design and configure database architecture, including hardware and physical layout. o Planned, installed and maintained SQL Server databases o Analyzed, tested and implemented database designs supporting various business applications. o Monitor/tune database resources using Profiler, logs, SpotLite, custom designed SSIS packages and jobs o Created backup and maintenance jobs using SSIS and LiteSpeed for compressed backups o Responsible for logical and physical database design, backup and recovery strategy including disaster recovery, load strategy design and implementation, security, and change management o Facilitate application development and customer problem resolution with optimum speed and efficiency. o Creation 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 o Worked with infrastructure owners to develop engineered solutions o Engineered with team members SQL Server 2005 Shared Farm Environment o Provided governance on the usage of DBMS as per defined strategy o Developed run books and database usage guidelines for database environment o Performed 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 o Single point of contact for audit o Designed solutions and coordinated efforts for the SQL Server 2000 to SQL Server 2005 migrations o Conducted Engineering Reviews for new/existing applications going into SQL Server 2005 environment o Designed FTP solution for legacy applications migrating to SQL Server 2005 from Oracle o Engineered Password vault solution to protect Service Account and System Administrator passwords using PAR product o Developed Team site using SharePoint Team Connects with custom forms with derived fields and calculations o Managed 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. o Performed data modeling to document source systems. o Scheduled/Created jobs to run DTS packages o Created/Modified DTS packages, stored procedures and views to load data into tables via text files, ftp’d data, tables and flat files o Ran and generated SQL scripts to correct/update data in tables (insert/update/delete/select) o Reverse engineered code to create documentation o Refreshed development and test server environments to synchronize with production and cleanse server environment o Created Stored procedures, views, functions and SQL queries to perform data manipulation and imports o Created 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 December 05 – September 06 Principal Consultant SQL Server • Assigned to Taubman Company o Modified the MRI/Intuit Leaseflow application. o Developed new workflows and updating existing workflows. o Developed new reports and updating existing reports. o Used 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 o Implemented a database for logging test data using Access 2003. o Developed database including tables, relationships and logical and physical data models. o Developed front-end application including menus, forms, reports, queries and macros for general application usage and functionality. o Designed and developed complex application functionality using VBA. o Created technical documentation. Technical Environment: Windows XP, Microsoft Access 2003, VB 6.3, MS SQL Server 2000, Intuit/MRI Publicis 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. o Planned, installed and maintained SQL Server databases o Performed data modeling to document source systems. o Monitored/tuned database resources using Profiler, logs, BMC Patrol o Used PeopleSoft DataMover to migrate data from multiple environments. o Built 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 o Supported SQL Reporting Services  Maintain reports, Upload RDL files, Administer web server and Reporting Services Server o Supported developers with release management, troubleshooting and overall database maintenance o Installed and configured SQL Server 2000 and services patches in both clustered and non-clustered environments o Designed & 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 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. o Monitor/tune database resources using Profiler and logs o ETL 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. o Administrator 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. o Design and code VB Scripts used to prepare data for upload into tax web applications. o Create process flows of applications using Visio. o Installed tax software upgrades into client and server environments o eRoom Administrator – Design and maintain databases, user access administration o SharePoint Administrator – Design, maintenance, setup, user access administration o Designed 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 Blue Cross Blue Shield of 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: o Coordinated efforts between the Engineering Department and project requests o HIPPA Implementations o Defined resource gaps for systems operations based on the implementation of HIPAA requirements. Technical Environment: Windows 2000, MS SQL Server 2000 EBSG/Conects 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 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 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 Electronic Data Systems 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

Educație

Software Engineering

1997 - 1999 (2 years)

Calificări

EDS Systems Engineer (1995)

EDS

Graduate of EDS Systems Engineering Development (SED) program

(SED) program (1995)

EDS

Graduate of EDS Systems Engineering Development (SED) program

Publicări

When Did Merge Replication Subscribers Last Sync

http://www.sqlservercentral.com/articles/Merge+Replication/74294/

Are remote databases fragmented? Let's Defrag

[login to view URL]

Centrally collect replication conflicts and send an alert

[login to view URL]

When did this DB property Change?

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

What’s going on, on my Server Right Now?

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

Various Articles

• August 18, 2011 - “When Did Merge Replication Subscribers Last Sync” on http://www.sqlservercentral.com/articles/Merge+Replication/74294/ • September 12, 2011 – “Are remote databases fragmented? Let's Defrag.” on [login to view URL] • October 17, 2011 – “Centrally collect replication conflicts and send an alert” on [login to view URL] • October 24, 2011 – “Update multiple servers in a single bound” on [login to view URL]

Certificări

  • US English Level 1
    88%

Verificări

  • Conectat pe Facebook
  • Freelancer Preferat
  • Metodă de plată confirmată
  • Număr de telefon confirmat
  • Identitate confirmată
  • Adresă de e-mail confirmată

Răsfoieşte Freelanceri Similari