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) at Statistics Canada

Provided support for SAP ASE 16.0.3, ASE 16.0.4 and SAP IQ 16.1 on Windows Server 2016 running under Vmware. Migrated SAP IQ 16.1 to Azure SQL.

• 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 monitoring and backups through Python scripting
• 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) at Passport Canada

Offered DBA support for Passport Canada’s IRIS application during the migration from ASE 15.0.3 on Windows 2003 to 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) at Teranet Inc.

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

• Migrated legacy surrogate key generation methods in 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) at Central 1 Credit Union

Provided administration and support for SAP 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.
• 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 in Computer Science & Mathematics – University of Toronto