Oracle DBA

Rana

Schaumburg, IL, *****

Tel: 224-***-****

Email: ***********@*****.***

OVERALL SUMMARY:

Over 10 plus years of extensive professional experience as Database Administrator and Business Analyst for Oracle Database Management Systems in the Information Technology Industry.

Extensive experience in Oracle 11g, 10g and 9i Database Administration and involved in installation, configuration, implementation, performance tuning and troubleshooting, logical and physical design of databases, creation of users, granting privileges and roles, managing schema objects, application testing and data modeling.

Experience in configuring OID/LDAP entries, tnsnames, listeners, sqlnet.ora and data guard on 10g databases.

Used SQL*Plus, SQL loader and export/import utility and to double check work performed I used OEM.

Extensive experience in Oracle Migration, Data Conversion, development of database triggers, procedures, functions and packages using PL/SQL. Also having experience in design, development, maintenance, Re-engineering and enhancements projects.

Extensive knowledge and work experience of Oracle 10g features like Automatic Storage Management (ASM), Data Pump, AWR

Implementation of Oracle Backup and Recovery strategies using RMAN (recovery manager) and creating RMAN scripts. Cloning of Databases using RMAN.

Expertise with usage of tools including Oracle Enterprise Manager (OEM), TOAD, ERWIN, Sql Developer.

Experience in RAC, ASM, Streams, DR& High Availability Solutions.

Extensive knowledge 11g databases to 12c and some experience on PostgreSQL.

Expertise with Real Application Cluster (RAC) form of Oracle DBMS.

Experience in Configuring Oracle DATA GUARD with Physical and Logical Standby, also familiar with 11g ACTIVE DATA GUARD.

Experience with Design and development of Conceptual, Logical and Physical data models.

Experience in Unix Shell Scripting for automating the DBA tasks and schedule Jobs in UNIX environment.

Database replication using Oracle Streams, materialized views and advanced replication methods.

Actively involved in resolving pre or post-implementation problems and work around.

Experienced in technical documentation.

Sound analytical, troubleshooting, problem-solving skills, and equipped with excellent communication and interpersonal abilities, and an acceptable teammate.

On call 24X7 Production Support. Willingness to work beyond regular hours.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQL*Plus, Java, Shell Script, C++, C, Pro*C

RDBMS: Oracle, SQL Server, Microsoft ACCESS, Mysql PostgreSQL

OS: UNIX, Linux, HPUX, AIX, Solaris, Windows

Tools: Oracle Grid Control, OEM, OID, SQL*Loader, Erwin, Import/Export Utilities, Quest Watch/Spotlight/Toad,SQL*Plus,SQL-Developer, Performance analyzer

PROFESSIONAL EXPERIENCE:

Schneider – Green Bay, WI (Jan 2016 - Present)

Sr. Oracle DBA

Responsibilities:

Proficient in Installation and configuring Oracle Restart, RAC 11gR2, Active Data Guard.

Installed and configured Oracle 11g R2,10g databases on HPUX, Linux, Sun and also upgraded Oracle databases from 9i to 10g to 11gR2 version using Opatch.

Resolving critical issues and educating the team to write root cause analyze and permanent fix.

Support Onsite / offshore DBA’s

Writing ad-hoc monitoring script to Monitor performance in DW Databases

Installed Oracle 11g R1/R2, 10g R1/R2, 9i software more than 50 Sun Solaris 10 Unix servers, Linux and Windows servers.

Created more than 100 Oracle 11g R1/R2, 10g R1/R2, 9i databases.

Upgraded Oracle servers from 9i to 10G R2 (10.2.0.2, 10.2.0.3, 10.2.0.4), Upgrade 9i/10g to 11g R1/R2.

Applied Oracle CPU patch quarterly for different version databases and other Oracle patches.

Troubleshooting various script and write new script to fix RMAN scripts

Installed and configured Oracle 11g R2, 10g RAC databases on HPUX, Linux, Sun. Configured CRS, ASM and grid infra-structure.

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Oracle 10g/11g RAC performance and tuning.

Restoration and recovery of databases during critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Performed installation and configuration of Oracle 10g/11g RAC databases on Linux.

Managing backup and recovery of Oracle 10g/11g RAC databases.

Tested database performance issues (monitoring and tuning) to ensure database optimization.

Implemented Oracle database backup & recovery solutions using RMAN.

Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.

Created user accounts, roles and granting required access permissions and privileges to the users based on the applications they are accessing.

Responsible for configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Worked with Data pump to take the logical backups of databases.

Performed automated backups and scheduling using scripting.

Wrote Stored Procedures and Triggers for database maintenance and management using PL/SQL.

Developing UNIX shell scripts and SQL scripts to carry out routine checks on databases.

Experienced in performing point-in-time recovery using RMAN.

Performed large batch jobs, and tuning of SQL queries and database systems.

Renaming and resizing the databases.

Configured and implemented Oracle Streams (Advanced Replication) for high availability.

Performed Schema as well as Table level Replication using Oracle Streams.

Configured Oracle Data Guard for disaster recovery.

Achieved high availability, data protection and maximum performance by maintaining both physical and logical standby databases.

Performed database replication through Golden Gate.

Used Oracle configuration assistants like DBCA (Database Configuration Assistant) for creating databases, DBUA (Database Upgrade Assistant) for upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNSnames etc.

Involved in designing logical and physical data models using Erwin.

Working experience with latest TOAD having new features, like PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, and Query Builder.

Created indexes to facilitate easy user interface implementation and tuning.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

RightWay Systems-UK (Feb 2015 - Dec 2015)

Sr. Oracle DBA/Business Analysts

Responsibilities:

Support a Data warehouse: Play a lead role in enterprise wide database optimization, instance resource monitoring. Perform root cause analysis on failures.

Resolve performance tuning related issues, reports and queries.

Work actively on new 10g features, Improved Intelligent Infrastructure (ADDM), Enhanced Active Session History (ASH), Automatic Workload Repository (AWR), and Automatic Storage Management (ASM).

Improved performance in daily transforms by identified and reorganizing indexes on major tables

Support a Data warehouse: Play a lead role in enterprise wide database optimization, instance

Identified, Led and established automation of repetitive processes to minimize errors.

Stared and managed biweekly optimization meeting with enterprise user groups to address and resolve performance related issues with high degree of success.

Working on setup a RAC data warehouse on Linux using ASM/OCFS2.

Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.

Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

Analyzed and maintained Business and System Requirements using Requisite Pro.

Involved in documentation during various phases of SDLC and SLC.

Analyzing migration business requirements and devising appropriate solutions. This included commercial requirements, customer experience issues, legal, regulatory and compliance requirements and operational exception processes.

Managing outstanding risks, issues and defects, and ensuring that these were successfully addressed and closed.

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Conducted designing, assembly and tuning of databases in coordination with development teams.

Coordinated with project teams for designing and implementation of database infrastructure designs by documentation and system testing.

Assisted in integration of Exadata applications into current IT actionable events and solutions.

Suggested procedures for database performance and tuning of all database machines and related components.

AT Digital-UK (Jan 2013 - Jan 2015)

Database Administrator-Business Analysts

Responsibilities:

Used Explain plan and oracle optimizer hints to enhance performance of SQL statements.

Performed the user requirements and troubleshooting activities and resolved connectivity issues,

Implemented, administrated and maintain daily backup and archived daily data on tap and dicks.

Created user accounts and system-level and user-level database objects.

Responsible for oracle 9i logical and physical database design, implementation and maintenance on windows.

Created new databases and users: setup backups, export and other monitoring scripts.

Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.

Managing database security, design, develop, and implement automated data backup and restoration procedures.

Provide technical support for database maintenance and disaster recovery.

Identify, recommend and implement all new database technologies and oracle license management.

Perform in-depth Gap analysis with different Business group that the system initiatives are met.

Modeling and documenting the end-user’s AS-IS workflow and TO-BE Business processes.

Created artifacts such as use case, and developed Use Case Diagrams, Activity Diagrams and Sequence Diagram.

Analyzed and maintained Business and System Requirements using Requisite Pro.

Involved in documentation during various phases of SDLC and SLC.

Analyzing migration business requirements and devising appropriate solutions. This included commercial requirements, customer experience issues, legal, regulatory and compliance requirements and operational exception processes.

Managing outstanding risks, issues and defects, and ensuring that these were successfully addressed and closed.

Gathering requirements for new system functionality.

Assisted in management and database administration of Oracle database applications on Exadata platforms.

Provided technical assistance for designing, installation and upgrading of existing Oracle databases.

Performed database management functions such as maintenance, access issues and security.

Conducted designing, assembly and tuning of databases in coordination with development teams.

Implemented procedures for automation of database management through tables and indexes.

Executed processes for evaluation of system space, database allocation and storage metrics.

Maintained all existing databases and new installations at current and stable production levels.

Heathrow Shuttle-UK (Jan 2012 - Dec 2012)

Data Analyst

Responsibilities:

Extensively gathered requirements from all users, experts, and key personnel to understand the current functionality of the existing system.

Perform in-depth Gap analysis with different Business group that the system initiatives are met.

Modeling and documenting the end-user’s AS-IS workflow and TO-BE Business processes.

Created artifacts such as use case, and developed Use Case Diagrams, Activity Diagrams and Sequence Diagram.

Analyzed and maintained Business and System Requirements using Requisite Pro.

Involved in documentation during various phases of SDLC and SLC.

Analyzing migration business requirements and devising appropriate solutions. This included commercial requirements, customer experience issues, legal, regulatory and compliance requirements and operational exception processes.

Managing outstanding risks, issues and defects, and ensuring that these were successfully addressed and closed.

Gathering requirements for new system functionality

Functional modeling of business scenarios through UML use cases

Working with Developer PL/SQL queries and Design New databases.

Created a new database, involving import and export, installing and configured database for oracle Application development environment.

Responsible for oracle 9i logical and physical database design, implementation and maintenance on windows.

Handled database server tuning, application tuning, maintaining, documentation, and capacity planning and database security.

Ora-Tech Systems Pvt. Ltd. Pakistan (July 2010 - Dec 2011)

Senior Software Engineer

Responsibilities:

Worked as Software Engineer in Campus Management Solution (CMS) based mini ERP solution using Oracle 10g for Arid Agriculture University Rawalpindi. That has Following

Modules o Getting Requirements, Analysis, Developed, tested and Implemented

University Admission, Academic System including admission process, student registration process.

Examination System including Enrolment process, Result Preparation process and result notification process.

Accounts system including computerized pay slip generation for students as

University staff which able to track students from getting the prospectus.

Attendance System both for Employee and Students. It includes date, subject and lecture wise student attendance which helps students to maintain their attendance.

Library system which includes Books/Journal/Non Book Materials/serials

Publication Purchasing process, issuance/receiving process, searching process and reservation process. It helps student wise Books/Journals/Non Books Materials searching and lost information.

Human Resource Management System capable to maintain employee’s procurement, Employee payroll integrated with Finance modules, point based increments and bonus system, Employee evaluation system, distributed timesheet Management Systems.

Library system which includes Books/Journal/Non Book Materials/serials

Publication Purchasing process, issuance/receiving process, searching process and reservation process. It helps student wise Books/Journals/Non Books Materials searching and lost information.

Budget system which includes add Budget, Budget Re appropriation and

Budget Revision and related reports.

Payroll system which includes adds Employees payroll and related reports.

Ora-Tech Systems Pvt. Ltd. Pakistan (Aug 2008 - Jun 2010)

Software Engineer

Responsibilities:

Worked as Software Engineer in Campus Solution (CS) based mini ERP solution using Oracle 10g for the University of Faisalabad. That has Following Modules

Getting Requirements, Analysis, Developed, tested and Implemented University

Academic System including admission process, student registration process.

Examination System including Enrolment process, Result Preparation process and result notification process.

Accounts system including computerised pay slip generation for students as

University staff which able to track students from getting the prospectus.

Attendance System both for Employee and Students. It includes date, subject and lecture wise student attendance which helps students to maintain their attendance.

Library system which includes Books/Journal/Non Book Materials/serials

Publication Purchasing process, issuance/receiving process, searching process and reservation process. It helps student wise Books/Journals/Non Books Materials searching and lost information.

Human Resource Management System capable to maintain employee’s procurement, Employee payroll integrated with Finance modules, point based increments and bonus system, Employee evaluation system, distributed timesheet Management Systems.

Inventory Management System capable to maintain store issue requisition, demand order, purchase order, goods receiving, one click goods inspection, maintain in with help of gate keeping system, complete BackOffice to manage administration tasks.

Vehicle/Transport Management System capable to Vehicle Maintenance, Vehicles, Vehicle Maintenance Plan, Transport Request and arrangement, Vehicle Parts Maintenance, Stops and Routes arrangement.

Construction and Maintenance Management System capable to tasks management to related Employee, Materials Usages, Task Categories, Task Status Check, and Task Type managed.

General Administration Management System capable visitor Check and balance, General Tasks of administrative, Proper Notes manage and proper record of notes, check notes status, managed daily calls, visitor status, visitor type, visitor organization.

Hostel Management System capable Hostels Proper Room allotments, Managed Hostel Members, Hostel Appliances, Hotels Item. o Access Management System maintain needs of Mini ERP, it fulfils constraints of role based access groups management, dynamic constraints allocation on data, maintains business logic on database level.

Worked as Software Engineer in Textile Solution (TS) based mini ERP solution using Oracle 10g for the HaamiTex Manufacturer.

Manzoor Sizing Industries Pakistan (Feb 2007 - July 2008)

System Analyst/Junior Database Administrator

Responsibilities:

Getting, Analysis Requirements and SDLC phase worked as System analyst and Team Lead on different projects such like Account, Inventory etc.

Help in different Issue to different Team Members in SDLC phase and projects during Requirements Gathering, Requirements Analysis, Testing, Implementation and Maintain Phases.

Analyze and resolve technical issues and problems.

Requirement Gathering, Requirement Analysis, Design, Implemented and maintenance issue as a Team Lead.

Primary responsibilities include design and development of Database.

Design Database such like Inventory, Accounts, and Payroll and Items orders.

User management, Creation and Assignment of Roles to users.

Checking Database Performance and taking care of regular backups of database.

Table space Management.

Tables & Views designing for development team.

Oracle Client/Server Networking

Provided help to team members in SQL Queries and other issues related to databases.

M. K. SONS Pvt. Ltd. Pakistan (July 2004 - Jan 2007)

Software Engineer

Responsibilities:

Worked as Software Engineer in Different module using Developer 6i and Oracle 9i for the M. K. Sons PVT. LTD. Faisalabad Pakistan. That has Following Modules

Developed, tested and deployed successfully implements

Purchased Inventory Module.

Marketing Management Module for order tracking and preparing order.

Export Management Module for Export Documentation.

Invoicing Management Module for customer different type invoice solution.

Production Management Module for production unit for lot management and gray management module also covered.

Finance and Salary Management Module.

Research Work in MS (CS): Enhancing Early and Cost-Effective Software Fault Detection through Monitoring Method during Development in Pakistan

Environment: Oracle 9i/10G/11g/12c, Toad, OEM 10g Grid Control, Shell Scripting, PL/SQL, SQL*PLUS, AIX-UNIX, AIX, Sun Solaris 2.9, Red Hat Linux.

ADDITIONAL SKILLS: Goal oriented: results achiever, Meeting deadlines, Quick learner, Excellent Communication Skills, Accountable, Self motivated, Honesty and Integrity, Multilingual (English, Hindi, Urdu\

Education:

MA in Marketing and Innovation (Anglia Ruskin University UK) (Cambridge)

PgD in Business Management (London)

PgD in Strategic Management and Leadership (London)

MS (CS) (Software Engineering) University of Agriculture Faisalabad

Master in Computer Sciences Hamdard University Karachi

Certification:

Certified Professional Oracle Database Administration

Certified Professional Oracle PL/SQL

Certified Professional Oracle Form Developer

Contact this candidate