Justin Samuel

SQL DBA Applications Support Engineer at 4D Security Solutions, Inc.

aca8mm@r.postjobfree.com

Summary

Has several years of experience in the analysis, design, development, implementation, testing, and maintenance

of application systems. Solution-oriented working with teams and demonstrated excellence in building complex

scripts and queries; high aptitude for learning involved in a wide range of projects. Hands on expertise in

installation, configuration, performance tuning, optimization, backup and recovery in SQL Server

2000/05/08/08 r2.

Extensive knowledge in T-SQL (DDL and DML), stored procedures, views, indexes, cursors, triggers, user

defined functions/types); Proficient in creating complex packages utilizing SSIS; Skilled at adhoc reporting,

parameterized, custom reporting using SSRS/Crystal Reports for daily reports; User profiles, query optimization

& performance tuning; Relational Database Models and Data Integrity in observing Business Rules; Creation

SQL jobs, SQL Mail, Alerts and schedule SSIS Packages via SQL Server Agent.

Experienced in using SQL Profiler, Execution Plan and Performance Monitor, Database backup and disaster

recovery procedures. Well-rounded skills in programming and debugging allow me to participate throughout the

project life cycle. Adept at developing creative solutions and meeting challenges head on. Strong problem

solving skills and has the ability to work in a team environment. Detail oriented with effective communication

and organizational skills.

Experience

SQL DBA Applications Support Engineer at 4D Security Solutions, Inc.

February 2011 - Present (2 years 10 months)

•Developed, tested & implemented database backup and recovery strategy.

•Implemented MS SQL Cluster (Active/Passive & Active/Active), multi node cluster up to 4 node.

•Analyzed and optimized SQL Server production databases in collaboration with third-party venue.

Suggested tuning changes for code, queries, SQL objects which may not be performing up to the optimum

database performance standards.

•Developed numerous queries (simple to complex) involving self joins, correlated sub queries and XML

techniques for diverse business requirements. Acted as Subject Matter Expert on coding with T-SQL and

stored procedures.

•Generated executive-management type reports (including sub reports / drill down / drill through and

parameterized) using SSRS.

•Designed SSIS Packages to extract data from various data sources into SQL Server for further Data Analysis

and Reporting by using multiple transformations provided by SSIS; Scheduled and maintained nightly and

weekly loads of data by creating the corresponding job tasks.

Page1

•Member of system integration team which acted as on-site technical support and liaison between developers

and client.

•Coordinating with offshore team for on time delivery of the products and query resolution activities.

•Perform comprehensive system level environmental tests including identifying types of integration issues by

analyzing test failures and performing root cause analysis and isolate faults.

•Provided database development support to development team.

•Planned & executed of any upgrade such as service pack and hot fixes.

•Coordinated with all parties and troubleshot application issues and system performance issues.

•Perform the tasks of applying system upgrades and validate of system integration procedures.

•Extensive knowledge of software fundamentals, SDLC, and configuration systems.

3 recommendations available upon request

Systems Control Programmer / Analyst at Cablevision

June 2005 - February 2011 (5 years 9 months)

•Developed and deployed multiple internal web applications to automate and streamline business processes,

thereby reducing overhead within the Billing and Collections departments and resulting in multi million

dollars savings for the company.

•Develop reports using SSRS/Crystal Reporting and utilizing complex SQL queries and stored procedures.

Configured and maintain report manager and report server for SSRS.

•Designed SSIS Packages to extract data from various data sources including FTP data from remote location

and ETL legacy Data, transform it into SQL Server for further Data Analysis and Reporting by using multiple

transformations and provide proper error handling and alerting; Scheduled and maintained nightly and weekly

loads of data by creating the corresponding job tasks.

•Developed multiple MS Access/Excel applications (front-end) with SQL Server (back-end). Estimated 200%

increase in productivity, drastic decrease in handling time by 300% as a result. In addition, users are able to

run reports in real-time that were previously unattainable.

•Analyzed business, functional, and technical requirements to make sure project met expectations.

•Support the user community with any issues that arise throughout the project life cycle.

•Physical design and implementation SQL Server databases.

•Performed code reviews of junior programmer’s projects. As part of this review, ensured adherence to best

practices and departmental standards. Assisted with scripts, SSIS projects, troubleshoot complex stored

procedures and query optimization.

•Conducted unit and system level testing of applications using use cases and other testing means, identified

system deficiencies and took corrective action.

•Created and maintained application programs/modules/support documentation.

•Production support on legacy application including break-fixes.

•Application Enhancement to provide permanent solution for recurrent issues.

2 recommendations available upon request

Page2

Skills & Expertise

SQL

Visio

Microsoft SQL Server

Visual Basic

XML

Troubleshooting

Integration

Windows

C#

Web Design

VMware

SQL Clustering

Oracle SQL

.NET

Access Database

C4I

System Integration Testing

Web Development

Web Applications

IIS

Telecommunications

Object Oriented Design

SSRS

Data Modeling

Version Control

ETL

Windows Server

SSIS

IVR

Customer Service

Performance Tuning

Technical Support

T-SQL

Process Control

Programming

SQL Tuning

Servers

Scripting

Powershell

Mentoring

System Deployment

Cluster

System Architecture

Page3

Education

New York Institute of Technology-Old Westbury

B.S in CS, Computer Science, 1998 - 2003

Interests

digital photography

Page4

Justin Samuel

SQL DBA Applications Support Engineer at 4D Security Solutions, Inc.

aca8mm@r.postjobfree.com

5 people have recommended Justin

"Justin is one of the best SQL guys I've ever worked with. His attention to detail and knowledge of his field is

second to none. On every project we've worked together I've always been happy to have him on my team

because I know I have a guy that can be trusted to accomplish the tasks he's been given with the utmost

professionalism."

John McCrudden, Lead Windows Server Specialist, ATS Abu Dhabi, managed Justin indirectly at 4D

Security Solutions, Inc.

"I worked with Justin at 4D, He is an amazing SQL DBA with great knowledge providing support to very

large SQL installations. He adds a value also as Developer by writing Custom Scripts for Applications. He

will be a great asset on any team/company."

Nish Shah,CISSP, PMP, CDCP, Director of Infrastructure Architecture/Engineering, 4D Security

Solutions, Inc., managed Justin at 4D Security Solutions, Inc.

"Justin is a very talented professional. He has always outperformed any tasks and always gone the extra mile

to meet deadlines. He is great at blending in to teams quickly. He always went out of his way to work with

other teams and align synergy with cross-departmental relationships."

Vivek Patel, System Integration Technical Lead, 4-D Security Solutions, managed Justin at 4D Security

Solutions, Inc.

"Justin is an extremely competent individual with a can-do attitude. There is no issue too big for him to

tackle. Justin takes the time to look at a process as a whole and understand the big picture. He has creative

solutions and offers valuable suggestions. I truly enjoyed working with Justin."

Carolyn Galasso, Systems Control Analyst, Cablevision, worked directly with Justin at Cablevision

"Justin Samuel is an excellent Programmer/Analyst who was always reliable and has good project

management skills. He managed very aggressive timelines while maintaining a sense of camaraderie with

peers in and outside his group. He always met his deliverables either on time if not ahead of schedule and was

always willing to own an issue to completion. I would be happy to work with Justin again in the future and

without reservation, I recommend his work to any organization."

James Thannickal, Project Manager, UBS, was with another company when working with Justin at

Cablevision Systems Corp

Page5

Contact Justin on LinkedIn

Page6

Contact this candidate