Murtaza Siddiqui Senior Oracle DBA

** ******** **.

Scarborough ON M1G K19

630-***-****

ac4irc@r.postjobfree.com

PROFESSIONAL SUMMARY:

I have hands-on, business oriented and professional experience of more than 9 years in Oracle Database Administration. I have worked on Oracle 12c, 11g, 10g, 9i, on different platforms as a Database Administrator/Architect. I have also worked on Microsoft SQL Server 2000 - 2014 databases. Most of my experience is related to the physical infrastructure of database administration. I have a good amount of experience in setting up Maximum Availability and Capacity on Demand Architectures using various products, protocols and methodologies from Oracle including 11g Real Application Cluster (RAC), Data Guard, 12c/13c cloud control, Automatic Database Diagnostic Management (ADDM), RMAN and Golden Gate replication.

TECHNICAL SKILLS:

Operating Systems

RHEL, HPUX, AIX, Windows

RDBMS

Oracle 12c, 11g,10g, 9i, SQL Server 2005/2008/2012/2014

High Availability

RAC, Data Guard

Languages

SQL, PL/SQL, UNIX Shell scripting, T-SQL, Perl

Tools

RMAN, OEM, sqlldr, exp, imp, expdp, impdp, ERWIN, TOAD, dbconsole, Solarwinds, BR Tools

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, Performance Analyzer

WORK HISTORY:

Advizex Technologies, Lombard, IL June 2015 - Present

Senior Oracle DBA

Roles & Responsibilities:

Supported more than 300 databases including development/production sizes up to 20 TB for 24/7.

Designed, Installed and configured the Oracle server software and related products. Upgraded various database versions (10g, 11g, 12c) on RHEL and AIX.

Managed over offshore teams to ensure effective delivery of service to clients. Conducted site visits to access client objectives were understood before onboarding as new clients.

Completely build RAC from scratch including OS and RAID configuration. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.

Worked with SAP on Oracle database and have experience using BR tools to manage day to day Oracle tasks such as backup, recovery, restores, and clones.

Worked on Exadata migrating Oracle databases and optimizing them to run efficiently on Exadata.

Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.

Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.

Monitoring and maintaining multi-node RAC databases on Red Hat Linux. Providing support to the development team and handling release schedules.

Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab. Also used third party tools like Networker, Avamar, DB Boost, etc.

Database refreshes using export /import and datapump using both local and network methods.

Used RDA, ADDM and AWR reports to monitor the database performance.

Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.

Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.

Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.

Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.

Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.

Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.

Primary DBA for 300GB - 20TB database for 24/7 support.

Worked on OLTP

Served as part of a 20 member DBA team which was involved in the maintenance of the Oracle 9i to 12c databases for the Production as well as the development environments.

Actively involved in designing/Testing of Disaster Crash recovery.

Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor.

Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.

Performed database cloning/exp/imp to setup identical databases in the production and development environments.

Created and maintain users, roles and privileges.

Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.

Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.

Provided technical troubleshooting and give consultation to development teams.

Implemented basic replication through Materialized Views.

Performed Oracle Golden Gate implementation, configuration. Golden gate basic administration and incident handling. .

Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.

Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.

Used Oracle AWR & ADDM to monitor database activities and performance tuning.

Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.

Worked on 12c and 13c OEM Cloud control

Installed, migrated, configured and tested Oracle databases in various environments.

Extremely dedicated, self–motivated, Pro-Active and willing to assume responsibility.

Environment:, SQL, SQL*Plus, Oracle 8i,9i, 10g, 11g 12c; RHEL, AIX, Windows NT/2000, HP UX,TOAD, Grid Control, OEM, SQL Developer

Bright Image Corporation, Broadview, IL April 2008 – June 2015

Oracle DBA

Role & Responsibilities:

Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.

Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.

Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers

Data modeling / Logical database design and implementation (including index design)

Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database

Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks

Create and maintain multiple databases.

Create multiple 11g databases on RHEL5 in development.

Schedule backup in 11g using db console.

Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g

Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.

Constant monitoring of database space and space management

Setting up Oracle Standby Data Guard.

Setting up of Oracle and Application user accounts and passwords, monitoring application security

Responsible to improve the performance by Using the Hints, Indexes, Explain Plan

Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace

Worked with RAC implementation team. Added nodes.

Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space

Help developers writing database triggers, packages, procedures, functions, utilities for application development.

Export and Import of User, Tables and Database using exp/imp and Data Pump.

Environment: Oracle 10g RAC, Data Guard, ASM, SQL*Plus, Oracle 9i, 10g, RHEL, AIX, Solaris

A&S Home Healthcare Downers Grove, IL August 2007 – April 2008

Oracle DBA

Role & Responsibilities:

Involved in Oracle database analysis and coding programs for various projects.

Generating data movement code, compiles code, execute the code and troubleshoot data movement problems. Control console for data transformer server using server console

Creating users and granting permissions. Map flat files, data, and Meta data management

Loading data into staging tables from flat files and tables

Loading data into ODS tables, dimension tables, base line tables, data mart tables

Prepared scheduler scripts and stored procedures. Prepared data models using Erwin Tool

Performed performance and tuning on SQL Queries and data movement scripts

Tables, indexes, users are created and permissions are granted to users

Experience in taking Daily and Weekly Physical backups using RMAN

Involved in writing korn shell scripts for daily RMAN backups, tape backups, Index rebuilding and to generate Multi-Master Replication. Databases are reorganized to improve performance

Administered two production OLTP databases along with one Staging and a test database.

Database Design for new modules added to the product. Developed and maintained PL/SQL objects and performed query tuning.

Configured and created required table spaces and database objects with appropriate storage parameters as well as placement.

Managed disk space requirements for growth of data tables and indexes.

Performed backups, export and import of data between instances, analyzing of objects through scheduled scripts.

Written bash scripts to trigger critical threshold alerts.

Run stats pack everyday to get the statistics of the production databases.

Provided security and access privileges to data.

Environment: Oracle 10g, RAC, RMAN

EDUCATIONAL HISTORY:

Bachelors in Computer Science – Osmania University Hyderabad, India - August 2003

PROFESSIONAL REFRENCES:

Available upon request

Contact this candidate