Sql Server Team Lead

Location:

Downers Grove, IL

Posted:

January 24, 2013

Contact this candidate

Resume:

Laura Prowicz - abqco9@r.postjobfree.com

http://www.udonet.com/laura/resume/

updated: April 15, 2011

OBJECTIVE :

To secure a challenging senior-level database engineer and/or database administrator position in a highly integrated data center environment.

CAREER HISTORY :

Acxiom Corporation, Downers Grove, Illinois

November 2009 – Present Sr. SQL Server DBA (Technical Lead)

Acxiom Information Management Services (Global IT Outsourcing): Delivering the most secure, high-performance infrastructure & information management services to clients for 40 years. Acxiom is a global leader in customer insights and information management, helps clients drive improved financial performance and uniquely positioned to deliver significant results for companies who rely on massive volumes of information for their success.Responsible for 24x7 Technical Lead operations database support of Acxiom client’s database infrastructure (over 250 instances, clustered, stand-along, DEV/TEST/PROD) Maintenance, management and troubleshooting/remediation for 64bit Windows 2008 Multi-Node Clusters (Active/Active/Active), SQL Server 2008R2 Enterprise, SQL Server Replication, Database Mirroring, Log Shipping, EMC SAN solutions, Veritas Storage Foundation, Netbackup backup solution, BMC Patrol, CA Service Desk, more Completed several large T-SQL programming projects in 2010/2011 including: Comprehensive, totally automated SQL Server (2000/2005/2008/2008R2) native backup process with a simple, easy to use rollout procedure suitable for scheduling and managing through the SQL Agent. Targeted, totally automated SQL Server (2000/2005/2008/2008R2) index maintenance and statistics update process with simple, easy to use rollout procedure suitable for scheduling and managing through the SQL Agent. Developed in-house standards for: Intel server builds (destined to become SQL Servers), SQL Server installation, database settings, performance configurations, SAN/disk allocations and physical database design.

Incisent Technologies, Chicago, Illinois

Incisent Technologies uses innovative practices to transform businesses in the manufacturing and consumer arenas including various aspects of the automotive industry (Three-Month Contract)

June 2009 – November 2009 Sr. SQL Server DBA (Lead)Responsible for 24x7 lead operations database support of Incisent’s complex system of 64bit Clustered SQL Server 2005 environments (EMC/Clarion 320 SAN) that power the FirstLook system. Responsible for daily ETL processes (SSIS); performance monitoring and routine operational DBA tasks; T-SQL scripting; documentation and development of standard operational procedures. One SQL Server 2008 test environment.

CQG, Inc., Chicago, Illinois

CQG leads the way in providing analytics software and trading solutions.

April 2008 – June 2009 Sr. SQL Server DBAResponsible for primary and backup DBA support of the CQG, Inc. SQL Server 2000 and 2005 high-transaction trading environments running on Clustered SAN environments. HP and DELL SAN technologies (various), Texas Instruments solid state disk, Windows 2003 Clustering, SQL Server 2000, 2005 and 2008, 64bit environments, system failover technologies including Double Take, Microsoft Database Mirroring, and Log shipping, SQL Server replication, TSQL scripting, database maintenance automation, enterprise monitoring applications including IPMonitor, Quest Spotlight on SQL Server.

NewEdge Group (formerly Fimat, LLC), Chicago, Illinois

Newedge offers global, multi-asset brokerage services on a range of listed and OTC derivatives and securities.

June 2006 – April 2008 Sr. SQL Server DBA (Lead)Responsible for team lead 24x7 DBA activities encompassing a large and volatile inventory of over (100) standard and enterprise Microsoft SQL Servers, including 64bit SQL Server clusters, EMC SAN technology and other high-end systems. Responsible for directing the project and support activities for one junior SQL Server DBA. HP and EMC SAN technology, Windows 2003 Clustering, SQL Server 2000 and 2005, 64bit environments, system failover technologies including EMC Geoclustering solutions, SQL Server replication, TSQL scripting, database maintenance automation, enterprise monitoring applications including MOM and Idera Diagnostic Manager.

Sara Lee Corporation, Downers Grove, Illinois

Sara Lee Corporation is a global manufacturer and marketer of high-quality, brand-name products for consumers throughout the world (relocated from Rolling Meadows to Downers Grove June 2006.)

January 2006 – June 2006 Sr. SQL Server DBA (Lead)

Career Education, Online Education Group, INC., Hoffman Estates, Illinois

Career Education Corporation’s Online Education Group operates American InterContinental University Online and Colorado Technical University Online and offers a variety of degrees in business, education, visual communication and information technology (subsidiary folded back into CEC Nov 2005.)

March 2005 – November 2005 Sr. SQL Server DBA (Lead)Responsible for team lead 24 x 7 DBA activities encompassing a diverse inventory of over (40) standard and enterprise Microsoft SQL Servers, including three large Unisys 64-bit, 8-way and 16-way SQL Server clusters. Responsible for directing the project and support activities for one junior SQL Server DBA. Responsible for primary DBA support of the OEG internet-accessible virtual campus database servers representing over 10,000 around-the-clock college students.

OfficeMax, Inc., Itasca, Illinois

OfficeMax is a leader in both business-to-business office product solutions and retail office products. The company boasts over $8 billion in sales, more than 40,000 associates and almost 1,000 superstores (relocated from Itasca to Naperville March 2005.)

October 2002 – March 2005 Sr. SQL Server DBA (Lead)Responsible for team lead 24 x 7 DBA activities encompassing a diverse inventory of over (40) standard and enterprise Microsoft SQL Servers, representing all modern versions from 6.5 through 2000 and over 300 distinct databases (several 1TB+ VLDBs and OLAP systems). Responsible for directing the project and support activities for two junior SQL Server DBAs. Responsible for primary DBA support of the OfficeMAX point-of-sale (POS) system representing over 3,500 interdependent SQL Server 2000 (MSDE) environments. Responsible for the creation and maintenance of entity relationship diagrams, meta data repository and comprehensive system documentation including everything from environment configuration information through standards, policies and procedures.Proficient in several programming languages including T-SQL, perl, HTML, Windows scripting (WSH) and Cold Fusion in support of DBA activities such as scripting, working with automated processes, creating stored procedures and triggers and integrating front-end web pages with back-end database engines.

MIDAS, Inc., Itasca, Illinois

Midas, Inc., is one of the world's largest providers of automotive service, including exhaust, brakes, steering, suspension, climate control and maintenance services (sold PWI division in Oct 2002.)

April 2001 – October 2002 Sr. SQL Server DBA (Lead)Responsible for team lead 24 x 7 DBA activities encompassing an integrated point-of-sale (POS) system of over (20) Microsoft SQL Servers, heavily reliant on SQL Server replication technology. This production SQL server system supports the Parts Warehouse, Inc. division of Midas, Inc. and includes (5) data center servers and (15) remote servers. Working closely with the user and application support teams, the following initiatives were achieved:Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates. Optimization and automation of data loading procedures for accounting, pricing, and catalog, implementation of test and staging servers, and creation of policies to guide use of same.

BLUEMETEOR, Inc., Chicago, Illinois

BlueMeteor is an Application Service Provider for companies seeking to solve complex business problems via the Internet (went out of business April 2001.)

July 2000 – April 2001 Sr. SQL Server DBA (Lead)Responsible for team lead 24 x 7 DBA activities and primary server/application administration for Fourth Floor Elevator (TM), an Active Server Pages/SQL Server application providing web-enabled business planning functionality. The data center production environment includes Compaq Proliant clusters with SQL Server 7.0 and load-balanced Compaq Proliant servers with IIS 4.0 and Active Server Pages. The development/staging environment includes Compaq Proliant 3000 servers with websites and databases under IIS 4.0 and SQL Server 7.0. Development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting. Maintenance activities include 24 x 7 Windows NT administration, database administration, database optimization/tuning, database updates and overall backup/recovery strategy. Creation and maintenance of a comprehensive set of production support and troubleshooting documentation for operations personnel. Production Windows NT Server administration team lead from July 2000-November 2000. Responsible for daily 24 x 7 administration of data center Windows NT servers including development of standard policies and procedures.

TRIBUNE COMPANY, Chicago, Illinois

Tribune is a leading media company with operations in television and radio broadcasting, publishing, education and interactive ventures. Technical Operations is a division of Tribune Information Systems and is charged with daily 24x7 operation of the Tribune Company Data Center.

June 1998 - July 2000 Windows NT Admin (Team Lead), DBA Specialist

June 1997 – June 1998 SQL/Web Developer, Independent ConsultantResponsible for primary DBA activities for four heavily trafficked Microsoft SQL Servers, including database optimization/tuning and backup/recovery strategy. Responsible for secondary DBA activities for two Oracle 8 datawarehouse servers. Successfully completed both SQL Server Administration and Oracle Enterprise DBA courses during first quarter of 2000.Responsible for development of an intranet-based client/server system developed for Allaire Cold Fusion database connectivity server. ‘ServerBase’ manages all information relevant to the Data Center, such as technical data pertaining to over 180 production servers. Includes features such as change management, server monitoring, and backup reporting. Activities:Cold Fusion programming, SQL programming, database design & architectureWeb server configuration and security. Project leadership and management of one apprentice programmerResponsible for comprehensive Windows NT 4.0 Server administration for twenty-five production servers, including web servers (IIS, WebSite Pro), FTP servers, and database servers (Oracle, SQL Server). Typically provide a range of client services from capacity planning and specification through server configuration, installation and testing as well as ongoing server administration and management. Strength areas:Application consulting and server security.Ongoing client consultation, planning and project management.

ACADEMIC HISTORY :

SOUTHERN ILLINOIS UNIVERSITY, Carbondale, Illinois

June 1988 Bachelor of Science, Electrical Engineering

PROFESSIONAL STRENGTHS :

Excellent communication and presentation skills.

Strong aptitude for project development, management and organization (team lead).

Self-starter with an ability to work independently or as part of a team.

PROFESSIONAL REFERENCES :

Available on request.

Skills Matrix

SKILL

SQL 2000

SQL 2005

SQL 2008

SQL 2008R2

Install/Upgrade

Yes

Create devices,

db’s and logs

Extensive

Yes

Security/User admin

DCL/DDL/DML

Yes

Extensive

SQL/Stored Procs, Triggers, etc.

T-SQL

BCP/Export/Import

DB Maint strategy

Team Lead

Documentation, policies and procedures

Team Lead

DTS/SQL Agent

Extensive

Extensive (SSIS)

Extensive

Network/Windows OS

I have a very strong hardware and engineering background, esp. with regard to disk subsystems (SAN, RAID) and clustering.

Hardware/RAID

Clustering

Extensive

N/A

Languages

Cold Fusion

T-SQL/WSH

HTML/ASP

Perl

Summary

SQL Server DBA Team Lead since 2000, SQL Server DBA since 1995

SQL Server developer and e-commerce programmer 1995 - 2000

Windows NT Admin Team Lead 1995 – 2000

Bachelor of Science, Electrical Engineering - Southern Illinois University in Carbondale, Illinois 1987

Contact this candidate