PROFESSIONAL SUMMARY

• 7 years of experience in Oracle Database Administration in very large Production, Test and Development environments in a diversified domains, on various versions of UNIX/LINUX and Windows Operating Systems.
• Oracle DBA experience with Installation, Configuration, Patching and Administration of multiple Oracle Enterprise Edition 9i, 10g, 11g and 12c databases on RHEL, OEL, Sun Solaris and Windows servers in production and development.
• Exceptional Knowledge of various states of Software Development Life Cycle SDLC i.e. System Analysis, Application Designs, Development, Integration System Testing support of Oracle 9i, 10g, 11g in Production, Staging, and Development environments.
• Experience in Installation, Configuration and Administration of Oracle 10g RAC, 11g RAC, Data Guard Standby Databases for High Availability and Disaster Recovery purpose.
• Backup of Databases Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc. with Hot/Cold Backup methods and Cloning of Databases using RMAN and other backup techniques.
• Proficient in migration of Database and up gradation from Oracle 9i to 10g 10g to 11g, Standalone to High Availability 10g RAC environment and Cross Platform SunOS to Linux .
• Expert in effective troubleshooting of production, development database environments on daily basis with Proactive performance monitoring for better performance in applications database using AWR and Oracle Enterprise Manager OEM .
• Proficient in using Oracle utilities like Export/Import Data Pump, Flash Back Recovery, Data Guard, TOAD, SQL Loader, Oracle SQL Developer, OEM, ASM and AWR.
• Strong Knowledge and Experience of Creating Users, Views, Materialized Views, Public Synonyms, Database Links, Roles, Profiles, Privileges and Assigning roles to users.
• Expert in Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Packages, Database Triggers and Shell scripting and worked with the users to meet business requirements.
• Working knowledge in production 24x7 , staging, and development test databases.
• Experience in Capacity Planning, Storage Allocation and Space Monitoring Management.
• Excellent knowledge of Database components and detailed Architecture
• Strong Troubleshooting, Problem solving, Analytical and Design Skills
• Highly motivated, excellent team player and quick learner of new technologies with Strong interpersonal and communication skills.
• Effective Supervisory experience and proven capability to direct and work with team to accomplish goals.

TECHNICAL SKILLS

• Operating Systems Red Hat Linux, Oracle Enterprise Linux, Oracle VM Server, SUN Solaris, VMware, Microsoft Windows
• Databases Oracle 9i, 10g, 11g, 12c
• High Availability Oracle 10g/11g RAC, Standby Database, Data Guard and Clustering Setup, Automatic Storage Management ASM
• Oracle Tools Oracle Enterprise Manager OEM , Recovery Manager, Export/Import, Datapump, RMAN, Toad, SQL Loader, Erwin, Putty
• Languages SQL, PL/SQL, Java, C, Unix Shell Scripting
• Others Microsoft Office

PROFESSIONAL EXPERIENCE

Sr. Oracle Database Administrator

Environment: - Oracle 9i/10g/11g, OEM 10g/11g, Sun Solaris, OEL, RHEL, RAC, ASM, RMAN, Data Guard, TOAD, SQL Developer, Goldengate

Responsibilities:-

• Responsible for continuous Oracle Database monitoring and reorganization for ensuring Database performance.
• Implementing and Maintaining Database security by creating and maintaining users, roles and assigning privileges
• Responsible for 24x7 Oracle Production Database Administrations support
• Proactive monitoring of Oracle Database Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.
• Responsible for Oracle Database 10g/11g Installation, configuration and maintenance and Oracle Applications.
• Configuration of Global/Table/Schema level Replication of various Oracle 10g/11g Databases using Golden Gate Replicator.
• Implemented and maintained Oracle 10g/11g Data Guard/standby Databases for fail-over purposes.
• Replicated to a disaster recovery site for increased server manageability and availability.
• Installing and configuring of ASM, RAC and Managing RAC Environment effectively and efficiently
• Responsible for Database tuning, Application Tuning Performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Coordinate with Project Management, Software Development, QA and Production teams to coordinate product release and forecast capacity planning.
• Working with Oracle utilities i.e. Export/Import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Troubleshoot performance issues and bugs in SQL queries and packages using Explain Plan. Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Advanced Backup and Recovery using Oracle's RMAN software used offline/online for recovery in a production environment via Korn shell scripting.
• Worked with oracle SR to investigate bugs in databases upgrades and coordinates with different team to implement solutions without interruption for customers.
• Implemented ASM, Migrate Databases from non-ASM file system to ASM file system with normal redundancy and external redundancy.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g 10g to 11g.
• Migrating Oracle databases from windows to Linux
• Installation and configuration of Golden Gate Validate on production, development and testing.
• Responsible for continuous monitoring the production Oracle alert logs for database errors.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Meta link
• Maintained documentation and coding standards, best practices, and quality improvement documentation. Architecting environments based on current demands and projection of future growth.
• Applying latest versions or releases of database patches to minimize the bug issues which caused by the previous versions of patches.

Confidential

Sr. Oracle Database Administrator

Environment: - Oracle 9i/10g/11g, RAC, ASM, RMAN, Data Guard, SQL Developer, SQL Loader, OEM, Sun Solaris, Red Hat Linux, OEL, Toad, PL/SQL,

Responsibilities:-

• Tuning the Applications for optimal performance, designed the backup strategy for the applications, Designed and developed table structures, PL/SQL stored procedures and database triggers to implement business rules. Created Tables, Views and Indexes for the Project
• Administration, Optimization, Monitor and Tuning of Oracle Databases.
• Performed DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Cloning of Database and applications for development and testing purpose.
• Monitored system resource availability and responded to system memory and data issues.
• Responsible for Creation and maintenance table space, data files, redo log files and renaming /relocating of data files on servers based on OFA model.
• Performed tasks to restore and recover databases from file system backup in order to bring it to the original state as per the business or user requirement.
• Configuration of various alerts and monitoring in Oracle database using Oracle Enterprise Manager Grid 10g.
• Support involves handling multiple Oracle 10g RAC with Veritas Cluster, Sun Cluster and Oracle Clusterware across various applications hosted in Oracle 9i/10g and 11g Databases across Linux, HP-UX and Solaris
• Troubleshoot the database performance using Oracle Enterprise Manager, generating the monthly reports on the database to see how much load has been applied on database constantly.
• Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements.
• Apply patches for both Server side and Client side.
• Standby Database Data Guard setup and configuration.
• Worked with Oracle support to resolve the issues quickly as per the business require.
• Defining and Setting backup and recovery procedures.
• Partitioning large objects to improve the performance and manageability.
• Working alongside programmers and contributing to the development process
• Installation and supporting oracle enterprise manager grid Control OEM Grid Control 10g , cloning of oracle 10g binaries, Deploying of OEM 10g agents, Migrating and Upgrading Database and Oracle binaries, Applying Patches etc with automate scripts.
• Handling all maintenance and administrative functions for databases, including space management, backup/recovery, RMAN Backup copying prod to development databases. Schema level refresh on user's request using import/export and data pump.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Installation and configuration of Oracle 9i 10gRAC database and Performed DBA tasks
• Migration of database from Oracle 9i to Oracle 10g.
• Performance Tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components
• Table Partitioning, Creating Locally managed Table spaces.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Meta link.
• Created Managed Database Structures, Storage Allocations, Table/Index segments, Undo management, Constraints, Database Access, Roles, Privileges and Profiles.

Confidential

Jr. Oracle DBA PL/SQL Developer

Environment: - Oracle 8i/9i/10g, SQL Loader, OEM, Red Hat Linux, Toad, PL/SQL, SQL Loader

Responsibilities:-

• Created Scripts to load the data into tables using SQL Loader
• Monitor and optimize performance analysis of different database objects, planed for backup and recovery of the Database
• Developed SQL scripts to create database objects like Tables, Views, Indexes and Sequences
• Developed Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers and SQL scripts to facilitate the functionality for various modules
• Working closely with DBA's for performance problems, fix the problem and make recommendations to technical staff to improve performance.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Cloning of databases from production to development and test databases
• Developed, Tested and debugged the code according to business requirements
• Worked on performance tuning and testing of Oracle PL/SQL database entities
• Designed and modified primary database objects, database structure as necessary for enhancements or performance
• Allocated system storage and plan future storage as needed
• Created database-related scripts and programs to support development and production environments.
• Research, evaluate, design and plan implementation of new or improved RDBMS, ETL and database tools.
• Prepare necessary technical development documents