ALI GILLANI
Winnipeg,Canada
Summary
To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Server Support – DBA(Operations)
Canada Life Assurance
08.2015 - Current
- Good knowledge of RDBMS technologies such as Oracle Exadata, SQL Server, DB2 and Sybase
- Operational DBA, On Call support on rotational shift at least 10-11 weeks in years, provide database support to keep databases up and running 24/7
- Queue Manager to assign, approve or rejects tickets in Service Now /ITSM
- Perform day to day database administrations task such as install patch, upgradate, backup, recovery, performance and tuning, and maintain database security
- Configure, trouble shoot and patch in rolling forward fashion in High Availability technologies on various DBMS such as DB2 ‘HADR’, SQL Server ‘AlwaysOn’ and RAC/Dataguard on Exadata
- Write Batch scripts to generate audit reports about admin accounts on Windows, monitor filesystem utilization on AIX and Linux operating system, Oracle tablespace reports on 11g,12g, 18c and 19c also DBA’s standard maintenance jobs in AIX/Unix
- Install Oracle 11g,12c, SQL Server and DB2
- Cross-platform migration of SQL Server, DB2 and Oracle databases
- Create custom Roles to manage access
- Familiar with Oracle imp/exp utilities technologies
- Create ad-hoc triggers to capture logins activities on SQL Servers
- Coordinate with business to create change request and provide solutions for day to day or long-term business requirements
- Analyzing business needs, formulating and implementing strategy
- Testing the compatibility of database with the business structure
- Operational experience with different OS technologies such as Linux/AIX and Windows.
Tech Associate
The Source (Bell) Electronics Inc
04.2014 - 09.2014
- Provide solution for operating system problems
- Promote wireless devices
- Explain operating systems configuration on various machine.
Education
Diploma in Information Technology -
NCR, I.T Institute
Karachi, Pakistan01.2001
Bachelor of Arts -
University of Karachi
Karachi01.1993
Skills
- Server Support – DBA(Operations)
- Good knowledge of RDBMS technologies such as Oracle Exadata, SQL Server, DB2 and Sybase
- Operational DBA, On Call support on rotational shift at least 10-11 weeks in years, provide database support to keep databases up and running 24/7
- Queue Manager to assign, approve or rejects tickets in Service Now /ITSM
- Perform day to day database administrations task such as install patch, upgradate, backup, recovery, performance and tuning, and maintain database security
- Configure, trouble shoot and patch in rolling forward fashion in High Availability technologies on various DBMS such as DB2 ‘HADR’, SQL Server ‘AlwaysOn’ and RAC/Dataguard on Exadata
- Write Batch scripts to generate audit reports about admin accounts on Windows, monitor filesystem utilization on AIX and Linux operating system, Oracle tablespace reports on 11g,12g, 18c and 19c also DBA’s standard maintenance jobs in AIX/Unix
- Install Oracle 11g,12c, SQL Server and DB2
- Cross-platform migration of SQL Server, DB2 and Oracle databases
- Create custom Roles to manage access
- Familiar with Oracle import/export utilities technologies
- Create ad-hoc triggers to capture logins activities on SQL Servers
- Coordinate with business to create change request and provide solutions for day to day or long-term business requirements Analyzing business needs, formulating and implementing strategy
- Testing compatibility of database with business structure
- Operational experience with different OS technologies such as Linux/AIX and Windows
Certification
- Oracle University (OCP– Certification), IZO-052 Oracle Database 11g: Administration I, 93%, 2015
- IZO-051 Oracle Database 11g: SQL Fundamentals, 91%, 2014
Training
- Oracle12c, DB2 and SQL Server, 2016
- Exadata training from Oracle, Toronto, 2021
- In-place training at The-Great West Life Assurance, 2014
- Oracle University (OCP– Certified Training), Database Administrator Track 11g Training, 2013
- Redhat University (RHCE–Certified Training), Redhat Certified Technician Training, 2013
Timeline
Server Support – DBA(Operations)
Canada Life Assurance
08.2015 - Current
Tech Associate
The Source (Bell) Electronics Inc
04.2014 - 09.2014
Diploma in Information Technology -
NCR, I.T Institute
Bachelor of Arts -
University of Karachi
Similar Profiles
Hoi Fung (Tom) NgHoi Fung (Tom) Ng
Manager, Reinsurance Pricing at The Canada Life Assurance Company (Canada Life)Manager, Reinsurance Pricing at The Canada Life Assurance Company (Canada Life)
James DrouinJames Drouin
Software Developer at Canada Life Assurance CompanySoftware Developer at Canada Life Assurance Company
Marilyn Jarrett-McFarlaneMarilyn Jarrett-McFarlane
Sales Support Associate at Canada Life Assurance CompanySales Support Associate at Canada Life Assurance Company
Ajitesh SandhuAjitesh Sandhu
Customer Service Specialist at Canada Life Assurance CompanyCustomer Service Specialist at Canada Life Assurance Company
Tanvinder SinghTanvinder Singh
Parts Counter Sales Person at Fort Garry IndustriesParts Counter Sales Person at Fort Garry Industries