Manager Data
Resume:
Talha Sr. Oracle DBA
**********@*****.***
PROFESSIONAL SUMMARY:
Over 10 years of extensive experience as an Oracle DBA on 10g, 11g,12c,18c and 19c.
Worked on Standalone and Cluster Environment.
Build RAC from scratch on Red Hat Enterprise Linux.
Experience in Data Centre Migration.
Experience in setting up Oracle Data Guard.
Experience in setting up Grid Control.
Experience in setting up ASM disk groups.
Experience in setting up Golden Gate.
Experience in Setting up Materialize View Server.
Worked with the following
SQL Access Advisor
SQL Performance Analyzer
SQL Plan Manager
Table compression enhancement
Active Data Guard
Upgraded from 10g to 11g R2 to 12c to 18c and 19c
Query Result Caching
Invisible Indexes.
Database Replay.
AWR Baseline Enhancements
Automatic Memory Management.
Automatic SQL Tuning.
Data Recovery Advisor.
Read-Only Tables
Flashback Enhancements
RMAN Enhancements
Table Compression Enhancements.
Worked on Tablespace/Extent/Segment Management
Worked on Backup and recoveries using user managed and RMAN.
Setup Oracle Enterprise Manager (OEM)
Worked on 11g/12c/18c Grid Control for database monitoring / performance / diagnostics.
Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
Maintain Oracle fail over databases (Physical and Logical standby databases- Data Guard)
Oracle Tuning Pack. Oracle RAC Good knowledge of Flashback technology in Oracle 10g,11g,12c,18c
and 19c.
Working on building environments on Exadata upto X-7
Proficient in Oracle RDBMS – including SQL, PL/SQL and all areas of database Administration.
Experience monitoring Oracle RDBMS availability, database exports, data pump, tablespace, and extents fragmentation.
Involved in Database sizing, Capacity Planning. Migrated databases to AWS.
Build new servers on AWS.
Worked on project to migrate databases to AWS instances
Set up oracle instances on AWS cloud.
Automated Storage Management (ASM) for 10g/11g/12c/18c/19c databases.
Managed the database technology like Oracle RAC install/configure, Golden Gate install/setup, Apache Cassandra install/setup);
Designing and building physical database schemas (relational DDL, documents, column families, graphs, etc.) and optimizing databases for speed, scalability and availability
Design/implement Golden Gate across different Data Centers;
Installed and Administered Grid Control.
Worked with Oracle on open issues.
Discoverer Administration including the design and administration of Business areas.
Skills Summary:
Oracle10g, 11g, 12c,18c,19c
Exadata
Golden Gate
AWS
Oracle Automatic storage Management
Real Application Clusters (RAC)
Performance Tuning
Security Administration
Replication
Partitioning
Disaster Recovery Solutions
Database Design
SQL Server
Recovery Manager (RMAN)
Standby Database Solutions
Oracle 9i, 10g, 11g,12c,18c,19c Data warehousing
Oracle Enterprise Manager (OEM)
Data pump, RMAN, Shell Scripting
SQL, PL/SQL
UNIX, Solaris, HPUX, Tru64, AIX
Windows Server 2003, 2008, 2012
12c/13c cloud control
Data Guard
Professional Experience:
Rolta Advizex Jan 2015 – Present
Lombard, IL
Title: Senior Oracle DBA
Responsibilities:
24x7x365 administrative support staff.
Manage offshore team on day to day to tasks.
Upgrading 8i, 9i version databases to 11g, 12c, 18c, 19c.
Designed, configured, and maintained backup and recovery policies including RMAN backups.
Monitored database space requirements and adjusted for future needs.
Performed version upgrades and patch installs.
Perform database administration tasks as part of a scheduled change management task.
Proficient in communicating directly with internal resources on a daily basis.
Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
Involved in Database sizing, Capacity Planning. Migrated databases to AWS.
Build new servers on AWS.
Worked on project to migrate databases to AWS instance.
Set up oracle instances on AWS cloud.
Database architecture design to meet applications needs.
Building Standalone and RAC environments and performing test activities before delivery.
Provide technical trainings to individuals on database migration activities from HP to Solaris.
Working on building environments on Exadata X-5 and X-7
Performed Silent installation on Exadata.
Applied patches on computer nodes, Exadata home and storage cells.
Migrated standalone databases to Exadata
Implement disaster recovery with use of Exadata
Setup Data guard using OEM and manually and building documentation for resources to follow.
Capacity planning for changes in the size of databases due to business growth.
Performing backup/recovery based on needs and troubleshooting.
Provide 24/7 On-Call support on site.
Building environments for Goldengate and provide technical support for related issues.
Provide support for PSU/one-ff patching activities using OEM and manually.
Good working knowledge in Exadata.
Good working knowledge in Oracle GoldenGate Replication.
Build 2 node and 4 node RAC Cluster.
Worked with offshore/onshore teams.
Worked with database export & import scripts to backup database structures and automation procedures.
Proactive database monitoring using grid monitoring tool.
Install Oracle supplied tools to assist in database and SQL Tuning like SQLT.
Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
Maintaining daily batch cycle and providing 24/7 support
Environment:
Oracle 9i,10g, 11g, 12c,18c,19c, Sun Solaris, AIX, HP-UX, Linux, Windows, 10g/11g /12c (Active) Data Guard, 10g/11g RAC, Data pump, Export/Import, Oracle Fail safe, Physical Backups.
T-Mobile, Jan 2010 – Jan 2015
Seattle, WA
Oracle DBA
Responsibilities:
Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers
24x7x365 administrative support staff.
Configured Data Guard to provide high availability by implementing Physical stand by database.
Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
Cluster Installation and Configuration, Administering databases in RAC for high availability.
Installation, Configure, setup of 11g RAC on Linux.
Add new nodes to RAC 11g Cluster to distribute the load.
Installed and implemented 10g RAC with 4 nodes with ASM.
Upgraded Databases from 10g to 11g and applied patches as per requirement.
Worked extensively on data centre migrations on multiple database versions. i.e, 9i, 10g and 11g.
Responsible for installing and configuring Golden Gate on Oracle Servers.
Database migration from 9i to 10g to 11g.
Designed, configured and maintained backup and recovery policies including RMAN backups.
Compared and contrasted multiple snapshots using AWR.
Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
Recovered databases and clone applications Using RMAN.
Performed RMAN restores and recovered database.
Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
OEM Grid Control installation and configuration for monitoring and performance tuning.
Proactive performance monitoring, and capacity planning for future database and server growth.
Applied CPU/PSU Patches
Performed Cross platform migration using transportable tablespaces and RMAN.
Performed Import and Export using Oracle Data pump utilities
Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
Used external tables and SQL*Loader to import data from flat files.
Monitored database space requirements and adjusted for future needs.
Performed version upgrades and patch installs.
Perform database administration tasks as part of a scheduled change management task.
Proficient in communicating directly with internal resources on a daily basis.
Able to work effectively with multiple teams at once.
Good understanding of ticketing system and change control process.
Solid discipline in providing end-users timely updates on their problems. Installing server software.
Review alert logs and dump files to check for any problems related to the database.
Used Export Import and Data Pump
Used Database Partitioning
Provided 24/7 Online support
Create and maintain users, roles and privileges.
Written Shell scripts
Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
Involved in Database sizing, Capacity Planning.
Perform Space Management & Troubleshooting the database issues.
Generated ASH, AWR, ADDM reports from Grid Control and command line.
Setting up privileges to create local and remote objects
Worked on Materialized Views
Upgrading/Migration from Oracle 8i databases to 9i to 10g/11g and 12c.
Applied CPU patches
Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
Environment:
Oracle 10g/11g and 12c databases, 10g/11g (Active) Data Guard, 10g/11g RAC, Data pump, Export/Import, SQL*Loader, Physical Backups, 11g Grid Control, 12c cloud control, used RMAN to backup database.
Education:
Bachelor in Computer Science
University of Karachi
Certifications
OCP
MCSA
AWS
ODCS
Contact this candidate