SUMMARY

• Around 8 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security wif Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, HP-UX, Windows, UNIX and Sun Solaris in OLTP environment.
• Upgradation of databases by applying patches, patch sets and critical patch updates.
• Installation and configuration of Oracle Server 11g RAC wif ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Extensive experience on Oracle 11g/ASM/RAC and Upgradation of standalone databases to 11g RAC environment
• Experience in Configuring Automatic Storage Management (ASM).
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM 12c) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Extensive experience in configuring and managing Data Guard on RHEL, OEL and Windows.
• Extensive experience wif Database Cloning and Refreshing pre-prod/dev databases wif prod/pre-prod databases.
• Experienced in setting up physical standby databases for Disaster Recovery in critical production environments using Data Guard.
• Experience in installation and implementing OEM 12c and TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Migration of databases from one platform to another platform.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000Windows Advanced Servers 2000/2003.

Databases: Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2005. Oracle Database Tools SQL*Loader, TKPROF, Toad, OEM 12c, SQL Developer, Grid Control

Data Warehouse Tools: SQL and ETL tools for above database environment Tools & Utilities Export/Import, RMAN, Data Pump, Winscp3 and ERWIN.

Languages: C, C++, UNIX shell scripts, PL/SQL

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, IL

Oracle Database Administrator

Responsibilities:

• Responsible for life cycle development, testing and production performing 9i, 10g and 11g, RAC installations, configuration, tuning and troubleshooting on Unix & Windows operating systems
• Supported installation and setup of ORACLE Cluster’s and RAC database. Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters(6 Node wif high availability )
• Table & Index partitioning to monitor performance issues and ensuring maximum uptime of the database. Importing of dumps using impdp/expdp utilities.
• Implemented Automatic Shared Memory Management (ASMM) and Automatic Segment Space Management (ASSM).
• Implemented cross platform migration from HP-UX to AIX, Solaris to Linux, Windows to Linux
• User accounts creation and Table Space Creation and managing the table spaces using the Oracle Default Compression.
• Implemented Oracle Advanced Security options such as data encryption for data privacy.
• Performed Patch set updates, CPU patches on RAC Databases to minimize the security issues and provide bugs fixes and Configured and Upgraded to Oracle 11gR2 from 10g.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Implementation and monitoring of all databases using OEM 12c/Grid Control
• Also applied Interim (One-Off), Setting up physical and logical standby database/data guard at DR site for operational recovery.
• Performance tuning and monitoring of Databases through v$ views, AWR, ADDM, statspack, etc.
• Analyzing the Tables and Indexes using DBMS STATS package.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Establishing back-up policies and Restore activity, backup using User Managed Backup (Data Pump) and Recovery Managed Backup (RMAN).
• Provided 24x7on call support for all the production databases.

Environment: Oracle 9i/10g/11g/11gR2/12c databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, RHEL, HTTP, F-Secure SSH,, F-Secure FTP, Oracle Enterprise Manager 12c, TOAD, ASM, Data Guard and Oracle Tools.

Confidential, Parsippany, NJ

Oracle Database Administrator

Responsibilities:

• Design and Create new databases based on requirements of the application / project
• Responsible for all the database related jobs for all the instances, performance tuning, backup and recovery, managing users & privileges, resource limits. Administration of database objects such as indexes, tables, views, constraints, and stored procedures.
• Performed database tuning using explain plan, tkprof, stats pack and other custom utilities
• Installed, configured 10gRAC on two node cluster, created databases in both in standalone and RAC environment.
• Oracle Streams Enabled the feature: data replications and integration feature in Oracle 11g
• Developed RMAN backup scripts and automating the RMAN backup scripts.
• Implement partitioning and indexing strategies
• Create users, roles and profiles wif different security levels. Grant and revoke privileges.
• Migrate changes to Oracle database objects and monitor/administer existing databases security wif Oracle database environment.
• Provide DBA support to developers, develop stored procedures and triggers. Also Provide on call support related to Oracle DBA activities.
• Taking reviews of physical database models. Develop procedures to troubleshoot issues.
• Handled day to day database activities including performance monitoring and tuning to ensure the efficient and accurate operation of the database software. Scheduling maintenance and health check of the applications and databases.
• Analyzing the schemas and individual tables Expert in Oracle Backend programming in SQL and PL/SQL, Writing Stored Packages, Procedures, and triggers in a Multi tier environment.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Planned and Implemented Disaster Recovery(DR) and HA using RAC, Data Guard, Streams and made sure that the database is always available for the users even at the critical times like failures and up-gradations.
• Cloned or refreshed the databases from production to development and test environments.
• Migrated database from Solaris to Red Hat Linux.
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Environment: Oracle 11g/10g, Oracle Enterprise Manager Grid Control, ASM, Real Application Cluster Loader, Oracle Enterprise manager (OEM), TOAD, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential, Bentonville, AR

Oracle Database Administrator

Responsibilities:

• Configured and installed Oracle 9i/10g Databases; handled migration/upgrades of databases from 8i to 9i and 10g manually and wif DBUA.
• Data modeling / Logical database design and implementation (including index design)
• Performed Backup/Recovery using RMAN and established testing standards utilizing the advantages of 10g Flashback.
• Performance tuned application/table design, data access methods, memory allocation, disk I/O, CPU usage and resource contention.
• Worked on debugging of databases and applied Oracle patches.
• Monitored Oracle Databases using scripts and OEM for database connectivity, table spaces monitoring and object growth.
• Conducting technology audits and performing GAP Analysis.
• Analyzed tables and rebuilt indexes to improve performance. Managed rollback segments, server processes, SGA, online redo log files and data files.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Monitored the server’s memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command-line utilities.
• Wrote SQL scripts for DBA functions. Designed and created database objects such as Tables, Indexes, synonyms, database links, views and snapshots.
• 24*7 production databases and handled all day to day database issues, upgrades and enhancements.
• Provided maintenance of User accounts and privileges. Using Data- Pump, Export/Import to ensure that the latest data is available in the development/test database.
• Resolving incident tickets in the production environment wif an good Service level Agreement.

Environment: Oracle 9i/10g on Sun Solaris 8/9, Real Application Clusters, Sun Solaris, Windows 98/NT/2000, IBM X Series,Oracle9i/10g,Oracle Enterprise Manager, EXPLAIN PLAN,RMAN.

Confidential

Oracle DBA/ Data analyst

Responsibilities:

• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity wif database.
• Implement Hot, Cold and Logical backup plans.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Worked on Oracle Configuration, oracle Tuning and Oracle Patch Administration.
• Knowledge experience wif Ethernet and mobility systems.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Performed Database Tuning. Performed Database Security and Integrity.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Created partitioning of its types like Range, List & Hash by the specific use.

Environment: Oracle 9i,8i, RMAN, SQL*Loader, Sun Solaris, RHEL, Oracle Linux, putty.