Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Ghulam H. Malik

Markham,Canada

Summary

Experienced Senior DBA with a proven track record at Bruce Power, managing large-scale databases up to 40 TB. Expertise in Oracle and SQL Server, applying advanced tuning techniques for optimal database performance. Achieved a 30% improvement in system reliability through high-availability configurations. Strong collaboration with vendors enhances problem-solving capabilities. Seasoned Senior DBA with deep understanding of database management systems, including design, implementation, and maintenance. Strong in troubleshooting performance issues and providing optimal solutions. Experienced in managing large-scale databases and ensuring data integrity and security. Proven track record of improving system efficiency and reducing downtime.

Overview

28
28
years of professional experience

Work History

Senior DBA

Bruce Power
Tiverton, Canada
03.2006 - Current
  • Database Administration (Oracle & SQL Server) supported multiple databases up to 40 TB in sizes (about 58 Oracle database instances and 52 SQL Server instances)
  • Tuning Oracle and SQL Server using various techniques such as Oracle advisor, SQLT, creating missing indexes, rebuilding fragmented indexes, gathering stats and histograms, partitioning indexes, SQL profile, etc.
  • Configuring and managing Azure databases (Azure SQL, Managed Instances, SQL Virtual Machine - 22 instances)
  • Backup and Restore using Netbackup policies- Agent installation, Configuring Netbackup Polices for Filesystems, Oracle & SQL Server databases.
  • SolarWinds - Used for monitoring Unix/Linux and Windows servers, Oracle and SQL Server databases
  • Configured and supported Oracle Data Guard, version 11c, 12c & 13c
  • Configured service guard clustering on HP-UX and RedHat Linux for Oracle databases high availability
  • Configured SQL Server failover clustering (version 2005 and 2008) and availability groups (version 2012,2014, 2016 & 2019)
  • Configured SQL Server Replication plus Oracle materialized views
  • OEM Configure and managed OEM Version 9i,10g,11g,12c,13c
  • Spotlight - Used for monitoring SQL Server databases
  • Refreshing Dev, Staging, Training, Acceptance/UAT & Testing database Oracle and SQL Server
  • Oracle and SQL Server patching cumulative, service pack, quarterly
  • Worked with vendors including Oracle and Microsoft engineers in different scenarios e.g. bugs fix, environment assessment for moving to cloud
  • Configured Crontab jobs, DBMS jobs, scheduler, SQL Server agent jobs

DBA

Rogers Media
Toronto, Canada
03.2005 - 02.2006
  • Refreshed development, test, QA and staging environments from production data by using export/import plus RMAN scripts. Installed oracle and created databases 9i and 10G.
  • Tuned production databases by using Statspack reports and by using OS tools
  • Developed reporting application data model and wrote scripts for database creation and application schema. Wrote scripts for data conversions and tuned data load process.
  • Created database objects e.g. tables, indexes (with appropriate storage sizes), views, synonyms, functions, stored procedures, packages etc. Created new schema and tablespaces for new applications
  • Calculated database growth and developed backup and recovery strategy.
  • Wrote shell scripts for refreshing data, data loads, data conversion, data purge and RMAN backup and recovery processes. Moved data and objects from SQL Server to Oracle 9i.
  • Created, maintained and supported Data Guard for Disaster Recovery (DR) and High Availability (HA).

DBA

Adelphia Communications
Coudersport, USA
02.2004 - 03.2005
  • Supporting 60 databases; Oracle, SQL Server, MySql and PeopleSoft Oracle Working as on-call DBA (pager duties). Made database structural, data or adding new functionalities in the existing production databases through change management process.
  • Developed data logical and physical data model for three tier applications e.g. Logistic and Supply Chain Management and Advance Diagnostic Manager. These applications were based on J2EE and the middle tier was IBM WebSphere. Data models were prepared with help of specifications and working with business and system analysts.
  • Oracle installation (on Linux Red Hat, Sun Solaris), configuration and application of patches
  • Installed and configured RAC databases for the mission critical applications.
  • Developed database creation scripts considering by using proper storage for large, medium and small tables and their distribution on file system such that it provide optimum performance.
  • Offline and online backup and recovery using RMAN. Configured RMAN for the faster backup and recovery process.
  • Involved in configuring Veritas NetBackup and Media and Storage Devices for the Netback.
  • Recovered database for Prod, QA/test environment with and without recovery catalog.
  • Scheduled jobs for mass updates, data extraction, data loadings and developed scripts to fix application bugs. Tuned databases, data load process by using sqlldr.
  • Created functions, store procedures, packages by using PL/SQL language elements such as records, types, objects, PL/SQL tables, nested table, Varrays, nested loops, cursors, bulk collect, complex triggers etc. and developed shell scripts to execute SQL and PL/SQL scripts.
  • Trained users, developed test plans and involved in capacity planning for the databases hardware, developed and implemented system securities.

Oracle DBA

Sigma/Liberate Technologies
Toronto, Canada
09.2000 - 11.2003
  • Developed data logical and physical data model for three tier applications e.g. service broker, service manager profile. These applications were based on J2EE and the middle tier was IBM WebSphere. Data models were prepared with help of specifications and working with business and system analysts.
  • Installed Oracle (7.x.x to 9.x.x) on UNIX, Linux and Window NT.
  • Created databases (OLTP and DSS) by using manual scripts, database assistant, DBCA and templates.
  • Implemented database backup, recovery, security and safety strategies.
  • Maintained large databases from 60 GB to 1.3 TB in sizes effectively and efficiently
  • Calculated tables, indexes and tablespaces (dictionary and locally managed) sizes and defined their logical structure, logs, control files etc. Partitioning of tables and indexes.
  • Created functions, store procedures, packages by using PL/SQL language elements such as records, types, objects, PL/SQL tables, nested table, Varrays, nested loops, cursors, bulk collect, complex triggers etc.
  • Developed data models by using Erwin / power designer tools. Modified database objects through DDL scripts.
  • Constructed complex and tuned queries, creating snapshots, materialized views, views and synonyms.

Oracle DBA

General Electric Power Systems
New York, USA
08.1997 - 09.2000
  • Installed oracle 7.3, 8.0.X databases on Unix Solaris 7.0 by using scripts / database assistants. Upgraded database from 7.3 to 8.0.
  • Created physical database files, redo logs, specific considerations given to performance factors plus database recovery and its safety using multiplexing philosophy.
  • Designed database for Gas Turbines and Generators by using Erwin. Used reverse engineering for the existing databases to convert into oracle and generated DDL scripts after creating ER diagrams.
  • Data mining and data analysis for Gas turbines and Generators by writing stored procedures, functions, packages or SQL statements in oracle data warehouse environment. Developed global data refresher process by writing stored procedures.
  • Tuned applications and database by using different database initialization parameters.
  • Converted all databases to Archive Log Mode to enable hot backups and additional recovery methodology. Created Cold and Hot backup strategy for all Oracle databases.
  • Automated Backup procedures using UNIX shell scripting.
  • Worked on large databases from 60 GB to ~ 3 TB.

Education

Microsoft Certified Azure Data Engineer Associate - Azure database administration, Azure Fundamentals AZ-900 Training

Oracle 11i system administration - security, Concurrent Manager and flex fields

Oracle 11i Installation and patches -

Oracle 9i, 10G and 11G Certified Professional -

Microsoft Certified IT Professional - (Database Administrator 2005 and 2008)

Microsoft Certified Technology Specialist - (SQL server 2005 and 2008)

Database Administrator - (Microsoft SQL Server 2000)

Microsoft Certified Professional - MCP 2.0

Course in Oracle 9i database performance and tuning -

Oracle University (DesTech)

Course in Sun Solaris UNIX administration - 1

Course in Linux administration - 1 & 2

Skills

  • Oracle 19c
  • Oracle 12c
  • Oracle 11g
  • Oracle 10g
  • Oracle 920X
  • Oracle 901
  • Oracle 8i
  • Oracle 80X
  • Oracle 73
  • SQL Server 2019
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2008
  • SQL Server 2005
  • SQL Server 70
  • SQL Server 65
  • PL/SQL
  • SQL Plus
  • SQL
  • TSQL
  • Java XML
  • C
  • C
  • HTML
  • Visual Basic
  • net
  • C sharp
  • OEM13c
  • OEM12c
  • Netbackup
  • Solarwinds
  • Spotlight
  • Oracle SQL Developer
  • PL/SQL Developer
  • Erwin
  • RMAN
  • SQL Loader
  • Data pump export
  • Data pump import
  • Informatica
  • Cognos
  • Content Server
  • Service Now
  • Linux Redhat
  • HP-UX
  • UNIX Solaris
  • Windows 2022
  • Windows 2020
  • Windows 2016
  • Windows 2012
  • Windows 2008
  • Windows 2003

References

Available upon request.

Timeline

Senior DBA

Bruce Power
03.2006 - Current

DBA

Rogers Media
03.2005 - 02.2006

DBA

Adelphia Communications
02.2004 - 03.2005

Oracle DBA

Sigma/Liberate Technologies
09.2000 - 11.2003

Oracle DBA

General Electric Power Systems
08.1997 - 09.2000

Microsoft Certified Azure Data Engineer Associate - Azure database administration, Azure Fundamentals AZ-900 Training

Oracle 11i system administration - security, Concurrent Manager and flex fields

Oracle 11i Installation and patches -

Oracle 9i, 10G and 11G Certified Professional -

Microsoft Certified IT Professional - (Database Administrator 2005 and 2008)

Microsoft Certified Technology Specialist - (SQL server 2005 and 2008)

Database Administrator - (Microsoft SQL Server 2000)

Microsoft Certified Professional - MCP 2.0

Course in Oracle 9i database performance and tuning -

Oracle University (DesTech)

Course in Sun Solaris UNIX administration - 1

Course in Linux administration - 1 & 2

Similar Profiles

CREATE PROFILE
Ghulam H. Malik