SUMMARY

• Over 10 years experienced as an Oracle Database Administrator in a multiplicity of database environments such as Online Transactional, Data Warehousing and General purpose database.
• Experience in database administration, production support, installation, upgrade, configuration, patches, performance and tuning, backup and recovery, export/import, storage management, database security, auditing, replication and designing databases.
• Strong Experience in Installing / configuring / maintaining Production, QA & DEV Oracle 10g/11g/RAC 11g in UNIX/LINUX, HP - UX and Windows Servers.
• Management of schemas, objects, indexes and tables partitioning, and indexes optimization for high-performance applications.
• Database defragmentation and reorganization, optimizing the database storage according to the application purpose, for example, organizing the transactional tables and redo logs in a high performance storage such as SSD.
• Proactive Monitoring, identifying opportunity areas in the database using Statspack, AWR, ADDM, Spotlight, and 10g/11g OEM Monitoring.
• Hands - on experience with RAC Cluster ware configuration, administration and patching, RAC Backup and recovery.
• Worked extensively in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using Oracle features Export/Import Data pump, FlashBack, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Performance and Tuning experience, specializing in SQL and Database/Instance Tuning, and Operating System Tuning.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases with large-scale (multi TB) databases.
• Experience in installing and troubleshooting Golden Gate issues using command level tools and utilities as well as LOGDUMP utility.
• Experience in Cloning databases and Oracle Golden Gate Replication.
• Good experience in Table and Index Partitioning, Logical and Physical Database Design, Backup and Recovery policies.
• Proficient in using OEM (Oracle Enterprise Manager), SQL Developer, TOAD, Spotlight, Export/Import, Export/Import data pump.
• Expertise in maintaining Database Security using security compliance auditing.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Experience in Data warehousing and ETL (INFORMATICA,OBIEE)
• Experience in ORACLE Database administration including space management, User Management (roles and profiles), Password Management.
• Performed database tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning.
• Experience in shell scripting, PL/SQL scripting and scheduling jobs using cron, DBMS JOBS, DBMS SCHEDULER and OEM.
• Experience in on-call support and 24x7 DBA support for production environment.
• Configured and maintained Physical Standby (Data warehouse) Databases for the Production databases using Golden Gate.
• Downsizing and defragmenting the Very Large Databases (VLDB) by export / import.
• Profound knowledge of Oracle BRM, Web Logic, and Oracle Enterprise Manager 11g.
• Applied patches as required for Oracle Databases.
• Experience in Database migration on various platforms.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Effective and efficient *NIX and Shell scripting (Ksh, Bash) experience.
• Worked for 2 years as a Software Engineer, providing support for GE clients located in USA; all the communication was in English.
• More than 3 years working in the Education, maintaining all the systems of the Institution and working as a Teacher as well.
• Proactive and self-taught, Ability to work under extreme pressure.
• Excellent Written and verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS

Operating System: Red Hat Linux, Solaris, HP-UX, AIX, Windows NT/2003/XP/7/8.

Databases: Oracle 8i/9i/10g/11g,RAC 10g/11g MS Access, SQL Server 2000/2005

Virtualization Technologies: VMware, Oracle Virtual Machine

Languages: SQL, PLSQL, Java, C, C++, HTML, ASP.NET, C#, UNIX shell scripting.

Web Servers: Apache Tomcat, Web logic

Tools: and Utilities(ORACLE): Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, STATSPACK, Golden Gate, AWR, ADDM, RMAN, FTP, TKPROF

Other Tools: Microsoft Visio, SQL Developer, OEM, VM ware, putty, TOAD, WINSCP

PROFESSIONAL EXPERIENCE

Confidential, Tempe, AZ

Oracle DBA

Responsibilities:

• Planning hardware and software requirements for installing Real application cluster (RAC) 11gR2.
• Installation and Database Administration of multiple Oracle 11gR2 instances, in a development and in multiple BETA-TEST, and Production environments on Oracle Linux and Red Hat servers, and VM’s.
• Extensive Performance tuning using the AWR and ADDM reports from time to time to analyze and enhance the database performance.
• Expert-level performance monitoring and tuning using OEM, TOAD DBA SUITE, Spotlight.
• Implemented RAC installations and configurations, database and tablespace restructure and redesign, partitioning and compression.
• Configured and implemented best practices, monitoring, performance tuning, backups, security and auditing, patch and software releases on Oracle11g databases.
• Implemented Database Backup and Recovery strategies and policies.
• Successfully, planned and implemented Oracle databaseinstallations and upgrade from Oracle 11.2.0.1 databases to Oracle 11.2.0.3 databases on Oracle Linux Servers for the development and production environments.
• Troubleshoot various Database instance tuning issues and maximize performance.
• Performed cloning of the databases from the production to test.
• Architected and implemented GoldenGate replication in Oracle RAC Multimode and Oracle RAC One Node.
• Worked with Oracle Service Requests, escalations and high severity requests.
• Regular Monitoring of databases: growth, performance, health of Cluster and archive log destination on Day to Day Basis using OEM and TOAD.
• Planned and implemented Table partitioning strategies for the Oracle Database in the BRM Application.
• Database monitoring and creation of reports of grow.
• Resource monitoring (servers, storage, services) using SiteScope.
• Working on the Linux Operating System user commands, crontab, and performance check.
• Closely work with the developers, performance testing engineers and program managers to recommend the best practices and troubleshoot prodigious problems.
• Troubleshoot Web Logic Server, collected, analyzed, archived and accessed diagnostic data generated by deployed applications with the Web Logic Scripting Tool.
• 24x7 on-call support for critical database issues to help meet the deadlines.
• Installation, Configuration and Administration of Oracle BRM Application and Database.
• Change and Release Management of the IPC, BRM, Siebel Applications.
• Moreover than Oracle Databases, I was responsible of the SQL Server and Progress Databases Administration (Installation, Maintenance, Performance, User Administration, Storage Management, Monitoring, Upgrade, Backup and Recovery)

Environment: Oracle 11g/10g/, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, Data Guard, OEM, Grid Control, Golden Gate, Data Guard, STATSPACK, AWR, Explain Plan.

Confidential, Milpitas, CA

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g databases on AIX.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RACdatabase on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Worked on import/export and SQL- loader.
• Setup backup and recovery procedures using RMAN.
• Configured and support Oracle middleware applications and Oracle Web Logic Server for Linux x86-64
• Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.

Environment: Oracle 11g/10g/, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, Data Guard, OEM, Grid Control, Golden Gate, Data Guard, STATSPACK, AWR, Explain Plan.

Confidential

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Provided production support for the 24x7 Oracle database availability.
• Configured Oracle Data guard for Disaster recovery solutions.
• Achieved High Availability, Data protection and Maximum performance by maintaining physical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Supported and Worked on CURAM for Oracle Databases.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Also migrated data from Oracle to SQL SERVER, Sybase, etc., for testing, reporting and analysis requirements.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Experienced in performing Point in time recovery using RMAN.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential

Oracle Database Administrator

Responsibilities:

• Oracle Database 11gR2 Real Application Clusters (RAC) Installation and Configuration on Linux
• Upgrading databases from 10.2.0.4 to 10.2.0.5 and Migration of databases between the RHEL AS4 update 8 to SOLARIS 5.10
• Patching, upgrading the database to 10g, 11g
• Creating databases as per client Standard
• Duplicating Database with RMAN from RAC to Single Node
• Duplicating Database with RMAN from RAC to RAC
• Data Guard Rebuild
• 11gR2 DR drill for Data Guard
• Migrated database from non ASM to ASM
• Understanding execution plan of top SQL statements by using Explain plan,Auto trace and TKPROF
• Refreshing Test Databases with EXPDP/IMPDP
• Handling database management and change requests in form of import and export.
• Oracle Server and client software installation
• User administration tasks
• Data guard setup and best practices
• Providing connectivity and troubleshooting of connectivity problems
• Check the performance of the database and tune as and when requires using tools AWR, EXPLAIN Plan.

Environment: Oracle 10g, 11g, RAC, LINUX, RMAN, RAC, Data Guard, ASM, AWR, EXPLAIN PLAN, Auto trace, TKPROF, EXPDP/IMPDP.

Confidential

Software Engineer

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database.
• Used PL/SQL developer to create PL/SQL Procedures.
• Refresh/Cloning of Database for development, testing.
• Monitoring and Management of database users.
• Testing PL/SQLprocedures against the test cases.
• Involved in creating use cases and test cases.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager.