About

Specific Technologies where I am proficient:

SQL Server DBA - 22 years experience

SQL Server:

• SQL Server Versions installed and administered: (SQL Server 6.5 through SQL Server 15)

• Setting up SQL Server always-on high availability failover clusters and managing and administering.

• Publish\Subscribe Replication administration and setup.

• Using DMVs for performance and troubleshooting. Writing custom scripts for monitoring.

• I have written functions and stored procedures that are part of workflows and ETL processes.

• Auditing processes and users.

• Managing Permissions. Adding\Removing Users, Groups, and Roles that interface with Active Directory.

• Installing, setting up, and supporting SSRS.

• Creating SSIS packages for various tasks.

• I have experience using the AWS Console for setting up, managing and administering AWS instances of SQL.

• SQL Server Query Store Setup and Query Plan\Performance monitoring.

  • I am experienced with SQL Server  trace flags and when to apply. 

  • I am experienced in troubleshooting performance problems through using the SQL Profiler, setting up traces, replaying and analyzing traces for problems.

  • I am experienced with many nuances on SQL Server and the permissions complexities.

  • I have experience creating CTEs (common table expressions) for both MySQL and SQL Server.

SAP/SYBASE DBA  -  22 years experience 

SYBASE running on IBM Unix AIX OS: 

• SYBASE ASE (vers: 10 - 15.7)

• SYBASE Replication (vers; 11 - 15.7)

ORACLE DBA -  15 years experience

Oracle running on Solaris, Linux, AIX, and Windows.

• Creating/Managing Oracle Database Instances in RAC & ASM environments.

• Installing and Monitoring Oracle Databases and RMAN backups.

• Disaster Recovery setups.

• Installing DataGard.

• Installing OEM.

MySQL DBA - 10 years experience

• Disaster Recovery Setup

• Administering MySQL on Linux and Windows

• Clustering MySQL on Linux

• MySQL on Azure

Third Party Software Systems interfaced with RDBMS that I have administered:

Third Party Software Systems that I have experience working with and administering DBA support on: 

• Facets\Cognizant\Trizetto running on SYBASE & SQL Server - (Insurance Claims Processing\Membership\Billing System\Provider Payment Systems) 

• IFS Inventory System running on Oracle - (Aircraft Maintenance Inventory Tracking Systems) 

• SunGard\Banner running on Oracle (Student Administration\Financial Aid\Learning\Software)

• DTI  - running on SYBASE (Digital Technologies Incorporated - Newspaper Publishing Software Systems)

• JD Edwards - running on Oracle (ERP)

• Crystal Decision Business Objects - running on Oracle, SQL Server, SQL Anywhere.

• Vista Blackboard running on MySQL and Oracle (Teaching\Learning Software)

• CyberSource - running on Oracle (Payment Processing Clearing House)

• Paylocity API

Operating System Proficiency:

Proficient at the Command Line Interface in Windows and Unix\Linux.

• All Windows & Windows Server OS versions.

• Unix (AIX, Solaris, BSD)

• Linux (Oracle SE, Ubuntu, SuSe, RedHat, CentOS)

• PowerShell

• Bash

• DOS

Scripting\Programming Language Proficiencies:

• TSQL

• Python

• Bash

• PL/SQL

• Perl

• VB

• PowerShell

Other Databases I have installed and administered:

• CouchDB

• Postgres

• MariaDB

Other related experience:

• In my capacity as a DBA I have supported both OLTP & OLAP systems.

• I have a solid 15 years of SAP/Crystal Decisions - Business Objects - Administration and Report Writing on Crystal Reports.

• I have experience troubleshooting queries, stored procedures, triggers, and various other performance issues for the following RDBMS systems:

     MSSQL Server, Oracle, Sybase, MySQL.

• I am experienced writing custom Python ETL pipelines using PANDAS and SQL Alchemy.

• I am experienced creating custom Dashboards/KPIs with python modules dash, pandas, plotly, plotly express, matplotlib, and seaborn.

• I have experience Interfacing SAP/Business Objects with BMC Control-M Scheduling Software.

• I have experience Interfacing Business Objects Crystal Reports with Image Archiving System to capture printed material for company archival system.

• I am experienced in Various Backup Systems: Veritas NetBackup - Tivoli - Microsoft Azure Backup

• Monitoring Systems Used and familiar with: Orion - SolarWinds - NAGIOS - Zabbix

• Monitoring Systems I have setup and administered: NAGIOS - Zabbix - Cacti - Munin.

• I am familiar and experienced with Code Repository technologies such as github and gitlab and integrating into pipelines..

• I have experience with deployment technologies, Jenkins Pipeline jobs and Ant.

• I have experience creating custom python pipelines using the RESTful API.

Familiar with common software tools and technologies for Database Administration:

• SQL Server Management Studio SSMS

• SolarWinds DPA for troubleshooting Database Performance Issues

• Embarcedero DBArtisan and RapidSQL

• Toad/Toad For DBAs and Data Analysts

• DBVisualizer

• Aqua Data Studio

• dbForge

IDE Proficiencies:

• PyCharm

• Visual Studio

• Comfortable and proficient in Unix, Linux, and Windows command line (shell) environments.

Over time and depending on the need, I have been a Database Administrator, Programmer, Operations Analyst, Business Analyst, Project Manager, Network Engineer, Network Admin, AS\400 Operator\Programmer, and Unix, Linux, and Windows Admin.