Oracle Database

Agha Haider

630-***-**** ********@*****.***

PROFESSIONAL SUMMARY:

* ***** ** ********** ** wide array of technologies with variety of clients in Oracle database administration as production support database administrator on Production and non production environments which includes planning, installing, configuring, upgrading Implementing, and administering Oracle databases on various platforms (Unix, Linux, AIX, Sun Solaris ).

KEY SKILLS:

Supported and maintained the Windows environment.

Created multiple Oracle 11g new databases manually through script and through a GUI interface.

Experience in Creating and maintaining Database Objects and managed Oracle Users, Profiles and the associated tablespaces, Roles & Privileges.

Participated in Disaster Recovery (DR) exercises.

Upgraded databases both manually and through a GUI interface from 8i to 11.2.0.2,from 10.2.0.4 to

11.2.0.2 on standalone (single instance) environment and from 11.2.0.1 to 11.2.0.3 on RAC environment.

Performed database refreshes using Export/Import utility and performed database Cloning.

Applied Quarterly SPU / CPU Oracle security patches.

Experience in using statspack, AWR/ADDM report, sqltrace, analyze schema to fix performance related issues.

Ensured successful database Archive log backups and regular COLD and HOT backups using RMAN.

Experience in Grid control installation and setup for oracle 10g & 11g.

Have experience implementing and using OEM (Oracle Enterprise Manager) and configuring database connectivity issues.

Identify and correct space contention issues on tablespaces and directories.

Created SR's and worked with Oracle support.

Experience in implementing 10g RAC with ASM & Data guard for various platforms.

Experience with tools/utilities: AWR, ADDM, Statspack, OEM, RMAN, traditional export/import and with Data pump.

Performed the Decommissioning of the databases

Developed Shell scripts to automate and monitor database operations on Cron jobs.

Evaluated hardware, system specifications, and capacity planning.

Coordinate with multiple teams and account administrators to ensure the success of scheduled projects and system changes.

Worked with application installation teams to determine database requirements for new applications.

Worked on multiple ticketing systems like Manage Now, Impact, Maximo.

Provided 24X7 production Database On call support and responded to off hours page out issues.

Ability to excel in a team environment, skill to coordinate and work within a team.

Excellent Verbal, technical Writing and Communication skills.

U.S. Permanent Resident (Authorized to work). TECHNICAL PROFILE:

Languages: SQL, PL/SQL

Databases: Oracle 8i, 9i, 10g, 11gR2.

Tools: SQLPLUS, Netca, DBCA, DBUA, Export/Import, Data Pump, crontab, ADDM,RDA, ASM, OEM, TOAD, RMAN, TKPROF, SQL Trace, STATSPACK, SQL Advisor.

Operating Systems: Red Hat Enterprise Linux (RHEL), HPUX, AIX, Sun Solaris, Microsoft Window 2003, 2008, XP.

Expertise:

Database Creation, Cloning, migration and Refreshes Materialized View Servers Setup.

RMAN, Export / Import, Datapump. Statspack, Analyze /ADDM/ AWR reports. High Availability and Tuning/Monitoring.

Data Guard (physical and logical SUPPORTED THE ENVIRONMENT) RAC Installation and Configuration

Grid Control

PROFESSIONAL EXPERIENCE:

Senior Technical Analyst/Engineer June 2015 to Present

Oracle Corporation America Lehi, UT

Respond to customer needs in supporting High Availability and critical systems issues dealing specifically with Oracle Enterprise Grid installations using Real Application Clusters and Automatic Storage Management.

Support Oracle Grid installations over multiple hardware and software configurations (Linux, Solaris or AIX and OS Virtualization)

Familiar with troubleshooting Network latency and performance issue that affect Grid and ASM Oracle installations as they pertain to both Private and Public networking schemes

Work directly with client in troubleshooting and identifying RAC and ASM errors and finding resolutions up to and including bug fixes, patches and upgrades to the newest versions of Oracle products as needed.

Troubleshoot, identify and submit bug request fixes working directly with client issues and the development team to provide the best possible support for Oracle clients.

Oracle Database Administrator Jan 2013 May 2015 Covisint Detroit, MI

Installation of Oracle 11g databases in production, development and test environments depending on project

requirements.

Collaborated with the UNIX system Administrator to configure any software and hardware requirements that

will function with the Oracle Database

Refreshing development/test database from production using Export/Import & RMAN backups.

Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.

Managing database security.

Creating and assigning appropriate roles and privileges to users depending on the user activity.

Defragmentation of tables and indexes for improved performance and effective space management.

Have touch point calls with offshore team and make sure all issues happens in off business hours are addressed with sense of urgency.

Setup the unidirectional replication on oracle 11g databases using Goldengate.

Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.

Successfully upgraded the databases from 11g to non CDB 12c.

Successfully migrated 12c Non CDB databases to pluggable databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

Managed Database Maintenance Activities to achieve optimum database uptime.

Configuration of Listener and Tnsnames.

Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.

Created database link between two databases to access the table data from one local database to remote

database using distributed database feature.

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..

Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users,

etc. as well as much problem solving.

Designed Logical and physical database for business transaction functionality.

Provide production support for the deployed project till it is stabilized.

Written SQL scripts to create database objects like tables, views and sequences.

Created procedures and functions using PL/SQL.

Preparation of High Level & Low Level Design documents.

Oracle Database Administrator Oct 2011 – Dec 2013

(Account Focal Security Team Member)

IBM – Dubuque, IA

Installation, configuration and upgrading of Oracle server software and related products, setup and maintain multiple Oracle 9i/10g/11g databases that includes the Oracle RAC databases on Linux, Sun Solaris and AIX servers.

Installed and configured 11g in production and non production environment.

Performed database cloning for multiple Oracle databases.

Coordinated and worked with development team extensively.

Applied quarterly SPU/CPU Patches.

Ran manual health checks on Oracle databases and did remediation.

Resolved Listener Configuration issues.

Supported and advised the development teams on database related issues.

Used Oracle Enterprise Manager (OEM) to view the performance of the database and view and pull out the ADDM report.

Granted and Revoked privileges, Roles to the users as required.

Ran weekly Analyze statistics on Schema and table level.

Created and granted Roles and Profiles to users.

Designed and implemented disaster recovery strategies, hot and cold backups.

Carried out the setting up of RMAN back up schedules of databases.

Performed database tuning using tools like AWR / ADDM Report, Stats pack etc.

Created, managed various users and the associated tablespaces.

Experience with DBUA for Upgrade and used Export/Import and RMAN utility to migrate the database.

Trouble shoot and fixed number of RMAN backup jobs and Data pump Export issues.

Upgrade from Oracle version 10.2.0.4 to 11.2.0.2 and 11.2.0.1 to 11.2.0.3 on the production and non production environment.

Created multiple databases manually using script and using GUI.

Managed the existing databases by applying new required release modification to existing database structure by applying new released Oracle security and bug patches as required.

Worked closely with Oracle Support on various Oracle issues.

Designing and developing backup and recovery strategies.

Built and configured RMAN Recovery Catalog for Backup.

Successfully recovered corrupted databases.

Participated in Disaster Recovery (DR) exercises.

Setup and maintained documentation according to standards.

Supported and performed the maintenance of the Dataguard environment databases.

Troubleshooted various issues during installations and day to day activities.

Worked on multiple ticketing systems like Manage Now, Impact, Maximo.

Worked with multiple cross functional teams of engineers, and production OS server, Project managers and Service delivery managers to understand business process and develop functional specifications as required to complete projects in time.

Worked as a part of global team to provide 24/7 supports on all production environment Oracle Databases.

Analyzed the infrastructure requirements for new projects & managed the environment build process.

Maintained all the documentation including all the procedure plan documents.

Environment: Oracle 8i, 9i,10g/11g, RAC on RHEL4 U6,AIX, SQL, PL/SQL,OEM, Dataguard, Shell Scripting, Windows 2005/2008.

**References Available Upon Request**

Contact this candidate