Ahmed
Oracle DBA
-
PROFESSIONAL SUMMARY:
Over 5 years of experience as Oracle DBA on 10g, 11gR2 database servers with high availability.
Pose strong experience working as an Oracle DBA which includes experience in 10g, 11g, ASM, Grid Control, 12 Cloud Control, Materialize Views, Data Guard, RAC, GoldenGate and managing databases using Toad and dictionary tables and views.
Worked with large database
Build RAC Clusters from scratch on Linux
Worked with offshore DBAs
Supported multiple projects in parallel.
Created Data Guard for RAC and standby servers.
Provided 24*7*365 DBA on-call
Worked on RMAN backups, restores and cloning of databases.
Strong experience in OEM (Oracle Enterprise Manager) and TOAD.
Worked with Developers during Deployments and SQL tuning
Worked on instance tuning as per the best practices.
Identified root cause of performance issue using ASH, AWR, ADDM, SQL Advisor, tkprof, execution plan etc.
Worked on databases ranging from a few GB to up to few TB.
Worked on Oracle 10g and 11g R2 database server installs from scratch.
Upgraded database from 10g to 11g R2 and 11.2.01 to 11.2.0.2 to 11.2.0.3
Monitored databases using Grid control and 12 cloud control
Used Export Import / Data Pump, DBLinks for data movement.
Experience in writing Shell and SQL Scripts.
Oracle RAC Good knowledge of Flashback technology.
Performed Database Migrations.
Performed Database Upgrades.
Worked with Storage Admins for carving out partitions for datafile systems.
Worked with SAN, NAS for ASM disks.
Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.
Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
Experienced in Database Security Administration using roles/grants.
Managed SQL Server Databases
Installed SQL Server 2005, SQL Server 2008 databases
Strong administrative skills in Windows and Linux.
Tablespace Management
Capacity planning
Database installation using Oracle Silent Install.
Applied Quarterly CPU and PUS patches.
Troubleshoot Oracle Networking Issues
Worked with Oracle in resolving issues.
Very familiar with Oracle Dictionary
Implementation of Golden Gate
TECHNICAL SKILLS:
OperatingSystems RHEL,HP-UX, Windows, Sun Solaris, CentOS RDBMS Oracle 10g R2, 11g R2, 12c Database, SQL Server 2005/2008
High Availability RAC, Data Guard, ASM, GoldenGate Languages SQL, PL/SQL
Tools RMAN, OEM, SQL Loader
PROFESSIONAL EXPERIENCE:
TDS TELECOM, WI Aug 2011 – Present
Oracle DBA
Role & Responsibilities:
Responsible for new 11g database installation
Upgraded and patched existing Oracle homes.
Build 2-node 11g R2 cluster from scratch on Linux.
Build Data Guard.
Designed roles and assigned permissions
Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
Automating the backup processes using shell scripts.
Build RAC clusters and added nodes.
Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
Export and Import of User, Tables and Database using exp/imp and Data Pump
Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
Used exp/imp, data pump and dblinks to move the data
Worked on standard and enterprise edition of the Oracle RDBMS.
Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.
Worked on schema Reorganizations for better space management
Performed Database Refreshes and Database Copies for Development, Test and Production databases
Installed, Migrated, configured and tested Oracle 9i databases in various environments
Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
Data modeling / Logical database design and implementation (including index design)
Migration of system and applications from Oracle 9i to 10g.
Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
Create and maintain multiple databases.
Create multiple 11g databases on RHEL5 in development.
Schedule backup in 11g using db console.
Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.
Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Standby databases to ensure high availability, data protection and disaster recovery.
Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.
Implemented unidirectional GoldenGate replication for schema/table level
Worked with Oracle in troubleshooting issues.
Worked with Development team in deployments.
Environment: Oracle 10g, 11g R2, RAC, Oracle Data Guard, Oracle GoldenGate EDUCATION:
-
Pursuing Bachelors in Computer Science