Skills and Education

Database Technology

• AWS RDS (MySQL, PostgreSQL, Aurora), Microsoft SQL Server, Oracle, Sybase, and DB2.
• SSIS, SSRS, DTS, and Visual Studio.
• Information Builders (Webfocus, Data Migrator, iWay), Database Performance Analyzer, Redgate Toolbelt, SentryOne, ApexSQL, MySQL Enterprise Monitor, Power Designer, Toad Data modeler, and DBA Tools Powershell library.

Server Technology

• Microsoft Server 2000, 2003, 2008, 2008 R2, 2012 R2, 2014, Ubuntu, Redhat, and CentOS.
• VMWare, VSphere, and Citrix.
• Git, Team Foundation, Solarwinds Network Performance Monitor, Solarwinds Server and Application Monitor, WS_FTP, Filezilla, WinSCP, Putty, Powershell, and Symantec Backup.

Education

• AWS Certified Cloud Practitioner (October 2021)
• Certified SAFe Agilist, Leading SAFe from Scaled Agile Inc (October 2020)
• DAMA-DMBOK2 Certified Data Management Professional – Practitioner (November 2019)
• MCSA Developing 2016 SQL Server Databases (July 2018)
  • MS SQL 70-761 Querying Data with T-SQL (December 2017)
  • MS SQL 70-762 Developing SQL Server Databases (July 2018)
• MCSE Data Management and Analytics (Nov 2020)
  • MS SQL 70-767 Implementing a Data Warehouse (Nov 2020)
• ONLC – Oracle Database 12c: SQL Fundamentals (August 2014)
• Advanced Excel classes hosted at FRCC, courtesy of Center Partners. (June 2009)

SQL Skills

Administration

• High Availability
  • Availability Groups / Clustering / Replication / Mirroring / Transaction log shipping.
• Disaster Recovery
  • Backup set up, retrieval, testing, and archiving.
• Configuration
  • Capacity planning for all resources (CPU, RAM, IO, Network, Licensing / Features, etc.)
  • Best practices for set up and configuration and adjusting ‘defaults’ to fit the nature of the business.

Security

• Auditing
  • Alerts and audit reports of permissions, individuals, processes, and procedures.
• Best practice security features
  • TDE, column encryption, temporal tables, and SSL / TLS cert configuration.
• Role and schema permissions based on AD or also SQL Server auth.

Business Intelligence / Reporting / Analysis

• Architect ETL and Data Warehousing to best practices.
  • Varied versions of normalization, OLTP / OLAP databases, Inmon, Kimball, and Lindstedt methodologies.
• Best practice constraints, data types, and documentation. Designing databases to have data integrity with proper automated auditing and alerting.
• Adhoc report design and delivery.

Performance

• Wait statistics from DMV’s, Extended Events, Query Plans, Query Store, and SQL Profiler.
• Proper index tuning and creation, including columnstore indexes.
  • Understanding of when to implement and use technology. (HEAP, Clustered tables, non-clustered tables, OLTP Memory, etc.)
• Partitioning
  • Table partitioning for quick ETL, searching, and file management.
• Transaction / error handling and proper searchable argument handling (Sargability).