MALIKE SABA

ac0hte@r.postjobfree.com

+1-630-***-****

SUMMARY:

More than 6 years of strong work experience as an Oracle Database Administrator in major organizations and in multi cultural work environment encompassing a wide spectrum of computing and information technology and delivering solutions within extremely stiff lead-time. The experience includes working on different platforms as Oracle DBA and Technical consultant in Oracle E-Business Suite Applications.

Looking forward to next level of career development in a challenging position in Oracle Database Administration

DBA Skills:

Proficient in Database Installation and Administration activities such as RAC, Dataguard, Upgrades, Patching, Cloning, script development, and documentation

Excellent experience on 11g new features and 10g features like Data Pump, RMAN, AWR, SQL Tuning Advisor, ADDM, database control

Good experience in Performance Monitoring and Tuning activities using EXPLAIN PLAN, TKPROF, STATSPACK, TOAD, AWR and ADDM

Good experience in writing different backup and recovery scripts, shell scripts, CRON jobs, Data Pump and Export/Import scripts, space management and storage allocation

Good exposure to Golden Gate monitoring, configuration and troubleshooting

Good experience in Oracle 12c multitenant setup, installations, database creations, plug/unplug, cloning, user maintenance activities and its new features

Experience with implementation of Audit and security implementation on oracle databases.

Good experience on user management, functions, triggers, cursors, ASSM, tablespace management, schema management, SGA management

Experience with Oracle Enterprise Manager, SQL* Loader, external tables, database configuration assistant (DBCA), database upgrade assistant (DBUA), NETCA for network configuration

Experience as On-Call 24x7 production DBA and development DBA and Oracle Support processes for technical requests through Metalink

Exposure to Oracle database designing, creating database structures and objects for supporting various applications and capacity planning for the different applications

Design and implement database backup and recovery procedures using RMAN

Cloning and refreshing the database as per the requirement using RMAN

Proficient in Oracle SQL, PL/SQL and Unix shell scripting

Self-starter, fast learner, highly organized and dedicated with a positive attitude

Strong communication, analytical, diagnostic and troubleshooting skills

Oracle Applications Technical Skills:

Strong analytical skills in GAP Analysis and business requirements gathering from end users to the client

Good working knowledge of Trading Community Architecture (TCA)

Proficient in writing Procedures, Functions, Packages and Interface Programs using PL/SQL

Well versed with all phases of the system development/implementation life cycle

CERTIFICATIONS:

Oracle Database 12c Administrator Certified Professional (OCP)

Oracle Database 10g Administrator Certified Professional (OCP)

Oracle PL/SQL Developer Certified Associate (OCA)

TECHNICAL SKILLS:

Operating System

Redhat Linux, Windows 2000/XP/2003, Solaris

Languages

SQL, PL/SQL, XML, Shell Scripting

Database

Oracle 12c/11g/10g/9i

Tools

SQL Loader, SQL*Plus, Toad, Oracle Enterprise Manager (OEM), Log Miner, RMAN, TKPROF, Orapwd, Data Pump, Oracle Grid/Database Control, Exp/Imp, FTP, Putty, STATSPACK, AWR, ADDM, DBCA, DBUA, SQL Trace

EDUCATION:

MS in Electrical Engineering, California State University Northridge, USA Year 2008

BE in Instrumentation & Control, Saurashtra University, India Year 2004

CAREER HISTORY:

Allstate (Jul 2014 – Present)

Lead Oracle Database Administrator (Lead IT Consultant)

Allstate Corporation is the largest publicly held personal lines property and casualty insurer in the United States. It ranks number 89 on the Fortune 500 list of largest companies in the United States.

Responsibilities:

Worked on cross-platform database migrations from Solaris to Linux using transportable tablespace

Involved in Oracle database designing, creating database structures and objects for supporting various applications and capacity planning for the various applications

Involved in query tuning and resolving of performance issues, Statistics Gathering, Analyzing Objects and troubleshooting of RAC issues

Worked on the implementation of DR activities using Dataguard, database refreshes, database growth analysis, creation of jobs for refreshes and scheduling them using tivoli

Worked on oracle 12c multitenant setup, database creation, plug/unplug, cloning and user maintenance activities

Exposure to Golden Gate configuration, monitoring and troubleshooting

Experience with implementation of Audit and security implementation on oracle databases

Worked on 11g to 12c Upgrades

Written Shell scripts for database backups and cloning the database

Worked on AGILE methodologies

Involved in the conversion of logical design layout into physical design layout and its implementation

Dealt with CPU and PSU7 patching, upgrades, database security and troubleshooting

Proficient in Oracle 11g installation, database creation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning and troubleshooting

Evolving knowledge Management exercise through mentoring the team and new recruitees on different areas of database administration and about the different applications.

Ideas and innovations for technological up-gradations/ improvements, planning and making road map of executions. Some of my ideas continue to be adopted as standards in the department.

Cost economy and cost competitiveness in designing database management system

Focus on Sustainable development and improvement in customer satisfaction

IPsoft Global Services Pvt. Ltd, India (Jun 2010 – Jul 2014)

Oracle Database Administrator

This is a subsidiary of IPsoft, a disruptive technology company pioneering innovation in the development and delivery of autonomic and cognitive technologies

Responsibilities:

Expertise in Oracle 11g/10g/9i installation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning and troubleshooting

Dealt with database creation for Testing and Development teams

Database refresh from Production to test and development (non-production) using duplicate and conventional methodologies

Written Shell scripts to automate the database cloning

Administered cluster(RAC) databases and created RAC system from non-RAC system

Upgraded the databases from 10g to 11g

Implemented standby databases supported by DATAGUARD and physical standby databases

Migrated databases from regular file system to ASM

Applied the CPU and PSU patches

Taken RMAN backups through NetBackup and tested crash recoveries using conventional hot and cold backups and RMAN

Installation and configuration of Oracle Client software and Tools

SQL Query Performance tuning, Statistics Gathering, Analyzing Objects

Worked on recovering data files, control files, block corruption

Used TOAD and OEM for database activities and script executions

Monitored running jobs and re-scheduled the failed jobs as per the scheduled time

Mekon Software LLC, Georgia, USA

Oracle E-Business 11i Technical Consultant (Jan 2009–Feb 2010)

Responsibilities:

Developed technical specifications from a business perspective depending on the specific business processes of the client as a part of Gap analysis

Implemented Customer Interfaces in AR to update the customer information

Used Service Contracts API’s to get contract details, coverage levels and available service for reports

Created Stored Procedures, Functions, Packages, Triggers using PL/SQL

Developed PL/SQL coding for packages, procedures, functions and database triggers to implement business rules

Helped in performing user management activities and database security management activities like password management, role based access control and grant/revoke privileges

Saturn Infotech Inc, Pennsylvania, USA

Client: Ricoh Family Group, UK (Aug 2008–Dec 2008)

Oracle E-Business 11i Technical Consultant

This client is market leader in manufacturing photocopiers and also manufactures cameras, printers, fax machines, etc.

Project 1: OA Framework for Efficient Meter Read Entry

Developed OAF pages for the Meter Capture form which enabled the capture of the Meter Readings more efficiently and helped in billing the customers

Responsibilities:

Extensively worked on creation of BC4J and UIX components required for OAF pages

Created and Customized UIX components such as Pages, Regions and items

Implemented Results Based Search in the Meter Entry Form

Deployed OA Framework pages and regions to the MDS Repository using XML Import Utility

Project 2: Interface of attributes from Siebel

Certain fields in Siebel for consumable and service orders were essential to be printed on dispatch notes and invoices in order for the end-customer to track the goods or check the invoices. For serving the above purpose, the fields needed to be interfaced with Oracle.

Responsibilities:

Created and amended PL/SQL Packages, Triggers, Functions and Procedures as per the requirement

Worked on Interface programs to load the data from flat files into interface tables

Prepared MD70, technical design document for the interface

Involved in creating users, menus, responsibilities, data groups and request groups using System Administration module

NOTABLE ACHIEVEMENTS:

Was rated as “Star Performer” twice for outstanding achievements by Allstate Solutions Private Limited

A plaque recognizing my outstanding achievements was awarded to me by IPsoft Global Services Pvt. Ltd

Reference:

Available on request.

Contact this candidate