SUMMARY:

• 8+ years of experience of Oracle Database Administration including 12c, 11g, 10 and 9i on platforms Sun Solaris, Unix/Linux, HP - UX and windows.
• Build and Configure Oracle 10g/11g R2 RAC on multiple nodes clusters.
• Lead team in migration of databases between data centers.
• Installed and applied CPU/PSU patches to oracle RDBMS
• Hands on experience in Backup, Recovery & Cloning of databases using RMAN
• Worked on setting up Physical standby Data Guard Environments
• Worked on Shell script.
• Experience in Tablespace Management, roles, grants and permissions.
• Experience in documenting procedures.
• Extensive use of RMAN to backup/restore/recovery scenarios.
• Experience in tuning Different components and identifying bottle necks in performance of databases on OS, Storage, SGA levels.
• Experience in 11g grid control and 12c cloud control
• Experienced in installing Oracle 10/11g Agent on DB server.
• Good experience in Transportable Tablespaces, SQL Tuning Advisor, Flashback Table, Table space Management, Materialized Views,
• Worked on SQL Profiles
• Worked on creating and Managing Users, Roles and Privilege
• Performed complete and incomplete recovery
• Worked on Disaster Recovery project.
• Flexible and excellent team player. Ready to work in any time slot.
• Excellent troubleshooting skills and quick learner.
• Worked on 24/7 high availability environment.
• Provided on-call support.
• Setup unidirectional replication using Oracle GoldenGate
• Handling tools such as TOAD, SQL*Navigator, SQL*Advantage and OEM.
• Hands on Experience in Performance tuning and optimization using DBMS STATS, AWR and optimizer hint and tools like Explain Plan, STATSPACK, SQL Trace, TKPROF.
• Analyzed ASH, AWR & ADDM reports
• Worked With Oracle Global Customer Support Service Request(SR) Analyst
• Performing design testing, implementation, maintenance and administration in a multiple platform SAP environment.
• Troubleshoot Networking issues.
• Worked with offshore team
• Very good understanding of Dynamic Views and Oracle Dictionary tables.
• Upgraded 10g to 11g R2
• Worked on 12c Multitenant databases.

SKILL:

Oracle 10G, 11G, 12C, Data Guard, RAC, ASM, RMAN

TECHNICAL SKILLS:

RAC, ASM, Performance tuning: Linux ASH, AWR, ADDM Data Guard, Statspack, Active Data Guard, Exadata, SQL, Profiling GoldenGate, RMAN, Oracle Security, SQL Developer, Shell scripting, Upgrades: OEM 12c Cloud Control AIX, HPUX SQL Baseline TOAD Cloning SQL Server Data Pump Grid Infrastructure

WORK EXPERIENCE:

Oracle DBA

Confidential, Framingham, MA

Responsibilities:

• Supporting Oracle Customers running various versions of Oracle RDBMS.
• Build multi node 11g R2 RAC
• Set up Active Data Guard
• Worked on various performances related issues.
• Very familiar with RAID configuration.
• Worked with Storage team for ASM and other file system needs.
• Set up uni-directional Golden Gate for replication.
• Setup the materialize views for replication.
• Worked For the support of Oracle Exadata Systems
• Managed SQL Server Databases.
• Provided assistance to Memory Corruption and Dictionary Corruption Errors
• Setup the replication using Oracle GoldenGate. Provided assistance to Slowness of Data Pump, expand SQL Loader utilities
• Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across the Globe.
• Involved in resolving issues after Installations, Upgrades, Cloning, patching (both DB and Applications), CPU patches, and one off patches.
• Development Life Cycle (ISDLC), that have high availability and scalability consistent with Customer needs, Mentors and develops Associates
• Applied On-off, CPU, PSU and CRS Bundle patches.
• Performing design testing, implementation, maintenance and administration in a multiple platform SAP environment.
• Provided assistance to Implement Huge pages /Large Pages in Unix platforms
• Assistance to High memory utilization issues in Unix and Windows Platforms
• Provides and supports the implementation of business solutions
• Upgrade databases from 9i to 10g to 11g R2
• Installed 12c database
• Worked on Multitenant databases.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Setting up and testing the backup and recovery strategies.
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Intensively used 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.
• Remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Database dot release upgrades using GUI and via command prompt
• Tested Recovery scenarios.
• Performed Security administration tasks, setup users accounts, passwords, roles
• Monitored data files, logical data storage and data growth activities
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze, DB backup logs etc.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM

Oracle Database Administrator

Confidential, Eatontown, NJ

Responsibilities:

• Responsible for administration and supporting oracle 11g, 10g and 9i databases.
• Coordinated system support and performance
• Actively participated in gathering Business Requirements and System Specification from system users.
• Responsible for Analyzing requirements, designing, maintaining and updating data models
• Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system.
• Installation of Oracle on Linux and Windows.
• Performed installations of Oracle 10g and 11g and SQL Server databases.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Analyzed and suggest improvements to SQL queries and statements written by others.
• Developed stored procedures to pull the data from the distributed systems.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Maintaining daily batch cycle and providing 24/7 support. Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Defined database requirements and designed data model.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Provided production support to the clients on Oracle 9i database administration aspects such as database backup using Oracle Export Utility and database crash recovery from the backup dumps and redo logs.
• Installation of Solaris, Linux and Windows on the servers.
• Monitored of tablespace related
• Developed various form-level and DML triggers to perform validation checks
• Worked Extensively in Menu Modules in forms Builder
• Developed Templates for new forms and generate scripts for database objects using oracle designer 10g
• Developed and implemented complex data models and logical database designs.
• Involved in unit testing and integrated testing.
• Involved in preparing the User Test plans. issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Involved in creating the new user management and security enforcement.
• Database links (DB Links) were created to access the data from remote databases.
• Solved different database related issues like taking care of different processes resources, listener and connect string.
• Written Cold and Hot backup scripts for backing up databases.
• Performed the logical backup at different levels like table, schema and database level.
• Interacted with other teams frequently in order to resolve different issues.
• Used Shell Scripting extensively to set up various jobs like backups, Housekeeping, and user deletion.
• Creating database triggers, Indexes after analyzing SQL for optimization.
• Monitored the database lock related issues.

Oracle Database Administrator

Confidential, Richmond, VA

Responsibilities:

• Involved in administration of Oracle instances.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Involved in the process of tuning and refining queries of various applications.
• Involved in team management, team building exercises for the Oracle team.
• Installed Oracle 9i Data guard. Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
• SQL issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Knowledge in writing shell scripts for automating backups and restoration.
• Worked on Data modeling tool POWER DESIGNER.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary table spaces.
• Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Developed startup/shutdown guides, troubleshooting documents, root cause analysis documents.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same. Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Involved in installing, implementing 32 bit and 64 bit 9i/10g/11g RAC on linux servers with ASM storage manager.
• Performing hot and cold backups.
• Restoration and recovery from backup.
• Conducting sizing and capacity planning for oracle databases.
• Initiated the project to migrate the storage from SUN T3 disk arrays to EMC symmetric to implement the SAN storage and EMC Time finder split mirror backups to reduce the backup downtime window. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Environment: Oracle 11g/10g/9i, Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/ SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader, Windows NT/2000