Technical Skills:

• SQL Server Clustering
• Performance Troubleshooting
• Index and Stats Management
• DB Optimization
• DB Backups / Restores
• Data Partitioning
• SQL Server Upgrades
• DB Migrations
• SQL Job Management

DETAILED EMPLOYMENT HISTORY

Confidential

SQL Server Database Administrator

• Migrated several DB platforms to new, modern SQL Server and OS platforms. They included the company's primary domain registration platform that's responsible for a significant portion of the organization's annual revenue.
• Consolidated several SQL Server instances and saved tens of thousands of dollars in licensing/hardware costs
• Implemented and managed database clustering and failover technologies such as active/passive database clustering and replication to improve HA/DR
• Configured and troubleshot transactional replication to BI platforms
• Optimized performance through the monitoring of DMVVs, evaluating execution plans and modifying indexes
• Upgraded SQL Servers from SQL Server 2005 and 2008 to 2008 R2 and SQL Server 2012
• Configured various native SQL Server backup options as well as used Idera's SQL Safe product to achieve compression rates and the benefit of a single management console.
• Recovered databases point in time using transaction log backups
• Investigated execution plans to identify variables that are negative effecting performance.
• Standardized SQL Server build outs and configurations across all instances according to industry wide best practices
• Standardized documentation templates for SQL Server in Confluence Data repository
• Standardized internal process to request SQL Server support. Used Jira for support ticket management.
• Provided production DBA support in a 24X7 environment
• Administered/managed a production environment of more than 50 instances
• Worked with the monitoring team to define monitoring graphing metrics for Centreon, Nagios and Cacti
• Used SQL Server profiler and extended events to capture running traces from an instance and used that data to troubleshoot performance problems
• Created database/infrastructure physical and logical designs, database upgrades and applied software patches within the confines of the change control process
• Provided database file layouts for optimal utilization of both storage and performance requirements
• Handled logical data and index partitioning for large tables
• Created, monitored and rebuilt indexes and statistics per fragmentation requirements
• Monitored data activities i.e. database status, logs, space utilization, locks and long transactions
• Experienced in SQL Server Reporting Services SSRS
• Created basic SSIS packages data import/export
• Provided overall configuration and change control management for SQL Server instances and adhered to change control procedures
• Set up notifications and alerting through database mail
• Managed SQL Server client security, by defining specific roles and permissions
• Conducted root cause analysis for database incidents and problems
• Estimated disk storage requirements for database software, database files, and database administration needs
• Researched, reviewed and recommended relevant solutions for preventive maintenance
• Interfaced with database vendors and client technical support teams to isolate and resolve database related problems
• Acted as an unofficial team lead, reporting to the director of Corporate database group
• Maintained database consistency through the use of DBCC commands
• Created Database maintenance plans for backup and restores
• Administered iSCSI initiator for shared storage
• Installed and configured database software, associated database tools and performance monitoring software

Confidential

IT Consultant in Information Security / Networking

• Evaluated, re-architected and implemented a completely new network infrastructure using stacked 3750 cisco l2/l3 network devices as the core
• Redesigned the entire clerk network migrating from a layer 2 to a layer 3 centric routing architecture.
• Installed and managed 50 network devices ranging from Cisco 3750 layer2/3 to Cisco 2821 network devices
• Rewired all clerk patch panels to streamline and organize cable runs
• Installed and managed Websense web filtering to control organizational web usage
• Installed and managed a solution to strengthen core network services by migrating to Infoblox appliances deployed in a fail-over configuration
• Installed and managed Checkpoint R61 to control the perimeter of the clerk's network
• Installed and managed Checkpoint's VPN-1 infrastructure to provide secure remote access
• Managed Cisco Ironport mail gateways to ensure secure mail delivery and security
• Managed Nortel Alteon layer2-7 IBM blade center switches supporting a comprehensive VMware environment
• Installed Solarwinds Orion network management suite to report on the availability and performance of over 200 network devices

Confidential

Adjunct Professor of Computer Networking

• Instructed college-level course titled Introduction to Computer Networking for two semesters At night, in parallel with the Duval County clerk of the Court

• Conducted lectures on information security, network fundamentals, overview of the ISO model, TCP/IP
• Created and administered hands-on technical labs
• Created and administered course exams
• Used Blackboard to administer most aspects of the course, including grading, attendance and all projects