Christopher J. Jackson

Sr. MS SQL Server DBA

Lake Hopatcong, New Jersey 07849 201-***-**** adcz17@r.postjobfree.com

TECHNICAL SUMMARY

Databases:

MS SQL Server, Oracle, Sybase, Interbase, Paradox

Software:

MSSQL 6.5, 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017 SQL Server Management Studio, SSIS, SSRS, SSAS, TSQL, Enterprise Server, ISQL, Query Analyzer, Report Services, Idera products, Brent Ozar’s Blitz’s, ETL, BCP, Oracle 7.3, 8, 9i, Oracle Enterprise Manager, .NET (ASP,C# and VB), PolyServe, Idera, Diagnostic Manager, SolarWinds, SolarWinds Database Performance Analyzer, Compliance Manager, Red Gate, Lite Speed, Sybase, Interbase, Delphi 3, 4 & 5, ColdFusion, Dreamweaver, Fireworks, Adobe Photoshop 7.0, DB Artisan, Toad, PVCS, Visual Source Safe, Visio, Erwin, Cobol II, C, C++, Visual Basic 6.0, Crystal Report writer, Xpediter, Assembler 370, CICS, DB2, Micro Focus Cobol, Micro Focus Workbench, OSVS MVS/JCL, TSO/ISPF, TPF, Panvalet

Concepts:

Full Cycle Database Development to Production Administration, Optimization, Data Modeling, Normalization, Replication and Network Clustering, Data Warehousing, Program Design, Structured Programming, Problem Analysis, Advanced Troubleshooting, Table Handling, Documentation, Program Maintenance, Testing, File Manipulation

PROFESSIONAL EXPERIENCE

NyeC New York eHealth Collaborative – New York, New York 05/2017 – Present

Senior Microsoft Database Administrator

Assess and tune SQL, indexes, queries and stored procedures to ensure peak performance.

Monitor database environment 24/7/365 for space, processing, performance and in meeting very strict SLA’s.

Implemented a minimum access standard to the production database server and set a policy to enforce security within the SQL server environment.

Identified problematic processes and took action whenever possible, altered code or added resources to ensure performance at a very high standard.

Created a process to automate smart index maintenance and statics updates on off peak hours.

Proactively identified SQL system hot spots and resolved them to avoid any potential future failures.

Identified any long running processes or queries and investigated the cause.

Addressed and resolved any failed processes or SQL jobs.

Benchmarked and baselined server resource performance at idle, normal and full throttle to better understand when the server goes sidewise and to help prepare for future server builds.

Was a source of information, documentation and proof towards HiTrust certification for the company.

Installed and or upgraded SQL servers to the latest version as well as monthly patching of all SQL servers in the company.

Constant monitoring of the Always-on cluster thru SQL monitoring tools and automated reports.

Continue to educate myself on new SQL versions and new applications to monitor and administrate the SQL environment.

Ran space capacity planning process to be prepared for future hardware purchase and upgrades.

Automated many processes freeing up time to take on new projects.

AYA Computer Services Inc. – Mount Arlington, New Jersey 11/2014 – 05/2017

Senior Microsoft Database Administrator

Assisted corporations and their technical DBA staff to resolve issues within their system utilizing my years of experience of the inner works of MSSQL.

Advising of physical and system changes to be made to the existing structure to optimize performance in SQL queries application associated with MSSQL

Mentoring those with less experience as to best practices and real world solutions. Giving them either work around scripts or a ways and means to resolve the issues on their own.

Setting up systems or resolving issues with systems that were set up beyond best practices to work with storage and the end user or application

Maintained and monitored Log Shipping on MSSQL 2012 servers.

Created performance report and overall health to be used in management meetings.

Created a project plan and coordinated the effort for compliance with security regulations to reset system passwords at a regular basis.

Created SSIS packages to insert financial sales data into the database from nightly feeds. Data to be used for client reports in SSRS and insertion into SSAS, Crystal reports and to feeds into the internal and web applications

Data mapping from flat files into existing and new tables using ETL SSIS

Extracting data from multiple sources to create source for reports and view for analytical information

Created SSRS templates to standardize corporate reporting

Pinnacle Consulting for the Lighthouse Guild 7/2014 – 10/2014

Sr. Microsoft Database Administrator

Maintained backups for all databases on over 40 SQL servers

Databases Restoration and replacement of production to Dev or QA servers.

Tuning indexes, creating new or removing old, outdate or unused indexes that have become obsolete.

Checking for fragmentation and resolving those issues.

Finding the cause of extended blocking deadlocking or bottlenecks.

Maintained and monitored all instances of mirroring, troubleshooting any issues.

Advising developers and management of best practices to improve work quality and avoid long running queries in the future.

Resolving space issues and poorly written queries and application code

Ran reports from Powershell scripts to extract information from the system and internal to MSSQL

Plus Diagnostic 8/2012 – 2/2014

Sr. Microsoft Database Administrator

Maintained and administered the companies’ databases using SQL 2008, SQL 2008 R2 and SQL 2012.

Maintained 16 mirrored databases synchronizing to a secondary site including a witness for automatic failovers.

Maintained multiple snapshot and transaction replication to multiple servers constantly monitoring them for any issues.

Created multiple alerts to notify me and the IT staff of any problems with Mirroring and replication as well as any issues with Dead locking.

Created standards and held training sessions in query optimization.

Trouble shot other issues with slow running processes and queries

Created alternatives to link servers for local synchronized tables to enhance report times

WorldWide Supply 1/2012 – 4/2012

Microsoft Database Administrator

Contract positions at Worldwide Supply .

Developed triggers and alerts for SAP using B1 up and other third party tools.

Maintained MSSQL 2008 R2 databases.

Created standards and held training sessions in query optimization.

Trouble shot other issues with slow running processes and queries

Univision Communication - Teaneck, New Jersey 9/2007 - 1/2012

Sr. Microsoft Database Administrator

Support and maintain over 750 MSSQL 2000 databases, over 50 MSSQL 2005 and 50 2008 R2 Databases hosted on over 80 servers.

Established and maintained Log Shipping for warm standby on 2000, 2005 and 2008 instances for failover.

Built and altered existing servers to configure for optimum performance and best practice processes. Moving databases and objects to take advantage of the SAN and new features in SQL 2005 and SQL 2008

Installed 32 and 64 bit versions of MSSQL 2005 and 2008 and 2008 R2 on stand-alone and Clustered servers on Windows 2003 and 2008

Created a suite of tables within a database to track and archive the system data associated with all SQL Servers in the organization. This was further used to analyze and forecast the future growth of disk drives associated with each server.

Tested disaster recovery scenarios with the clusters and log shipping running on the clustered servers.

Set up merge replication and database mirroring for other instances, monitoring them on a daily basis.

Installed Rapid Mart and populated the database from production Oracle data using Data integrator to develop the data flows and objects used in the process to update the database from production Oracle. This is primarily to be used for reports for the business.

Instructed the developers when needed optimizing the SQL statements used in the reports and application developed in-house.

Created SSIS packages to extract information to be used in attached emails

Created SSIS packages to insert external data into the databases

Created altered Powershell scripts to extract system information on all the MSSQL servers.

Elangeni Consulting - Mt Lakes, New Jersey 4/2005 – 7/2007

Microsoft Database Administrator

Contract position at Reliant Pharmaceuticals (6/05-6/06) and Novartis Pharmaceuticals (6/06-7/07)

Engineered and created an entire database to support an application to track and identify leased machines within an organization.

This project was built with an ASP front end and .NET c# and powered by stored procedures within the database. It was also engineered using EWRIN to be 3 separate modules to be sold as whole or individual parts.

Evaluate full system process across all functions, ensuring complete system integrity

Analyze business needs to determine and write requirements if needed

Allow for future growth of and capacity planning of the database and connecting systems Consolidation of 10 MSSQL servers into 1, with a cost saving of over $450K in licensing alone.

Implemented an alternative to Microsoft’s clustering, with a cost savings of over $80K.

Establish best practice guidelines for the development team Eliminated well over 40 databases in production to free up over a half terabyte of space.

Set up notifications to automatically identify system errors and send detailed email direct to my mobile phone.

Implement structural changes to the existing architecture

Document all new and existing systems with standardized software documentation protocol

Establish formal code review process and implementation

Convert database versions from 2000 to 2005.

Imported and created Data mart and Data Warehouse databases from existing databases.

Designed and created reports thru reporting services.

Responsible for all database changes and change documentation.

Built web forms with .Net to administrate the information held in the database.

Established a secure link with the customer to transfer sensitive data to and from the database.

Implemented indexed views on a highly used database to increase throughput.

Installed and maintained the PolyServe matrix server cluster solution for 3 instances.

Re-wrote DTS packages to reduce the execution time from over 4 hours to less then 15 minutes. This opened up a window of system usability for the users.

Helped implement a share point site for a central repository of information and documents.

Troubleshot an existing instance of Oracle 9i that the backup software was not able to connect to the database.

AYA Computer Services Inc. - Landing, New Jersey 8/2002 – 4/2005

Microsoft Database Administrator

Contract for Simon and Schuster and Thor Labs

Built and maintained multiple instances of MSSQL on a cluster 2003 server.

Converted and consolidate multiple databases to the cluster server from DB2, Sybase, Oracle, and other versions of MSSQL.

Built and maintain DTS packages using T-SQL to automate data processes.

Implemented pull merge and dynamic merge replication.

Physical and logical database design including indexes, triggers, stored procedures, and SQL tuning.

Responsible for maintenance jobs and database backups.

Setup multiple BCP jobs to process files coming from the mainframe.

Wrote stored procedures to eliminate some batch processing that failed sporadically.

Built a process to synchronize the sales force Sybase database to the new MSSQL 2000 while the migration is in process.

Converted Stored Procedures and Functions from a Sybase version 6 to work in MSSQL 2000.

Convert existing VB code to .Net.

Contract for Thor Labs

Build Ecommerce Web Pages using Cold Fusion for a new line of Laser devices to help increase baseline sales.

Develop Charts and dynamic WebPages using Dreamweaver, Fireworks, and Adobe for graphic depiction of company’s products.

Microsoft Database Administer using versions 6.5, 7 and 2000.

General Contract

Engineer and maintain database systems for small businesses.

Build configure and install computers for individual homeowners and small businesses.

Set up and maintain network systems for homeowners.

Essex Corporation - New York, NY a John Hancock company 10/2000 – 8/2002

Microsoft Database Administrator

Administrate MSSQL (6.5, 7.0, and 2000) on NT and 2000 Servers.

Daily maintenance of all 210 databases running on 20 servers.

Continuous tuning databases for top performance.

Migration and data conversion between all versions and files.

Adjust the data and procedure cache to allow the proper balance.

Nightly backup to hard drive and to tape to aid in recovery.

Create additions to existing database and add new databases to the system.

Write triggers, indexes, views and stored procedures for faster response to the user interface.

Nightly trade feed monitoring into the production databases.

Data manipulation using Transact-SQL and Enterprise Manager to correct user erroneous input.

Built views for creating reports and adhoc reporting.

Help create a data model to interact with a new product being created from specifications using Erwin and Visio.

Install, maintain and version control of MS SQL systems.

Responsible for the design, build, and architecture of the SQL servers.

Plan and design disaster recovery plan then test into a simulated system periodically.

Delphi Application Developer

Write the applications within 2 weeks that converted user’s trade data from one clearinghouse to another clearinghouse keeping a 3 Billion company from closing its doors.

Develop software to support nightly trade input into the existing system.

Develop new programs for replacement of aging systems, improving its functionality.

Create tools to help administrate and schedule processes.

ABI TruTrac - Inc, Parsippany, NJ 1998 –10/2000

Database Administrator and Developer Analyst

Administrated Oracle (7, 8), Sybase, MSSQL (6.5, 7.0), and Interbase databases.

Created Oracle instances, allocated space, defined/created databases devices, run/altered SQL scripts to created the tables in the database, tune Oracle instances for maximum performance, ran SQL scripts to update the database to higher version, database backups, database exports, database restores, database imports, remote administration through a dial up connection, download existing client databases from their servers for our test environment.

Used Erwin and Visio to develop Databases and Database structures.

Assisted client with any and all problems.

Installed TruTrack, CS500com, Tasker, and any new task that may need to be placed on a customer servers or workstations.

Remote install/instruction over the telephone with the customer doing the installation.

Loaded, install windows 9x’s NT, or any software package that needs to be placed on any PC in the office.

Administrated new and existing users in the network.

Borg-Warner Protective Services - Parsippany, NJ 1996-1998

Programmer Analyst I

Maintained and Developed programs for the Nation Screening center in Clipper

Rewrote customer interface of the National Screening Center in Delphi

Updated tested programs via modem/server connects

Maintained and developed projects using Visio.

Developed and design programs in Cobol and Natural batch and on-line

Wrote JCL to run new and existing projects

Maintained existing programs in the payroll and other systems for updates or changes

Met with customers for updates and approvals of completed projects

Documented and place into production completed projects

Beneficial Financial Services - Peapack, NJ 1996

Programmer

Tested and maintained TPF system in Assembler

Compiled, test and debug programs for proper output

Maintained existing programs for updates or changes

Met with customers for updates and approvals of completed projects

Selective Insurance of New Jersey, Branchville, NJ 1995-1996

Programmer

Developed and designed programs in Cobol II and Easytrieve

Wrote JCL to run new and existing projects

Compiled, test and debug programs for proper output

Maintained existing programs for updates or changes

Modified existing programs to improve time efficiency

Met with customers for updates and approvals of completed projects

Tested in CICS environment

EDUCATION

Presently working towards my MCSA and MCSE Certificate

Oracle University, Parsippany, NJ

Courses towards Oracle Professional Certification

The Chubb Institute, Parsippany, NJ

Diploma in Computer Programming

County College of Morris, Randolph, NJ

Courses in Drafting and Introduction to CADD

Trained in Agile and scrum

Contact this candidate