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