OBJECTIVE

• Seeking a carrier in Oracle Database Administration to leverage a company’s investment as well as provide an opportunity for advancement

SUMMARY

• Around 9 years of professional experience in Oracle Database Administration
• Expert in areas of Oracle 12c/11g/10g/ PL/SQL, SQL, SQL*Plus, SQL*Loader.
• Experience with Building RAC, Data Guard, ASM, Flashback and RMAN
• Experience in Various Flavors of UNIX - Linux and Sun Solaris.
• Implemented Oracle11g RAC and Oracle 12c RAC with ASM files system using Oracle cluster ware.
• Implemented Data guard (Physical Standby) for standalone databases.
• Migrated Non ASM databases to ASM.
• Experience with High Availability features ( RAC / DG/ ASM / Flashback / RMAN)
• Implemented data replication using Oracle golden gate.
• Upgraded 10g databases to 11g.
• Good knowledge of Oracle 12c and Oracle 11g new features.
• Experienced in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, database access and Security and auditing.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, OEM Grid Control and manual scripts.
• Installation, Configuration and administration Oracle Golden Gate
• Refresh and Cloning using Data pump and RMAN utility.
• Expertise in Maintenance, Patching, Cloning and troubleshooting.
• Excellent knowledge in User Managed / RMAN backups and Recovery.
• Experienced in Database Point in Time Recovery and Tablespace Point in Time recovery.
• Enforcing security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.
• Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Stored Procedures, Triggers, Stored Procedures and Packages.
• Experience in Working with Oracle Support to resolve issues and open SR.
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Planning and scheduling for the backup of database information using UNIX shell script and Cron-Jobs.
• Enforcing data integrity using integrity constraints & database triggers.
• Good experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures, full-backup, incremental and cumulative backups.
• Excellent Analytical, Communication and Presentation skills.
• 24x7 support provided during on-call schedules.
• Installation of ETL Tools and repository creation for developers.
• Supported ETL and BI teams in development process.
• Created Container and Pluggable databases by using Oracle 12c Database.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting

Database: Oracle 11g Oracle 10g

Operating System: UNIX, Solaris, Linux and Windows

Tools: SQL*PLUS, SQL Developer, TOAD, PUTTY, OEM, RMANSQL* LOADER, Imp/Exp and Data pumpTuning Tools TKPROF, EXPLAIN PLAN, ASH, AWR, ADDM

Tools: /Utilities: RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, expdp, impdp.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Beaverton, OR

RESPONSIBILITIES:

• Installed and maintained Oracle 12c/11gR2 databases having good exposure on Linux, Solaris and Windows.
• Upgrade (10g to 11g) and patching Oracle databases.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Installed and implemented Golden gate to replicate data between two databases.
• Monitor Oracle databases, server performance and capacity. Formulate and execute plans for resolving performance issues and meeting resource, growth/capacity demands.
• Investigate, diagnose, and quickly resolve database issues and problems in production and testing environments. Work closely with operations staff to quickly resolve production problems.
• Create, maintain, and test backup and recovery procedures for all databases.
• Install and configure database changes, builds and deployments in support of QA and production testing and release schedules.
• Managing users and resources, controlling user privileges, roles and auditing database use.
• Configuring the Data guard set up for Disaster recovery.
• Database cloning for development and testing.
• Monitoring user sessions using OEM 12c and TOAD.
• Involved in database capacity planning and monitor the growth of the database.
• Served as rotating on-call DBA in support of 24x7 operational databases.
• Good experience with user account creation and manage them.
• Implemented Oracle security my granting roles and privileges to particular users.
• Creation and maintenance of users and roles.
• Implemented Data guard (Physical Standby) for standalone databases.
• Worked with security team and generated audit reports.
• Supported backup and recovery using cold backup, hot backups, and flashback in 10g, written shell scripts for the UNIX environment.
• Worked on ASM redundancy levels, load rebalancing on RAC as well as standalone systems.
• Use of explain plans to tune SQL queries, building indexes to improve performance.
• Good experience in writing SQL and PLSQL queries.
• Good experience in tuning SQL and PLSQL queries to tune the code.
• Created and modified Database objects like Tables, Indexes, Views,, Stored Procedures, Triggers, and Packages.
• Good experience in performance tuning of the database.
• Gather table/schema stats on regular basis to improve performance.
• Analyzing and applying of quarterly security patches.
• Experience with Oracle Golden Gate tool for data migration.
• Involved in setting up and Managing Disaster Recovery sites.
• Worked on Golden Gate Replication tool.
• Backup of the Production & Development Databases, based on business requirements, perform daily incremental backup, weekly backups using Hot and Cold Backup.
• Checking Alert Logs, Archive Logs, Trace files and backup verifications.
• Granting and Revoking Permission to/from the users
• Monitoring of Invalid objects.
• Creation of test and development environments for production databases.
• Supported ETL team and BI team.
• Configured Oracle Data Integrator (ETL Tool) for data migration.

Oracle DBA

Confidential

Responsibilities:

• Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Creating users and roles for database and give the privileges to suitable user.
• Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases
• Using the ADDM to analyze performance problem and with help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
• Prepared Installation Procedures for current Patch, Documentation for Adding a node to Existing RAC environment and Data Guard.
• Experienced in cloning databases and Setting up Disaster Recovery Database using Physical Standby.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Created Standby databases for Disaster Recovery, using Data Guard.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated Database auditing and managing user groups, Database security, OS space monitoring etc.
• Database Administration and Planning including physical design, backup & recovery.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing.
• With help of Database links provided connectivity to other databases.
• Created database objects like tables, views, indexes, partitions.
• Develop, document and enforce database standards and procedures.
• Setting Oracle Streams for replication between two databases.
• Implementation of RAC, ASM, DATAPUMP, FLASH BACK Recovery
• Clear communication and documentation of technical specifications...
• Experience in developing Oracle Alerts, SQL Tuning and Optimization.
• General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema

Oracle DBA

Confidential

Responsibilities:

• Designed, configured and installed Oracle Real Application Clusters on a 2 node Cluster.
• Experience in taking backup of OCR.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Designed the database schema and created any necessary database objects.
• Monitor production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
• Applied patches or upgrades to the database as needed.
• Created number of LINUX shell scripts for various tasks.
• Worked on Oracle Meta-link in case of problems.
• Experience in using Veritas volume manager on UNIX.
• Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Assist application developers to meet their day to day requirements related to performance.
• Handled databases with size more than 1 TB.
• Responsible for code migration between production, development, test and pilot databases.

Oracle DBA

Confidential

Responsibilities:

• Installing, configuring and administering Oracle 9i on LINUX and Solaris.
• Worked in Development Support for Oracle based systems and Unix based Server environments
• Perform capacity planning required to create and maintain database environments.
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.
• Planning Backup and Recovery Strategies for various database environments.
• Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Created PL/SQL and shell scripts to automate batch jobs through cron jobs.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Writing scripts for the system and database for the effective functionality and report generation.
• Applied High priority, security patches downloaded from Meta link.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Monitoring Database for fragmentation and correcting them.
• Experienced with Space Management and Security.
• Management of table space growth, monitoring data files additions, extent growth
• Performed Database, OS and application tuning.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Used Database export/import using exp and imp utilities to take logical backups.
• Performed Data loads using SQL loader utilities.
• Contact to the development team to solve the issues with the new enhancement releases.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

Oracle DBA

Confidential

Responsibilities:

• Installation and configuration of Oracle 10g and 11g server.
• Responsible for support, maintenance and administration of development, test and production database.
• Backup of the Production & Development Databases, based on business requirements, perform daily incremental backup, weekly backups using Hot and Cold Backup.
• Performing Logical Backup (Full, User, Table)
• Checking Alert Logs, Archive Logs, Trace files and backup verifications.
• Granting and Revoking Permission to/from the users
• Monitoring of Invalid objects.
• Creation of test environments for production databases.
• Monitor space usage of users and resizing tablespaces.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
• Expert in applying the patches by using Opatch utility.
• Creation of Development database and Test databases.
• Backup of the Production & Development Databases, based on business requirements, perform daily incremental backup, weekly backups using Hot and Cold Backup.