SUMMARY

• Around 7 years of IT experience as Oracle Database Administrator with key strengths in Oracle 8i, 9i, 10g and 11gR2 databases on Linux, SOLARIS and Windows operating system environments.
• Hands on experience with installing, upgrading SAP databases and administration using BRTools.
• Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version’s 8i, 9i, 10g & 11g along with 24 X 7 Support to the Production database.
• Installed Oracle server and client software, configured, upgraded and applied critical patches to databases of various versions on HP - UX, AIX, Solaris, Linux and Windows in Production and QA environments and migrated databases from Oracle 8i / 9i, to 10g and 11R2.
• Installed 10g, 11g GRID control and deployed OEM agents.
• Managed database Privacy and Security by monitoring User Privileges, Schemas and using Auditing techniques.
• Expert level knowledge of creating and maintaining Tables, Partitioning, indexes, Materialized Views, Parallel Execution, Global Temporary Tables, Triggers, Stored procedures and database refreshing using Export/Import, Datapump.
• Implemented DR & High Availability oracle solutions using oracle Streams and Data guard.
• Performed Database backup, Restoring Databases, Creating Database Objects, Ensuring Data Integrity, Performance Tuning and Troubleshooting, Replication, Migrating Data between Database servers.
• Sound RMAN experience of Backup, Restore and Recovery in different scenarios and requirements using RMAN, Data pump and Flashback with different backup technologies TSM, Commvault, SQL Backtrack and logical backups like export dumps.
• Experience in database migration using Golden Gate on Red Hat Linux 4 servers.
• Extensive experience in Transformation, Loading Data into various Databases using Datastage, External Tables, Transportable Tablespaces.
• Performance Tuning and Optimizing database parameters using AWR, ADDM, Explain plans, STATSPACK.
• Experience in OWI reports and various advisors like ASMM, Undo Advisor, and Segment Advisor.
• Worked on Switchover and Failover scenarios for high availability Server with Data Guard Broker.
• Experience using shell script to automate OS and database related process schedules and monitoring of databases.
• Proficient in tracing sessions using SQL trace/10046 trace and use TKPROF output files to monitor resource utilization.
• Performed User Account Management - Creating database Users, Schemas, Roles, Privileges, Password management, Connectivity issues related to Listener, tnsnames, ODBC.
• Worked on Oracle RAC (9i/10g/11g) on AIX, Red hat Linux, Sun Solaris platforms. Hands on experience at setting up CRS, TAF, VIP’s and other latest Oracle Databases technologies setups like ASM and OCFS.
• Wide experience in Tuning and Optimizations for good throughput and performance including RAC/Cluster related performance issue for Maximum availability environments.
• Monitored and optimized the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Data and Database replication using snapshots, materialized views, Golden Gate and Streams.
• Possess excellent inter personal and communication skills.

TECHNICAL SKILLS

Database Experience: Installation & Configuration of Oracle, Oracle RAC, Database Server Tuning and sizing, Application SQL Tuning, User-Space management, Backup/recovery techniques, SQL*Net configuration, PL/SQL, SQL* Loader, Oracle Migration Tools. Capacity Planning, Oracle RMAN, RCVCAT, Oracle Application Server, Oracle Data guard / Standby database, Oracle Replication/ Oracle Streams.

DBA Tools/Oracle Products: OEM (Oracle Enterprise Manager), SQL Navigator, Platinum SQL Station & Analyzer, Oracle Grid Control, RMAN, Statspack, Korn shell, Shareplex, TKPROF, Data-pump, DBCA, DBUA, CRS, RAC, ODSM.

RDBMS: Oracle 8i,9i,10g,11g, SQL Server 2000/2005, DB2

Programming & Scripting languages: SQL,PL/SQL,XML, UNIX Shell Scripting, C, C++, C#, Oracle Forms (10g, 9i, 6i)/Reports (10g, 9i)

Operating Systems: UNIX (HP UX 9.x/10.20/11.0, Sun Solaris OS 2.8/2.9/2.10 , AIX 5.x,4.x), Windows NT 4.0,Windows 95 /3.X, Novell NetWare 4.0

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle Database Administrator

Responsibilities:

• Install Oracle 11g and refresh databases on windows servers.
• Setup Oracle 11g databases for Applications and upgrade several 10g databases to 11g.
• Install 11g SAP database binaries and upgrade SAP databases from 10gR2 to 11gR2.
• Schema consolidation while moving application servers to new virtual servers and database checkout during server consolidations.
• SAP database administration using BRTOOLS and ensuring backups.
• Provided DBA support to SAP basis Team to install SAP solution manager 7.0.
• Enhanced SAP database performance and space utilization using 11g ADR tool
• Moved FDA data using validated EXPORT/IMPORT techniques and document it for auditing.
• Installed Grid control 11g and installed Oracle Management Agents (Management Agent) with the help of a central, shared Oracle home location.
• Schedule cronjobs and refresh databases using hot backup.
• Installed SQLServer ’05 on new virtual windows servers and moved databases from old servers to new. Install patches.
• Move SQLServer databases from physical servers to Virtual as a part of consolidation project.
• Create maintenance plans for SQLServer user databases.
• Test and Schedule maintenance plans for SQLServer databases using AVAMAR backup tool.
• Recover and replace SQLServer databases using AVAMAR backup and recovery tool.
• Managed tickets escalated to DBA team and provide production support on a rotation basis.

Environment: Solaris 5.X, Windows 2K, Linux, VMware, Oracle11g R2/10g R2, AWR, ADDM, ADR, SAP, RMAN, EXP/IMP

Confidential, Houston, TX

Oracle Database Administrator

Responsibilities:

• Setting up daily monitoring jobs, automatic alert notification when database is down or preset thresholds exceeded, installation of new database upgrades, patches, create databases, primary database objects like table spaces, tables, views, synonyms, snapshots, partitioning and sizing tables, indexes etc.
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g.
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitored and Administrated ORACLE RAC databases on ORACLE 11g Clusters.
• Implemented security policy using Fine Grained Audit (FGA) to watch any suspicious activity on objects.
• Automated the different tasks like (Creating Databases, Binaries Installation, backups) using KORN shell scripts.
• Configured logical stand by database for the primary database and opened up the database to the reporting users group to distribute the load between primary and standby database.
• Monitored performance of queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor
• Created and analyzed Statspack report, AWR reports and identified solutions.
• Performed Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, and Data Pump tools.
• Managed Oracle in High Availability environments using Real Application Cluster (RAC), Failovers, Data Guard and Cloning technologies.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Tuned database parameter, PL/SQL scripts and queries using statspack report, TOAD, AWR, ADDM or through the end users. Used Materialized Views when possible to reduce network load.
• Backup of Database (Performed database Backup depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Created and deployed VMware templates for Oracle Standalone databases in test environment.
• Used Oracle Directory Services Manager to configure the structure of the directory, define objects in the directory, add and configure users, groups, entries and manage security.
• Handled complete and incomplete recovery in case of database failure.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Managed schemas, user privileges, suggested and implemented external tables instead of SQL* Loader to reduce time and resources.
• Managed database availability by replicating physical database by installing and configuring Golden Gate.

Environment: Solaris 5.X, Windows NT, VMware, Oracle11g R2/10g R2, 7x HP UX 10.2/11.X, IBM AIX, RAC, AWR, ADDM, SQL trace, TKPROF, Golden Gate, TOAD.

Confidential, Dallas TX

Oracle DBA Consultant

Responsibilities:

• Setting up Oracle 10g databases on Solaris, Red hat Linux, installing Oracle Enterprise Manager on Workstation to monitor multiple Oracle instances.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Supported Migration of Databases using Golden Gate. Installed, configured Golden Gate and its Processes with File permission for Cross Platform Migration, Replication.
• Oracle Database Administration on 24x7 critical production and large databases of over 4 TB using Oracle 10g, 9i.
• Managed application development rollovers to production. Implemented data security using database roles and views.
• Continuous monitoring of Database Performances and identifying any bottlenecks hindering the performance of the database
• Database Fail over / Switch over activities for maintenance and time-to-time DR drills with Oracle9i/10g Data guard.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Preparing OS Environment for Database, especially RAC environment doing thorough testing of all RAC nodes using FEMA guidelines at Server Level, Interconnect, Failover/load balance and Database level.
• Performed tasks associated with tuning of database systems for performance and efficiency enhancements, reviewing the logs, available space, configuring the initialization parameters based on application requirements, optimizing complex SQL queries, adhering to the OFA standards, using RAID drives to implement file systems.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, Tkprof, and Oracle Enterprise Manager.
• Create, maintain and refresh required Oracle instances/databases for development, test and production environments, install patches.
• Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation.
• Implement backup and recovery procedures using RMAN for Oracle databases and test regularly in conjunction with Operations.

Environment: Oracle 10gR2, SAN, HP-UX 11.31, Linux AS 5, AIX 5.3, OEM (Grid Control), RMAN, SQL*Plus, PL/SQL, SQL*Loader, AWR, Explain Plan

Confidential, Las Vegas NV

Oracle DBA Consultant

Responsibilities:

• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.
• Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases workload.
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Used Flashback technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager
• Configured users into consumer groups and set the resource utilization based upon business activity using Resource Manager.
• Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using DBUA/Manually.
• Refreshed PROD, DEV, UAT databases using Datapump, RMAN, and Transportable Tablespaces etc.
• Administrated database regarding space related issues- monitoring Tablespaces, users’ security of data accessibility and Configuring Archive log destinations and Flash Recovery Area (FRA).
• Create Triggers and defined constraints to maintain the data integrity in the databases.
• Installation and configuration of ORACLE Net8 for client-server connectivity.
• Planning and scheduling for the backup of database information using Crontab jobs.
• Generated daily, weekly and monthly reports regarding total revenue management.
• Developing various Business and ad-hoc Reports.
• Writing stored procedures to achieve back end functionality
• Assisted DBAs for Creation of all database objects, Allocate system storage and Plan future storage requirement.
• Develop and maintain Application and Database Security Standard. Wrote and trouble shoot database triggers/Stored Procedures.
• Shell Scripting in csh and ksh
• Security Management that includes enrolling users and maintaining system security by controlling and monitoring user access to database.

Environment: Oracle 10g,/ 9.0.1/9.2.0 , Oracle Applications 10.7 NCA, Shell Scripts, SVRMGR, Adadmin, SQL Plus, PLSQL, SUNDBLINK, RTRENF, Sun Solaris 2.6, Win NT

Confidential, Fairfax VA

Oracle DBA Consultant

Responsibilities:

• Worked on EM grid control setup and deploying agents on to Servers.
• Designed and developed database DDL and DML scripts to meet development application requirement for tablespaces, security and roles, SGA and other memory configurations for both OLTP and ETL applications
• Design and development of shell and database scripts for data loads and conversion of DB2 data to Oracle
• Worked with development team to design data model and architect solution for database components
• Worked with SA, Integration Architect, Application Server Admin, Unix Admin to resolve infrastructure and database related issues
• Designing the logical and physical architecture of the database - Erwin Converting the conceptual model into logical and physical model Indexing strategies.
• Configured Oracle 10g Physical Standby DB with appropriate lag time and logical for reporting DB.
• Installation and configuration of Oracle 10g Grid and its agents on DB server.
• Tuned SGA by Tuning Library Cache, Dictionary Cache, and Buffer Cache. Tuned OS by Reducing Paging/Swapping. Tuned I/O which includes Separation of Data files and Redo log files.
• Supported the migration of Oracle datafiles to ASM filesystem
• Implemented & designed Oracle Portal 10gAS in 3 tier enterprise distributed architecture with SSO/DAS in secure DMZ tier with configuration of HTTPS/SSL and split the customer database (metadata) on different cluster environment for better performance, availability and scalability
• Upgraded VIVID database to 10.2.0.3. Applied few other opatch patches. Worked on several SR’s with Oracle Support.
• Installed and configured Oracle Enterprise Manager (OEM) in order to provide ongoing, remote database support using the OEM intelligent agent, OEM repository, event monitor and paging system. Implemented hot backups using RMAN with jobs scheduled via OEM.
• Responsible for creating hot backup and recovery scripts and plans. Designed and implemented backup methods and disaster recovery strategies. Used RMAN for NT databases hot backup. Used a combination of shell scripts and SUN OS file snapshots technology to create daily hot backups for Oracle databases running on AIX and SUN OS.

Environment: Oracle 9i, 10g, SQL*Loader, SQL*Plus, SQL Server 2000, Oracle Enterprise Manager (OEM), RMAN, RHEL AS 3.0, and Windows 2000

Confidential

Junior Oracle DBA

Responsibilities:

• Responsible for database refreshes/cloning from production to QA/Reporting environments. Responsible for localizing the cloned databases for QA/Reporting use e.g. creating users, resetting privileges/passwords, resetting sequences, resetting database links etc.
• Executed all major DBA activities which include creating databases, performance tuning, backup and recovery, import/export, network administration, installation, managing the physical and logical structures, managing database availability, monitoring databases on a daily basis, creating users/profiles/roles/db-links/tables/indexes/sequences, troubleshooting etc.
• Co-ordinated backup and recovery operations over all databases and ensured complete restore and recovery.
• Performed installation of Oracle software products and database creation and upgrade. Responsible for data integrity and user security. Perform physical database design, database space needs and growth analysis, and future disk need analysis. Implement backup and recovery strategies for archiving and non-archiving databases.
• Conducted database and applications performance tuning operations making significant improvements in database system performance. Supported developers in tuning DB and apps for optimal performance.
• Administered, maintained, developed and implemented policies and procedures for Managing DB Security and alert log entries.
• Resolved database performance issues, database capacity issues, and distributed data issues.

Environment: Oracle 8i/9i, SQL Server 7.0, PL/SQL, SQL* Loader, RMAN, Import/Export, Oracle Enterprise Manager (OEM), MS Access, Sun Solaris, HP-UX.