Oracle Database 11g Administrator

Location:

Richardson, TX, 75081

Salary:

90$

Posted:

September 26, 2019

Contact this candidate

Resume:

CERTIFIED PROFESSIONAL

Oracle Database **g Administrator

Mohd K. Rahman (MBA (with IT))

Oracle Certified Professional DBA (11g, 10g & 9i)

Legal Status: US Citizen

Phone: 609-***-****

email: ******.********@*****.***

SUMMARY:

Information Technology professional with extensive Oracle database administration experience

and Oracle Certified Professional credential. Has a diversified exposure to advanced technologies.

>Have advanced Oracle database design, Install and administration knowledge, capable to write scripts, query the system and generate customer reports.

>Dealing with customers to gather and document requirements as specified by the customer.

>Experienced to work across a diverse team of software and systems engineers, training development specialists, software technicians, and security specialists.

>Efficient in successfully develop, plan & establish Database Performance Bbaselines and Monitoring Performance trends to identify and correct problems.

>Experienced with architects and technical specialists to identify proper hardware and Software Upgrade implementations.

>Managed database security infrastructure and manages user accounts.

>Worked closely with IT project managers, database programmers, and multimedia programs to accommodate / develop and implement the customers' business needs.

>Efficient in preparing database documentation, including standards, procedures and definitions for deliverable data dictionaries.

>>Apps:

• Oracle E-business suite (install, upgrade, maintenance)

• Oracle Fusion middleware product, WebLogic, SOA etc.

• Oracle Access Manager/Oracle internet directory

• Oracle Hyperion (DRM, HFM, FDM, Essbase)

• Informatica

• OBIEE

• Oracle enterprise manager (OEM12c, OEM13c)

Oracle 12c/11r2g/10g/9i Database Administration Grid Infrastructure and ASM

EXADATA

Oracle Real Application Clusters (RAC) Data Guard

GoldenGate

AWS

Oracle Maximum Availability Architecture Disaster Recovery

RMAN Backup and Recovery Capacity Planning

Clone Export Import and SQL*Loader Table Partitioning

Materialized View Replication Performance Tuning

* OEM GRID Control configure to Monitor.

* Performance Tuning / SQL Tuning.

* Backup & Recovery: Configuring, Automating and Maintaining using RMAN, IBM TSM / Tivoli, and DDboost.

* Oracle GoldenGate: Installation, Configuration and Monitoring / Maintaining.

* Oracle Advanced Security Option (ASO/NDE).

* ETL: Extracting, Transforming, Loading business data into Data Warehousing and Testing environments.

(Maintained up to 46 TB Data Warehousing / Repository Database during my last engagement with IBM)

GoldeGate related skill set:

(Oracle related Golden Gate expertise)

- Experienced in Implementing GoldenGate on Oracle environments.

- Configuring / Implementing Oracle to Oracle Uni-directional GoldenGate replication.

- Configuration of Replicating Transactions between SQL Server and Oracle Database Using GoldenGate.

- Upgrading Goldengate from 10g to 11gr2.

- Writing & automating necessary monitoring UNIX scripts for GoldenGate using Crontab.

- Configure error handling, logging.

- Trouble shooting and performance tuning GoldenGate replications to speed up & handle Lagging issue.

Over all 11+ years of Professional in Oracle RDBMS OLTP, OLAP / DSS / Datawarehouse databases (12c, 11g, 10g, 9i & 8i) Administrative functionalities such as RAC/ASM, OEM Grid, Golden Gate / Shareplex, Dataguard Implementation, Administration, Database Designing / Creating, Upgrading, Migration, Backup & Recovery. Moving Data, Partitioning, Performance Tuning at Instance level and SQL level, Space Management, Database Security, Auditing, Troubleshooting, Writing / Debugging PL/SQL code, Shell Scripting on various Operating Systems environments (LINUX / HP-UNIX / SUN SOLARIS /AIX and Windows platforms).

11+ years of Production Support DBA.

3 years of MSSQL DBA Experience: MSSQL 2005/8/12

8 years of Oracle Security and User Accounts Management.

6 years Performance Tuning (SQL level & DB level using OEM Diagnostic Pack & Toad).

6+ years of Database Architecture, Installation / Setting up / Patching GRID infrastructure & RAC(10g, 11g & 12c) and Designing / Creating, Troubleshooting / Performance Tuning, Monitoring and Maintaining RAC Databases.

6 years Installation, Migrating and Upgrading the databases from 9i onward upto 11g.

5 Years of SQL and PL/SQL Programming / Scripting.

5 Years of Shell / Perl Scripting.

4 Years of Configuring, Implementing, Syncing Dataguard (Physical Standby Databases) on standalone as well as multi-nodes RAC environments.

4+ Years of configuring & maintaining Shareplex (Uni-directional) as replication tool in number of VCS cluster environments.

5+ Years of Backup & Disaster Recovery with RMAN, IBM TSM / Tivoli, DDBOOST and Export/Import.

6 years of Oracle Architect DBA experience.

3 Years of Oracle Developer DBA (PL/SQL Programmer) experience.

4+ Years of experience in Configuring / Implementing & Maintaining Shareplex (Uni-directional) as the replication tool in number of VCS cluster environments.

5+ Years of experience handling extensively ETL processes (Data Extracting, Transforming & Loading).

7+ Years of experience in using OEM (12c & 13C) for monitoring and Performance Tuning.

6+ Years of experience in using TOAD managing DB objects and Performance Tuning / Scripting.

3+ years of experience in Configuring / Implementing & Maintaining GoldenGate (Uni-directional and Bi-directional ) replication.

5 years of Oracle Architect DBA.

3 Years of Oracle Developer DBA.

4+ Years of GoldenGate DBA.

4 Years of Oracle Developer (PL/SQL Programmer) DBA.

3 Years of SQL server DBA.

3 Years of DB2 DDBA.

2+ Year EXADATA experience.

2 Years of Database Project Management experience.

NB: I also have experience with Oracle Advanced Security Option (ASO/NDE).

My Strengths includes:

Supporting over 600 Oracle Databases 8i, 9i, 10g RAC, 11g RAC and 12c RAC including production critical 24x7 instances running in archive log OLTP, OLAP / DSS / Datawarehouse databases sizes of range up to 46TB data warehouse Databases.

Oracle PL/SQL Development, Debugging, Coding, SQL Tuning and SQL Server on various LINUX, UNIX, Sun OS and Windows

Working as a Team Lead Role or any other designated Role.

Experienced in entire system life cycle including Analysis, Design, Programming, Testing, Debugging and Implementation of client/server based Oracle applications.

Good Technical, Analytic, Communication and Interpersonal skills.

Experience with SOX auditing processes.

Experience with Oracle Advanced Security Option (ASO).

Collaborative teamwork: Experience working with operational support teams, both on-shore & off-shore.

Ability to investigate and/or coordinate investigations into high-profile, high-priority issues.

Experience building small applications with Oracle Application Express (APEX).

TECHNICAL COMPETENCIES

Oracle DBA and IT Professional:

Installation, configuration of Oracle 7.3 .4 on SCO UNIX 5.0.5, Oracle 8.1.7 on SCO UnixWare 7.x and

Oracle 9.2.0.1 on Red Hat Advanced Server Linux2.1 Up gradation of Oracle Databases from Oracle7.3.4 to Oracle8.1.7, 9.2.0.1.Applying Patches to Oracle as and when Oracle releases (Applied 9.2.0.2, 9.2.0.3, 9.2.0.4, 9.2.0.5, 9.2.0.6 patches to Oracle 9.2.0.1)

Oracle7.3.4, 8.1.7, 9i and 10G Database Administration, UNIX (SCO Open Server 5.x, UnixWare 7.x, Open UNIX 8.0, Red Hat Advanced Server Linux 2.1, Red Hat Advanced Server Linux 3.0 & Red Hat Advanced Server Linux 4.0 &5.0.

Performance and Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, Oradebug, Tkprof and Explain Plan, Diagnostic ADDM, AWR, ASH Methods.

Oracle PL/SQL Development, Debugging, Coding, SQL Tuning and SQL Server on various LINUX, UNIX, Sun OS and Windows

Backup and Recovery : Implemented Hot backup in manual method using scripts and Using RMAN

and recovered various development and critical Productions systems on various products.

RAC ( 10g & 11g RAC) : Setting up GRID infrastructure & RAC Installation, Designing / creating RAC Databases,, patching, Troubleshooting & Performance Tuning, Monitoring and Maintaining RAC Databases

Database Upgrades: Handful experience in Upgrading oracle databases from

Versions 8 to 8.1.7.4 8i to 9i, 9i to 10g, And 9i Upgrades like 9.2.0.6/7 to 10.2.0.2/3 on Red Hat Linux

Database Design experience, Shareplex.

Cloning databases & Oracle Installations on various UNIX & LINUX servers.

Maintained Standby Databases and implemented 9i & 10G Data Guard Setup.

Data Privacy: Successfully Implemented latest 10G security features like TDE (Transparent data encryption), VPD (Virtual private database), FGAC (Fine grained auditing control at row and column level).

Automated various monitoring scripts and converted various shell scripts using the feature DBMS Scheduler

Oracle 9iAS, Portal Database Setup, Tuning and Configuration.

Capacity Planning and Sizing the Servers for entire system life cycle.

Oracle Tools – Oracle Enterprise manager (OEM), Stats pack, SQL Trace, TKPROF, AWR, ADDM, SQL*NET, Net8 Assistant, TOAD, SQL * Loader, DB artisan.

Maintaining of Weblogic servers .Monitoring and resolving the issues.

Maintaining, installing web servers/Apache server in APPS 11i Database.

GoldenGate, Materialized views, streams, Shareplex replication experience with Oracle 8i, 9i & 10G Databases.

Managed number of 14 TB Data Repository / Datawarehouse Databases, performed structural changes and ETL activities.

Set up monitoring for various environments using tools like Oracle Enterprise manager (OEM).

Shareplex replication: Installation, configuring, Monitoring, Troubleshooting and Tuning Supporting Shareplex in Stand-alone environment.

GoldenGate: Installation, configuring, Monitoring, Troubleshooting and Tuning Oracle GoldenGate in number of RAC (Real Application Cluster) environments.

Data Encryption, Transferring (export/Import) Encrypted Data using Datapump and Backup & restore Encrypted Data using RMAN

Implementing and Managing Wallet

Mid-level DB2 DBA expertise

Junior level of PeopleSoft Admin

Junior level of SAP BASIS Admin

Mid level SQL DBA

OTHERS:

Maintenance and Monitoring & Development of PL/SQL

Rebuild indexes periodically. Very flexible Oracle job would accept the owner, tablespace and table name patterns and rebuild all matching indexes or only those that were too large, very fragmented. Extents re-sized appropriately. Target tablespace could be different for fragmenting an entire tablespace.

Monitor long transactions. Pro-actively take care of potential performance issues due to uncommitted hung transactions or poor query

Database health. Set of scripts for detailed and precise information about locks, SGA, cache, objects in cache, stats, events, and space in the database at the current time. Another script for trending over a period of time. Monitored largest free chunk per tablespace as well.

Analyze tables and indexes. Stored procedure could decide if to compute or estimate or let the caller override. It took owner, object name pattern as input

Alert log error mailing Sending SMS to DBA team of any errors in alert log every 10 minutes.

Disk space. Monitor disk space free space. Monitor archive destination. Setting up Mobile Alerts which sends SMS to DBA team in critical situations

Archive Logs. Monitor archive logs and zip, move, purge them periodically. Redirecting the Archivelog directory in SAP databases.

Secure SQL*Plus connections so that only privileged users can connect. Monitored logged sessions and killed unauthorized sessions.

System table space, Oracle job to move new users off of the SYSTEM table space

Database structure. Script to dump database table, index and column definitions into flat files. Script could then recreate optionally resized objects.

Schema comparison: for differences in tables, indexes, columns, grants, triggers etc.

Maintaining of Weblogic servers web logic servers (6.0.7.1 and 8.0) .Monitoring and resolving the issues.

Maintaining, installing web logic servers (6.0.7.1 and 8.0)/Apache server in APPS 11i Database.

Invalid Objects: Find and compile all invalid objects using SQL generating scripts.

Standards: Script to help follow company standards when creating a new database. UNIX system administrator. General System Admin duties including creating users, backups, vi editor, ftp, mounting and unmourning, creating mount points, creating users, groups and giving access rights, Creating Disk groups and Volumes on Veritas. Crontab jobs for backup, security checks and file system dumps/restores. Monitor important daemons and to restart if any fails.

Tuning of DB and coding

I/O balancing: split the tablespaces in 5 or more datafiles to even out on all the disks. Moved datafiles for partitions of large partitioned tables to their own tablespaces distributed on various disks. In sort-heavy situations, split the TEMP tablespace over multiple disks as well. Working with Locally Managed Tablespaces

Rollback, Redo, Extents: Resize rollback segments to avoid dynamic allocation of space by pre-allocating the extents. Presently working with SMU (System Managed Undo).Increased numbers of redo log groups to avoid archiver hanging, increase size of redo logs to avoid too frequent archive logs. Maintained extents previously and now all working with Locally Managed.

Optimized SQL queries: To run from a few minutes to 15 seconds or less by reordering the where clause, using subqueries in joins, realizing and creating indexes on columns in the where clause. Tuned PL/SQL codes to run in shorter time.

Used UTLESTAT and UTLBSTAT and STATSPACK for Database wide performance issues to tune the SGA and all. Used Analyze, Explain Plan and Tkprof to tune the SQL Queries.

Technical Training

Oracle 12c: Performance Tuning: inside Verizon facilities, Dallas, TX

Oracle Database 11g: Real Application Clusters: inside Verizon facilities, Dallas, TX

Oracle Database 11g: Performance Tuning

DBA Training in Oracle 11g, 10g & 9i at Teckskills Inc., Dallas, TX

Integrating Data Encryption into a Database Security Design: Virtual Lab

PeopleSoft ADMIN training at TS Techno services USA, Reston, VA

SAP ADMIN: BASIS & ABAP training NIMO IT Inc., Richardson, TX

(Other essential Admin/required trainings listed at the end as Training Received)

Technical Proficiencies

Platforms : HP-UX 10.x/11.x, Sun Solaris 8/ 9/ 10, AIX 4.3/ 5.1,RHL/LINUX 2.0.1

High Availability : Oracle 10g/11g RAC Advanced Replication, Clustering and Data Guard Setup, Configuration and Tuning.

RDBMS : Oracle 12c/11g/10g/9i/8i, SQL SERVER 2000, 2005 and DB2

Languages : PL/SQL, Shell Scripting, C, Visual BASIC, C++ and ABAP (SAP)

Tools : Export/Import, DATAPUMP, RMAN, OEM Grid Control, SQL*Loader, TOAD, DBARTISAN

Replication : Shareplex & Golden gate /Oracle streaming

ETL Tool : Informatica 8.2, Cognos (Datawarehouse / Repository Database tools)

Education

MBA in Information Technology (IT Major)

Oklahoma City University, OKC, Oklahoma

NCC International Diploma in Computer Studies

(NCC Education & Training, Oxford, Manchester, UK )

Certifications

1. Oracle 11g Certified Professional DBA (OCP DBA)

2. Oracle 10g Certified Professional DBA (OCP DBA)

3. Oracle 9i Certified Professional DBA (OCP DBA)

Professional Experiences

Verizon

October 2016 – Till date

Role: Senior Oracle DBA

My main Role in this group is to provide Infrastructure Building/Change/Restoration support as well as production support (maintenance support) to all the RAC, Dataguard, Backup & Recovery (RMAN, DDBOOST and EXPORT-IMPORT) and GoldenGate environments.

Roles & Responsibilities in Verizon:

Various DBA roles such as Architect DBA as well as Production support DBA Roles (as follows):

•Installation, Configuration and Maintenance of oracle 12c/11g/10g/9i databases on AIX / Sun Solaris / HP-UNIX, oracle enterprise Linux servers an d on Windows.

•Configuration and implementation of RAC, ASM, Clusterware, Grid Infrastructure, addition/ removal of RAC nodes.

•Troubleshooting RAC issues like bugs, network issues, configuration files issues, OCR issue, and Node eviction issue.

•Configuration and Implementation of Dataguard Physical / Logical Standby Databases and Automating the Monitoring / Resolving on and off Gap or lagging issues..

•Installation and configuration of GoldenGate 11g to maintain the schema level Replication and High Availability of the Database.

•Configuration and Implementation of Oracle to Oracle Uni-directional & Bi-directional GoldenGate Replication.

•Enforcing DDL changes Replication using GoldenGate.

•Upgrading Goldengate from 11g to 12c.

•Configuration and implementing various RMAN Backup and Recovery using Catalog or controlfile.

•Configuration and implementing DDBOOST and TAPE (TDPO) Backup and Recovery.

•Configuration and implementing / Automating Datapump Backup jobs (Full DB, Schema Level, Table Level).

•Frequently Cloning/Refresh Databases using RMAN, DDBOOST, Datapump export and import utilities.

•Configuring and performing Flashback, Restorepoint, Archivelogs managing and Recovering Block-corruption using RMAN.

•Pro-actively Monitoring and Management Databases using OEM GRID Control.

•PL/SQL and Shell scripting to Automate Monitoring, Backup jobs, cleanup and Reporting jobs using CRONTAB as well as DBMS_SCHEDULER utilities.

•Enforcing and managing Security and Audit requirement compliance.

•Performance tuning by Fine Tuning Initialization parameters, I/O, Memory, storage and Operating System kernel parameters, Oracle SQL, optimizer, and query plan, optimize queries and performing PL/SQL code profiling.

•Troubleshooting the Database Performance issues by analyzing Automated Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostics Monitor (ADDM) reports, using SQL Adviser & UNDO Adviser tools, OEM GRID, TOAD / DBARTISAN (third party tool).

•Tracing Blocking / Locking and Long Running sessions, Wait Interface.

•Capacity Planning as per Data growth and work-load by working closely with other decision making Teams such as Development, Business / Clients.

•Sharing ONCALL rotation weekend shift.

•Working with Application Development and testing teams for new Project Builds and troubleshooting the performance issues for SQL.

Environment: Oracle 12c/11g RAC, ASM, GoldenGate 11g, Oracle Cluster ware, SAN, OEM Grid Control, Dataguard, EXADATA, AWS, OUI, EXPDP, SQL*LOADER, Wallet PL/SQL, Unix Shell scripting, RMAN, Oracle Enterprise Linux 5, AIX 6.1/7.1, Sun Solaris, Windows NT, Windows 2008 server.

IBM

March 2013 – Jan 2016