SUMMARY:

• 8+ years of Professional IT experience in Analysis, Design, Development, Implementation, Version Upgrade, and Support & Maintenance Projects.
• Experience in handling Oracle 9i, 10g and 11g Database in RAC/Non - RAC environment.
• Experience in installation of Oracle 11g Release2 RAC Database with Grid Infrastructure.
• Experience in working with Oracle Enterprise Manager 12C.
• Excellent exposure in Installing, Upgrading and Configuring Oracle Databases on Windows and Red Hat Linux Operating System.
• Experience in working with DB Management.
• Experience in Implementing and maintain the high availability solutions such as Oracle Data Guard and Real Application Cluster with ASM Storage.
• Evaluating Oracle Database new features and related products.
• Deploying RMAN backup jobs and reconfiguring when needed.
• Experience in applying Oracle Database Patches as needed by the client to fix Bugs.
• Verifying various kinds of Backups on the scheduled basis and preparing reports for the top management review.
• Experience in Database/Schema refreshments using Export/Import Utilities.
• Migrating Oracle Database across different platforms.
• Implementing and maintaining Database securities (Create and maintain users, roles and assign Privileges) as per audit policies.
• Experience in Database Cloning for Testing Purpose.
• Experience working with data modeler tools like ERWIN, Oracle SQL Developer.
• Experience working on Golden Gate.
• Experience in Data Masking for Non-Production environments after Cloning from Production.
• Experience in Performance tuning of the problematic queries.
• Experience in Fog light Tool used to monitor the Database and identifying the problematic queries.
• Coordinated with Developers/Application support team by generating and analyzing AWR and Statspack reports for performance tuning and optimization.
• Excellent communication Skills with strong Troubleshooting, willingness to learn and problem solving ability.
• Providing on-call support for Oracle Production Databases in 24*7 environments.

TECHNICAL SKILLS:

Operating Systems: Red hat Linux, windows - 2008 server

Database Technologies: Oracle9i, Oracle10g, Oracle11g, 10g RAC, 11g RAC, Oracle 12c

High Availability: Oracle Data-Guard and Real Application Cluster.

Database Tools and Utilities: Oracle 12c Enterprise Manager, AWR Report, Statspack Utility, Putty, SQL Developer, SQL Plus and Fog light.

Backup Tools: RMAN, Import/Export, Data pump.

Programming Tools: SQL, PL/SQL.

Development Methodology: Software Engineering, System Analysis and Design, Data and File Structures and Information Security.

PROFESSIONAL EXPERIENCE:

Confidential

SENIOR ORACLE DBA

ENVIRONMENT: Oracle Database 11g, Oracle Database 12c UNIX, SQL*Loader, PL/SQL, Fog light, golden gate.

Responsibilities:

• Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Table spaces and Temporary Table Space etc.
• Implemented nightly backup routines which include Oracle Managed Backups complete and incremental methods to optimize the time-window for backups.
• Creating users, roles,profiles and Auditing of Users according to the application requirement.
• Performing Weekly stats gathering activities.
• Experience in Disaster Recovery Strategy using oracle RMAN.
• Performing weekly rebuild partition index.
• Experience implementing Golden Gate.
• Tuning the PLSQL Packages/Procedures by doing analysis.
• Experienced in working with Fog light for monitoring the Database and Identifying problematic Queries.
• Creating new indexes for several Custom Tables.
• Developing custom programs to gather stats on several Global Temp Tables.
• Working with Oracle SR for performance Issues and applying Patches to upgrade the file versions as per Oracles recommendations.
• Tuning the DOP value according to instance work load.
• Monitoring of unusable indexes for Dev, Test and Production databases.
• Created materialized views with different refresh options to improve performances.
• Implemented ARCHIVELOG process to produce local and remote Archive log files with Multiple-Archive log Destinations for high-availability of the Database.
• Refreshing database and data load.
• Managing partition/sub partition/exchange partition for data warehouse.
• Managing RAC instances and data guard standby server.
• Reporting to business during database audit logs.
• Created many shell scripts for database monitoring.
• Checking invalid objects for databases and making it valid with scripts.
• Monitoring and deploying the TNS and LISTENERS for RAC database.
• Monitoring of RMAN.
• Transported the Table space from production database and plugged-in it in development database for the usage of developers.
• Extensively used Export /Import utilities for selective backup and defragmentation.
• Monitoring the Database growth and increase the table space size in Production database.
• Installed Oracle 11g on Linux.
• Experience working on Golden Gate.
• Regular Monitoring Alert log Files on Day to Day Basis.
• Enrolling users and maintaining system security.
• Controlling and monitoring user access to the database
• To keep the system highly available and on-call support 24hours and 7days of a week.

Confidential

ORACLE DATABASE ADMINISTRATOR

ENVIRONMENT: Oracle Database 11g, 10g, UNIX, SQL*Loader, RMAN, Data guard.

Responsibilities:

• Upgrading Oracle 11.1.0 Database Server to Oracle Database 11.2.0.
• Responsible for managing and support of Oracle Database Servers running on Oracle 11g (Release2).
• Experience in installation and administration of Oracle 11gR2 Database with Grid Infrastructure including ASM/Non-ASM Storage option.
• Evaluating new features of Oracle 11gR2 Database.
• Monitoring usage of databases and performing database tuning to enhance application functionality.
• Creation/Accepting of SQL Profiles to improve the performance.
• Creation of Hints in SQL queries forcing the Optimizer to choose specific path for optimal performance.
• Working on HP Service Manager Tickets/Incidents.
• Managing table spaces, data files, redo logs, tables and its segments.
• Using Oracle database configuration and administration tools such as SQL*Plus, Enterprise Manager.
• Experience in implementing Data Guard.
• Applying Patches and bug fixes as per Oracle recommendations after working on Oracle SR.
• Database cloning and schema refreshment for testing.
• Data Masking in Non Production environments after the clones from Production.
• Upgrading and migrating Oracle 9i Database Server to 10g Database servers, 10g Database Server to 11g Database Server .
• Responsible for managing and support of all Oracle Production Database Server running on Oracle 9i/10g/11g (Release1) and Development and UAT Database Servers running on 9i/10g/11g (Release1/Release2).
• Adding/removing nodes from RAC databases.
• Evaluating and reviewing of Oracle Database 10g and 11g new features (OEM, Oracle Data Pump, AWR, etc).
• Monitoring of alert log and troubleshooting by analyzing and reading the trace files.
• Creating and managing permanent, undo and temporary table spaces.
• Migrating single instance database to RAC database and from file system storage to ASM storage.
• Administering Oracle networking such as tnsnames.ora & listener.ora.
• Implementing and maintaining database security with the help of roles and privileges.
• Using Oracle database configuration and administration tools such as SQL*Plus, Enterprise Manager.
• Designing and implementing Backup policy i.e. RMAN Backup and Logical Backup.
• Transporting database objects within the Database (Data pump, Export & Import, etc.)
• Handling and resolving the various incidents/tickets raised by the internal ticketing tool (involves handling critical production P1’s/P2’s).
• Handling the various database alerts like database/instance/listener down, tablespace space check, blocking user sessions, alert log errors, TEMP space usage, standby lag check etc..
• Patching and upgrading the oracle databases as per the planned maintenance activity.
• Managing the standby databases.
• Experience working on Golden Gate.
• Co ordinate with Oracle Technical support for any critical issues.
• Planning for system growth and monitor capacity usage for new hardware/software requirement and communicate these capacity requirements to Sr. Management.

Confidential, NEW YORK

ORACLE DBA

ENVIRONMENT: Oracle database 11g, Oracle 10g LINUX, OEM, and RMAN.

Responsibilities:

• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, table spaces, indexing, data maintenance, user management, and maintenance and solving critical errors like ORA-600, ORA-7445.
• Performed backup and recovery using RMAN and conventional hot & cold backups.
• Converting data files across different platform using RMAN convert, Transportable Tablespace (TTS), Export/Import and Data pump (expdp/impdp).
• Involved in maintenance of Oracle 11g/10g RAC databases for the Production and development environments and migrated Database between servers using Data pump.
• Extensive knowledge on database administration fororacle 10g and 11g with experience in very large scale database environment and critical OLTP systems.
• Experience in managing oracle databases running on Linux, HP-Unix and windows.
• Good experience in Installation, Creating and maintenance of oracle 10g, 11g standby database for High Availability and DR purpose.
• Good Experience in RAC cluster ware Configuration, administration and patching.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Experience in Level2 performance tuning.
• Good Experience in patching and up gradations
• Experience in flashback technologies
• Good experience in Change management and ITIL process.
• Experience in User management, creating roles, permissions in Oracle database.
• Expertise in upgrading test, development and production databases from 10g to 11g.
• Proficient in raising TAR with oracle support and using Metalink to resolve the errors in the database environment.
• Good Experience in RMAN, Logical (Data pump, Export & Import) and Physical backup (Hot & Cold).
• Hands on experience in Switch-over and Fail-over process.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD.
• Experience in cloning and refreshing the databases
• Creating, Configuring, scheduling and troubleshooting database backup and restoration plans
• Experience in creating databases based on functional requirement and developing the successful backup strategies based on recovery models.
• Designing and managing backup strategies, disaster recovery solutions, Log shipping
• Responsible for creating and scheduling and troubleshooting of SQL Server jobs
• Checking the maintenance plans on all the servers on a daily basis. These plans used to create backups on a daily basis and used to check optimization and integrity on a weekly basis.
• Maintaining the database consistency with dbcc commands.
• Creating of logins, Roles and granting rights, Assigning permissions and mapping user databases as per the client's requirements.
• Planning and implementing disaster recovery procedure to ensure minimal downtime and data loss.
• Remove any unneeded space from the transaction log and data files by shrinking the databases.

Confidential

ORACLE DBA

ENVIRONMENT: Oracle Database10g, SQL*PLUS, SQL*LOADER, Oracle Toad 9.1.0, SQL*PLUS, SQL*Net, Linux, UNIX.

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Converting data files across different platform using RMAN convert, Transportable Tablespaces (TTS), Export/Import and Data pump (expdp/impdp).
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and
• Created and configured partitioned database servers.
• Installed, configured and upgraded symmetrical multi-processing systems.
• Oracle Database Performance tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN etc.
• Experience with SQL, DDL, DML, DCL, PL/SQL coding, stored procedures, functions, packages, triggers and Periodically uploading data from flat files using SQL*Loader.
• Explored 10g’s improved Automatic Optimizer Statistics Collection using Automatic Workload Repository (AWR).
• Proactively monitoring, identifying areas that need to be improved in the application and database using Stats Pack, AWR, ADDM and 10g OEM Grid Monitoring.
• Database Capacity Planning & configuration (redo and stream sizes), design staging schema and use of DBMS STREAM ADM packages.
• Detect corrupted blocks by using DBVERIFY utility and schedule jobs by DBMS.Scheduler.
• UNIX Shell scripting for database monitoring, backup and to simplify day to day activities.
• Partitioning tables by determining the suitable methodology to improve performance and manageability and other activities like applying RDBMS patches, security patches.
• Cloned/Refreshed environments to create test, development and QA environments

Confidential

ORACLE DBA

ENVIRONMENT: Oracle10g, SQL*LOADER, SQL*PLUS, Linux, UNIX.

Responsibilities:

• Developed Shell Scripts to automate job scheduling for various database related program execution like SQL script.
• Used EXPORT and IMPORT utilities to copy data between different schemas in Oracle Databases.
• Experience in User management, creating roles, permissions in Oracle database.
• Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery.
• Documenting all the processes followed in the production DB work.
• Designed structure to keep all the logical backups of important schemas.
• Appreciations for quick problem solving.
• Transported table spaces between production and development databases.
• Handling the various database alerts like database/instance/listener down, tablespace space check, blocking user sessions, alert log errors, TEMP space usage, standby lag check etc..
• Installed, configured and maintained oracle 10g on Linux.