David Goodman

Database Administrator offering extensive expertise in coding and tuning Transact-SQL optimizing across Linux, Windows, and cloud platforms like GCP and Azure. Proven track record in leading complex database migrations, performance tuning, automation via Python and shell scripting, and troubleshooting critical issues to ensure data integrity. Skilled in cross platform migrations, collaborating with development and support teams to streamline operations and reduce downtime.

Database Administrator (DBA) - CGI CANADA - Toronto, ON

(2023-07 - 2025-07)

Provided Transact-SQL support for SAP Sybase ASE versions 16.0.3 and 16.0.4, hosted on Red Hat Linux 9.4 virtual machines within Google Cloud Platform (GCP), as part of the “Compass Modernization” project:

• Provided ongoing support to database users, managing user accounts, application databases, and troubleshooting issues.
• Investigated and fixed performance issues arising from migration of SQL across systems
• Resolved tempdb issues by analyzing and aligning differing "sap_oltp" optimization goals and parallel query settings.
• Resolved legacy-to-development database loading issues by scripting and applying missing tempdb objects, cleaning inconsistent login to-user mappings, and standardizing user/group permissions, restoring full database functionality and user access post-migration.

Database Administrator (DBA) - Statistics Canada - Ottawa, ON

(2019-08 - 2023-04)

Provided support for SAP Sybase ASE 16.0 and SAP IQ 16.1 on Windows Server 2016 running under VMware

• Investigated and reported on data quality issues in legacy systems through direct collaboration with data owners.
• Conducted proof-of-concept testing for Azure SQL columnstore indexes and documented findings.
• Automated SAP IQ administrative tasks such as backups and routine maintenance by developing Python scripts
• Assisted in SAP IQ migration to new hosts through Python scripting and hash-based data verification (via hashlib) to ensure complete and accurate data transfer.

Sybase Database Administrator (DBA) - Passport Canada - Gatineau, QC

(2017-06 - 2017-10)

Offered DBA support for Passport Canada’s IRIS application during the migration from SAP Sybase ASE 15.0.3 on Windows 2003 to SAP Sybase ASE 15.7.1 SP138.

• Developed key scripts for disk initialization and database creation to support the migration process.
• Executed and debugged migration scripts; automated the setup of development, testing, and production environments using SSH and RDist.
• Troubleshot application issues related to database migration to ensure smooth transition and minimal downtime.

Database Developer & Database Administrator (DBA) - Teranet Inc. - Toronto, ON

(2016-10 - 2017-05)

Supported the Teraview application running on SAP Sybase ASE 15.7.1 Cluster Edition SP138 and Replication Server 15.6 on AIX.

• Migrated legacy surrogate key generation methods in SAP Sybase ASE to use shadow identity tables.
• Designed and implemented mapping tables and procedures to synchronize key values between the main tables and key generation tables.

Principal Sybase Database Administrator (DBA) - Central 1 Credit Union - Mississauga, ON

(2014-10 - 2016-09)

Provided administration and support for SAP Sybase ASE and Replication Server environments on Linux, including system monitoring, performance tuning, database migration, and troubleshooting. Collaborated closely with cross-functional teams to ensure high availability, data consistency, and smooth transitions during upgrades and migrations.

• Improved batch processing efficiency by optimizing server configurations for Murex databases.
• Led the migration of production and QA ASE databases to new storage arrays and coordinated ASE migration to VMware virtual machines.
• Supported 14 QA and test Murex database environments during the “Murex Phase 2” development cycle.
• Key Achievements: After the “Murex Phase 2” rollout, improved batch processing runtime by 50% and reduced database server CPU usage from 100% to a peak of 30%, through index additions and cache tuning targeting spinlock contention, guided by MDA table analysis.
• Upgraded SAP ASE to version 15.7.1 SP50 and deployed a robust “log shipping” warm standby solution to enhance database availability.

BSc - Computer Science & Mathematics - University of Toronto