DBA
Resume:
Mike Roddy
Weston, FL 33326
SYSTEMS PROFICIENCY
Windows Datacenter and Enterprise Edition Servers, 32 and 64-bit Wintel Architectures, SQL Server 2000, 2005, 2008 Enterprise Database Servers, Oracle v7, 8, 8i, 9i and 10g databases, Windows NT, 2000, XP and Windows 7 desktop systems, Microsoft Office XP, 2003 and 2007 desktop suites, VB Scripting for office applications, programming in Windows architecture, creating user interfaces using ODBC and OLE DB, DSN’s for user interface management, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Active Directory Domain Services, AD Users and Computers, AD Sites and Services, Symantec Endpoint Protection, Firewall, Antivirus, Antispyware, Intrusion Prevention, Browser Protection, Ghost Solution Suite and Symantec System Recovery Services. Adobe Flash, Acrobat Professional 8, CITRIX MetaFrame Presentation Server 4.5, Terminal Emulation, ETerm-32 and Reflection client emulation software, BMC Remedy Action Request System, Ad-hoc report processing, Microsoft Project, Visio Enterprise Architect, VMWARE and WEB, cloud-based Software as a Service (SaaS) computing solutions.
SQL SERVER DATABASE EXPERTISE
Develop SQL queries to analyze tables and indexed views for the presence of inconsistent data-types
Analyze index usage patterns for fragmentation and reorganize or rebuild indexes when necessary
Perform profile traces to identify and fix performance related queries in SQL Server
Develop SQL queries to view dynamic CPU, I/O, OS and logical memory for performance tuning
Recommend application of Stored Procedures to enhance performance of SQL queries
Analyze and apply patches, analyze and document SQL Server version levels
Search and rename or replace objects in tables, stored procedures, functions and triggers
Move or relocate databases, data files and associated user logins across SQL servers
Configure, compare and edit server configurations using Central Management Server
Diagnose network connection issues and identify application disconnects reaching SQL Servers
Analyze space requirements and request additional hardware resources when necessary
Troubleshoot production job failures by analyzing stored procedures, functions and triggers
Monitor alerts, event notifications, backup logs, transaction logs and workload statistics
Monitor custom SQL Code and make recommendations to Development for configuration changes
Monitor/configure high availability databases for Log Shipping, Mirroring and Replication technologies
EDUCATION
M.S. Computer Information Systems, University of Phoenix
B.S. Business Management, Franklin Pierce College
A.S. Business Management, Franklin Pierce College
CERTIFICATIONS
M.C.I.T.P. Microsoft Certified Information Technology Professional, SQL Server 2008
M.C.T.S. Microsoft Certified Technical Specialist, SQL Server 2008
O.C.P. Oracle Certified Professional, Oracle Database Operations
M.C.P. Microsoft Certified Professional, Windows NT Operating Systems
C.N.E. Certified NetWare Engineer, Novell Networks
C.N.A. Certified NetWare Administrator, Novell Networks
EXPERIENCE
ULTIMATE SOFTWARE GROUP (2011-2012)
Tier II/III Technical Support Engineer
• Provide recommendations to Development for SQL Server query performance tuning.
• Resolve SQL issues for on-premise and dedicated servers in support of core applications.
• Troubleshoot CITRIX, VMWARE, DPM and SQL Servers in-house and at customer sites.
• Troubleshoot WEB servers and network connectivity in a large DPM processing environment.
• Recommend solutions to the SaaS team for upgrading server hardware and software as needed.
• Maintain security permissions and verify roles are configured correctly in SQL Server.
SOUTH FLORIDA WATER MANAGEMENT DISTRICT (1997-2011)
West Palm Beach, FL
Database Administrator / Systems Administrator
• Provide maintenance and support for Windows enterprise servers and desktop systems.
• Provide performance monitoring and tuning for T-SQL queries across multiple server platforms.
• Resolve SQL Server performance issues using PERMON and Activity Monitor in SSMS.
• Provide recommendations for installation and support of remote computer systems.
• Design client/server configurations for deployment throughout the enterprise environment.
• Provide daily administration of SQL Server including assigning user roles and permissions.
• Initiate test environment to evaluate compatibility with new versions of SQL Server.
• Resolve real-time application support on a 24x7 on-call rotation for high availability databases.
• Create stored procedures for maximizing the performance of T-SQL queries.
• Provide project management on short and long term planning for systems maintenance.
• Develop a disaster recovery plan and initiate testing of backup/recovery procedures.
• Configure and troubleshoot Microsoft ActiveSync, Blackberry and email technologies.
• Provide technical leadership by conducting seminars for newly deployed applications.
• Design and develop ODBC and OLE DB interfaces for deployment with new images.
• Develop SQL Server replication environment in support of data center operations.
• Resolve TNS client/server connectivity issues in the Oracle Enterprise environment.
• Work closely with UNIX Administrators to resolve server related performance issues.
• Provide systems level support for the Enterprise-wide computing infrastructure.
• Install Windows terminal servers and configure for CITRIX farm technology.
• Maintain the infrastructure using Windows Clustering with NAS-based network storage.
• Design, deploy enterprise systems and install patches and security updates as required.
• Install, configure and maintain Windows Exchange, IIS and SQL Servers.
• Install Active Directory on the domain and configure for the enterprise environment.
• Provide ongoing technical support of Active Directory users, computers and sites.
• Resolve TCP/IP connectivity issues involving DNS and DHCP servers on the domain.
• Work closely with Security team members to identify and resolve firewall related issues.
• Monitor reliability of servers and produce stability reports on systems usage.
CHASE MANHATTAN BANK (7/95-4/97)
Palm Beach, FL
Network Administrator / Systems Administrator
• Provide client/server application support during banking transaction processing and batch operations.
• Configure user profiles, adding and deleting logins and managing permissions for security access.
• Upgrade all hardware and software resources and creating images for desktop PC replacements.
• Integration of file servers, providing system level support for bank branches throughout Florida.
• Upgrade network end-points, configuration and installation of Cisco routers/switches
• Maintain vendor contracts and provide overall security for the banking network.
• Provide daily Technical Support for all Data Center hardware, software and network equipment.
Contact this candidate