Jeremy Black
32 Jefferson Street, Paris, Ontario, N3L 3C3
Ph: 226.920.4824 Email: jblack7708@gmail.com Portfolio: http://jeremydblack.blogspot.com
CERTIFICATIONS
Ø Microsoft Certified Technology Specialist (MCTS), Vista Configuration
Ø Microsoft Certified IT Professional (MCITP), Enterprise Support Technician
Ø Microsoft Certified IT Professional (MCITP/MSCE), Active Directory Configuration, Network Infrastructure Configuration, Server 2008 Administrator
Ø Microsoft Certified Technology Specialist (MCTS), SQL Server 2008, System Administration
Ø Microsoft Certified Technology Specialist (MCTS), Exchange Server 2007, Configuration
Ø CompTIA A+ Certified
Scheduled Certifications: CompTIA Linux+, CompTIA Network+, BlackBerry Phone & BlackBerry Enterprise Server
TECHNICAL PROFICIENCIES
PLATFORMS: Windows XP, Vista, Windows 7, SBS
2003, Server 2003, Server 2008, Linux, Mac OS X
TOOLS: MS SQL 2000/2005/2008, VM Ware, SSIS/SSRS,
MS Access/Excel, MySQL
PROJECTS
Department of Medicine, Division of Gastroenterology, McMaster University Medical Centre
Database/Application design for Clinical Study (Access 2007)
QUALIFICATION HIGHLIGHTS
Ø In depth understanding of technology with focus on delivering businesses solutions
Ø MS Server 2008 and SQL Server 2008 advanced training/certification: Modeling, Maintenance, Deployment, Administration
Ø Superior communication, presentation, analytical and problem solving skills
Ø Database administration for multi-terabyte databases including T-SQL coding, stored procedures, backup/recovery, high availability
Ø Expertise in full project life cycle database development for implementation and integration
EXPERIENCE
SQL Server Administrator (DBA)
The Marco Corporation,
Brantford, ON Sep 2010-July 2012
Ø Manage
multiple SQL Servers containing 100+ databases (SQL Server 2005/08, MySQL)
Ø Design/Implement
new databases/stored procedures/triggers/SSIS packages/SSRS/Reports/maintenance
plans/Agent Jobs/Backups/Migration (MSSQL 2005 to MSSQL 2008)
Ø Linked
Servers, Remote Servers, Log shipping, Mirroring, Data Mining, Traces, Disaster
Recovery
Ø Design
internal applications for reporting/manual and auto generating business metrics
(Front end)
Ø SQL Server
backend application support, internal applications, multifunctional web based
applications
Ø Automate
Import/Exports
Database Administrator (DBA)
VDC Canada/DSW Stores, Niagara Falls, ON Jan 2007-Jan 2009
Ø Database modeling, deployment and administration for corporate network
Ø Network Infrastructure design, deployment and administration for network supporting over 50 employees
Ø Perform day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database
Ø Created various Microsoft Access based front-end applications for large scale Production, Sales and Invoicing with SQL Server 2000 back-end
Ø Implemented backup and recovery procedures of databases in a MS SQL Server 2000 and MS Access 2003 environment
Warehouse Manager
VDC Canada, Niagara Falls, ON 2001-Jan 2008 (promoted to DBA Full-Time- listed above)
Ø Manage Warehouse time and space, employees, dock times and delegation of staff duties
Ø Maintain Databases for Inventory, Sales and Production
Ø Audit Inventory, Production/Product cost (Excel, Access, MS SQL Server)
Ø Introduced various production automated systems and structures that increased productivity by 70%
EDUCATION
triOS College
Hamilton, ON – Network Engineer Diploma
July 2009 – July 16th
Hamilton, ON – Network Engineer Diploma
July 2009 – July 16th
