Hosein Soleimani

** ******* *****, ***** **** Toronto, Ontario M2N 2W7

Cell : 416-***-**** Email : ac4dxu@r.postjobfree.com http://ca.linkedin.com/in/hoseinsoleimani/

Profile Summary

• Senior Oracle certified(OCA) and SQL SERVER DBA, PL/SQL and T-SQL developer with more than 10 years of experience in database administration, tuning,design, development and support, Data Conversion,,OLAP,OLTP, Data Warehousing,BI,ETL, database modeling,reverse engineering legacy databases

• Hands-on experience in Unix-Linux, shell and Perl scripting

• Practical experience in data modeling and analysis

• Languages : English (Full professional proficiency), French (working proficiency), German(Familiar),Persian Technical Strengths

Database: Oracle 10g & 11g & 12C administration,tuning and development, RMAN,OEM,Oracle Data Guard, RAC, Delphix,DB2,SQL Server, Sybase ASE, Mysql

OS Platforms: Redhat Enterprise Linux, Cent OS, Solaris 10, Windows Infrastructure and Database Tools: Informatica,Datastage,Autosys, SVN, Perforce, PL/SQL developer,Toad,OEM Scripting: Bash, Perl

Development languages: PL/SQL, T-SQL,XML,Change Management,Code Management EDUCATION

BS in Computer Engineering majoring in Software Payam Noor university, Tehran, Iran 2006 Professional Trainings

• Oracle 11g Administration Workshop 1 (certified) Asre Danesh Afzar - Tehran, Iran 2011

• Oracle 11g Administration Workshop 2 (certified) Asre Danesh Afzar - Tehran, Iran 2012

• Oracle 11g Performance Tuning (certified) Asre Danesh Afzar - Tehran, Iran 2012

• LPIC 1 Anisa Institute - Tehran, Iran 2011

• ITIL Foundation version 3 (certified) Quint Institute- Tehran, Iran 2011 Professional Experiences

Scotia Bank Toronto,Canada Sept 2017- Jan 2018

Sybase and ETL Developer

Responsibilities:

• Working as Sybase/ETL Developer on Enterprise Repository Risk Management Databases

• Tuning ETL processes to enhance performance and efficiency

• Preparing QA and PROD release packages and runbooks

• Developing new ETL processes and changing legacy ones

• Developing back-end T-SQL codes for front-end reports BNP Paribas Bank Montreal,Canada May 2017- Oct 2017 (6 Months) Oracle 12c DBA on OFSAA databases

Responsibilities:

• Working as Oracle administrator and tuning adviosr on Enterprise Data Architecture, Data Warehouse, Data Marts,Data Flow (LANDING,ETL,,STAGING,OFSAA,DW,BI) as per Oracle best practices.

• Scheduling Autosys and Crontab jobs for DB maintenance and ETL routines

• Deploying Code and Data between DEV,QA,PROD environments and preparing release runbooks

• Developing scripts to automate ETL and data loading processes

• Developing ETL and Data Warehouse routines

• Wide variety of Oracle Performance tuning tasks (query tuning, Indexing, partitioning, storage tuning, instance tuning,re-setting Oracle Parameters,etc)

• Transforming Informatica transformation to PL/SQ L scripts and vice versa when necessary

• Preparing PL/SQL scripts for Oracle DB maintenance and data migration

• Instructing and advising Development, BI, DW, Hyperion, Risk Management, ETL(Informatica) teams on how to write well-performing queries and mappings

• Changing legacy database objects to embed new requirements

• Implementing Security measures

CGI Co. Montreal,Canada Jan 2015 - May 2017 (2.5 years) Consultant for 3 clients:

DB2 DBA - Consultant Jun 2016 - May 2017 (12 Months) Morgan Stanley

Responsibilities:

• Working as DB2, Sybase administrator and developer

• Monitoring QA database regarding various aspects (security, capacity, storage, connectivity, etc.);

• Optimizing database and its objects to achieve a better performance.

• Developing data migration and database infrastructure maintenance PL/SQL, Shell and Perl scripts.

• Documenting the release turnovers, database changes and maintenance procedures

• Deploying objects and synchronizing databases across TEST,DEV,QA and PROD environments Senior Production Support - Consultant Jul 2015 - May 2016 (11 Months) Société Général Bank

Responsibilities:

• Working as Unix Shell script developer

• Monitoring Unix servers regarding various aspects (performance, storage, connectivity

• Providing 24 X 7 rotation on-call support on the applications connecting to global exchanges

• Collaborating with counterpart teams in Europe, North America, Asia to deliver a round-the-clock support on capital markets and trading applications

• Implementing Unix and applications changes

• Participating in disaster recovery tests

• Documenting the infrastructures including servers, databases, applications and the daily and weekly support procedures

Achievements

successfully transferred support center from Chicago to Montreal in a challenging teamwork Sybase DBA and Developer - Consultant Jan 2015 - Jun 2015 (6 Months) Deutsche Bank -32-64 upgrade remediation project

Responsibilities:

• Working as T-SQL developer in Deutsche Bank 32-64 remediation project

• Reviewing complicated procedures in Sybase ASE to identify the affected ones and spot the required code changes in them and any other objects across 9 databases

• Preparing T-SQL scripts for implementation and rollback routines in the project

• Performing various test scenarios in DEV and UAT environments for timing and capacity measurement

• Being in close contact with application team to identify,prepare and implement changes on both application and database ends.

• Performing performance tuning in T-SQL code for quicker and more traceable execution of changes

• Managing development, test, deployment code in SVN Achievements

Successfully completed 32-64 bit remediation project across 9 big and voluminous databases

Oracle/Sql Server DBA Mar 2012 - May 2014 (26 Months) Tecnotree Co. Tehran,Iran

Responsibilities

• Preparing Oracle PL/SQL,T-SQL scripts for required provisioning activities on big tables having more than 500 million records and preparing Unix shell scripts to extract requested reports from DB and system

• Implementing business rules in database through database objects : procedures, functions, triggers, etc.

• Defining and implementing ETL processes to feed data from various resources and databases to Data Warehouse

• Migrating Data between Oracle and SQL SERVER

• Maintenance of Enterprise Data Warehouse and generating the requested BI reports

• Monitoring Oracle DBs on RAC environment to proactively take action for any lock, performance,security issue

• Creating any newly required databases after communication with QA and DEV teams

• Deploying releases to Test, QA and Production environments under scheduled downtimes and being responsible for starting and stopping all required databases

• Using oracle features like AWR,ADDM,ASH reports for performance tuning and troubleshooting

• Migrating data and objects across databases upon request of DEV and QA teams and deploying releases to production databases

• Implementing the pre-defined backup policy on the databases Oracle/Sql Server DBA Mar 2010 - Mar 2012 (26 Months) SepidSystem Co. Tehran,Iran

Responsibilities

• PL/SQL,T-SQL programming

• Designing databases of Biometric solutions applications

• Preparing new databases and allocating the required resources, implementing the security measures on them

• Writing PL/SQL and T-SQL routines to convert data between SQL SEVER and ORACLE and other data sources

• Implementing business rules in database through development of new database objects and also changing existing long and complicated procedures, functions and triggers in ORACLE and SQL SERVER

• Monitoring and configuring Oracle regarding performance,security, storage aspects

• Writing the embedded queries in Crystal Reports for generating the requested reports for clients

• Oracle performance and SQL tuning using OEM or relevant Oracle provided tools

• Providing development team with required advices to enhance database and applications performance like partitioning,creating new indexes, changing them and modifying SQL queries in application and reports

• Performing database refreshes, cloning, backup, and recovery using RMAN and Oracle Dump

• Implementing Time Attendance databases replication using Oracle Data Guard Oracle/Sql Server DBA Mar 2007 - Mar 2010 (3 Years) SamanehSazMorvarid Co, (SIDA Group) Tehran,Iran.

Responsibilities

• PL/SQL programming and implementing business on database side

• Coding Java for data conversion processes

• Designing physical and logical structures of Time Attendance Database

• Converting data from various sources and legacy systems and SQL SERVER to Oracle

• Installing and configuring Unix-Windows-Oracle servers and taking required dumps and backups

• Helping Dev team to write better queries in terms of performance

• Monitoring database performance and taking required action to improve it.

• Having the responsibility of taking backup, dump

Contact this candidate