Asim Rasheed

*** ********* ****, *******, ***, CANADA L3S4V2

Cell Phone: 647-***-****

Email: actb1o@r.postjobfree.com

Database Administrator (DBA)

CAREER OBJECTIVE

To join a leading organization with a competitive environment, where I can enhance my skill sets as database administrator more proficiently

Keyword Summary

Multi-lingual professional with over 7 years of experience in the field of Information Technology with core area of expertise in Database Architecture, and Database Administration (DBA) in Oracle & SQL Server on Linux and Windows Plat-forms. MCS degree in computer science with OCPDBA (Oracle Certified Professional) Training from University of Oracle

Database Administration

Successful Senior Database Administrator with 6yearsexperience in the design and implementation of enterprise data strategies, RAC, ASM, Standby and RDBMS (Oracle, SQL Server ) on Windows and Linux servers

RAC, Golden-Gate, physical standby database/Data-Guard, Distributed databases

ORACLE database up-gradation from 9i to 10g R2,11g R2 and 12c R1

Experience in distributed replication using DBLINKS, MATERIALZED VIEW

Responsible for the management and support of all Production, Development and Staging instances of databases

Database performance tuning including instance tuning, I/O tuning, SQL Tuning, ETL process etc.

Ensuring successful & periodical Backup, Restoration using RMAN and SQL Server EM

Write scripts (cron-jobs) to automate database functions like status, performance and Space Management

Provide technical support and assistance to all database end-users

Plan for system growth and monitor capacity usage (Capacity Planning) for new hardware or software requirements and communicate these capacity requirements to management. Furthermore, act as liaison to interact with the database vendors

Installing, patching database server software and any front-end tool & database application that access the database

Database Development

Advance Development skills in PL/SQL and SQL to perform SELECT& DML operations by making procedures, functions, triggers and packages according to the evolving need of the program. Also have knowledge about Linux CRON scripting

TECHNICAL SUMMARY:

Operating Systems:

Linux, Windows 2012/2008/2003/2000 Servers

Database:

ORACLE 12c/11g/10g, MS SQL-Sever 2005/2008

Back-up and Recovery

RMAN, Log miner, Flashback

Performance & Diagnostics

Oracle Performance Manager, OEM 12c/11g,AWR, ADDM

Database Up-gradation

Oracle 11g to 12c using DBUA, SQL Server DTS, Access Upsizing

Tools

SQL*PLUS, RMAN, TOAD, OUI, DBCA, DBUA, Oracle Net Manager, ASM, GoldenGate

High Availability

12c/11g/10g ORACLE RAC, Data Guard Stand-by

Bulk -loads / Data migration

SQL* Loader, Imp/exp. Data Pump, GoldenGate

Languages:

PL/SQL, T-SQL

Replication

DBLINKS, MATERALIZED VIEW, GoldenGate

PROFESSIONAL EXPERIENCE

Oracle DBA:

Global Components Inc (Toronto, Canada) June 2015 – Present

Global Components Inc is a IT services company which is providing IT solutions in professional market

Responsibilities:

Installation of Oracle 11g Enterprise software on Windows Server 2008 and Linux

Upgrading Oracle 11g Database with latest patch releases and O-patch versions

Completing DBA daily jobs including user management, space management, monitoring

Administrate and configuration Oracle Active Data-guard on high availability over 2 standby database severs

Database performance tuning exercises, involving both RDBMS engine and the Operating Systems configuration changes, assisting development team in the understanding and tuning of SQL code

Perform index rebuilding and shrink database for database performance

Maintaining three Standby database servers, one of them is remote Standby Database server

Creating, updating and maintaining documentation of build, upgrade, patching and troubleshooting activities on Oracle databases

Monitoring active/inactive database application sessions for database performance

Tune SQL and T-SQL queries and stored procedures for better response of database

Maintaining import/export of database objects and validate database objects

Environment:

Oracle Enterprise Linux 5.6, Oracle 11g R2, ASM, MS Windows 2008

Selected Accomplishments:

Installation and administration of Oracle Enterprise Grid 11g for monitoring multiple database through OEM

Prepare log miner for database transactions and SQL executions and database health check reports

Latest patch upgrading Oracle Database 11g R2

Oracle Database Trainer & Consultant:

Canadian College Of Higher Studies (Toronto, Canada) June 2015 – Present (ON CALL)

Canadian College of Higher Studies offers practical training programs that will help you achieve your career and educational goals

Responsibilities:

Training Oracle 11g Database (DBA-Track)

Consultation to become OCP (ORACLE Certified Professional)

Provide training of Oracle Exam 1z0-051 SQL Fundamentals

Provide training of Oracle Exam 1z0-052 Database Administration Workshop I

Provide training of Oracle Exam 1z0-053 Database Administration Workshop II

Maintaining Oracle Database servers in College labs

Maintaining Oracle Replication servers for college labs

Environment:

Redhat Enterprise Linux 6.6, Microsoft Windows Server 2008, Oracle 11.2.0.3, Oracle Enterprise Manager 11g, ASM, RAC

Senior Database Administrator

KASB Securities Limited April 2014 – February 2015

KASB Securities is a financial brokerage house and belongs to KASB Group which is a leading Enterprise providing financial solutions such as Online Stock Trading, Banking, Finance Schemes, Educational Institutions and Software Solutions

Responsibilities:

Resolve slowness issues in the databases over HP-UX, Dell, IBM-AIX servers

Evaluate and test Oracle Enterprise and MS SQL Server engine and prepare a roadmap for upgrade to Oracle releases

Resolve performance related issues in live databases on Oracle and Microsoft SQL-Server.

Configure and maintain two Oracle standby databases of live/production database

Direct Backup and Recovery strategy of the group so as to ensure that disaster recovery, business continuity and protection of critical data service level agreements are both met as well as improved

Provide performance tuning guidelines and direct the team in constantly optimizing response times for both batch processes as well as online transactional systems

Migrate Oracle databases from MS Windows Server to Redhat Linux Operating System Platforms

Upgrade live/production Oracle database and MS SQL Server to latest databases releases and patches

Install Oracle RAC and ASM database (dev, production, test) environment on virtual (VMWare) Machines

Perform ETL support through import and export backup of live Oracle databases according to company SLA for test applications and in house application support

Assisting with monitoring and troubleshooting of scheduled batch jobs in Windows Task Scheduler, Oracle jobs Scheduler, MS SQL Server jobs scheduler and Linux cron jobs

Perform Oracle database administration on Windows Server and Redhat Linux plat forms

Prepare and update documents for database health, performance tuning and administration

Perform space management of databases backups for Oracle and MS SQL-Server

Managed processes through HP service manager and monitor change control

Prepare database, schemas and database objects for application testing and troubleshooting

Provide on call support in off hours via telephony, emails and remote connections

Environment:

Redhat Enterprise Linux 6.6, Microsoft Windows Server 2003/2008/2012, Oracle 10g R2/11g R2/12c, OEM GRID 10g/11g/, ASM, RAC, MS SQL-Sever 2005/2008

Selected Accomplishments:

Automated daily backup reports pulled out from database server through OEM 10g/11g/12c

Maintain batch files for daily backups at operating system and oracle engine level

Perform ETL for test database to support test applications and reports

Perform 8 TB data migration from MS Windows Sever to Redhat Linux

Batch files scheduling for daily backups on operating system and Oracle engine level

Senior Oracle Database Administrator

ZH Investment Inc (Houston, TX, USA) May 2012 - March 2014

Cell Phone Retailer - A fast growing speciality retailer in Cell Phones technology and providing a great assortment of product categories aimed at helping customers and latest selection of smart phones and cell phone accessories

Responsibilities:

Installation of Oracle Enterprise Engine over x64 Oracle Enterprise Linux System and HP-UX server

Administrate and configuration Oracle Active Data-guard on high availability over 3 standby database severs

Creating, updating and maintaining documentation of build, upgrade, patching and troubleshooting activities on Oracle databases

Database performance tuning exercises, involving both, RDBMS engine and the Operating Systems configuration changes, assisting development team in the understanding and tuning of SQL code

Fulfilled DBA daily activities including user management, space management, monitoring etc and comprehensive testing and documentation and standardization of systems and procedures

Installation and administration of Oracle Enterprise Manager Grid (OEM) and MS SQL Server agent for monitoring

Perform index rebuilding and shrink database for database performance

Maintaining three Standby database servers, one of them is remote Standby Database server

Plan GoldenGate setup to achieve Unidirectional replication and test initial data load option during environment build and setup GoldenGate database user with necessary privileges

Performance and Tuning and resolves application slowness issues during market hours

Tune SQL and T-SQL queries and stored procedures for better response of database

Maintaining automated database backups on daily basics on SAN storage devices

Maintaining import/export of database objects and validate database objects

Monitoring active/inactive database application sessions for database performance

Maintaining database high availability on OLTP during market hours

Generate ADDM, AWR report for solving database problems and issues

Environment:

Oracle Enterprise Linux 5.6, HP-UX, Oracle 11g R2, Oracle 12c, SAN Storage System, ASM, RAC, OEM 11g/12c,

MS SQL-Server 2005/2008,GoldenGate 11

Selected Accomplishments:

Installation and implementation of Oracle RAC for Load Balancing and Failover

Administrate database on high availability in OLPT environment during market hours

Maintained database on SAN storage systems and provide proper assistance of space management in respect of the size of database

Installation and administration of Oracle Enterprise Grid 11g for monitoring multiple database through OEM

Prepare logminer for database transactions and SQL executions and database health check reports

Oracle Database administrator

A.R Associates Pvt. Limited January 2009 - March 2012

Insurance Services Company - Provides insurance claim settlements, loss assessments and property valuation facilities

Responsibilities:

Installation of Oracle Enterprise Database over Windows Server and Linux system

Oracle Enterprise Manager Gird Control for better monitoring and administration in multiple database environment

Perform upgrade modules with latest release of patches and O-Patches to keep database bugs free

Reconfigured invalid components after upgrade and import of databases

Configure Enterprise Manager and listener services for better monitoring

Configure Oracle Active Data-Guard and Data-Guard broker for switch over in times of failure of production or live databases automatically

Resolve issues of moving files on primary databases without effect on standby

Auto start database and listener services configuration in Linux Environment

Prepare test databases for application testing and response time

Environment:

Redhat Enterprise Linux 4.5, MS Windows Server 2003/2008,Oracle 10g R2, Oracle 11g,ASM

Selected Accomplishments:

Installation of Oracle Enterprise database and MS SQL-Server engines over x86 and x64 machines

Perform database engine upgrade according to the latest release following through company SLA

Prepare Linux scripting for auto start Oracle database and Listener services

System Administrator

SATA Industries May 2007 – December 2008

Graphics Designing and Print Media Press- A printing press which provides graphic designing and printing solutions to industries

Responsibilities:

Perform Operating System Installation (MS Window Server, Redhat Linux) over HP, Dell servers

Perform network solutions and manage IP network infrastructure and subnets

Perform Linux Bind installation for resolving naming nodes over network

Perform upgrade of Windows server and software installation

Linux Server RPM installation with all dependencies and libraries requirements

Provide on call assistance during off hours over call and remote sessions

Environment:

Server OS:MS Windows Server 2000/2003/2008, Redhat Linux 4.5, 4.7, Client OS: MS Windows XP/ Vista/ 7, Ubutu, Mac OS, Mobile Devices

Selected Accomplishments:

Perform installation of server and client side operating systems

Perform network management through cable and wireless on ITIL according to the company's SOP

Perform software installations and script writings for system management

Setup mobile devices according to company network infrastructure and network management

Education

University of Karachi 2012

Master in Computer Sciences (MCS)

Indus Institute of Higher Studies 2007

Bachelors in Computer Sciences (BCS)

Certifications

Oracle University 2013

(OCP) Database Administrator Track (Training)

Redhat University 2013

Redhat Certified Technician (Training)

Contact this candidate