SUMMARY:

• Over 29 years of experience designing, testing, implementing, tuning, migrating, upgrading and supporting relational databases in corporate environments
• Over 24 years of experience in SQL Server administration, including installation and configuration, maintenance, performance tuning, migrations, upgrades, security, disaster recovery, data mart and data warehouse design, replication, clustering / high availability, and advanced Transact - SQL (T-SQL)
• Over 11 years of experience creating SQL Server Reporting Services (SSRS) reporting systems
• Over 11 years of experience developing SQL Server Integration Services (SSIS) ETL packages
• Experienced in organizing and managing multiple projects, project teams, and deliverable deadlines in changing environments keeping within scope and within budget

TECHNICAL SKILLS:

Databases: SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005, 2000, 7.0, 6.5 (64- and 32-bit)

Systems: Windows Server 2016, 2012, 2008, 2003, 2000, Vista, Windows XP, NT, MS-DOS

Languages: T-SQL, SQL, PowerShell, HTML, VBScript, DOS

Tools: AWS, Clustering, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), ER/Win, ER/Studio, Change Manager, Visual Studio, SQL Profiler, Performance Dashboard, sp Blitz, Performance Monitor, Dynamic Management Objects and Views (DMOs/DMVs), OSQL, ISQL, SQLCmd, Crystal Reports, VMWare, Data Transformation Services (DTS) Packaging, OLAP, LiteSpeed Backup, Veritas tape backups, WebTrends, Tivoli SQL database backups, Spotlight, MS Office Suite (Word, Excel, PowerPoint & Outlook), Microsoft Project, Visio

PROFESSIONAL EXPERIENCE:

SQL Server Database Administrator / SQL Server Developer

Confidential, Oakbrook, IL

Responsibilities:

• Developed performance-tuning recommendations for current and future client implementations in Amazon Web Services (AWS), virtual and standard environments
• Executed performance testing utilizing various tools for including SQL Profiler tracing, Performance Dashboard, sp Blitz, Performance Monitor, query plans, and Dynamic Management Views (DMVs)
• Designed and implemented standardized maintenance routines, backup procedures and proactive alerting in AWS, virtual and standard environments
• Reviewed existing development, testing and production environment database designs and database implementations
• Documented physical database environment, including hardware and software configurations, as wells as database design of tables, views, columns, and indexes

Confidential, Vernon Hills, IL

Senior SQL Server Database Administrator

Responsibilities:

• Supported 300+ servers with 3600+ databases on physical and virtual servers in development, test and production environments
• Installed, monitored and enhanced standardized optimization and integrity routines, backup procedures and proactive alerting across all database servers
• Reduced runtime of multiple processes significantly through stored procedure query tuning using SQL Profiler tracing, Performance Dashboard, sp Blitz, Performance Monitor, query plans, and Dynamic Management Views (DMVs)
• Provided SQL Server expertise on company project using agile/scrum methodology
• Developed and supported SQL Server policy alerting using T-SQL and PowerShell
• Provided company-wide 24x7 off-hours support 1 out of every 4 weeks

Confidential, Schaumburg, IL

Senior SQL Server Database Administrator

Responsibilities:

• Supported multiple SQL Server database servers/instances, including multiple databases, multiple instances and multiple environments
• Standardized optimization and integrity routines and backup procedures across all database servers
• Performed and documented environment assessment and recommendations
• Reduced runtime of multiple processes significantly with environment reconfiguration

Confidential, Chicago, IL

Senior SQL Server Database Administrator

Responsibilities:

• Supported over 35 SQL Server database servers/instances, including multiple databases, multiple instances and multiple environments
• Standardized maintenance routines and backup procedures across all database servers
• Reduced runtime of multiple processes significantly using smart procedures
• Trained several employees on database administration concepts and procedures

Confidential, Northbrook, IL

Senior SQL Server Database Administrator

Responsibilities:

• Planned, developed and supported the SQL Server clustered systems, including multiple databases, multiple instances and multiple environments
• Reduced runtime of multiple processes significantly using performance tuning tools
• Designed and implemented multiple database reporting structure using SQL Server Reporting Services (SSRS)

Confidential, Chicago, IL

Senior SQL Server Database Administrator

Responsibilities:

• Planned, developed and supported SQL Server 2000 Enterprise 64-bit, 32GB RAM environments, including Windows 2003 Datacenter 64-bit, 32GB RAM clusters with multiple database instances
• Used ER/Studio to develop the physical database components of the operational data store, including primary keys, foreign keys, indexes and alternate keys
• Developed failover and failback strategy and testing
• Designed and implemented application database security documentation and strategy

Confidential, Chicago, IL

Senior SQL Server Database Administrator

Responsibilities:

• Performed as a DPS Consultant to DPS client
• Planned, developed and supported several 5-20GB intraweb-based application databases in a SQL Server 2000 / Windows 2000 environment
• Assisted in the design of new databases using Embarcadero ER/Studio
• Supported database environment using SQL Server 2000 tools and Embarcadero Change Manager
• Determined and implemented performance tuning measures
• Developed SQL replication creation and deletion scripts
• Implemented various Data Transformation Services (DTS) packages
• Maintained database environment security for development, test and pre-production environments