SUMMARY

• Over 7 years of professional IT experience especially as Oracle DBA.
• Business Information System's expert with excellent analytical and problem solving skills.
• Significant expertise in Object oriented programming languages.
• Completed M.S degree in a field that combines MBA classes with IT Classes.
• Good experience in Business concepts like Management, Accounting, and Finance principles.
• Excellent Math and Statistics skills.
• Works well independently and as a team member.
• Very active with thirst for learning new skills and technologies.
• Passion for solving Real World Problems.
• Seeking a position where I can utilize my knowledge, professional experience, and formal education helping your organization to improve, extend existing success, and achieve competitive advantage.

EXPERTIES SKILLS

• Database:

Development and Administration Using Oracle 10g and 11g.

24/7 Multi nodes Real Application Cluster RAC Environment with installation and configuration.

Significant experience in RDBMS.

Good understanding of Object Oriented Database.

Good understanding of Microsoft SQL Server 2008

• Database tools:

Automatic Storage Management asmcmd

RMAN for backup and restore.

Toad OEM as monitoring tools.

Services srvctl for load balancing failover.

• Performance Tuning:

Applying The normalization Strategy on database large tables, Using Partitions, Indexes, explain and execution plans, and Automatic Workload Repository.

• Coding programming languages:

Shell scripting, SQL/PLSQL stand alone and embedded with Java, courses in HTML, C and Java.

• Replication Technique:

Significant experience in Oracle Streams, Golden Gate, and Data Guard.

• Operating Systems:

UNIX Linux/AIX 7.1 64bits , Microsoft Windows.

• Management Skills:

Good understanding of Project life cycle, and business concepts.

• Science:

Excellent in Mathematics, and Statistics, with good knowledge of accounting and finance concepts.

• Interpersonal Skills:

Excellent communication skills, with great attitude.

WORK EXPERIENCE

Oracle Database Administrator

Confidential

Responsibilities:

• Installed Oracle 10g 11g with RAC on IBM AIX operating system.
• Supporting Oracle 11g 46TB Database with 5 nodes RAC 24/7 OLTP env.
• Upgraded and migrated from Oracle 10g to 11g, in place and out of place.
• Transferred SQL execution plan after migration to keep the same performance.
• Grid control and cluster management.
• Using RAT Capture, Replay, and SPA 11g Features in testing environment.
• Working on AIX platform.
• Supporting development, performance testing, and production environments.
• Provided on call support related to Oracle DBA activities.
• Working on Oracle streams source, destination databases.
• Used Golden Gate to keep source target database in sync while testing the target performance.
• Using Oracle ASM for storing the datafiles and the archivelog files.
• Converting database files from OS file system to ASM.
• Using Oracle Services srvctl for load balancing node maintenance fail over fail back.
• Analyzing SQL explain plan for the best query performance, and the least CPU utilization.
• Responsible for day to day activities like health check, space utilization monitoring, performance tuning, backup, restore, and managing user accounts.
• Writing shell scripts that help for monitoring, like alert log monitoring and deleting the archive log files.
• Using the backend programming like SQL, PL/SQL, writing stored packages, procedures, functions, and triggers in a multi tier environment.
• Analyzing AWR for database and sql performance.
• Gathering schemas and database objects stats.
• Implementing partitioning and indexing strategies.
• Using the Recovery manager RMAN for Backup and recovery by writing RMAN backup scripts.
• Joining meetings to analyze the business requirements, and how it is related to the available data.

Environment: Oracle 10g/11g 5 nodes RAC, AIX 7.1, RMAN, ASM, Oracle Service srvctl , Grid Control, shell script, SQL/PLSQL, Oracle Streams, Golden Gate, Toad, Database upgrade migration, RAT.

Developer/Database Administrator

Confidential

Responsibilities:

• Worked on and installed Oracle 10g/11g.
• Designed and created new databases based on business requirements.
• Managed 12 Oracle databases 10g 2 nodes RAC.
• Used RMAN for backup and restore.
• Used Data guard to migrate RAC databases from one data center to another.
• Responsible for database day to day related activities, performance tuning, managing users and privileges.
• Managing database objects such as indexes, tables, views, constraints, and stored procedures.
• Performed SQL tuning by implementing partitioning and indexing strategies.
• Created users, roles and profiles with different security levels.
• Developed stored procedures and triggers.
• Developed RMAN backup scripts.
• Automated jobs using UNIX shell scripts.
• Analyzed schemas and individual tables.
• Performed Oracle backend programming in SQL and PL/SQL.
• Created automated primary key generation using sequence and appropriate triggers.

Environment: Oracle 10g 2 nodes RAC, Unix, Windows, RMAN, ASM File system, shell script, SQL/PLSQL, Data guard, Database migration, Erwin, Toad.

Oracle Developer/DBA

Confidential

Responsibilities:

• Involved in the project life cycle, Initiation, Planning, Development, Implementation and Closure.
• Involved in application development, supporting, and enhancements.
• Installed Oracle 9i, 10g, and Oracle forms on the client servers.
• Used oracle forms to design and develop interfaces.
• Used Pl/SQL to write procedures, functions and triggers.
• Used PL/SQL embedded with Java J2EE for more object oriented programming
• Designed and developed resource management system using Oracle forms and PLSQL.
• Designed and developed customer reward points system using Oracle forms and PLSQL.
• Changed my role to Oracle DBA supporting the client database remotely and on the client side.
• Trouble shooting the client side database performance.
• 24/7 on call support for the client side database performance issues.

Environment: Oracle 9i/10g, Oracle Forms, Unix, Windows, RMAN, SQL/PLSQL, Java Data guard, Erwin, Toad.