Jimmy Abraham

  • Senior Database Administrator
  • Ontario, CA
  • Member Since Apr 23, 2023

Candidates About

 

Jimmy Abraham

                                                            IT Database Manager

Profile:

·         Team Leader & People Manager with extensive experience (17 years of IT Experience)  in ITIL Standards like Problem & Incident management (RCA), Change Management, Service Management, Performance Management, Project Management, Relationship Management, Configuration & Release Management and IT Auditing, Infrastructure Management & Operations in a very complex Tier IV Data Centre and with almost all clients

·         Expertise in handling various Oracle Database and Application Migration & Patching Projects across different platforms

·         Skilled Oracle Professional with over 15 years’ experience in the technology field where activities included in-house and client site Production Database Administration (Oracle 12c, 11g, 10g, 9i, 8i) Oracle Application (Oracle EBS) and low level System Administration

·         Proven abilities in building database environments for maximum performance, maximum availability, providing effective backup and recovery strategies

·         Expert in developing policies and procedures for cost reduction, improved efficiencies and securities

·         Excellent working experience in Solaris, Linux and Windows based Systems

·         Good knowledge in Web Applications, Weblogic Server and Veritas Products (File System, Volume Manager, OS Clustering and Netbackup)

·         Strong leadership, communication, and organizational skills

·         Experience in supporting different clients in Government and Federal Government Sectors, including Municipalities, Hydro, Telecom, Oil & Gas, Consulting, Food & Agriculture.

Technical Skills:

Database Systems           : Oracle 12c, 11gR2, 11gR1, 10gR2, 10gR1, 9i, 8i, Cassandra, MS SQL

ERP Systems                      : Oracle R12, 11i, JDE Xe One World, JDE Enterprise One 8.11, SAP

High Availability                                : Oracle RAC (11gR2, 11gR1, 10gR2, 10gR1), CRS, Grid, Data guard, ASM,

                                                  Goldengate, HACMP, Cloud.

Backup Tools                      : RMAN, Tivoli, Networker, Veritas Netbackup, BCV, Flashcopy

DBA Tools                            : Oracle EM Grid Control (12c, 11g, 10g), Statspack, Toad, Quest Spotlight,

  SQL Developer, Aqua Data Studio

Hardware                            : Sun, IBM, HP, Compaq, Dell, MAC, Cisco, EMC, NAS, SAN, Exadata

Storage Systems              : ASM, HP SAN EVA 4000, Dell PowerVault MD3000, EMC

Helpdesk Tools                 : CA USVD (Unicenter Service Desk), HP Service Manager, Jira, Service Now

Operating Systems          : Solaris, Linux, Microsoft Windows 9x, NT, 2000-2008, XP, Vista, 7, 8, MAC

 

Major Implementations:

·         Active member of CAB (Change Advisory Board) and IRB (Incident Resolution Board) for various clients making sure of smooth transitions of all changes from evaluation to go live and for identification, RCA (Root Cause Analysis), resolution and documentation for proactive response to all incidents .

·         Lead Member or Team Lead for Production Support for many clients.

·         Implemented ORACLE RAC (11gR2, 11gR1, 10gR2) with ASM, OCFS2 & QFS

·         Extensively migrated Databases and systems across platforms

·         Upgrade Oracle Database and Applications to higher levels and across platforms

 

Certifications and Training: 

·         ITIL Certified – Foundation Certificate in IT Service Management

·         Oracle 10g Certified Professional

·         Microsoft Certified Professional

·         Oracle Trained 10gR2 RAC Specialist

·         Oracle Trained 10gR2 Data Guard Specialist

·         Oracle Trained R12 System Administrator

·         Certified E - Commerce Professional

·         IT Workshop for Foreign Trade – Ryerson University & Acces Employment, Canada

·         Co-op Program for Foreign Trained Professional – Dufferin-Peel District Board

Professional Experience:

Senior Consultant – DB and Infrastructure Delivery                                                      August 2017 – Present

HCL, Canada                                                                                                                                                 www.hcl.com

Working for Rogers, Canada’s dynamic communications and Media Company as an HCL Consultant.

·         Following ITIL Practice in Change Management, Incident Management, Release Management and Configuration Management in almost all projects.

·         Facilitate integration and communication of IT with other departments in Rogers Client

 

Senior Database Administrator (Infra Delivery Lead, SME)                                             March 2015 – Present

Rogers, Canada                                                                                                                                    www.rogers.com

Rogers, Canada’s dynamic communications and Media Company.

·         Following ITIL Practice in Change Management, Incident Management, Release Management and Configuration Management in almost all projects.

·         Facilitate integration and communication of IT with other departments 

·         Designing  and Reviewing the implementation plans and migration plans for Oracle & Infrastructure projects

·         Expert level experience with Oracle, Exadata, MS SQL and other Database technologies

·         10+ years’ experience vendor management.

·         Experience with implementing and managing DBaaS, IaaS, PaaS and Cloud Integration

·         Good understanding of Oracle and Microsoft technology stacks, including awareness of cloud computing architecture.

·         Conducting data capacity planning, life cycle, duration, usage requirements, feasibility studies, server consolidations, System virtualizations

·         Triage issues, provide technical guidance, manage, motivate and mentor team

·         Coordinating the team for all dba activities

·         Implementation and support of Golden gate systems ( both integrated and classical mode)

·         Ensures efficient and thorough communication with Team and End-users & high quality of service and customer satisfaction. 

·         Work proactively with Support and Delivery teams, building efficiencies in processes which enhance overall customer satisfaction. 

·         Key contributor to solution architecture

·         Led service review meetings

·         Having strong technical knowledge across the entire technology stack but is mainly based on Oracle, Exadata , MS SQL Server & NoSQL Databases.

·         Took the lead on major incident resolution and communication; point of escalation for database and customer-service issues

·         Provide expertise to staff for escalation of problems/incidents and Changes.

·         Day to Day support activities like DB Promotions and Cloning

·         Handling Data storage, its backups, disaster recovery and Business Continuity Planning & executions.

·         Managing day to day Support operations, coordinate and promote changes to environment to gain efficiencies.

·         Handling all kinds of projects from business analysis, designing architecture, resource allocation ( both insource and outsource), quality assurance, performance testing, Process Reengineering, implementation and post implementation support, project planning and management with both budget and time frames, steady state support, post live releases etc.

 

Advisory I/T Specialist (Lead SME)                                                                                           July 2013 – March 2015

IBM, Canada                                                                                                                               www.ibm.com

International Business Machines Corporation, or IBM, is a multinational technology and consulting corporation, with headquarters in Armonk, New York, United States. IBM manufactures and markets computer hardware and software, and offers infrastructure, hosting and consulting services in areas ranging from mainframe computers to nanotechnology

·         Following ITIL Practice in Change Management, Incident Management, Release Management and Configuration Management in all client sites by taking major role in decision making as well in CAB

·         Facilitate integration and communication of IT with other departments 

·         Designing  and Reviewing the implementation plans and migration plans for Oracle projects

·         Communicate support process issues or product issues arising from escalation so Customer business can continue without issues and minimal disruption.

·         Conducting data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks

·         Triage issues, provide technical guidance, hire, manage, motivate and mentor team

·         Conducting DB Upgrades and DB Migration across platforms

·         Coordinating and leading the team for all dba activities

·         Ensures efficient and thorough communication with Team and End-users & high quality of service and customer satisfaction. 

·         Act as people manager through reviews, evaluates and prepares periodic performance reports of staff. 

·         Performing as a Team Leader for various Oracle projects and involved with new technology initiatives/projects. 

·         Large enterprise IT application systems development/implementation and related organizational transformation and support Enterprise IT Operations

·         Work proactively with Support and Delivery teams, building efficiencies in processes which enhance overall customer satisfaction. 

·         Act as delivery lead for various projects.

·         Provide expertise to staff for escalation of problems/incidents and Changes.

·         Upgraded Oracle DB from 10g to 11gr2

·         Upgraded Oracle GI from 11.2.0.3 to 12.1.0.1.4

·         Upgraded RAC and Non RAC Databases from 11.2.0.3 to 11.2.0.4.3 using dbua and manual upgrade.

·         Day to Day support activities like DB Promotions and Cloning

·         Managing day to day Support operations, coordinate and promote changes to environment to gain efficiencies, provide weekly and monthly overall status reports of operations and performance to goals.

·         Handling all kinds of projects from business analysis, designing architecture, resource allocation ( both insource and outsource), quality assurance, performance testing, Process Reengineering, implementation and post implementation support, project planning and management with both budget and time frames, steady state support etc.

·         Major Clients are IESO, Bell Canada, Enbridge and Government of Saskatchewan.

 

Data Engineer (Data Engineering)                                                                            April 2013 – June 2013

Ticoon Technologies Inc., Toronto, Canada                                                                         www.ticoon.com

Is an innovator and is focused on driving change in the financial services market.              

·         Audit Oracle Databases and submit the reports

·         Do performance Analysis using statspack and suggesting recommendations.

·         Learn Ticoon Applications and environments (eg. Pentaho, Jira, MAC)

 

Information Specialist (Infra & Operation Delivery Lead)                                                                                        Dec 2007 – July 2012

Injazat Data Systems, Abu Dhabi, UAE                                                                                   www.injazat.com

A joint venture of Hewlett Packard (HP) and Mubadala Development Company (a Tier IV design, Certified Premier Data Centre facility) providing services to the Federal Government offices and Municipalities in Abu Dhabi    

·         Followed ITIL Practice in Change Management, Incident Management, Release Management and Configuration Management in all client sites by taking major role in decision making as well in CAB

·         Implement and Enforce policies and procedures aligned with established Problem/Incident and Change Management. Ensures issue resolution in minimum time. 

·         Managed and administered the High Available Systems on technologies like ERP, RAC, ASM, OCFS2, OEM Grid Control (10g, 11g, 12c) on Solaris/ Linux / Windows (32 bit/ 64 Bit)

·         Completed over 10 Oracle RAC Implementations, 8 Oracle EBS Implementation (Full cycle)

·         Performed several platform migrations and upgrades

·         Designed, installed, monitored, maintained and performance tuned production databases while ensuring high levels of data availability

·         Led the team in upgrading the technology stack and DB Tier and migrating the 11.5.10.2 Apps of clients from one data centre to a Tier IV data centre and from a 2 node architecture to 5 node architecture

·         Defined and documented the high level corporate application and data architecture, frameworks and models and supporting high-level business process model

·         Conducted research and made recommendations upon products, services, processes and standards

·         Involved in the design of application and data based solutions and provided continuity in all major application solution decisions

·         Proactively advise the Service provider groups of any negative trends with the intent of improving the overall service.

·         Help drive problem tickets to resolution.

·         Manage and create service level reporting for your portfolio of services

·         Developed and promoted data management roadmap, methodologies and standards

·         Provided expertise to teams working on Maximo and Open Source systems like PostgreSQL and Pythian and integration with Microsoft SQL Server

·         Designed the implementation plans and migration plans for Oracle projects for different clients

·         Established and wrote the company’s standards and best practices document for all Oracle database environments based on Oracle's Optimal Flexible Architecture (OFA) for ISO Benchmark

·         Outlined all standards for the DBA Operations Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, coding standards for PL/SQL, policies, practices and procedures

·         Established methods and procedures for tracking and reporting upon data quality, completeness, redundancy, and improvement

·         Conducted data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks

·         Act as a key stakeholder/reviewer for major incident reviews

·         Act as a key stakeholder/reviewer for the change management process

·         Manages multiple projects, professional and technical staff, and other related activities of the area, including input to, and management of budget for the offices supported.

·         Assisted external auditors, regulatory auditors and other 3rd parties as needed. And also in company-wide compliance initiatives. 

·         Define and maintain enterprise-wide security policies, standards like ISO, and guidelines to satisfy legal/regulatory requirements and industry good practice.

·         Collaborate with teams cross functionally to standardize security best practices.

·         Work with various teams to define, design and develop information security metrics.

·         Support security awareness component to raise awareness of the risk controls process, schedule, and benefits to internal business partners.

·         Provide strong leadership, coaching and guidance to a multi-disciplinary, professional team of employees.

·         Performed as a Team Leader for various Oracle projects by preparing Project Plans

 

Sr. Oracle DBA (Team Lead)                                                                                                       Apr 2006 – Dec 2007

Al Jaber Group LLC, Abu Dhabi, UAE                                                                                        www.aljaber.com

A privately owned multi-faceted group of companies which provides its professional services in the sectors of Construction, Heavy Lifting & Logistics, Industrial and Trading. It has a workforce in excess of 50,000 and a total asset base exceeding AED 18 billion)

·         Managed and administered the RAC & Dataguard.

·         Collaborated with the JD Edwards XE One World & Enterprise One (8.11) ERP team for implementation, training and support

·         Designed the implementation plans and migration plans for Oracle

·         Installed and configured database and application server on Windows (32 bit/ 64 Bit) / Linux platforms

·         Implemented 5 nodes RAC with 64 bit Oracle on 64 bit Windows using ASM

·         Worked on technologies like RAC, ASM, Dataguard, EM Grid Control, Shared server etc.

·         Implemented high availability solutions for a group of companies running 10g (10.2.0.3.0) using Data Guard, RMAN, Oracle Real Application Clusters (RAC). Installed Oracle 10g R2 RAC database (6 DC & 2 DR) for production DB & 2 node RAC for development and testing.

·         Implemented high availability solutions 10g Application server (5 node cluster) with central repository in 2 node RAC on rack - mounted dual processor hp Blade servers & hp SAN (3 TB) for Windows Server 2003 R2

·         Prepared the diagrams and documentation for the whole project. Established and wrote the company’s standards and best practices document for all Oracle database environments based on Oracle's Optimal Flexible Architecture (OFA)

·         Outlined all standards for the DBA Operations Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, coding standards for PL/SQL, policies, practices and procedures

 

Oracle Database Administrator/System Administrator                                                  Aug 2003 – Mar 2006

Ivision Technologies, India                                                                                                         www.ivisionindia.co.in  

Established to offer innovative electronic surveillance systems, security alarms and access control systems.

·         Monitored in-house database backups and maintenance of the Database

·         Installed database on Solaris and Linux platforms

·         Worked with the technical implementation team in Oracle 11.5.10 Apps

·         Planned, implementation and maintenance of Local Area Network

·         Set up the Solaris, Linux and Windows Servers for the company

·         Upgraded existing Windows 2000 Advanced Server to Windows 2003 Advanced Server

·         Prepared standards and best practices document for Oracle database environments based on Oracle's Optimal Flexible Architecture (OFA) for implementations and future support

Education:     

·         Bachelor of Technology in Computer Science and Engineering, Mahatma Gandhi University, India

Evaluated by ICAS, Canada