PROFESSIONAL SUMMARY:

• Experienced in maintaining large Production, UAT, QA, SIT and DEV environments.
• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
• Planned and Implemented DR& High Availability oracle solutions using Data Guard, Streams.
• Proficiency using Flash - Back Recovery, Automatic Storage Manager (ASM) &Automatic Database Diagnostic Manager (ADDM).
• Supported installation and setup of oracle Cluster’s and RAC database.
• Monitoring and administrating oracle RAC databases on oracle 11gClusters.
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR, ASH and ADDM.
• RAC database build 11gR2 with Goldengate.
• Experience on perform RAC (refresh/cloning/asm migration) activities.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Have working knowledge on data replication using SHAREPLEX.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, fullback up, incremental and cumulative backups.
• Experience with oracle backup procedure with Tivoli Storage Manager.
• Implemented data transfer using Export/Import utilities and Data Pump.
• Automated database periodic maintenance and activities using Korn, Perl Shell Scripts, Autosys.
• Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Designed and developed PL/SQL scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Worked extensively on Oracle Version Upgradation, Migrations and Patching.
• Configured & implemented different types of Advanced Replication Models of distributed databases.
• Used Repository manager to build Repository and managed Very Large Scale Databases (VLSD).
• Configured Oracle on different Operating Systems for OLTP& Data Warehousing environments.
• Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Informatica, Dataflux, Data Stage.
• Assisted in designing conceptual, Logical and physical data models using Erwin, Pl/Sql Programming, and Shell Scripts.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Worked as a team member to provide 24x7 on call support production database support.
• Create proactive proposals, solutions and proof of concepts to fuel new business growth.
• Participate in management reviews and contribute to decision making.
• Thorough understanding of the SDLC with proficiency in mapping client requirements, scope management & activity sequencing.

TECHNICAL SKILLS:

Database: Oracle 8i, 9i, 10g, 11GRAC, 12c, Data guard and ASM,Oracle XE, Microsoft Access

Operating Systems: Linux, Sun Solaris, HP-UX,Windows NT/2000/2003, Windows XP.

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: and Utilities:Oracle Enterprise Manager (OEM), OBIEE and SQL*Loader, Export/Import, TOAD, DB visualizer.

Partitioning techniques: Using OINLINE REDEFINITION and Normal.

Backup Tools: RMAN (Recovery Manager)

EBU: (Enterprise Backup Utility) OS Hot and Cold BackupsPerformance Tuning:AWR, ADDM, STATSPACK.TKPROF, EXPLAIN PLAN,UTLBSTAT/UTLESTAT

Reporting Tools: Oracle SQL*Plus, Oracle Reports

Protocols: TCP/IP, FTP, Telnet

Office Software: Microsoft Office

Web: ASP, JavaScript, VBScript, HTML

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Implemented advanced features of Oracle 12C such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Implemented OBIEE11G and Oracle 12C Software and generating reports related ATM transactions at Bahrain daily and weekly and monthly reports sending to the concerned authorities.
• Installation of OBIEE at all client machines trained them to utilize the software.
• Configure workflow notifications, printers, and form servlets in Oracle financial applications.
• Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans.
• Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans.
• Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup.
• Monitor all production Oracle Databases for disk usage to plan future disk space needs per database.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
• Expertise in creating primary database storage structures (Table spaces) and primary objects (Tables, Views and Indexes).
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), and TOAD.
• Hands on Experience in Space Management, Capacity Planning.
• Implemented 100TB of Backup system for Exadata databases machine and Exalogic Elastic cloud computing servers &VDI environment involving Oracle ZFS 7420 storage systems and HP Data protector 6.11.
• Creating Users, Roles and Profiles, Privilege management with role-based security.
• Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.

Environment: Oracle 11g/12c, RAC, LINUX, Solaris 10, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, WebLogic, EXPLAIN PLAN, Business Objects XI, Data Guard.

Confidential

Lead/Sr. Oracle Admin

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Cluster ware and Oracle RAC on Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Load balancing, databases/schema/table re-organization for faster performance.
• Performing Capacity planning and evaluations with regular Maintenance cycles.
• Installation of Oracle version 10g on Linux.
• Applying patches whenever required.
• Created and scheduled the packages using SQL server’s packages.
• Extensively used SQL serverBCP utility and IMPORT/EXPORT to load the database from text files received from different applications Continuous Performance Monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACKetc.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different tablespaces.
• Performance Tuning of Oracle Database Objects.
• Taking periodic Backup of the database and the software using RMAN.
• Handling Database storage, Reading Alert. Log and User Trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
• SQL Tuning for Performance of Objects.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, Scripts for Cold Backups, Script to check Oracle errors in alert log file and Send Mails.

Environment: Oracle 10g/11g, SQL SERVER 2005, Oracle RAC, Solaris, Linux, Toad, RMAN, Dataguard, Data Pump, Goldengate, Exadata, SQL*Plus, SQL, PL/SQL, SQL*LOADER, Oracle OEM, Import/Export .

Confidential

Lead/Sr. Oracle DBA

Responsibilities:

• Implemented 100TB of Backup system for Exadata databases machine and Exalogic Elastic cloud computing servers &VDI environment involving Oracle ZFS 7420 storage systems and HP Data protector 6.11.
• Patched 11g Grid Infrastructure &RAC databases on Exadata Database Machines.
• Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans and automated scheduled jobs.
• Setup and maintain database backups for production servers. This includes using native Rman backup.
• Monitor all production Oracle Databases for disk usage to plan future disk space needs per database.
• Maintain Oracle service patch levels on all production oracle servers based on the client requirements.
• Patched Oracle Exadata Machine 11gR2 Grid Infrastructure and RAC databases. Involved in Exadata switch patching and cell storage.
• Configured Oracle Grid monitoring system for Exadata database machine &Exalogic on separate network.
• Implemented Oracle Virtual Machine virtualization 2 node cluster on HP Blade G470c servers for different needs.
• Implemented Database Listeners on infiniband network from Exadata Machine to Exalogic Machine.
• Worked on Scan listeners for 11g grid infrastructure.
• Administering Cell Storage servers for Exadata Database Machines.
• Provided installation, configuration support of Oracle 10g to, 11gRAC databases from building server to installing databases.
• Involved in upgrading Oracle10g to Oracle11g database
• Configure workflow notifications, printers, and form servlets in Oracle financial applications.
• Cloned 2-tier, 3-tier eBusiness suite application from production to test environment.
• Involved heavily in different kind of cloning requirements. Restoring databases in same cluster system and different cluster system to other database.
• Worked extensively on HP data protector and managed system wide backups. Configured backup polices for oracle databases and system wide backups.

Environment: Oracle 11g/10g, Data pump, Data Guard, Red Hat Enterprise Linux 4.x, AIX 5.2, OEM, PL/SQL, Oracle 10gRAC, Exadata, TOAD, Erwin, STATSPACK, EXPLAINPLAN, Datastage, Weblogic, SQL Server 2005.

Confidential

Sr. Oracle Database Admin

Responsibilities:

• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• Installing Oracle Golden Gate for EBS Reporting Databases
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• Configuring Extract Parameters for Golden Gate EXTORA, RMTHOST, RMTTRAIL
• Configuring Replicate Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
• Creating GLOBALS for Golden Gate and Adding database checking points.
• Migrated the data from old storage to a new EMC INVISTA Storage to minimize downtime and provide High Availability.
• Migrated data on different Oracle versions of 9i and 10g, 11g and on different operating systems of AIX/Sun Solaris/Linux.
• Migrated data from File System/Non - ASM to ASM storage.
• Migrated data from ASM disks to ASM disks by using Rebalancing techniques.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5
• Production databases and few development databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code
• Taking backup of databases using RMAN.
• Used tools like export/import and data pump export/import.
• Involved in export and import of database objects in order to copy them from one database to another &for backup the tables.
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Experienced writing UNIX scripts and troubleshooting issues.
• Upgraded Real Application Cluster (RAC) from Oracle 9i to Oracle 10g on HP-UX.
• Used tools like TOAD, SSH.
• Involved in Database Tuning for the performance of databases.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 9i/10g/11g, Oracle RAC/ASM on AIX/Sun Solaris/Linux/WIN, Oracle Golden Gate 11g, Toad, SSH, RMAN, SQL*Plus, SQL, Import/Export.

Confidential

Sr. Database Administrator

Responsibilities:

• Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans.
• Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup.
• Monitor all production Oracle Databases for disk usage to plan future disk space needs per database.
• Maintain Oracle service patch levels on all production oracle servers based on the client requirements.
• DB User Administration and Security management
• Problem & Incident Management.
• Monitor all production Oracle DB servers for performance bottlenecks.
• Installation of Oracle11GR1,10G Database patches. Database creation of the Development, Test and Production for databases.
• Managing Day-to-day Basic Database Administration work deployments in Development Database, Test Database and Production Database.
• Maintenance of database like rebuilding indexes, analyzing of tables, segment advisor.
• Creating new database for Developers and users, roles related to the database.

Environment: Oracle 9i/10g, UNIX, LINUX, Windows 2003 server, SQL server, Shell Scripting, PL/SQL, RAC, OEM, QUEST tools, Erwin, SQL*Loader, Toad, SQL*Plus, Data Mover, Object Security, Import Manager, Oracle Configuration Assistant, PeopleSoft, Oracle Data guard, Oracle Universal Installer.

Confidential

Database Administrator

Responsibilities:

• Attending meetings and understanding the client needs.
• Installing &upgrading the Oracle Database server and applications.
• Creating primary objects (users, tables, views, indexes).
• Experience on HA features: RAC / Standby + Data Guard
• Kernel Parameters tuning / adjustments - knowledge of UNIX commands like SAR / VMSTAT / IOSTAT / PRSTAT and TOP etc.
• Unix shell scripting knowledge and examples of scripts written
• Experience of Tuning in below topics:
• Oracle performance baseline report generation (Business Application reporting metrics)
• Oracle SGA/Pool configuration and optimisations
• Server load analysis
• Oracle RAC configuration and tuning (Multi-Node active/active RAC)
• Working knowledge of multi-instance HA production estate
• Oracle AWR review/analysis
• TKPROFF analysis
• Capacity Management capacity management (CPU/mem/IO/storage)
• Hardware and application capacity forecasting for UNIXflavors and Oracle utilisation.
• Creating indexes (Btree) etc.
• Backup and restore of databases.
• Taking logical backups involving both export and import.
• Customizing Oracle applications.
• Troubleshooting of Database tickets resolving.
• Preparing the required customer report.
• Involved in to Database Creation and Database Design.

Environment: Oracle 9i, AIX 5, Sun OS 5.6, Export, Import, ERWIN 4.14, SQL Developer, OEM, SQL*LOADER, Cute FTP

Confidential

Database Administrator

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Performed Database upgrade of Oracle 9i from existing oracle 8i system.
• Involved in analysis of market risk and claims data.
• Performing backups and recoveries using RMAN/conventional hot backups.
• Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.
• Worked closely with senior DBA to understand the business and technical requirements.
• Developed entity relationship, data flow and functional diagrams.
• Designed database tables, implementing referential integrity.
• Developed triggers which internally called procedures and functions.
• Performed complex SQL query tuning, index reorganization, and Rollback.
• Developed oracle forms and reports using oracle designer 2000.
• Involved in all phases of the software development life cycle.
• Involved in documenting the entire system architecture and data flow
• Maintained control files, log file, data files, table spaces and rollback segments.
• Developed stored procedures and functions using PL/SQL for complex updates.
• Designed Entity-Relationship model and normalized database.

Environment: Windows 98/NT/2000, UNIX, HP-UX, Oracle 9i/8i, TOAD, Database Tools & Utilities, Perl.

Confidential

System Administrator

Responsibilities:

• Admin and maintains the servers, installing and administering the Client and Server side software.
• Taking the back-ups from the Server at regular intervals and maintaining the user data secured.
• Taking periodical system preventive maintenance.
• Worked on Windows-NT and Windows-2000.
• Worked on MSSQL servers.