DUNCAN LLOYD RHODEN

***** ** ** ******

Pembroke Pines, Florida 33025

acf149@r.postjobfree.com

Cell: 954-***-****

Home: 954-***-****

Microsoft Database Developer/ Administrator

OBJECTIVE

To work in a competitive and challenging environment where I can contribute towards the growth and

development of a progressive organization and to fully utilize my innovative skills to pursue a rewarding

career.

EDUCATION:

Masters in Business Administration, MBA from American Intercontinental University, Weston, Florida,

USA (2006)

Bachelor of Science in Information Technology from American Intercontinental University, Weston,

Florida, USA (2004)

Diploma, Health Information Technology, Broward College, Davie, Florida, (2011)

Certifications:

MCSA (Microsoft Certified System Administrator 2008)

MCDBA (Microsoft Certified Database Administrator 2008)

MCP (Microsoft Certified Professional)

TECHNICALSKILLS

SQL Server 2005/2008/2012

Databases:

O/S: Windows Server 2000/2003/2008/2012

Programming Languages: SQL, PL/SQL, VB.Net, C#, VBScript

Web Technologies: Asp.Net, HTML, XML, IIS 6.0, Java Script

MS Visual Studio .Net 2003, SQL Server, MS Office2007

Tools:

BI Tools: MSBI (SSIS, SSAS and SSRS), Introduction to Business Objects

PROFESSIONAL SUMMARIES

• Experience in Installation, Configuration and Updates of SQL Server.

• Involved in Huge data migrations, transfers using utilities like Data Transformation Services

(DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

• Experience in BI Development and Deployment of DTS, SSIS packages from MS Access,

Excel, and Oracle.

• Designing and Deployment of Reports for the End User requests using Web Interface &

SSRS.

• Experience in controlling the User Privileges, Monitoring the Security and Audit issues as per

Standards.

• Experience in Performance tuning, Optimization, Data integrity and Statistics by using SQL

Profiler, Performance Monitor

• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query

Tuning, Error and Event Handling.

• Experience in SQL Server Storage Structures and Security Architecture for databases

residing on SAN storage

• Experience in Installation, Configuration and Deployment of SSRS using Scale Out, Scale Up

and Local topologies.

• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging

for SSIS Packages.

• Experience in Performance Tuning in SSIS packages.

• Experience in generating reports using SQL Server Reporting Services, Crystal Reports, and

MS Excel spreadsheets.

• Experience in writing Stored Procedures, Indexed Views, User Defined Functions, Triggers,

and Distributed Transactions.

PROFESSIONAL EXPERIENCES:

HealthSun INC March 2014 September 2014

Data Base Developer/Administrator

• Responsible for all Corporate Business Office Database Interfaces, Maintenance, and Reporting

functions of the Claims Management System (CMS)

• Create track and trend reports to identify process improvements in an effort to optimize recovery

efforts.

• Create and run automated processes in an effort to maximize productivity

Organize data to be meaningful to the decision at hand.

• Installation, Configuration and Updates of SQL Server.

• Experience in BI Development and Deployment of DTS, SSIS packages from MS Access

• Designing and Deployment of Reports for the End User requests using Web Interface & SSRS.

• Planned, Configured, Installed, Maintained SQL Server in environment of Multi node Cluster with

Multi instances.

• Configured and Monitored Database Mirroring for Application Development

New Market Inc. July 2013 April 2014

Data Base Developer

• Installation, Configuration and Updates of SQL Server.

• Involved in Huge data migrations, transfers using utilities like Data Transformation Services

(DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

• Experience in BI Development and Deployment of DTS, SSIS packages from MS Access, Excel,

and Oracle.

• Designing and Deployment of Reports for the End User requests using Web Interface & SSRS.

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts,

Client team, Development team, Capacity planning and Up gradation of System Configuration.

• Planned, Configured, Installed, Maintained SQL Server in environment of Multi node Cluster with

Multi instances.

• Configured and Monitored Database Mirroring for Application Development

Cendyn Inc, Boca Raton FL. February 2013 June 2013

Data Base Developer

• Installation, Configuration and Updates of SQL Server.

• Involved in Huge data migrations, transfers using utilities like Data Transformation Services

(DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

• Designing and Deployment of Reports for the End User requests using Web Interface & SSRS.

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts,

Client team, Development team, Capacity planning and Up gradation of System Configuration.

Configured and Monitored Database Mirroring for Application Development

Comcast, Sunrise April 2012 September

Data Base Administrator

• Installation, Configuration and Updates of SQL Server.

• Involved in Huge data migrations, transfers using utilities like Data Transformation Services

(DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

• Experience in BI Development and Deployment of DTS, SSIS packages from MS Access, Excel,

and Oracle.

• Designing and Deployment of Reports for the End User requests using Web Interface & SSRS.

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts,

Client team, Development team, Capacity planning and Up gradation of System Configuration.

• Planned, Configured, Installed, Maintained SQL Server in environment of Multi node Cluster with

Multi instances.

• Configured and Monitored Database Mirroring for Application Development

Ryder System, Miami February 2012 – April 2012

BI Developer/ DBA

• Installation, configuration and upgrading of MSSQL server software and related products

• Evaluate MSSQL features and Microsoft related products

• Implement data availability solution,Replication, Log Shipping, MSSQL cluster High

Availability, SQL 2008 Mirroring, Database Snapshot

• Establish and maintain sound backup and recovery policies and procedures

• Implement and maintain database security (create and maintain users and roles, assign

privileges)

• Perform database tuning and performance monitoring

• Perform application tuning and performance monitoring

• Setup and maintain documentation and standards

• Plan growth and changes (capacity planning)

• Work as part of a team and provide 7x24 support when required

• perform general technical trouble shooting and give consultation to development teams

• Interface with Microsoft Corporation for technical support.

• Maintaining Databases and Indexes

• Implement backup and restore solution for SQL 2005/2008

• Implement data availability solution,Replication Log Shipping

• Install and Setup Reporting services, SQL Mail

• Create Packages Using SSIS

• Use SQL Profiler to monitor SQL 2008

• Perform database upgrades and apply security patches.

• Monitor and proactively address potential problems to promote stability, security and optimal

performance of databases.

Vista Technologies, Miami September 2011 – December 2011

Data Base Administrator

• Experience in Installation, Configuration and Updates of SQL Server.

• Involved in Huge data migrations, transfers using utilities like Data Transformation Services

(DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

• Experience in BI Development and Deployment of DTS, SSIS packages from MS Access, Excel,

and Oracle.

• Designing and Deployment of Reports for the End User requests using Web Interface & SSRS.

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts,

Client team, Development team, Capacity planning and Up gradation of System Configuration.

• Planned, Configured, Installed, Maintained SQL Server in environment of Multi node Cluster with

Multi instances.

• Configured and Monitored Database Mirroring for Application Development environment

• Created Data driven Packages in SSIS as part of the automating the process for the Referral

Process.

• The packages created included a variety of transformations, for example Slowly Changing

Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast,

and Data Conversion.

• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005/2008 Business Intelligence

Development Studio.

• Studied existing OLAP system(s) and created facts, dimensions and star schema representation

for the data mart and warehouse systems.

Florida Career College March 2005 August 2011

Information Technology / Business Management Instructor.

• Conducted Information Technology Training In SQL, MYSQL, PHP, .Net Networking, A+

• Conducted lectures, practical and laboratory work.

• Ensured that all mid term, final and practical examinations are administered, marked and entered

into the student database.

• Responded to all queries from students and team leader in a timely manner

• Liaise with other staff members when involved on Information Technology projects and decisions.

• Counseled students in all aspects of their training including practical experience and

examinations

• Undertook continuous professional development and participating in staff training activities.

Keiser University September 2010 February 2011

Information Technology Instructor.

• Conducted Information Technology Training In SQL, PHP, .Net, Networking, A+, Network+

• Conducted lectures, practical and laboratory work.

• Ensured that all mid term, final and practical examinations are administered, marked and entered

into the student database.

• Responded to all queries from students and team leader in a timely manner

• Liaise with other staff members when involved on Information Technology projects and decisions.

• Counseled students in all aspects of their training including practical experience and

examinations

First Business Inc., Miramar May 2007 – Aug 2010

DBA Administrator

• Responsible for installation, maintenance and Monitoring SQL 2005

• Maintaining Databases and Indexes

• Implement backup and restore solution for SQL 2005

• Implement data availability solution, Replication Log Shipping

• Install and Setup Reporting services, SQL Mail

• Create Packages Using SSIS

• Use SQL Profiler to monitor SQL 2005

• working closely with IT project managers, database programmers and web developers

• Maintains development, test, and production RDBMS environments

• Administrator SQL server users and provide access as needed

• Performs scheduled backups of the data

• Monitors and tunes the system to improve performance

• SQL tuning, Knowledge of clustering and fail over

• Manage large database, Stored Procedures, backing up and restoring databases

• Maintaining Productions databases

• Installing and upgrading database and application middle tier software, testing, tuning database

applications, and maintaining database space

• Performance Monitoring & Tuning

• Implementing windows clustering and SQL Clustering and managing large databases, High

Availability, Log Shipping, Replication

• Extensive Knowledge of Enterprise Manager in SQL Server.

• Backup and Recovery of SQL Server.

• Experience of Monitoring 24/7 Databases.

• Configuration, and administration of relational database management systems

• Import and Export file to and from Excel etc.

APPLICABLE EXPERIENCE

• Solid understanding of software systems and software design principles.

• Good Communication Skills and technical skills.

• Understanding of basic concepts of SQL and RDBMS structure.

• Real time experience with SQL Server Database Administration.

• Migration of Databases from SQL Server 2005 to 2008.

Contact this candidate