Bobby Franklin

acek1e@r.postjobfree.com

Summary

Comprehensive SQL DBA experience combined with a thorough background in systems administration. Managed VLDB 3TB+ with 1 billion row count tables, high volume transactions databases peaking over 1000 trans/sec. Automate critical database health monitoring DMV’s to maintain optimum performance. Business intelligence experience using SSAS with data warehousing to provide key metrics business decisions and systems forecasting.

Personal

• Marked ability to set clear goals and stay focused on the task at hand until completed, keeping the task in perspective with the overall project plan or IT strategy.

• Adept at automating repetitive tasks and applying best practices to increase efficiencies of existing systems.

• Strong commitment to getting the job done right the first time with dedication to providing solutions.

• Ability to effectively transfer knowledge to clients or team members and to create clear, concise documentation.

• Excellent interpersonal, written and verbal communication skills with proven experience interfacing between business and technical teams.

Professional

• Extensive MS SQL 2000/2005/2008/2012 experience with installs, maintenance, performance tuning and troubleshooting.

• SQL 2012 production server upgrades and maintenance.

• MS SRSS experience creating decision making reports, system baselines for trend analysis, customer delivered statements and many other ad hoc reports on demand.

• Strong Data modeling and T-SQL skills.

• Experience as both Production and Development DBA.

• Extensive experience developing, deploying and troubleshooting DTS and SSIS packages.

• Some VB.net and C++ programming experience with currency trading systems formulation.

• Experience with VMware, EMC SAN infrastructure.

Certifications

MCT (DBA SQL 2005/2008) MCSE

CCNA

Education History

Broward Community College Completed some coursework A.A. Engineering

Employment History

SQL DBA/Data Architect

10/2013 – Present

Allegiant Air

o Design MySQL database for migration from IBM DB2.

o Design and maintain ETL packages to move data between MySQL, IBM DB2 and MS SQL 2012

o Provide obfuscated data to development environments

o Install and maintain SQL Clusters.

o Implemented replication to support SSRS reporting services.

MS SQL DBA

10/2012 – 10/2013

Marshall Watson

o Database architect SQL 2008 R2.

o Administer production version releases via MS TFS.

o Migrated system from SQL 2005 to SQL 2008R2.

o Implemented clustering with mirroring disaster recovery plan (SQL 2008 R2).

o Implemented replication to support SSRS reporting services.

o Designed, implemented and maintained SSIS packages to interface with client and vendor systems.

o Designed and implemented data warehouse for business trend analysis.

o Work closely with systems administrator to optimize performance and troubleshoot SAN system.

o Assist in data warehouse design and deployment using Analysis Services (SQL 2008 R2).

MS SQL DBA

2/2012 – 10/2012

Acquinity Interactive

o Manage 20+ SQL servers housing 100+ databases. Mixed environment predominantly SQL2012 with some SQL2008 still in production.

o Manage Teradata in production for performance and availability.

o Maintain and design ETL processes to move TB of data to data warehouse for reporting.

o Manage data partitioning for performance and maintenance optimization.

o Manage (3) three active/passive MS clusters. Mixture of 4 and 3 node clusters.

MS SQL DBA

3/2009 - 2/2012

Marshall C. Watson

o Migrated system from SQL 2005 to SQL 2008R2.

o Implemented clustering with mirroring disaster recovery plan (SQL 2008 R2).

o Implemented replication to support SSRS reporting services.

o Designed, implemented and maintained SSIS packages to interface with client and vendor systems.

o Designed and implemented data warehouse for business trend analysis.

o Work closely with systems administrator to optimize performance and troubleshoot SAN system.

o Assist in data warehouse design and deployment using Analysis Services (SQL 2008 R2).

MS SQL DBA

2/2008 – 2/2009 I-ntegrators LLC.

o Responsible for supporting MSCS two (2) node active-passive server cluster.

o Performance tuning using Server Profiler and Database Tuning Advisor (DTA).

o VLDB maintenance including horizontal partitioning and administrative duties on SQL 2008 server - backups and restores, disaster recovery planning, DDL triggers table indexes and constraints.

o Created a telecom billing system based on gateway CDR. Designed and implemented a solution that fully automated the company’s CDR management.

o Implemented ETL procedure with the use of SSIS packages created with MS Business Intelligence.

o Created stored procedures and jobs to deliver various statistics hourly and daily.

o Designed customer invoice and reports using SSRS 2008 also automated the invoice and receipt delivery to customers via email.

o Design, implemented and maintained client subscriptions using SQL Service Broker.

o Emc CLariion SAN administration, maintenance and performance monitoring using NaviSphere.

MS SQL DBA/Systems Administrator

9/2006 – 12/2007 DHM Vacations LLC.

• SQL DBA.

o Provided product support for the company’s production MS SQL 2005 system - TimeShareWare (TSW).

o Installed and configured Windows 2003 Server and SQL 2005 Server database mirroring.

o Created and implemented backup, restore and disaster recovery plan.

o DBCC commands to perform maintenance tasks – index defragmentation, re-indexing, usage statistics.

o Resolved deadlocking issues using Server Profiler to trace blocking and exclusive locking in inefficient code.

o Integrated SQL security policies with Active Directory structure.

o Developed custom Crystal reports per request by managers utilizing both MS SQL T-SQL and Crystal’s Query Language.

o Server security and maintenance – applying Service packs and hot-fixes.

o Saved the company thousands of dollars on support from TSW.

• MS Exchange 2003.

o Implemented account policies and quotas based on MS Active Directory groups.

o Created, deleted and maintain user mailboxes, including deleted item recovery.

o Implemented and maintained backup and recovery plan.

• Citrix Access Essentials.

o Published third party TimeShareWare (TSW) and Crystal Reports for remote access by headquarters.

o Provided access to network shares allowing viewing/editing of manually created reports in MS Excel.

o Provided remote printer from client side to network printers.

• User support.

o Analyzed reporting needs with managers and created or modified Crystal Reports.

o Performed bug fixes to TSW as they were discovered and reported by employees.

Provided assistance with desktop applications such as MS Excel, Word, Outlook, TSW.

MS SQL DBA/Systems Administrator

3/2001 - 8/2006 Coral Beach Travel & Tours Inc.

• Performed production DBA tasks – backup restore and disaster recovery planning and testing.

• Automated maintenance procedures using scripts.

• Optimized performance using Index Tuning Wizard.

• Used DTS and BCP to insert and update data from vendor flat files (Excel).

• Applied Service packs and security fixes for Windows Server and SQL 2000.

• Implemented MS Windows 2000 Network infrastructure.

• Administration (Backup & Recovery, performance tuning and optimization) of MS Windows 2000 Server, MS Exchange Server 2000 and MS SQL 2000.

• Defined global security policies for domain.

• Administration of Avaya PBX.

• Implemented and maintained SonicWall SOHO PPTP VPN to two (2) remote sites, 20 user remote clients.

• Linux Fedora Core 4, XINETD port redirection and SQUID for MS Exchange OWA proxy.

• End user support for MS Office Suite of applications.

Jr. Network Administrator

7/2000 - 2/2001 Victoria Mutual Bldg Society.

• Migrated IT department inventory system from FileMaker to MS SQL 2000.

• IBM LAN Image server configuration for new hardware roll out and remote desktop re-imaging.

• Windows 2000 desktop support.

• Network printing troubleshooting and printer hardware issue resolution.

• Microsoft Office user support – Excel, Word, Power Point.

Projects

System Migration

8/2008 – 9/2008 JW Insurance

• Led the site preparation project for relocating the company’s network into a newly constructed building.

• Structured cabling layout design.

• Designed and implemented the communications room.

• Configured MS VPN for remote network access on Windows 2003 Server.

• Configured router firewall to enable VPN pass through.

• Added new workstations and users to the existing network upon migration completion.

• Upgraded Backup Exec installation and external hard drive storage.

Build Business Domain

12/2008 –2/2009 ProTravelAmerica

• Designed and presented network architecture for new business.

• Created Active Directory domain - Windows 2003 Servers.

• Installed and configured MS Exchange 2003.

• Installed and configured Fedora Core7. Linux box processing inbound mail for the Windows domain and inspects and rejects spam and viruses through SpamAssassin and MailWatch.

• Configured Sonicwall firewall for VoIP and VPN traffic.

• Configured BizHub Fiery enabled networked multi-function copier, scanner and fax machine with MS Exchange 2003.

• Registered company domain and created DNS zone file.

• Installed and configured FileMaker server and hosted databases.

References

Available upon request

Contact this candidate