Resume

Sign in

Oracle Manager

Location:
Toronto, ON, Canada
Posted:
December 29, 2019

Contact this candidate

Resume:

Salman Siddiqui

*** ******** ****, ***********, ** L5W0C5 E-mail:ada55r@r.postjobfree.com

Ph: 416-***-****

Summary

Over 18 years of Oracle 8i, 9i, 10g, 11g and 12c Database Administration experience in Telecom & Energy sectors, Public & Private organizations, Manufacturing, Financial and Services Industries.

Over three years of experience in Database Administration of SQL Server (2008, 2012 and 2014).

Well diversified experience in Installation, Configuration, Integration, Administration, Optimization and Support of MSSQL Servers and Oracle (RAC, Clustered & Standalone) Database Systems & technologies in OLTP and DSS on UNIX / Linux / Windows Platforms.

Extensive experience of trouble shooting and resolving complex database (SQL and Oracle) problems and providing improved database performance by tuning of database Instance, queries and applications in Standalone, Clustered and RAC environments

Extensive experience of planning and implementation of recovery strategies with RMAN Backup/Recovery and 3rd parties MM Layers, replication, flashback & Data Guard technology

Well versed and actively involved in Logical and Physical database design, configuration, upgrade, production planning, sizing, security management, performance tuning, backup/recovery procedures, and overall project management (SQL Server and Oracle).

Developed many Unix Shell and Windows/DOS Scripts specially for RMAN backups, Data pump export/import and Database Monitoring jobs

Strong Academic and Training foundation, with a Master degree in MIS and completed a number of directly- related professional development courses and certifications

Excellent interpersonal and communication skills; a well-organized, self-motivated team player and team leader; and a quick learner of new technologies

Education

M.B.A in MIS - University of Dallas, TX, USA

B.S in Finance - University of South Alabama, AL, USA

Work Experience

Scotia Bank (Aug 2017 – Present), Toronto, Canada

Senior Database Administrator

Installed, Configured and Administered Oracle 12c Database Servers on Unix and Linux platforms including High Availability Oracle RAC for OLTP and DSS Applications and SI with HAS.

Created and Administered 12c Pluggable database.

Performed upgrade of RAC and non-RAC Oracle from 11g to12c Databases

Planed and performed the required CPU/PSU patching to various Oracle RAC and non RAC environments.

Converted Single instance to RAC database.

Created and administered physical standby using dataguard broker.

Configured Active Data Guard for physical standby databases.

Tested and supported failover and switchover of Standby Databases during Disaster Recovery using dg broker.

Analyzed database performance utilizing Oracle ADDM, AWR, OEM and Ignite.

Performed cloning and refresh of Database from PROD environment to SIT/UAT/DEV/TEST environment using RMAN Duplicate database command.

Involved in Setup the Oracle Wallet for database connections and Encryption Functions

Implemented Oracle TDE (Transparent Data Encryption) in all of our new/existing databases for Tablespace encryption

Created Tables that Contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption

Installed and configured OMS 12c and 13c (include single and multi-OMS with SLB).

Assisted in deploying OMS 12c/13c agents on production and development database servers.

Applied PSU patches on OMS and agents.

Created software image and database template in OEM.

Created Metric Extension, Monitoring Templates and Incident Rules in OEM

Exported/imported software image from one OMS to another.

Provisioned oracle database (RAC, SIASM) using OEM

Installed and configured Oracle Goldengate for replication

Monitored and Resolved issues in conflicts between the target and source database in Golden Gate.

Designed and implemented full and incremental backup policies and procedures in SQL Server

Responsible for setting up security, and providing user access to SQL Server instances and objects.

Worked on building and supporting highly available clusters using ALWAYSON configuration

Configured and supported Log Shipping and Database Mirroring strategies to support application team

Performed database refresh in SQL Server for application team

Provide DBA support and technical expertise for multiple applications in development, test, QA and production using Oracle and SQL Server environments.

IBM Canada (Jan 2015 –Jun 2017) Toronto, Canada

Senior Database Administrator – Consultant

Clients : Celistica, Govt of Alberta, Economical Insurance, Desjardins

Installed, Configured and Administered Oracle 12c, 11g Database Servers on Unix, Linux and Windows platforms including High Availability Oracle RAC

Performed Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases

Migrated 11g Databases from Non-ASM to ASM.

Performed application and database tuning, worked with Developers helping optimized SQL performance via AWR/ADDM, ASH, Advisory services, Statspack, Oracle Waits &, OS Statistics

Configured Oracle RMAN Backups using Tivoli Storage Manager.

Worked on Planning and implementing of DR & high availability solutions using Oracle 11g /12c Standby Database using Data Guard.

Configured and setup Data Guard Broker for switchover.

Experienced in switching primary database to snapshot standby for reporting and testing purpose and back to physical standby using Data Guard.

Involved & performed Change Requests for PRD and TEST major database changes and various database housekeeping activities.

Followed change control, Information Security and IT audit standards and documented procedures for any schema setup and DBA activity.

Provisioned Oracle GRID/DB through OMS.

Lead projects of new database builds, upgrades and migrations; Mentor junior and new team members

Member of a team providing 7 X2 4 Support, troubleshooting for Production environments, performed Daily/Weekly and expedited Changes to fix the Database issues/problems and resolved the incidents

Rogers (Mar 2005 – Jan 2015) Toronto, Canada

Senior Database Analyst

Dedicated primary DBA for the numerous production instances.

Installed, created and configured databases in 10G and 11G.

Engaged in building and supporting 10g and 11g RAC environments with ASM (automatic storage management) on AIX and HP UNIX, where production DB size is in terabytes.

Upgraded the databases from 9i to 10G and later 10G to 11G.

Configured Oracle RMAN Backups using Veritas Netbackup

Developed, tested and implemented backup and recovery procedures, policies and disaster recovery plans using RMAN, cold/hot backup and export/import techniques to ensure 0% data loss.

Worked with the development teams to determine the storage requirement and submit the storage document to UNIX team for hardware availability.

Created and suggested table partitions in the reporting and data warehouse databases. Performed day-to-day DBA work, such as creating users, roles, indexes and tablespaces, monitoring UNDO/TEMP usage, applying database patches, rebuilding indexes and generating stats on the tables and indexes.

Cloned and refreshed the databases as required.

Created and configured standby database using data guard.

Worked with Oracle Support to troubleshoot bugs and critical database issues.

Also involved with implementation of Data Archival strategy using partitions and transportable tablespaces.

Installed, configured & administered non-Clustered and Clustered MS SQL Server 2008 and 2012 instances and databases.

Performed backup and restore of MSSQL database from PROD to DEV/TEST environments.

Detached and attached SQL Server databases from one instance to other.

Helped developer in refreshing objects in SQL Server databases

Provide 24x7 on-call support of Production databases (Oracle and SQL Server).

Vartec Telecom (Dec 01 – Jan 2005) Dallas, USA

Database Administrator II

Primarily provide Database administration of ten databases running on different Oracle versions that include 8, 8i, 9i.

Regularly perform resource, storage and space management/planning, performance tuning, capacity planning, installation/Upgrade and administration of the databases. Involved with testing, maintaining and implementing backup and recovery strategies, including disaster recovery (DR) and High Availability (HA) planning.

Perform routine maintenance work such as monitoring data, index, rollback/UNDO and temp tablespaces, analyzing indexes and tables, recreating indexes and gathering statistics.

Developed PL/SQL procedures for database loading and refreshing.

Helped developers in writing efficient code, analyzed SQL Explain plan

Performed tuning of the databases using STATSPACK and OEM.

Carry out database, application or SQL level tuning when required; also monitor resource utilization of the database and application servers.

Involved in a project that involved migration of ten Oracle 8i databases to 9i on Unix platform.

Involved with the DR planning and implementation of the databases, using Oracle Data Guard.

Also write code in SQL and PL/SQL as per the need.

Developed and implemented backup and recovery strategy for the production databases. This involved Oracle Standby Database implementation.

Handled capacity planning, space/growth management and forecasting to ensure smooth operation

Operating Systems

HP-UNIX, AIX, SUN Solaris, Linux (Red Hat and SLES), Windows, Novell Netware

Database and Tools

Oracle (7, 8, 8i, 9i, 10g, 11g,12c), Grid Infrastructure, Oracle Grid Control, ASM, Oracle Enterprise Manager (12c, 13c), RMAN, Exadata, Oracle Golden Gate, Quest Spotlight, TOAD, SQL Navigator, SQL Loader, SQL Server (2008, 2012, 2016), DPA (Ignite)

High Availability Solutions

Oracle Grid Infrastructure, Oracle Clusterware 12c, 11g, Oracle standby/Data Guard, SQL Server (Clustering, Log Shipping, Database Mirroring, Replication, AlwaysOn)

Certifications

Oracle Certified Professional (OCP) in 9i, 10g and 11g

Courses

Oracle 10g, 11g & 12c : New Features

Oracle 10g : RAC for Administrator (Release 2)

Oracle 9i: Performance and Tuning

Teradata Physical Database Design

Teradata Warehouse Administration

Golden Gate (Basic and Advanced)

Security Clearance available



Contact this candidate