Candidates About

 

Danish

Oracle DBA

SUMMARY:

Ø  Total of 6 plus years in relevant IT field

Ø  6 years of experience in Oracle DBA

Ø  Build, configured and administered 2 node RAC

Ø  Worked extensively with ASM builds and disk group management.

Ø  Implemented proactive monitoring scripts for production databases.

Ø  Troubleshoot performance issues using ASH, AWR and ADDM

Ø  Worked on Data Migration project.

Ø  Implemented Various RMAN backup methods.

Ø  Worked on Data Movement using Export Import and Data Pump

Ø  Build Data Guard for disaster recovery site.

Ø  Worked on Materialize Views

Ø  Strong Administrative skills on Linux

Ø  Worked on SQL Server Database Management.

Ø  Vast experience on Linux, AIX, HPUX, Solaris and Windows.

Ø  Build and configure 12c standalone databases.

Ø  Familiar with container and pluggable databases concept.

Ø  Upgrade databases from 9i to 10g to 11g to 12c

Ø  Restored and recovered the databases using RMAN

Ø  Experience in installing patches for upgrades and for various problems.

Ø  Experience working with 24x7 production support.

Ø  Good knowledge of Oracle internals and architecture.

Ø  Experience in installing, configuring and maintaining Standalone and RAC databases

Ø  Creating roles, profiles, privileges and assigning roles to users.

Ø  Extensively worked on monitoring and optimizing the database by performance tuning

Ø  Monitor usage of the databases and perform database tuning.

Ø  Worked heavily with 10g, 11g and 12c Grid control.

Ø  Troubleshooting of networking issues.

Ø  Good understanding of Indexes and statistics, Dictionary tables and views.

Ø  Analyzed Tables, Indexes periodically to optimize the SQL queries.

Ø  Have knowledge in Exadata.

Ø  Worked on GoldenGate replication

Ø  Applied one off, CPU and PSU patches.

 

TECHNICAL SKILLS:

 

OS & Administration	Ø  Linux, Windows, Solaris,
Database	Ø  Oracle 9i, 10g, 11g, 12c / SQL Server 2005, 2008
Concepts and Administration	Ø  12c Data Guard, RAC, ASM, GoldenGate, 12c Cloud Control, TOAD, ERWIN

 

 

 

EXPERIENCE:

 

Company       : HP, Dallas, TX       

Role                : Oracle DBA

Period             : Mar 2014 – Present

Environment  : Oracle 10g, 11g RAC, ASM, Linux, Solaris, DataGuard

 

Ø  Provided day to day operation to support production and non-prod databases

Ø  Build 2 node RAC clusters

Ø  Setup Data Guard form standalone and RAC clusters.

Ø  Provided support to application and development team.

Ø  Automated tasks using shell scripts

Ø  Worked with storage team for ASM disk layout.

Ø  Applied Quarterly patches.

Ø  Working knowledge on Golden Gate tasks.

Ø  Installed Databases on VMWare.

Ø  Involved in 24x7 support for production RAC databases with on-call pager

Ø  Installation of 11g and 12c clients/databases on Solaris and Linux.

Ø  Worked with Storage team to allocated SAN to RAC

Ø  Worked with offshore team.

Ø  Worked on 12c cloud control.

Ø  Worked on monitoring shell scripts.

Ø  Configured and installed with SQL Server Performance Dashboard.

Ø  Migrated 11g database to 12c R1.

Ø  Helped application team troubleshooting performance related issues.

Ø  Very familiar with Oracle internals.

Ø  Worked closely with developers on performance issues.

Ø  Familiar with ASH, AWR and ADDM reports.

Ø  Experienced with Space Management and Security.

Ø  Experienced with GUI and CLI to manage database farm house.

Ø  Rebuilding of Indexes for better performance and maintenance of Oracle Database.

Ø  Configured and Maintenance of SQL Server databases

Ø  Implemented 10g, 11g Physical Data Guard.

Ø  Importing data from flat files into database using SQL loader and External Tables

Ø  Written shell scripts to automate the tasks

Ø  Comfortable supporting physical and logical database design of RDBMS

Ø  Database sizing, Capacity Planning.

Ø  Worked on relational modeling using ERWIN.

Ø  Worked very closely with development team

Ø  Perform capacity planning required to create and maintain database environments.

Ø  Supported 24/7 on-call pager support for mission critical financial databases.

Ø  Performed administrative maintenance, monitoring on Oracle database systems in a global

Ø  Provided 24x7 operational environments.

Ø  Involved in gathering requirements from end users.

 

 

Company        : Boeing, Glendale, AZ

Role                : Oracle DBA

Period             : Feb 2011 – Feb 2014

Environment  : Oracle 9i, 10g, 11g RAC, ASM, Linux, Solaris, Data Guard, GoldenGate

 

Responsibilities:

 

Ø  Installing ASM environment and migrating database from NON-ASM to ASM.

Ø  Configure and manage tablespaces, tables, and users for custom applications.

Ø  Developed views, materialized views, functions, procedures, triggers, packages using DDL DML, PL/SQL, and SQL to transform data between source staging area to target staging area

Ø  Creating and dropping of users, granting and revoking permissions to users/roles as and when required.

Ø  Created users, roles and granted privileges per the business requirements.

Ø  Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.

Ø  Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.

Ø  Restored and Recovered SQL Server Databases.

Ø  Configured and installed with SQL Server Performance Dashboard

Ø  Performed database cloning to setup test and development database.

Ø  Migrated databases to different data datacenter.

Ø  Handled RAC Node hangs and node eviction issues.

Ø  Maintaining schemas and partitioning tables.

Ø  Worked on DB Monitoring scripts

Ø  Configured Alerts using 12c Cloud Control.

Ø  Index management for better performance, maintenance of Oracle Database

Ø  Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.

Ø  Responsible for administration and supporting oracle 11g, 10g and 9i databases

Ø  Created, upgraded, and cloned Oracle databases for Development and testing databases.

Ø  Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Ø  Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.

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

Ø  Created indexes to facilitate easy user interface implementation and tuning.

Ø  Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic

Ø  Data Modeling, Database Design and creation using Erwin.

Ø  Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.

Ø  Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Ø  Automated the replication process using materialized views for reporting databases.

Ø  Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth.