Sql Server Management

MITCH DE CAMP

*** * ***** ****** #**** Chicago, IL 60654 810-***-**** ********@*****.***

PROFESSIONAL EXPERIENCE

Levenfeld Pearlstein, LLC, Chicago, IL

Levenfeld Pearlstein, LLC (LP) is one of the leading legal practices in the greater Chicago area, representing clients in all industry

standard areas of law.

SQL Server Database Administrator

Responsible for implementation, development, management, support, upgrade and monitoring of database environments supporting CQG

applications, infrastructure systems and services. Define, implement and test backup & recovery standards and best practices for

databases integrity, security, data protection and disaster recovery for customers.

• Manage 10+ SQL Servers with very large database file sizes

• Perform SQL Server health checks

• Automate manual processes for multiple departments via T-SQL and SSIS jobs – create support documents

• Develop scripts for stored procedures, functions and notifications as part of the day to day management functions

• Develop SSIS 2008 integration packages for a variety of projects and tasks

• Develop SSRS 2008 reports and create appropriate subscriptions

• Maintenance and monitoring of database systems for optimal performance and availability of databases

• Implement new enterprise applications and document support policies

• Support replication software (NeverFail)

• Monitor jobs execution, and make correction actions when necessary

• Primary support for document management system (iManage)

• Primary support for accounting/financial/billing system (Prolaw)

• Primary support for multiple applications that are integrated with a document management system

• Assist in creating annual IT budget

CQG, Inc, Chicago, IL 9/2011 – Present

CQG concentrates on creating innovative solutions for the financial trading industry. CQG leads the industry in providing reliable data,

superior decision making, and order execution software with customer support that understands the trader.

SQL Server Database Administrator

Responsible for implementation, development, management, support, upgrade and monitoring of database environments supporting CQG

applications, infrastructure systems and services. Define, implement and test backup & recovery standards and best practices for

databases integrity, security, data protection and disaster recovery for customers.

• Manage 10+ SQL Servers with very large database file sizes

• Monitoring replication and make correction actions in case of problems

• Monitor jobs execution, and make correction actions when necessary

• Respond quickly to requests for data, requiring writing some ad hoc queries – i.e.: request for audit trail for some accounts etc.

• Maintenance and monitoring of database systems for optimal performance and availability of databases

• Maintain and enforce corporate database security policies and controls for all database environments

• Develop scripts for stored procedures, functions and notifications as part of the day to day management functions

• Develop SSRS 2008 reports and create appropriate subscriptions

• Develop SSIS 2008 integration packages for a variety of projects and tasks

BDO USA, USA, Grand Rapids, MI 11/2006 – 9/2011

BDO is a U.S. professional services firm providing assurance, tax, financial advisory and consulting services to a wide range of publicly

traded and privately held companies.

Application Support Developer / Database Administration

Microsoft SQL Server Database Administrator for all enterprise applications.

• Manage 20+ SQL Servers

• Develop and deploy custom SQL Server Integration Services to migrate Oracle (PeopleSoft) and SQL Server data

• Design and maintained project databases using SQL Server; ensured accuracy of information and automated numerous functions

• Analyze and optimize SQL Server production and development databases.

• Research and recommended best practices for application upgrades and fresh installations

• Build SQL 2005/2008 reports

• Configure SQL Server storage drives to leverage an off-site DR location, to ensure reliable backups

• Create and implement database design solutions in collaboration with development team

• Responsible for disaster recovery planning for SQL Servers

• Used clustered SQL environments

Application Development

Develop, revise, and maintain custom applications and websites.

• Develop custom applications Symantec Workflow Solution to automate many internal and professional processes

• Integrate Active Directory authentication in custom applications

• Build relational databases for custom applications

• Maintain firm web sites (ASP, ASP.NET, CSS, Portal Management)

• Support enterprise applications

• Document disaster recovery implementation and testing plans for assigned applications

• Document data retention policies for assigned applications

Altiris Administration

Implement and support an Altiris 6.x and 7.x environments.

• Administer all Altiris functions (Helpdesk, Software Delivery, Notification Server, Active Directory integration)

• Act as level 3 support to vendor

• Develop custom SQL reports for key performance indicators; Helpdesk SLA’s, user inventory, and incident trending & alerts

• Implement Asset Management and Application Metering to increase efficiency of software license management; decrease unused

software licenses by 25%

MITCH DE CAMP 2

PA G E

UNIVERSITY MEADOWS, Mount Pleasant, MI 9/2004 – 2/2006

University Meadows is an American Campus Community. American Campus Communities is the nation's premier owner and manager of

luxurious, academically-oriented student housing.

Computer Technician / Network Administration

• Implemented and supported a residential network that served 600+ users.

• Administered residential wireless network

• Administered office and computer lab Local Area Network

• Installed network switches, hubs, and routers

• Built and managed residential tech support appointment system

• Installed and upgraded office hardware and software

• Responsible for handling all office and residential technical support

• Communicated directly with corporate headquarters

• Coordinated ISP (internet Service Provider) property services

• Awarded twice by corporate office for outstanding work performance

• Supervised one intern

CRESTLINE DEVELOPMENTS, Flint, MI and Mount Pleasant, MI 4/2004 – 11/2006

A self operated effort that served small businesses with website development and networking solutions.

Independent Consultant - Owner

• Developed and design websites for small businesses

• Contracted LAN administration

• Designed physical network architecture

• Developed business proposals for contracting bids

• Communicated and consult directly with all clients

• Supervised one other employee

• Performed desktop maintenance

CENTRAL MICHIGAN UNIVERSITY, Mount Pleasant, MI 8/2004 – 3/2005

A Division 1 university in the Mid American Conference, CMU offered high-end technology to students throughout campus.

Computer Lab Consultant

• Assisted lab participants with all technical problems

• Maintained all network printer performance

EDUCATION

UNIVERSITY OF MICHIGAN - FLINT (Fall of 2001-Winter 2003)

Major: Computer Information Systems

CENTRAL MICHIGAN UNIVERSITY (Fall of 2003 - Spring 2006)

Bachelor of Science in Business Administration, May 2006

Major: Management Information Systems Major GPA – 3.43(4.0) overall

LEADERSHIP ACTIVITIES

• Big Brothers Big Sisters

• Association of Information Technology Professionals, 9/2003 - present

• Alpha Sigma Phi Fraternity, 9/2004 – Present

President, 2/2005 – 5/2006

Technical Director, 5/2005 – 5/2006

Social Director, 9/2005 – 5/2006

Contact this candidate