NADEEM ALI
Mississauga,Canada
Summary
Position as an Sr. Oracle Database Developer
Overview
24
24
years of professional experience
1
1
Certification
Work History
Oracle Database Developer
TD Bank
10.2021 - Current
- Environment: Oracle 19c RAC large multi-tenant environments, Oracle Exadata, Oracle Data Guard, Oracle SQL and PL/SQL, Unix/Shell scripting, Autosys
- Projects: GAML, FCCM and CRR TM Solution Replacement, OFSAA US and Canada, SAS AML DB2 migration to Oracle for US and Canada
- SAS AML DB2 migration to Oracle for US and Canada - DB2 Migration scripts to export data and validations scripts, Oracle DDL, SQL loader scripts to import data from DB2 to Oracle 19c and provided support to Oracle team to troubleshoot errors/issue
- Created Oracle scripts for tables, partition tables, views, grants, indexes, materialized views, synonyms, functions, procedures and packages
- Created Linux shell scripts to run SQL Loader to import data in Oracle 19c RAC
- Capacity planning and Design Database to migrate from SAS AML DB2 migration to Oracle for US and Canada in development and production database environments
- OFSAA US and Canada - Deploy Oracle Database changes and support daily request to resolve Oracle database issues like add columns, fix data types, add tables, function, procedures and packages, add Oracle range and list partition tables
- Experience with deployed databases security i.e. ensuring appropriate security and auditing controls is in place to meet security and privacy requirements
- Providing Oracle production support and for other database environments working as an Oracle App DBA for multiple AML application databases
- Lead Oracle Developer and App DBA on database migration from DB2 to Oracle DB for Canada AML and database migration from Oracle to Oracle for US AML
- Created Oracle database scripts for tables, partition tables, views, indexes, sequences, primary key, foreign key, procedure, functions, packages, created shell scripts to import data using Oracle SQL loader
- Deployed and maintained Oracle Database Scripts production and non-production database
- Optimize and Improve performance of US and Canada databases using maintenance packages, rebuilding indexes, parallelism, no logging, gathering statistics, writing SQL scripts and packages
Oracle Database Developer
Bank of Nova Scotia
03.2020 - 09.2021
- Environment: Oracle 19c, Oracle Fusion - Forms and Report, Oracle SQL Developer, SQL, PL/SQL, Toad, Linux/Unix shell scripting using scheduler
- Installed Oracle Forms and Reports with WebLogic 12c, migrated existing application on older version to newer version, deployed application on new upgraded Oracle form servlets and report servlets
- Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Experience with deployed databases security i.e. ensuring appropriate security and auditing controls in place to meet security and privacy requirements
- Providing Oracle production support and for other database environments working as an Oracle App DBA for multiple AML application databases
- Linux shell scripting to load and transform data using SQL Loader in Oracle 19c RAC database
Oracle DBA
Allstate Insurance Co of Canada
12.2019 - 03.2020
- Environment: Oracle 19c/12c, OEM 13c/12c, Oracle SQL Developer, SQL, PL/SQL, Toad, Linux/Unix shell scripting using scheduler
- Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Providing Oracle production support and for other database environments working as an Oracle App DBA for multiple AML application databases
- Maintain Production and Non-production multiple Oracle RAC Databases, DB Clone and Data Refresh
- Support ETL application and resolve production and non-production database performance issues
- Deployed database releases in staging and production database environments
- Resolve incidents on daily basis using Service Now tool
Oracle Database Developer
TD Bank
11.2017 - 10.2019
- Environment: Oracle 12c/19c RAC large multi-tenant environments, Oracle Exadata, Oracle Data Guard, Oracle SQL and PL/SQL, Unix/Shell scripting, Autosys
- Projects: GAML, FCCM and CRR TM Solution Replacement, OFSAA US and Canada, SAS AML DB2 migration to Oracle for US and Canada
- SAS AML DB2 migration to Oracle for US and Canada - DB2 Migration scripts to export data and validations scripts, Oracle DDL, SQL loader scripts to import data from DB2 to Oracle 19c and provided support to Oracle team to troubleshoot errors/issue
- Created Oracle scripts for tables, partition tables, views, grants, indexes, materialized views, synonyms, functions, procedures and packages
- Created Linux shell scripts to run SQL Loader to import data in Oracle 19c RAC
- Capacity planning and Design Database to migrate from SAS AML DB2 migration to Oracle for US and Canada in development and production database environments
- OFSAA US and Canada - Deploy Oracle Database changes and support daily request to resolve Oracle database issues like add columns, fix data types, add tables, function, procedures and packages, add Oracle range and list partition tables
- Created Oracle database scripts for tables, partition tables, views, indexes, sequences, primary key, foreign key, procedure, functions, packages, created shell scripts to import data using Oracle SQL loader
- Deployed and maintained Oracle ETL Database and Data ware code for production and non-production database
- Optimize and Improve performance of US and Canada databases using maintenance packages, rebuilding indexes, parallelism, no logging, gathering statistics, rewriting new and existing SQL scripts and packages
Oracle Database Developer
Bell Canada
05.2017 - 09.2017
- Environment: Oracle 19c, OEM 13c/12c/11g, Oracle SQL Developer, SQL, PL/SQL, Toad, Linux/Unix shell scripting using scheduler
- Projects: Bell Mobility Database warehouse
- Linux/Unix shell scripts for Oracle 12c/11g ETL Database Applications, schedule maintenance and hygiene jobs using Unix/Linux utility, defragmentation, rebuild indexes and gathering statistics
- Prepare documentation for Production, SI and UAT Oracle database environment and provided 24X7 support on rotation basis and shadow DBA’s team from CGI
- Developed Oracle triggers, procedures, functions, packages using SQL-PL/SQL with Oracle 10g/11g/12c Databases, performance tuning and optimization, deployment in production and non-production database environments
- Production and Non-Production Database support and maintenance, shell scripting for daily maintenance, troubleshooting issues 24X7
Oracle Database Developer
Bank of Nova Scotia
10.2016 - 04.2017
- RMIT - Group Treasury/Liquidity Risk Development
- Environment: Oracle 19c/12c, SQL, PL/SQL, SQL Developer, Toad, Sun Solaris, Linux, Shell Scripting.
- Projects: SAG-Managing Position feed from various data sources, Filtering, Error reporting, Converting options and equities.
- Shell Scripting: Process control shell script, move files from CTR drop off location to file watcher pickup location, generate sag position extract exception report.
- Oracle Database Optimization and tuning SQL and workflows
- Fund Apps Project: Develop SQL Loader, DDL, DML scripts for necessary data feeds, enrichment, and transformation processes, output will ultimately flow into the vendor application, FundApps
- SAG: Review BRD and developed database and shell scripts for CTR_Epsilon and CTR_CAMRA internal mapping
Oracle Database Developer
Morgan Stanley
06.2015 - 08.2016
- Environments: Oracle 19c/12c/11g PL/SQL, OEM 12c, Linux shell scripting, Green plum DB, Postgres SQL, Toad, SQL Developer, PL/SQL Developer, pg Admin, Autosys, Leela, perforce
- Capital market trading applications responsible for developing enterprise Oracle database applications for a diverse set of businesses including Fixed Income, Equities, Commodities, Investment Banking, Research, and Global Capital Markets.
- Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Providing Oracle production support and for other database environments working as an Oracle App DBA for multiple AML application databases
- Development and production for ETL Database – Oracle Application Development
- Logical and physical data modelling, database schema releases for adding new column and row-based partition tables in QA and production
- Troubleshooting production issues, data warehouse design including OLTP and OLAP
- SQL scripting using PL/SQL, created function using dynamic SQL and complex SQL, tables, partition tables, views, triggers, set up AutoSys job
- Tuned/optimized SQL which greatly improved performance of ETL Database.
- Data migration and set up new Oracle Database, develop application code and logic using PL/SQL
Oracle Database Developer
Ministry of Government Services, Services Ontario
04.2015 - 05.2015
- Environment: Linux, Oracle 12c/11g, Cognos, MS SQL Server, Toad for Oracle, SQL Developer for Oracle, SQL, PL/SQL, MS Visio, ER Win, Oracle Scheduler
- Data Architect and designed Logical (Conceptual) and Physical Data Modelling using MS Visio and ER Win of Accessibility Compliance Report Application as per OPS Enterprise Architecture standards
- ACR application - Oracle database development using SQL and PL/SQL scripts
- Provided development and production support to resolve critical issues, authored SQL script to back up and data cleansing, supported in UAT and production deployment, Optimized and Tuned Oracle 11g Materialized views of ACR project for business reporting, imported data from production into development databases using Oracle 11g import and export utilities to perform testing for accurate results
Oracle Database Developer
CIBC, Consultant
10.2014 - 04.2015
- Environment: Oracle RAC 12c/11g, Unix, Linux, Toad for Oracle, SQL Developer for Oracle, PL/SQL Developer, MS Visio, Toad Data Modeler, MKS Integrity, Attachmate Extra, Developed, maintained and enhancement regulatory Database Applications in Oracle, authored complex SQL queries and PL/SQL packages
- Optimized and tuned SQL for reporting data. Authored SQL, PL/SQL packages for front-end applications. Logical and Physical data modelling.
- Provided DBA support to development team and resolve critical issues.
- ETL (Extract Transform Loading) Coding for Data Stage, DataMart Development, Metadata and application code in Oracle
Oracle Database Developer
BlackBerry (RIM)
01.2006 - 10.2014
- Environment: Oracle RAC 12c/11g/10g, Oracle Exadata, Oracle RMAN, Oracle Enterprise Manager 12c, Oracle forms and reports, Oracle SQL, PL-SQL Developer, Toad for Oracle, Oracle SQL Developer, Linux Shell Scripts and schedule jobs using crontab, Cognos Business Intelligence, Enterprise Architects, MS Visio, Perforce and MKS Integrity
- Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Experience with deployed databases security i.e. ensuring appropriate security and auditing controls in place to meet security and privacy requirements
- Providing Oracle production support and for other database environments working as an Oracle App DBA for multiple AML application databases
- Oracle Enterprise Data Warehouse project:
- Developed Oracle ETL Data warehouse application using tables, external tables, partition, tables, views, materialized views, PL/SQL package to maintain, extract, load and transform data with advanced techniques of direct load and error logging, advance techniques of Oracle with clause, partition pruning and enable high degree of parallelism with no logging option
- Designing Data warehouse components, workflow, staging data, ETL Scripts and SQL Queries, optimize processes using Informatic to increase performance, provided production support to identify and resolve critical issues related to Oracle data warehouse related to application code and administration, assisted Oracle DBA to deploy database code in UAT and production environment
- Analyzed and tuned a variety of management report queries and cpu-intensive batch jobs, reductions in processing time resulted in visible improvements to overall performance during peak usage periods
- Relay Logging Database (BlackBerry Data Services) has transactional and analytical database: logical and physical data modelling. Designed data warehouse (500 TB in size) using Oracle SQL, PL-SQL, Linux shell scripts.
- ETL(Extract Transform Loading) Coding for Data Stage, DataMart Development, Metadata and application code in Oracle for tables, external tables, partition, tables, views, materialized views, PL/SQL package to maintain, extract, load and transform data, provided on going database application support to resolve critical production issues and deployed application code for future enhancements, managed and developed sizeable Oracle application with numerous tables, procedures and view requires PL/SQL development to load data into tables, performed advanced calculations, normalize data and write queries in order to obtain accurate and timely data
- Monitored, Managed and Improved performance using Oracle Enterprise Data warehouse using Oracle Enterprise Manager 12c. Automated Database Maintenance Task Management using Oracle Enterprise Manager Database Control on Oracle 12c/11g
- Used Oracle RMAN for Backup, Recovery, Integration with Oracle secure backup and space consumption during backup with file multiplexing and backup-set compression.
- Performed ongoing tuning of PL/SQL packages and procedures used by custom-built applications deployed across multiple sites
- Data Architecture, logical and physical data modelling, SQL scripting, deploy code in QA and production, bug fixes, BI/Reporting SQL and PL/SQL packages, ETL scripting and coding for Data warehouse/DataMart database including OLTP and OLAP using star schema and snowflakes modelling techniques
- Provided after-hours support for critical production issues relating to PL/SQL application code, DML error logging and to improve performance of database using parallel DML and no logging options
Oracle Database Developer
ZAB Solutions
01.2002 - 01.2005
- Environment: Oracle Developer 6i/9i, Oracle 10g/9i, PL/SQL Developer, Linux Shell Scripts and schedule jobs using crontab, ER Win, MS Visio
- Ensured database development efforts adhered to company standards in terms of documentation, procedures, and software development methodologies.
- Developed sizeable Oracle application with numerous tables, procedures and view requires PL/SQL development to load data into tables, performed advanced calculations, normalize data and write queries to obtain accurate and timely data
- Analyzed requirements, logical and physical data modelling, designed databases and developed software with advanced knowledge of PL/SQL using Oracle Forms and Reports
- ETL (Extract Transform Loading) Coding for Data Stage, Datamart Development, Metadata and application code in Oracle for tables, external tables, partition, tables, views, materialized views, PL/SQL package to maintain, extract, load and transform data
- Assisted in the development of processes, procedures and jobs to monitor tasks required to maintain database and provided valuable feedback on technical issues
- Fulfilled DBA responsibilities for internal and external database environments.
Education
Master of Computer Science -
University of Karachi
PakistanBachelor of Science - undefined
University of Central Florida
Florida, USADiploma in Oracle - undefined
Oracle Education Services
PakistanCertification
- Oracle 10g Architecture/Admin Oracle University, Canada
- Oracle 11g SQL-PL/SQL Oracle University, Canada
- Oracle SQL Optimization Oracle University, Canada
- Oracle Certified in SQL/PL-SQL and DBA
- Oracle Database 11g: Administration Workshop II Release 2
- Oracle Grid Infrastructure 11g: Manage Cluster ware and ASM Release 2
- Oracle Database 11g: RAC Administration Release 2 NEW
- Oracle Exadata Database Machine Administration Workshop
Overview
- 5 Years Experience with TD Bank, Canada - Oracle 19c Database Developer
- 2 Years Experience with Bank of Nova Scotia, Canada - Oracle 19c Database Developer
- 9 Years Experience with BlackBerry, Canada - Oracle Database Developer
- Master’s degree in computer science
- Bachelor of science in Engineering, USA
- Over Fifteen-year experience with Oracle 19c/12c/11g Oracle Database Developer, Developed ETL Data ware and Databases, database design and data architecture. Maintain and support existing applications by using a standardized methodology as required with the preparation of status reports, testing plans as well as writing technical documentation along with writing, modifying, integrating and testing software code
- Over Fifteen-year experience of data architecture, design logical and physical data modelling, developing application and code, deployments, data migration and managing of Oracle database application code using external tables, partition tables, triggers, views, materialized views with Optimized techniques of PL/SQL using procedures, functions and packages
- Five years’ experience in Oracle Forms and Reports
- Team player, detail-oriented with excellent written and communication skills
Timeline
Oracle Database Developer
TD Bank
10.2021 - Current
Oracle Database Developer
Bank of Nova Scotia
03.2020 - 09.2021
Oracle DBA
Allstate Insurance Co of Canada
12.2019 - 03.2020
Oracle Database Developer
TD Bank
11.2017 - 10.2019
Oracle Database Developer
Bell Canada
05.2017 - 09.2017
Oracle Database Developer
Bank of Nova Scotia
10.2016 - 04.2017
Oracle Database Developer
Morgan Stanley
06.2015 - 08.2016
Oracle Database Developer
Ministry of Government Services, Services Ontario
04.2015 - 05.2015
Oracle Database Developer
CIBC, Consultant
10.2014 - 04.2015
Oracle Database Developer
BlackBerry (RIM)
01.2006 - 10.2014
Oracle Database Developer
ZAB Solutions
01.2002 - 01.2005
Bachelor of Science - undefined
University of Central Florida
Diploma in Oracle - undefined
Oracle Education Services
Master of Computer Science -
University of Karachi