Sql Server Data

M agnas Saint H i lai re

*** ** **** ** ******.*******@*****.*** Home: 954-778-

2401

Deerfield Beach, FL, 33441 Mobile: 954-***-****

DATABASE PROGRAMMER / ADMINISTRATOR

Highly motivated IT professional with proven experience in database programming/ Administration,

SSIS, SSRS, T-SQL design, and network support. Appreciates challenges, steep learning curves, and

high-pressure deadlines. Outstanding ability to analyze, develop, and implement technology solutions.

Reliable team player with effective troubleshooting and debugging experience.

Equally strong project leadership experience introduces out-of-the box thinking and problem-solving

analysis that improve processes, systems, and methodologies currently in place and exceed business goals

and customer expectations.

TECHNICAL COMPETENCIES

Databases

T-SQL, ANSI SQL, SQL, MS SQL, stored procedures, triggers, UDF`s, views, dynamic management

views, index design and tuning, table partitioning, 1st, 2nd,3rd normalization, de-normalizing, transforming

and cleansing data, crash recovery, MS cluster services/servers, replication (transactional and snapshot),

database mirroring (synchronous and asynchronous), log shipping, security, file system design, data load

balancing, forced parameterization, MS SQL Server 2000 / 2005 / 2008 /2008R2 /2012

Software/Utilities

SQL Server Management Studio ~ SQL Server BIDS ~ MS SQL Enterprise Manager ~ SQL Query

Analyzer ~ SQL Server Profiler ~ DTA ~ DTS ~ SSIS ~ SSRS ~ SSAS ~ MS Visual Studio ~ ODBC ~

FTP ~ SFTP ~ IIS ~ DQS ~ MDS ~ MS Office Suite ~ SQL SPOTlight ~ Idera

Computer Languages

T-SQL ~ HTML ~ ASP.Net ~ XML ~ VB.Net ~ C# ~ Sequel ~ Object Oriented Programming

Operating Systems

Windows 7/8 ~ Windows Vista ~ Windows Server 2003/2008/2012 ~ IBM AS400 ~ iSeries System

Administration

EDUCATION

Bachelor of Information Technology ~American InterContinental University ~ Weston ~ FL ~ 2007

A.S., Computer Networking & Security Management ~Keiser University ~ FT Lauderdale ~ FL ~2005

Certifications

MCSA - Microsoft Certified Solutions Associate ~ SQL Server 2012

MCITP - Microsoft Certified Information Technology Professional ~ SQL Server 2008 DBA

MCTS - Microsoft Certified Technology Specialist ~ SQL Server 2008 ~ Database Development

MCTS - Microsoft Certified Technology Specialist ~ SQL Server 2008 ~Implementation & Maintenance

Comptia - Network+

MAGNAS SAINT HILAIRE PAGE TWO

PROFESSIONAL EXPERIENCE

Alliance Entertainment, Inc., Plantation, FL 03/2014 to Present

SQL Server Developer/ BI Developer

• Designed, Developed and Deployed sales reports in MS SQL Server environment using SSRS-

2012.

• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and

Expressions.

• Designed packages to extract data from xml file and load into Data warehouse

• Created dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using

SSIS.

Worldata InfoCenter, Inc., Boca Raton, FL 05/2008 to 03/2014

SQL Server Developer/ Administrator/ Data Analyst

• Maintained MS SQL Server 2000/2008/2012, including security, configuration and install service

packs upgrades.

• Extensive ETL processes designed and developed for the migration of data from AS400, csv,

excel, text to SQL Server 2008. Development consisted heavy work in cleansing, transformations

of data from development environment to production environment including extensive error

handling.

• Built ETL processes utilizing T-SQL/SSIS /DTS, including FTP/SFTP data from remote location,

transform it, mart it to data warehouse and provide proper error handling and alerting.

• Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and

stored procedures.

• MS SQL Server database administration, including configure Scheduled Tasks for regular

Database Backup and Maintenance Activities, create and modify tables, stored procedures,

various clustered/non-clustered indexes, triggers, check constraints and functions.

• Logical and physical design and implementation SQL Server databases.

• Create triggers to keep track of changes to the fields of tables when changes are made.

• Wrote ad-hoc query batches and stored procedures to assist in analyzing, cleaning, checking and

processing data to ensure the maximum possible integrity and quality.

• Wrote ad-hoc queries to extract data as per Business Requirements.

• Performed regular reviews of the database to identify performance problems, inadequate

programming, and data duplication problems.

• Build applications that use C#/batch scripts to automatically upload and download data from

SFTP servers.

• Created ad-hoc queries from SQL Server databases for custom reporting needs

• Assisted and supervise operation crew with scripts, SSIS projects, troubleshoot complex stored

procedures and query optimization.

• Developed & maintained scripts, utility jobs or implement needed software for database

maintenance.

• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 2

Node

• Performed query tuning to reduce response time by 90% in some cases, using cache plans,

execution plans and index tuning.

• Monitored data activities (i.e. database status, logs, space utilization, extents, checkpoints, locks

and long transactions).

Verio Inc, Boca Raton, FL January 01/2008 to 05/2008

Tech Support Specialist

• Handled over 50 inbound technical support emails and calls in a busy environment while

maintaining polite and friendly manner.

• Debugged and trouble-shot Windows and Unix Servers and correct errors as required for clients.

• Handled security, performance, and tuning issues on Web servers to optimize performance.

• Provided effective and consistent technical support.

• Audited log files to identify problems and researched solutions.

Contact this candidate