Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Skills
Skills
Generic

Zahid Hussain

East York,ON

Summary

Highly skilled Senior Oracle Database Administrator with over 15years of experience offering a unique combination of technical and analytical skills. Extensive experience designing and supporting heterogeneous database solutions utilizing Oracle, MS SQL, MySQL technologies.

Overview

11
11
years of professional experience

Work History

Senior Database Administrator

Shaw Communications Inc
Toronto, ON
01.2022 - 08.2023
  • Install, manage, and upgrade Oracle 10g/11g/12c/19c RAC databases on Unix/Linux platforms
  • Configure and administer Oracle 11g/12/19c Automatic Storage Management (ASM) and RMAN backups of production and non-production databases, ensuring maximum availability
  • Performance/capacity planning, performance tuning, backup and restore of Oracle 19c databases
  • Provide subject matter expertise in design, maintenance, troubleshooting and enhancement of production and non-production database environments of 12/19 databases
  • Ensure application security, compliance, stability, reliability and accessibility of databases
  • Ensure data integrity and security in upgraded platform post successful data migration
  • Manage database distribution, configuration, security, and access requirements
  • Experience in installing, configuring and cloning of pluggable databases in multi-tenant environments
  • Conducted tests to identify issues and make necessary modifications

Senior Database Administrator

Cognizant Technologies Solutions
Toronto, ON
06.2021 - 12.2021
  • Supported migration from 12c to 19c databases
  • Migration of different type of databases using export/import, standby, backup/restore methods
  • Cloned pluggable databases from production to non-production environments
  • Build new 19c database instances using scripts and GUI
  • Installed and configured 12c, 18c database and 12c,18c OEM on development and production database
  • Upgraded databases from 11g to 18c in CDB and non CDB environment
  • Implement upgrade testing best practices to ensure quality and successful upgrade.
  • Manage transition of application, contents, users and integration components to new upgraded platform
  • Ensure application security, compliance, stability, reliability and accessibility after successful upgrade.
  • Ensure data integrity and security in upgraded platform post successful data migration
  • Troubleshoots upgrade related issues, problems, research solutions, engage vendors and other subject matter experts to efficiently resolve issues
  • Involved in implementing Oracle DR and Corporate Criticality Level policies regarding Database restores/recoveries
  • Successfully planned and migrated database to could with minimal downtime
  • Implementation and support of Oracle Database auditing for SOX complaint systems

Senior Oracle DBA and Programmer / Analyst

Express Scripts
Mississauga, ON
09.2020 - 06.2021
  • Configure and build Golden Gate Extracts/replicate for multiple databases
  • Configure error handling for restart, logging, production support and status reporting in Golden Gate
  • Trouble shooting and performance tuning Golden Gate replications
  • Identified requirements for improvements to databases by determining users' information requirements and system performance
  • Supported migration from 12c to 19c databases
  • Cloned pluggable databases from production to non-production environments
  • Build new database instances using scripts and GUI
  • Identified requirements for improvements to databases by determining users' information requirements and system performance
  • Review Oracle Database data model design and recommendation normalization of data
  • Programmed System (Shell scripts and SQL) to automate database backup, monitoring and other DBA functions
  • Configured and maintained Oracle Data Guard, RAC and Cluster environment databases
  • Installed and configured 12c, 18c database and 12c,18c OEM on development and production database
  • Analyzed and investigated potential problems as described on incident management tickets to determine root cause, take necessary action or escalate when necessary
  • Analyzed and ensured information on request for change tickets were clear prior to execution, closing ticket with details of actions upon completion
  • Upgraded databases from 11g to 18c in CDB and non CDB environment
  • Migrated database from non-Exadata to Exadata environment using Golden Gate
  • Configured RMAN for full and archive database backups

Senior Database Architect

FIS Global
Toronto, ON
08.2019 - 05.2020
  • Responsible for all Oracle databases; tuning, maintenance and development
  • Implemented database monitoring using OEM, batch scripts, Java Stored Procedures and Sun Microsystems Java Mail package
  • Designed and implemented scheduled database backups using RMAN
  • Working closely with developers and providing support for schema design and implementation by using ERWin, PL/SQL packages, database auditing by using Oracle Designer
  • Reports automatically generated and e-mailed to management team on weekly, monthly and quarterly basis

Contract Oracle DBA

Express Scripts
Mississauga, ON
02.2018 - 06.2019
  • Installed and configured 3 nodes Oracle RAC 11g and 12c databases on Linux and Solaris
  • Provided subject matter expertise during deployment process of physical 12C RAC database design and layout - log files, data files, rollback segments and table spaces
  • Automate database tasks such as database install build, backup database, gathering stats recycling alert and listener logs using shell scripts
  • Oracle database provisioning and patching using Oracle OEM Grid Control
  • Discovering, adding and deploying hosts using Oracle OEM Grid Control
  • Setting up jobs and creating alerts using OEM Grid Control
  • Cloned pluggable databases from production to non-production environments
  • Upgraded Oracle DB from 11g to 12c in development/production/cloud control environments running data guard with standby databases
  • Build new database instances using scripts and GUI
  • Identified requirements for improvements to databases by determining users' information requirements and system performance
  • Review Oracle Database data model design and recommendation normalization of data
  • Programmed System (Shell scripts and SQL) to automate database backup, monitoring and other DBA functions
  • Installed and configured Oracle Data Integrator 12c
  • Designed, modeled and implemented fact tables, dimensional tables, dimensional hierarchy
  • Developed, tested and supported mapping from source to landing area in Oracle Data Integrator
  • Worked on migration project of OLAP database to DWH
  • Create PL/SQL scripts, triggers and procedures
  • PL SQL optimization of poorly designed code
  • Performance analysis on Exadata's/Oracle's CPU, Memory, storage and I/O
  • Configured and maintained Oracle Data Guard, RAC and Cluster environment databases
  • Installed and configured 12c, 18c database and 12c,18c OEM on development and production database
  • Develop technical specification documents and automation scripts
  • Perform knowledge transfer, mentoring and guidance to designated staff.
  • Analyzed and investigated potential problems as described on incident management tickets to determine root cause, take necessary action or escalate when necessary
  • Analyzed and ensured information on request for change tickets were clear prior to execution, closing ticket with details of actions upon completion
  • Installed and configured Oracle 18c database for Microsoft SQL Server environment in non-production and production environment

Oracle DBA and Programmer / Analyst

Scotiabank
Toronto, ON
06.2017 - 02.2018
  • Provide technical advice, subject matter expertise, and guidance on analysis, interpretation and evaluation of complex database features
  • Implementation and support of Oracle Database auditing for SOX complaint systems
  • Automate database tasks such as database install build, backup database, gathering stats recycling alert and listener logs using shell scripts
  • Provide technical day to day operational support to; incident management (break/fix), change management, release management and maximize availability and usability of cluster supported solutions
  • Provided on-site database and system support
  • Oracle database provisioning and patching using Oracle OEM Grid Control
  • Setting up jobs and creating alerts using OEM Grid Control
  • Discovering, adding and deploying hosts using Oracle OEM Grid Control
  • Monitored, collected statistical information and provided reporting on capacity and system performance
  • Configured RMAN for full and archive database backups
  • Analyzing Auditing reports and make necessary database changes in database for compliance
  • Made recommendations to maintain and improve capacity and system performance, based on statistics
  • Build new database instances using scripts and GUI
  • Configured and maintained Oracle Data Guard, RAC and Cluster environment databases
  • Trained in MongoDB by MongoDB consultant (in-house)
  • Configured RMAN for full and archive database backups
  • Provided leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database environments
  • Recommend optimization of poorly design PL/SQL code
  • Programmed System (Shell scripts and SQL) to automate database backup, monitoring and other DBA functions
  • Monitored system, and acted upon system and application automated alerts
  • Performed diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
  • Read and interrupt alert logs and error messages generated by Oracle systems.
  • Generated and interrupt Oracle performance metrics reports to provide evidence on DBs performance and stress points.
  • Experienced in generating ‘debug' traces of Oracle system as requested by Oracle support or for their own diagnosis.
  • Participate in planning activities; complete all required change request assessment tasks; participate in release management activities and method of procedure (MoP) walkthrough meetings.
  • Provided resources and skill sets to support DBA functions for applications
  • Proposed database changes to ease monitoring and administrative effort
  • Troubleshot database issues to create and resolve trouble tickets

Senior Database Administrator

DXC Technology
Mississauga, ON
06.2016 - 06.2017
  • Set up and controlled user access levels across databases to protect important data.
  • Conducted tests to identify issues and make necessary modifications.
  • Designed and developed analytical data structures.
  • Created and updated database designs and data models.
  • Led and/or provided subject matter expertise in production and non-production databases for database development, maintenance ensuring consistency and integration with existing database infrastructure
  • Installed and configured new SQL Servers (2012,2016)
  • Configured RMAN for full and archive database backups
  • Supervised Oracle production environment, database backup and restore, database performance diagnostics and tuning for ALL databases
  • Automate database tasks such as database install build, backup database, gathering stats recycling alert and listener logs using shell scripts
  • Maintain security or implement security improvements by; assessing current situation, maintaining current security posture, evaluating trends, anticipating requirements, and applying security patches/fixes
  • Installed and configured 3 nodes Oracle RAC 11g and 12c databases on Linux and Solaris
  • Managed database distribution, configuration, security and access requirements
  • Led reporting, performance/capacity planning, performance tuning, backup and restore
  • Provided leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database environments
  • Configured and maintained Oracle Data Guard, RAC and Cluster environment databases
  • Provided subject matter expertise during deployment process of physical 12C RAC database design and layout - log files, data files, rollback segments, and table spaces
  • Implemented, deployed and upgraded security patches and day–to–day operations MS SQL Server 2005/2008 including Development, QA, UAT and Production systems
  • Worked on 12c Database and upgrade from 11g to 12c Database
  • Analyzed and investigated potential problems as described on incident management tickets to determine root cause, take necessary action or escalate when necessary
  • Analyzed and ensured information on request for change tickets were clear prior to execution, closing ticket with details of actions upon completion
  • Identified requirements for improvements to databases by determining users' information requirements and system performance
  • Performed ongoing tuning of database instances using AWR, ADDM, ASH to meet SLAs
  • Monitored drives to ensure it did not reach critical level and created outages, and determinate whether or not to escalate
  • Installed and configured 12c databases on Linux/Unix servers
  • Programmed System (Shell scripts and SQL) to automate database backup, monitoring and other DBA functions

Senior Database Administrator

Ontario Government
Toronto, ON
06.2014 - 06.2016
  • Upgraded Oracle DB from 11g to 12c in development/production/control environments running data guard with standby databases
  • Installed latest patches (including latest released Oracle security patches) in database in both production and backup environment
  • Automate database tasks such as database install build, backup database, gathering stats recycling alert and listener logs using shell scripts
  • Maintained Production and Standby Emergency Backup environment and user access control
  • Provided system support to resolve issue related to Oracle database, WebLogic and Cloud Control
  • Loaded off-loading of data using different methods of ETL’s
  • Supported /patched / maintained Data guard databases
  • Build new database instances using scripts and GUI
  • Provided leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database environments
  • Configured and maintained Oracle Data Guard, RAC and Cluster environment databases
  • Installed and configured 12c database and 12c OEM on development and production database
  • Monitored health of databases by monitoring alert logs, operating system file system space usage and trace files
  • Involved in ETL tool evaluation, selection, data management strategies, standards, best practices
  • Provided technical support for database performance tuning including environment preparation (e.g. database restores, promotions, batch jobs setup). Analyze results and document recommendations for tuning. Implement approved changes and update documentation
  • Recommend and implemented database improvements that enhanced availability and security and stability
  • Provided database support and assisted in execution of operability, performance testing.
  • Developed, documented and maintained operational and maintenance procedures for SAMS, DSCIS database management system
  • Programmed System (Shell scripts and SQL) to automate database backup, monitoring and other DBA functions
  • Performed Database de-fragmentation using different methodologies to reclaim space

Database Administrator

IBM
Markham, ON
01.2013 - 05.2014
  • Tested programs and databases to identify issues and make necessary modifications.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Created and updated database designs and data models.
  • Created and implemented database designs and data models.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Coordinated with project management on database development timelines.
  • Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.

Education

Advanced Diploma - Database Application Developer

Herzing Career College
Toronto
09.2005

Skills

  • Database servers
  • Performance tuning
  • Capacity monitoring
  • Disaster recovery planning
  • High availability
  • Data security
  • Strong analytical skills
  • Strong collaborative skills
  • Excellent problem solving skills
  • Oracle Fusion Middleware

Accomplishments


  • Excellent accomplishments with combining Oracle and Pure Storage ZeroSnap technologies. Implemented and documented cloning procedure for Oracle database running on Linux using ASM.
  • Successfully deployed OEM Cloud Control (10g to 13c) and MySQL Enterprise Dashboard into company's network to fully automate database and system monitoring. Ability to proactively monitor and manage 100 production systems has minimized incident rate and need for off-hour support by 50%.
  • Completed installation of OBIEE 11g and Oracle Retail Data Model, successfully configured Single-Sign-On with Microsoft AD and implemented OBIEE SSL.
  • Managed and completed Exadata V2 POC migrating data from ODA to Oracle RAC on Exadata achieving up to 20 times better query performance.
  • Successfully migrated 300 plus applications from one data center to another saving thousands in costs

Timeline

Senior Database Administrator

Shaw Communications Inc
01.2022 - 08.2023

Senior Database Administrator

Cognizant Technologies Solutions
06.2021 - 12.2021

Senior Oracle DBA and Programmer / Analyst

Express Scripts
09.2020 - 06.2021

Senior Database Architect

FIS Global
08.2019 - 05.2020

Contract Oracle DBA

Express Scripts
02.2018 - 06.2019

Oracle DBA and Programmer / Analyst

Scotiabank
06.2017 - 02.2018

Senior Database Administrator

DXC Technology
06.2016 - 06.2017

Senior Database Administrator

Ontario Government
06.2014 - 06.2016

Database Administrator

IBM
01.2013 - 05.2014

Advanced Diploma - Database Application Developer

Herzing Career College

Skills



OEM, Cloud Control, Exadata, ASM, RAC, AIX, RMAN, auditing, backup, Basic, C, C , CCSA, client and server, hardware, consulting, validate data, database applications, database administration, DBA, Database, database development, ERWin, Forms 6, FTP, HTML, HTTP, DB2, IIS, Java, JavaScript, Linux, Mentoring, MS Access, migration, MySQL, Object Oriented Programming, Operating Systems, Oracle, Oracle database, Oracle DBA, DB, Oracle Designer, Developer, PL/SQL, Perl, Perl CGI, processes, programmer, programming, Project lead, Project Management, Protocols, RedHat, Reporting, Storage Area Network, SCO, Servers, scripting, Scripts, Software Engineering, Solaris, MS SQL Server, SQL Plus, Microsoft SQL Server, SQL, SQL Server, SQL*Loader, Sun Microsystems, TCP/IP Networking, TCP/IP, user support, Time Management, Tomcat, troubleshooting, UNIX, UNIX Administration, Unix Shell, upgrades, utilities, Veritas NetBackup, Visual Basic, WebLogic, WebSphere, Windows Server, Workbench, workflow, Golden Gate

Skills



OEM, Cloud Control, Exadata, ASM, RAC, AIX, RMAN, auditing, backup, Basic, C, C , CCSA, client and server, hardware, consulting, validate data, database applications, database administration, DBA, Database, database development, ERWin, Forms 6, FTP, HTML, HTTP, DB2, IIS, Java, JavaScript, Linux, Mentoring, MS Access, migration, MySQL, Object Oriented Programming, Operating Systems, Oracle, Oracle database, Oracle DBA, DB, Oracle Designer, Developer, PL/SQL, Perl, Perl CGI, processes, programmer, programming, Project lead, Project Management, Protocols, RedHat, Reporting, Storage Area Network, SCO, Servers, scripting, Scripts, Software Engineering, Solaris, MS SQL Server, SQL Plus, Microsoft SQL Server, SQL, SQL Server, SQL*Loader, Sun Microsystems, TCP/IP Networking, TCP/IP, user support, Time Management, Tomcat, troubleshooting, UNIX, UNIX Administration, Unix Shell, upgrades, utilities, Veritas NetBackup, Visual Basic, WebLogic, WebSphere, Windows Server, Workbench, workflow, Golden Gate

Similar Profiles

CREATE PROFILE
Zahid Hussain