Rob Connock

Senior Database Administrator and database leader with more than 30 years of experience designing, administering, optimizing and supporting Microsoft SQL Server environments. Deep production and development expertise across SQL Server versions 6.5 through 2022, with extensive experience in high availability, disaster recovery, replication, performance tuning, database architecture, ETL, reporting and business intelligence. Proven team leader with experience supervising DBAs, planning projects, mentoring technical staff and delivering solutions that improve reliability, performance and operating efficiency.

Director of Databases / Senior Database Administrator at Premier Eye Care, Inc. (2015-02 – Present)

• Lead database administration for 168 highly transactional instances; oversee production support, job failures, performance issues, procedure tuning, backups and disaster recovery.
• Designed and implemented a three-node Availability Group/failover architecture with two local synchronized nodes and a remote Colorado disaster-recovery node; built Power BI dashboards and SQL alerts for monitoring.
• Created SSIS processes to move nightly backup files for additional redundancy and developed an auto-refreshed staging environment so developers could refresh databases without DBA assistance.
• Built automated release/change-management workflows using Team Foundation and Red Gate, reducing implementation effort and supporting High Trust requirements.
• Developed companywide tracking, monitoring and reporting systems, including Premier Tracker, database-growth dashboards, SQL activity capture and 'WhoisActive' blocking/waits monitoring with Power BI.
• Migrated and upgraded production infrastructure from SQL Server 2014 Enterprise to SQL Server 2022 Enterprise and created companywide database monitoring and alerting systems.
• Diagnosed storage-related performance bottlenecks exceeding 100 ms transaction latency, guided SAN/SSD changes, and helped achieve less than 1 ms latency; average SSRS reporting time dropped from 200 seconds to 9 seconds.
• Created 20+ complex SSIS packages for migrations, data quality, maintenance, backup archiving, SID migrations and Team Foundation backups.
• Led and supervised database staff, including recruiting, onboarding, project delegation, planning, mentoring and quarterly/year-end goal management using SCRUM methods.
• Designed and administered an on-premises SharePoint 2013 farm supporting executive dashboards, reporting, ticketing, project management and HR functions.

Senior Database Administrator at G4S Government Solutions (2012-05 – 2015-02)

• Solely responsible for production and development database systems supporting more than 4 TB of data and 24/7/365 availability.
• Supervised database staff, delegated work, planned projects, mentored junior DBAs and led daily SCRUM meetings across database and development teams.
• Led the ADP tax-service database project across six states and three countries and represented the company in project meetings.
• Managed development of executive dashboards, a web-based procurement/accounts-payable system and multiple enterprise IT initiatives; the procurement project saved more than $10,000 per month in consulting fees.
• Created a VB.NET employee benefits application and SQL database interface that resulted in a documented $2 million annual tax benefit.
• Designed and implemented remote disaster-recovery replication that reduced failover time from 12 hours to 1.5 hours.
• Implemented SQL Server Reporting Services 2012, Team Foundation development workflows and SharePoint 2013 environments; optimized database queries, views, jobs and reports.
• Led ADP Tax Credit work that produced more than $1 million per year in tax savings.

Senior Database Administrator at Lydian Private / Virtual Bank.com (2009-08 – 2012-05)

• Managed 66 high-availability database instances with more than 30 GB of daily transactional data; led a team of four DBAs and one report developer.
• Owned companywide database activity, reporting, backup/DR, performance standards and coordination with executive and development teams.
• Created a corporate deposit data mart using SSIS and SSAS with SharePoint/SSRS front end and led SQL upgrades, database consolidation and remote recovery/replication projects.
• Resolved a long-standing parameter-sniffing performance issue and established query-performance standards for reporting workloads.

Database Administrator at Fidelity National Financial (1997-05 – 2009-08)

• Senior DBA for 14 databases in West Palm Beach and Orlando and assistant DBA supporting a 24+ TB, highly transactional environment with more than 160 database instances.
• Designed ETL/SSIS/.NET solutions for billion-record data, custom table partitioning, indexing, execution-plan optimization and high-volume database processing.
• Performed SQL Server installations, migrations, service packs, hot fixes, security, maintenance, backup/restore, disaster recovery, monitoring and third-tier troubleshooting.
• Established log shipping, performance monitoring, indexing and maintenance routines; supported 24/7 SQL Server operations.
• Co-developed a complete imaging system using VB6 and T-SQL, including proprietary image compression/storage within SQL Server.
• Created more than 100 DTS packages and numerous SSIS migration packages, reporting systems, Crystal Reports solutions and SQL Reporting Services applications.

Junior Database Administrator at Communitex Inc. (1989-11 – 1997-05)

• Progressed into database administration and built the foundation for a long-term career in SQL Server database development, administration, reporting and technical support.