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 wif 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.) wif 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 wif 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 wif teh users to meet business requirements.
• Working noledge in production (24x7), staging, and development & test databases.
• Experience in Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Excellent noledge 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 wif Strong interpersonal and communication skills.
• Effective Supervisory experience and proven capability to direct and work wif 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

Confidential, Atlanta, GA

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 wif Project Management, Software Development, QA and Production teams to coordinate product release and forecast capacity planning.
• Working wif 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 wif oracle SR to investigate bugs in databases upgrades and coordinates wif different team to implement solutions wifout interruption for customers.
• Implemented ASM, Migrate Databases from non-ASM file system to ASM file system wif normal redundancy and external redundancy.
• Involved in Upgrade/Migration of teh 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 teh 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 teh bug issues which caused by teh previous versions of patches.

Confidential, Lewisville TX

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 teh Applications for optimal performance, designed teh backup strategy for teh applications, Designed and developed table structures, PL/SQL stored procedures and database triggers to implement business rules. Created Tables, Views and Indexes for teh 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 teh original state as per teh 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 wif 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 teh database performance using Oracle Enterprise Manager, generating teh monthly reports on teh 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 wif teh users to meet business requirements.
• Apply patches for both Server side and Client side.
• Standby Database (Data Guard) setup and configuration.
• Worked wif Oracle support to resolve teh issues quickly as per teh business require.
• Defining and Setting backup and recovery procedures.
• Partitioning large objects to improve teh performance and manageability.
• Working alongside programmers and contributing to teh 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 wif 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 wifin tablespaces, reclaimed space whenever possible. Reorganized tables and indexes wifin 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 teh SQL, which are not written well, providing inputs to teh application programmer, correcting and implementing teh 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 teh data into tables using SQL Loader
• Monitor and optimize performance analysis of different database objects, planed for backup and recovery of teh 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 teh functionality for various modules
• Working closely wif DBA’s for performance problems, fix teh problem and make recommendations to technical staff to improve performance.
• Implemented Cold Backup and Hot Backup depending on teh 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 teh 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