Sql Server Information Technology
Resume:
DUNCAN LLOYD RHODEN
Pembroke Pines, Florida 33025
*********@*****.***
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