MUBEEN QURESHI

438-***-****

+1-781-***-****

Location: Montreal, Canada.

CANADIAN PERMANENT RESIDENT

acxvqg@r.postjobfree.com

CAREER SUMMARY

I am Oracle DBA and SQL Server DBA.

ITIL Certified PRINCIPAL DATABASE ADMINISTRATOR DBA with over 10 years of proven track record in delivering high quality technical services to internal and external customers. Exceptional skills in Administration of Oracle Database 12c, 10g/11g/9i, 10g RAC, 11gRAC as DBA/Database Administrator/Architect and Administration of EBS R12, R12.2, 11i as Apps DBA with hands on experience as SQL DBA on MS SQL Server 2012

Hands on experience in Designing complex infrastructure/Architecture, multi node environment setups, configuring network/port, implementation and installation of variety of Applications/Softwares like Oracle database, MS SQL Server 2012, EBS, Weblogic server,10gAS and Primavera on various Operating systems/Platforms like Unix/windows/AIX .

Solid Knowledge of managing Oracle Technology Stack on Oracle Cloud, On premise and across datacenter operations. Expertise in execution of multimillion dollar projects involving Implementation and administration of Oracle Database 10g/11g/12c,MS SQL Server 2012,10g RAC, Oracle Fusion Apps 11.1.4/Fusion Middleware, Oracle Weblogic Server 11gR1 and Oracle Primavera Applications which includes OPPM 15.1, P6EPPM 15.1 and Unifier 15.1.

I am currently working as Associate Manager with Accenture Limited. Past experience of providing innovative solutions in the field of Database to some of Oracle Corporations biggest customers including Rogers Telecommunication, Bank of Montreal, SMART Technologies and Research in Motion.

EXPERIENCE SUMMARY

Over 10 years of experience in IT industry in Infrastructure Planning/Designing, Setup and Administration of environments, Implementation of Oracle 8i /9i /10g/11g/12c Database and Oracle E-Business Suite R12, R12.2, 11i on Unix/Linux/Windows/AIX including Administration of SQL Server 2012 .

Installation, configuration and maintenance of MS SQL Server 2012.

Implementing Windows Level Security Policies for SQL server .

Backup and restoring SQL Server Databases

Configuring and Implementing Jobs, Alerts on SQL Server.

Working with Replication for high availability on SQL Server 2012.

Expertise in Weblogic administration 11gR1/10.3.5/12.1.3

Unix Administration with Specialization on Oracle Enterprise Linux 3/4/5/6 (64-bit), Red hat Linux 2.1/3.0/4.0/5.0 and AIX

Expert skills in Oracle RDBMS (12c/11g/10g/9i/8i) Installation, Capacity planning, Database Creation, Performance Monitoring & tuning and Backup & Disaster Recovery strategies.

SME (Subject Matter Expert) for Primavera Applications, Fusion Applications, EBS R12.2, R12 and Database technologies in Accenture.

Managed end-to-end life cycle implementations of many Oracle ERP and Primavera projects involving Infrastructure Planning/design, Installation of Operating system, network configuration, installation /administration of Oracle EBS applications 11.5.9, 11.5.10.2, R12 and Oracle databases 8i, 9i, 10g,11g in multi node RAC/ASM environments.

Managed project lifecycle, including indirect resources, reporting regular project status, identifying & mitigating risks, and communicating with executive leadership where necessary to ensure alignment of strategic vision and drive project

Two Complete Implementations of Primavera OPPM 15.1, P6EPPM 15.1 and Unifier 15.1 involving Design, Installation, Configuration and Administration/Maintainence.

Infrastructure support for the on-going projects.

Design and implement Business continuity Plan (BCP).

Plan and implement Disaster recovery strategies.

Site-to-Site VPN setup.

Hands on experience on R12.2 administration

Responsible for understanding strategic client program drivers to define project scope, schedules & delivery.

Experience on Multi node Architecture with Databases and Applications on different nodes.

Well versed with Administration of Fusion Applications 11.1.4 and Fusion Middleware

Provide complete architectural and engineering details of Products and Hardware requirements and layout.

Solid experience in managing Oracle in High Availability environments using Real Application Cluster(RAC), Data Guard and Cloning technologies.

Managing Very Large Database with size up to 9 Terabyte size and with more than 12000 TPS.

Experience in Transportable Tablespace for migrations

Database Performance Tuning using dynamic performance views, AWR, Explain Plan, SQL TRACE, STATSPACK and different OEM utilities.

Successfully implemented Oracle10g/11g(R2) on RHEL5/4/3,Solaris 9/10 and Windows 2008R2 and 2012R2.

Performed a lot of Database upgrades from Oracle 8/8i/9i/10g to Oracle 10.2.0.x and Oracle 11.1.0.x.

Installing/Managing RAC, Non RAC to RAC conversion, Add/Remove Node.

Solid experience on Database/EBS Upgrades.

Patching (adpatch, adop and Opatch), Cloning.

Received Many Appreciations for high quality and dedicated work during Project Go-Live.

24x7 Production Support Experience and On-Call support including Pager support.

Working with Oracle Support for TAR/SR.

Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump(EXPDP/IMPDP) tools.

C++, Java, Perl and Shell Scripting, Unix cron jobs, Database tools and configurations including Net8 service configuration.

Well versed with client server environment & tools like TOAD.

Widespread use of Shell scripts and other UNIX scripting tools like Awk, Sed and Perl for automation.

Write Technical Documentation and Procedures for implementations and setups.

Ability to interact effectively with clients/customers, Understanding their requirements and providing optimum solution and support.

Excellent Analytical, interpersonal and communication skills.

Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

Coordinated meeting with vendors like Akamai and Cisco as part of Vendor management at Oracle Corp and with vendors like Telstra in Accenture.

Played key role in automation of Backup/Cloning process as part of Automation initiative.

Conducted resource planning and budgeting and also tracked costs to ensure adherence to budgetary constraints.

Coordinated product enhancements by acting as the interface between QA and development teams.

Facilitate technical and functional requirements meetings, workshops, and business process design sessions.

Exceptional Problem solving skills

TECHNICAL SKILLS

ERP: Oracle E-Business Suite Oracle Applications Release’s: (R12, 12.2 and 11i);10g AS, 9iAS, Oracle Weblogic Server 12.1.3/11gR1/10.3.5 and Fusion Applications 11.1.4.

RDBMS: Oracle 12c/11gR2/10gR2/9.2.0.7 and Microsoft SQL SERVER 2012

Primavera Products : OPPM 15.1, P6EPPM 15.1, UNIFIER 15.1

Operating Systems: Oracle Enterprise Linux 3/4/5/6 (64-bit), Red hat Linux 2.1/3.0/4.0/5.0, Sun Solaris 5.6/5.9/10, IBM AIX, HP-UX, Microsoft Windows 2008R2 and Windows 2012R2

Languages/Tools: OEM, C,C++, Data Structures Programming, SQL/PLSQL, HTML/DHTML, XML,Java,, Java script, Perl, Shell Scripting .

Database Monitoring and Tuning: AWR, SQL Trace, Explain Plan, Wait Events, STATSPACK, TKProf, OEM Grid

Web Servers: Tomcat, OHS, Apache, Oracle Weblogic server, Oracle Apps Server 10g

EDUCATION SUMMARY

Distinction in Masters of Computer Application.

Bachelor of Computer Application

TRAININGS AND CERTIFICATIONS

ITIL Certified

Oracle Application 11i Administration

Oracle Application Server (AS) 10g Administration.

Oracle 10G Database.

MS SQL Server DBA

Oracle 10g/11g RAC Workshop from Oracle Corp

Oracle WebLogic Administration 10.3.5/12.1.3/11gR1

EXPERIENCE SUMMARY

Accenture Canada. Oct 2016-Dec 2016

Project :

Role: Oracle DBA

Client : OMERS .

Responsibilities:

I was on Contract as Oracle DBA to support the DBA related activities for Accenture deployed at client OMERS in Toronto.

Atelka Canada. May 2016-Sep 2016

Project :

Role: Support Analyst

Client : FIDO .

Responsibilities:

I was support representative for Atelka.I supported their applications like V21, ICM and others.

The project was based out of Montreal

Future Electronics Canada. Mar 2016-Apr 2016

Project :

Role: Oracle DBA

Client : Future Electronics .

Responsibilities:

I was on a contract to support as Oracle and SQL DBA deploted at Future Electronics Pointe Claire office.The activities included Cloning,patching,performance tuning etc.

Accenture India Pvt Limited. May 2014-Feb 2016

Project 1:

Role: Oracle DBA

Client : Morningstar .

Responsibilities:

Implemented ITIL V3 Model into each phase of the project and aligned the whole project as per the ITIL guidelines.

Install Oracle 10g/11g and 12c databases as shared oracle home and non shared oracle home.

Installing, Configuring and Maintenance of SQL Server 2012, including service pack deployments

Troubleshooting and resolving database and server issues on SQL Server.

Managing Security (Creating users, logins and roles,granting permissions) on SQL Server

Ensuring Data consistency in the database through DBCC commands

Backup client SQL Server databases and perform database restore as required.

Perform and monitor daily database operations and set-up backup schedules

Implemented Snapshot, Transactional Replication/Publication.

Database upgrades from 9.2.0.X to 10g and 10g to 11g

Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases

Database Performance Tuning using AWR/ADDM/SQL Tuning Advisory .

Administering R12.2 and Fusion Apps 11.1.4

Install, Maintain and Patch Oracle EBS 11i (11.5.10.2) and R12 (12.0.6 /12.1.1/12.1.2/ 12.2) ERP system on Multi Node Architecture.

Using ADADMIN, ADCONFIG, ADPATCH(R12.1.X,R12.0.X,11i)/ADOP(R12.2) and Rapid Clone utilities for EBS maintenance and patching.

Perform EBS Cloning and Refresh from Production System using Rapid Clone on Single and Multi Node .

Administer the Amazon Web Services(AWS) VMs.

Implemented Business continuity plan for Morningstar project.

Setting up the Infrastructure for starting operations in new cities.

Archive log files management and Database recovery options.

Logical Backup using exp/imp and Oracle Data Pump Technology

redo log and control file management and UNDO management

Managing Space related issues both with permanent and temporary tablespaces

User/Role/Profile/Space management.

Monitoring and Auditing User-Activities.

Managing network related issues and setting up Oracle Client on Application Server.

Database links, Materialized view, Flashback query,version qurey

Migration of Database/EBS instance from one Platform to another.

Administering NTTA Cloud.

Using RMAN Duplicate for database cloning.

Performing cold and hot backups

Automated the Backup and cloning process.

Manual database Refresh and Cloning.

Implemented Dataguard Physical standby using RMAN Duplicate.

Data files migration from One location to another.

Installation of Oracle database 12c on shared oracle home.

Expertize in Unix administration

Code Migrations.

Weblogic server 12.1.3/11gR1/10.3.4 Installation and administration.

JDK installation/upgrade

As Oracle Database Architect/Specialist worked on the Core ERP R12.2/R12.1.x/R12.0.X/11i and Database Performance Tuning.

Install/setup of fresh Oracle R12 instances for Test and Development environments.

Manage Concurrent Managers and SYSADMIN Role

Configured RMAN Backups and Restore.

Applied CPU/PCU patch application to Oracle Database using Opatch.

Applied latest RUP patch .

Upgraded EBS from 11i to R12, R12.0.X to R12.1.X and other Patch set level upgrade .

Setup and installing the Solaris / Linux 4/5/6 64-bit/AIX operating systems in LAN and WAN environment and set up the database servers from scratch

Installation of RPMs and YUM packages on Linux .

10g/11g RAC Installation

Conversion of Standalone 10g Non RAC Database to RAC database.

Expert in troubleshooting EBS login page issues, Apache issues, Concurrent Manager issues.

Well versed with SYSADMIN activities.

Excellent skills in collaborating with project teams, interfacing with clients, and deploying technology to build successful solutions for clients.

Organized special trainings and Response Guides for technical development of the off shore team.

Established post-production support and provide detailed cost, schedule, and forecasting reports to ensure customer performance metrics are met.

Project Planning and Budget management.

Extensive interaction with Customer and 3rd party hardware provider for understanding the requirements and providing the world class service.

Project 2:

Role: Principal DBA /Database Architect/SME

Client: Queensland Department of Transport and Main Roads .

Responsibilities:

Laid down the complete Infrastructure for Queensland Project in Accenture including Plan/Design/Implement.

Performed installation and configuration of RDBMS 11gR1/11gR3 and upgraded 10g to 11gR1

End – to – End 2 Complete Implementations of P6EPPM 15.1, Unifier 15.1 and OPPM 15.1

Troubleshooting day to day Infrastructure issues by co-ordinating with Accenture and Telstra network teams.

Plan and gather the infrastructural/Architectural requirements like the number of VMs,OS, RAMs,CPUs, network requirements etc.

Administer the NTTA cloud VMs

Troubleshooting day to day P6EPPM/OPPM/Unifier issues faced by end users/Developers/Testers

Responsible for H/W replacement of both Database Tier+MiddleTier servers with new H/W.

Performance tuning & monitoring of the Databases

Installed and Cloned 11g RAC environments between prod and UAT .

Conducted Sizing & Capacity Planning for Oracle databases

Worked on Datafiles movement online in Oracle database 12c

Setup Dataguard Physical standby in Sydney data center.

Daily, weekly system and DB server maintenance like cleaning the old archives, validating the backups, monitoring Alert Logs & Trace file and Application Logs, managing the security at user level and at application level.

Interface with network, hardware and system operations teams to resolve problems with application/database systems.

Well versed with SYSADMIN tasks on P6EPPM/Unifier and Oracle primavera portfolio management.

Conducted corporate trainings/Intervews for Primavera OPPM, P6EPPM and Unifier.

Designed the Primavera Installation, Training, Documents.

Works on User preferences and administrator preferences in Unifier.

Works on Project setup and user setup and Report generation in Project portfolio management tool and Primavera P6.

Implemented/Created projects in Primavera P6 EPPM and Played a role of Primavera Administrator as well as Scheduler

Coordination with the IT team of Telstra(client) group to help us provide with proper configured systems & other necessary parameters like opening of ports, allocation of server etc for the Primavera Setup

Technics Integration Technologies Pvt Ltd. Dec 2013-May 2014

Role: Oracle Principal Database Administrator / Database Architect

Client: Noble Energy .

Responsibilities:

Installation, configuration and maintenance of SQL server software and related products.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policy for various categories of User Support.

Backup/Restore/Attach/Detach of SQL server databases.

Implemented High availability using Merge Replication/Publication.

Monitor Disk space to ensure smooth running of SQL Server databases

Monitoring SQL server performance using SQL Profiler and system monitor.

Checking Database Consistency using DBCC at regular intervals for SQL Databases.

Scheduling and Monitoring Jobs in SQL Server.

Forecasting the Hardware requirements based upon the number of users.

Started DBA operations for client Noble energy in India.

Install and setup virtual machines and analyzing and deciding hardware configurations.

Implement and support DR setup for the client

Acted as escalation point for change requests and client concerns and worked closely with the development teams to prioritize issues and coordinate troubleshooting efforts.

Migration/Upgrade of Old databases from 9.2.0.X to Oracle10g And from 10gR1 to 11g

Experienced in using Oracle's Transportable Tablespace (TTS) for migration from one platform to another

Real Application Cluster Installation, administering and troubleshooting

Implemented backup and recovery using RMAN.

Managing Shifts in 24x7 environments and Hired resources as per the requirement.

Upgraded Oracle Applications from release 11.5.10.2 to R12.

Installation of 12c Database and R12 EBS.

Implemented Shared Oracle Home for 12c databases.

Configured standby databases for existing Production database and activated for testing.

Tuned JVM and Performed Undo Management for optimal system performance.

Oracle Corporation Jan 2008-Dec 2013

Role: Senior Oracle DBA/APPS DBA

Client: 1000+ Clients including Rogers Telecommunication, Bank of Montreal, RONA, SMART Technologies, Research In Motion, Quantas Airlines

Responsiblities:

Administer Fusion Applications 11.1.4 Environments for top Oracle customers.

Administering R 12 .2, R12.0.6, R12.1.1, R12.1.2, 11i environments for internal Dev/QA users and external customers.

Part of the Team that Built the EBS R12.2 from Scratch and witnessed its release to the external customers.

Ebusiness Suite Upgrades from 11.5.9 to 11.5.10.2 and 11i to R12, 12.0.6 to 12.1.1 and from 12.1.1. to 12.1.2.

Upgradation of Oracle Database from 9.2.0.6 to 10.2.0.2, 10g to 11g.

Installed the Unix Operating system and did the Network setup and connectivity between different servers.

Installed and administered Virtual Machines.

Setup Site-to-Site VPN tunnel

Installed binaries, RPM/YUM packages and established Network connectivity between servers.

Addition/deletion of hardware to the existing Infrastructure.

Gather the client requirements and prepared usecase diagrams.

Involved in RAC to non RAC and vice versa cloning’s

Conducted many corporate trainings on Oracle Database Administration.

Created ASM Instances/Disk group

Did Presentations for every build release

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN

Implemented and Tested PCP(Parallel Concurrent Procession) setup and configuration .

Configured EBS R12 with SSO/OID.

Installation of 11gR1 Oracle databases on Linux/Windows/AIX.

Installation of EBS 11i and R12.0.x/R12.1.x and Oracle 10g AS on Linux.

Performed Migration from AIX to Linux for Application.

Performed Migration from Linux to AIX for 11g Databases.

Implemented Disaster recovery for PROD Instances.

Administering and installation of Oracle Weblogic Servers 10.3.4/11gR1.

JDK and JRE upgrades

Create databases using DBCA, tablespaces, users and tables for custom applications and maintained security.

Grant and restrict access to the Database users.

Expert in All SYSADMIN activities in EBS ii1 and R12.

Performance Tuning of application R12.2 and R12.1.X environments.

Fine tuning the Oracle Database 10g/11g to meet end user expectations.

Setup Oracle 10g Dataguard for physical standby .

Troubleshooting Concurrent Manager, forms issues.

Expert in Cloning and Patching issues.

Troubleshooting Apache and JDK issues.

Extensive Cloning of eBusiness suite R12 on single node, multi node, shared and non shared appl top.

Conversion of non RAC to 10gRAC environments.

Applied Patches to 10g RAC Database.

Real Application Cluster Installation.

Bug fixing high severity defects

Well versed with AD Utilities like ADPatch, ADAdmin, ADRelink, ADSplice and ADOP(12.2)

Experience of WorkFlow Mailer Configuration.

Administering Oracle Application Manager and 12c OEM.

Managing Discoverer 9i and 10g issues.

Troubleshooting Apache-Jserv, JDK, JRE issues.

Performing Backup and Recovery using RMAN.

Troubleshooting ORA-1555,1652,1654 errors and all Database issues.

Wipro Technologies Oct 2006-Jan 2008

Role: Oracle DBA

Client: Emerson Technologies

Responsibilities:

Installation of 9i (9.2.0.4/9.2.0.7) and 10gR1 databases

Preparing usecase diagrams.

Oracle 9.2.0.x refreshes.

Install all pre-reqs on the unix server for Oracle database installation.

Setting up net8 service on Application server.

Operating system installation.

Installation of Oracle 11i Ebusiness Suite on 2 Nodes (11.5.10.2)

Performed Multinode to Multinode cloning of EBS 11.5.10.2.

Perform Disaster Recovery drill.

Administration experience on Shared Appl top .

Applied Database Patches using Opatch

Extensively worked on Patch Analysis for Huge Patches.

Closely work with Dev Team to fix their Issues.

Providing the 24X7 production support to all the instances

Used to perform System Administration tasks.

Planning Oracle11i Migration/Upgrade

Hardware evaluation for Oracle 10G Implementation

Upgrade 9.2.0.4 to Oracle10g .

Applied Latest Family Packs, huge RUP patches for HRMS.

Applied Patch HRGLOBAL.drv for HRMS Family Pack.

Upgraded HRMS Family Pack to the Latest Patch set level.

Upgrade Application Server and techstack components

Applied the latest patches including 11.5.10 CU2

Applied Patches using adpatch on Dev/Test and PROD in Shared APPL TOP Env.

Implemented Shared APPL_TOP technology for EBS 11.5.10.2 release.

Supported Oracle 11.5.9 Oracle Apps on Linux/Solaris/AIX on Two Node.

Applied Year End Patches for Pay Roll.

Upgraded DB from 9.2.0.4 to 9.2.0.7

Automated Health checks through Shell Scripting.

Installed and Configured Oracle ERP on HP-UX

Designed and Implemented capacity planning, sizing, installation, configuration

Configured and supported : HP-UX 11i operating system for Oracle ERP

Post Implementation 11.5.10 Production Support

Working With KINTANA.

PERSONAL PROFILE

Date of Birth: 17th February

Languages : Proficient and Expert in English Communication.

Marital Status : UnMarried

Date: 1st Nov 2016 (MUBEEN QURESHI)

Contact this candidate