SR.Oracle Database Administrator

PROFESSIONAL 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.
• Oracle DataGuard implementation for EBS.
• High Availability configuration for EBS.
• Experience in E-Commerce modules GL, AP, AR, PO, CM .
• Proactive Monitoring, identifying opportunity areas in the database using Statspack, AWR, ADDM, Spotlight, and 10g/11g OEM Monitoring.
• Configured and implemented Oracle GoldenGate 11g/12c Data Mining.
• 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 ETL using ODI for Business In telligence.
• Worked with OID and ASO integrated with SAP.
• 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.
• Experience working in a heterogeneous Golden Gate replication environment e.g. Sybase to Oracle .
• Experience administering Sybase ASE databases.
• 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:

Professional Experience:

Confidential

Role:Oracle DBA

Roles and 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.
• Administered Oracle EBS Suites, troubleshot Forms server, Reportsserver and Webservers.
• Trained development team on SQL tuning and support of EBS application and 10gAS SSO components.
• 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.
• Created Virtual Machines for WebLogic Server and Oracle OEM 12c
• 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.
• Implemented GoldenGate replicationin a Sybase ASE Environment.
• 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.
• Implementation and Management of OID to resolve database services and as a repository for names and passwords.
• Configuration of the network traffic between clients and server using Oracle Advance Security Option ASO .
• 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 Sybase 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

Role:Oracle DBA

Project Description:Business users are currently using CIS ticketing system which is a based on Oracle Online and the Clarify ticketing system for Case, Service Contracts and Knowledge management. The scope of this project is to replace them with Salesforce.com cloud based case management system. Currently end users have the ability to run reports both canned and ad-hoc on these systems. They also have the ability to take the data and feed it into a downstream called TL9000

Roles and 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 .
• Configured and implemented Oracle GoldenGate 11g/12c. Configured GG plugin in OEM12c.
• Executed backup and recovery techniques using RMAN and processed multiple items of Oracle EBS 11.
• 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

Role:Oracle DBA

Project Description: Worked for MultimediosRedes on the Data and Infrastructure Department. Multimedios Reds is a Telecommunication Company that provides cable, internet, telephone and video services for residential and Entrepreneur customers. The Infrastructure Department is on charge of data and Infrastructure services like Storage Management, SysAdmin, Database Administration, Application Administration, Network Administration the purpose is to maintain the business operation and continuity in order to provide an excellent service to the client.

Roles and 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

Role:Oracle Database Administrator

Roles and 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

Role:Software Engineer

Roles and 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.