Professional summary

Seasoned Senior Database Administrator/ Developer with extensive expertise in Oracle DB management, architecture, installation, upgrades, and troubleshooting. Possesses over 20 years of experience in Oracle DB support, scripting, debugging, and collaborating with stakeholders. Adept at managing databases, resolving coding issues, and optimizing performance across diverse industries.

Core Skills

Database Management: Oracle (12c, 19c, 21c+), SQL Server, PostgreSQL, MS SQL, MongoDB

Programming Languages: SQL, PL/SQL, T-SQL, PL/PgSQL, Java, HTML, XML, JSON

Methodologies: Agile, BI, ETL, ELT, SCRUM

Tools: SQL Server SSIS, SSMS, Oracle Toad, SQL Developer, Amanda, JIRA, SVN, GIT

Administration: Backup and recovery, optimization: Database admin,

Operating Systems: Windows, Linux, UNIX Shell Scripting

Education and Qualifications

Master in Computer Science

Post Graduate Diploma in Computer Science and One year Diploma in Computer Science

Project Management Professional (PMP), Effective 2021

Oracle PL/SQL Certified Associate, Effective 2000

Oracle Application Developer Certified Professional, Release 2, Effective 2001

Oracle Forms and Reports Certified Professional, Effective 2001

Oracle Certified Java 6 Programmer

Oracle certified Database Administrator, Effective 2006

Experience

System Analyst (PL/SQL) - Independent Contractor, Apr 2023 – Present

Alberta Blue Cross (Remote)

Tools used: Oracle DB, SQL, PL/SQL, SQL Server, Java, GIT, Agile methodology, Confluence

Conducting system study and coordinating with team members for System Design

Translating Business documents into technical specifications

Write efficient and complex queries against large data sets

Maintain database of large data to store, process used for reporting and analysis

System Analysis, Database Development and Application Support

Specialty Developer (PL/SQL) - Independent Contractor, Jun 2021 – Feb 2023

Canadian Imperial Bank of Commerce – CIBC Bank

Tools used: Oracle database, SQL Server database, Unix Shell Scripting, ETL

Interface with business owners and IT to prioritize improvement initiatives

Coordinating with different stakeholders to gather Anti Money Laundering data

Mapping client requirements and providing ETL solution

SQL (doing your own development as opposed to deploying someone else's scripts)

Extensive development and performance tuning and writing queries (most important)

Business System Analyst (PL/SQL) - Independent Contractor, Jul 2021 – Jun 2022

Ontario Municipal Employees’ Retirement System - OMERS

Tools used: SQL, ETL. Agile, Scrum, sprint, Visio, Confluence, JIRA, GIT, Version Control

Analyze legacy code and data model and provide data integration and migration solutions

Understand and document legacy system processes and suggest process re-engineering

Emphasize on ERD to support logic, UI screens, reports, data integration and migration

Ensuring processes and standards adherence, improvement and proliferation according to the industry best practices

Process Automation Architect, Jan 2021 – Jul 2021

StelCo (Steel Company of Canada)

Tools used: Oracle RDBMs, SQL, PL/SQL, Forms and Reports 12c, WebLogic Server

Develop specifications, design and analysis documentation for digitizing processes

Migrating data from legacy systems and development of new applications

Align automation processes, tools, and strategies with business goals.

Provides database support by coding, responding to user questions, and resolving problems

Oracle ETL / PL/SQL Developer - Independent Contractor, Aug 2018 – Dec 2020

City of Toronto

Tools used: Oracle RDBMs (12c, 19c), SQL Server, JSON, XML, ETL, APEX, GIT and Amanda

Writing complex database packages for ETL batch processing using collections, bulk processing

Designing distributed database for Microservices and generating JSON/XML with SQL Queries

Data Modeling, designing and DB coding for public safety websites

Created Materialized Views and partitioning tables for performance reasons

Indexes, partitions, parallelism, storages and query optimization

Oracle Application Developer - Independent Contractor, Apr 2018 – Aug 2018

City of Mississauga

Tools used: SQL, PL/SQL, Oracle Forms (10g, 11g), Oracle Apex and Oracle WebLogic Server

Assisted in third level support of systems and applications once delivered into Production

SQL query tuning and optimization using explain plan and optimizer hints

Worked with team to achieve timely resolution of all production issues

Worked with team to achieve timely resolution issues meeting

Rebuild Oracle Reports into OBIEE 12c

Oracle Forms and Apex Developer - Independent Contractor, Jan 2018 – Mar 2018

Ministry of Natural Resources and Forestry, Ontario

Tools used: SQL, PL/SQL, Oracle Forms (10g, 11g), Oracle WebLogic Server, DB2, Oracle APEX

Maintained legacy systems developed in Forms and Apex

Improved the performance of the application by rewriting the SQL queries

Provided troubleshooting assistance and technical support to end users and developers

Oracle Application Developer - Independent Contractor, Jun 2017 – Dec 2017

Bank of Montreal, Toronto

Tools used: SQL, PL/SQL, Oracle Forms (11g, 12c), UNIX Shell Scripting, Proc *C, PL/SQL Developer, GIT

Collaborated with Business Analysts and Business Partners on requirements and solution design

Provided estimates and prepared technical specifications based on functional specifications

Performance tuning for SQL queries, PL/SQL and Database.

Application Developer (Enterprise) - Independent Contractor, Sep 2016 – Jun 2017

Computer Methods, North York

Tools used: SQL, PL/SQL, Oracle Forms (11g, 12c), ADF, Jasper reports, Java, JDeveloper, PVCS, SVN

Wrote code using PL/SQL, Oracle Forms, Reports, ADF Framework and Java

Participate in project and team meetings interacting and collaborating with team members

Rewrote SQL queries to improve the permeance after analyzing using executions plans

Senior Oracle Fusion Middleware Developer - Independent Contractor, Aug 2014 – Jun 2016

Ministry of Municipality, Oman

Tools used: SQL, PL/SQL, Oracle Forms (11g), APEX, Java, WebLogic Server, UNIX, Linux, MySQL

Designed, code and maintain Oracle Systems based on established standards

Analyzed, troubleshoot database design and system issues

Prepared functional and technical documentation

Assistant Manager/Programmer Analyst - Independent Contractor, Dec 2012 – Aug 2014

Riyadh Bank, Saudi Arabia

Tools used: SQL, PL/SQL, Oracle Forms, WebLogic Server, ETL, PL/SQL Developer, ER WIN, ER Studio

Working with other functional teams, including Business and IT to gather requirements

Data modeling ODS to support different banking channels like ATM, WEB, Mobile, IVR etc

Developed loaders, import and export between databases and provided support for SIT, UAT and production.

Database Administrator, Aug 2010 – Dec 2012

Science and IT Department, Government of Pakistan

Database used: Oracle, MySQL, MS Server

Implement and enforce security for all the databases and ensure integrity of the databases

Perform ongoing tuning of the databases and plan and implement backup and DR using RMAN

Perform database re-organizations as required to optimize performance

Database Administrator, Dec 2009 – Aug 2010

United Nations Development program, Pakistan

Tools used : Oracle Database, SQL, PL/SQL, Oracle Forms, Toad, SQL Developer, Esri ArcGIS

Took part in database logical and physical designing

Managed schema objects, such as tables, indexes and views

Carry out day-to-day Database Administration, integration, multi-tier configuration and security

Senior Software Engineer / Senior Oracle Developer, Feb 2008 – Aug 2009

Emirates Airline, Dubai, UAE.

Tools used: SQL, PL/SQL, Oracle Forms, Toad, SQL Developer and PL/SQL Developer, Explain Plan

Handled faults included assignment, analysis, investigation, resolution, tracking and escalation.

Assisted senior management in budgeting, estimation, review of SLAs and RFPs.

Analyzed problems and took necessary action to resolve issues.

Senior Software Engineer, Apr 2007 – Feb 2008

Federal Board of Revenue, Pakistan

Tools used: SQL, PL/SQL, Oracle Forms, Toad

Collect and document user's requirements and develop logical / physical specifications

Worked on distributed database and Oracle Replication

Administer and maintain the Oracle Internet Application Server (10gIAS).

Oracle Database Administrator/Senior Software Engineer, Mar 2005 – Apr 2007

Digital Processing Systems and associated with Key Food Confidential Stores, New York

Tools used: Oracle Database, SQL, PL/SQL, Forms

Converted the old system running on AS400 to a new environment of Oracle.

Design, coding, implementation and maintenance of thin client applications.

Create stored procedures, packages and functions

Contact this candidate