SUMMARY

• About Seven plus years of experience as an ORACLE DBA (8i/9i/10g/11g) on different Unix and Windows environments like - Linux, HP-UX, Sun Solaris, Windows NT/2000/2003.
• Installed and configured 2, 4, 6 node server side load balancing RAC (Real Application Clusters) databases on HP UNIX and Linux with ASM (Automatic Storage Management) and Data Guard.
• Experience in Upgrade from oracle 8i, 9i to oracle 10g, 11g and Migration of oracle database from red hat Linux, Window platform to Linux on development, integration and production environment
• Experience in full life cycle of database administration. Worked both as a Development and Production Support DBA on a 24x7 Basis. Willing to work beyond regular hours.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Experience in Installation, upgrades, patches, SR support. Duties included database creation, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and recovery. Logical backup using and full/ partial export/import and Data Pump.
• Experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Efficient in SQL query optimization and instance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, Running scripts.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Experience in maintaining and monitoring databases By Oracle Enterprise Manager (OEM).
• Design and Implement Database security, schema management, Back-up, Restore, Scheduling and Maintenance task in SQL SERVER.
• Experience with FTP,SFTP,PSFTP,SCP files on cross platform
• Experience with OEM agent and GRID control Installation and configuration.
• Working knowledge of DATAWAREHOUSING tools like ETL (Extraction, Transformation and Loading).
• Experience in VM Ware Oracle Server administration, installation.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team.

TECHNICAL SKILLS

OPERATING SYSTEM: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows NT/2000/2003.

DBMS: ORACLE 8i/9i/10g/11g, SQL SERVER, MS ACCESS

TOOLS: Oracle Migration Workbench, SQL-Navigator, OEM, Power Designer, ERWin, TOAD, SQL* Loader, Crystal Reports, RMAN

LANGUAGES: SQL, PL/SQL, UNIX Shell scripting, C

ETL: SQL Server Integration Services(SSIS)

PROFESSIONAL EXPERIENCE

Confidential, STAMFORD, CT

ORACLE DBA

Responsibilities:

• Responsible for support of global Oracle Databases of sizes ranging from 100 GB to 4 TB, for 25 applications, used by global users in different countries.
• Responsible for design, installation, administration, capacity planning, upgrade, security, management, performance tuning, backup & recovery, patch management, shell scripting, 24/7 technical support of Oracle 11g, 10g databases, on Development, Test, QA and Production environments.
• Part of database support team, providing 24/7 support for Production database. Responsible for timely resolution of tickets and support of 1500 users.
• Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, RMAN.
• Configured deployed and administered 4 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 4.0
• Assisted developers in application performance tuning by using Explain Plan, ADDM and AWR reports.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Managed & monitored the Database space requirements.
• Created tablespaces, schema objects and stored procedures.
• Participated in migrating Oracle database server from 10g to 10g in Solaris 10 Environment to RHEL Environment and then Participated in upgrading Oracle database server from 10g to 11g.
• Debug database backup script, and other Monitoring script
• Maintaining processes that load Traders data from web application (XML, HTTP) to Oracle database.
• Basic worked on Java to support Java application connected with the db.

Environment: Oracle 10G, Solaris 10, Linux, SQL, PL-SQL, Stream

Confidential, CHERRY HILL, NJ

ORACLE DBA

Responsibilities:

• Installed and configured 4 node server side load balancing Oracle RAC 10g, 11g databases on Linux.
• Production support database on 9i, 10g and 11g versions with standalone and RAC environment.
• Supported database platform are Solaris 10, RHEL and Window.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Upgraded databases from 9i to 10g, 11g and 10g to different 10g versions.
• Migrated databases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment
• Worked on Auditing and security with Oracle databases.
• Worked with Functions, Procedure, triggers, synonyms and profiles.
• Worked with Flash Recovery Area.
• Created and Managed user, Indexes, table spaces, datafiles and archive log
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Worked on Clone the databases.
• Worked on oracle Public and Private Database Link.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Transported tablespaces and data exports from production and staging databases.
• Applied client patches and other patches as required.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Working knowledge of DATAWAREHOUSING tools like ETL
• Experienced with all standard request tools.
• UNIX Shell scripting for backup and monitoring of databases.

Environment: Oracle 10G, Oracle 11G, Solaris 10, Linux, RMAN, SQL, PL-SQL.

Confidential, PACIFIC PLSDS, CA

ORACLE DBA

Responsibilities:

• Installation and configuration of Oracle Database Software 10g.
• Creation and configuration of Oracle database.
• Migration of database (from 9.2.0.5 to 10.2.0.1) on SUN Solaris 2.7.
• Installed and Configured RAC on Red Hat Linux Advanced Server with 4 nodes.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Production support of Databases on HP-UNIX.
• Worked on FTP, ZIP files on cross platform.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration
• Designed and Implemented database security using Oracle roles and privileges.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• UNIX Shell scripting for backup and monitoring of databases.

Environment: Oracle 10g/9i, SUN Solaris 2.7, Red Hat Linux, Hp-Unix, Windows 2000/2003, TOAD, OLTP, RMAN.

Confidential, SCOTTSDALE, AZ

ORACLE DBA/DATA ANALYST

Responsibilities:

• Installation, configuration and troubleshooting of Oracle Database Software 9i and 10g on RHEL 3.0 and 4.0 environment and RAC setup with ASM.
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Worked on backup, recovery and disaster recovery strategy using RMAN.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL performance tuning and korn shells, Unix shell Scripting.
• Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
• Worked on logical backup using and full/ partial export/import and Data Pump.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server.
• 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.
• Tuned Production database performances and instrumental in SQL tuning that improved application response and supported the Production DBA Team and analyzed each project in the production environment.
• Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle 10g.
• Developed and maintained logical schema, physical records and SQL queries for Oracle applications 9i databases.

Environment: Oracle 9i, HP-UNIX, Sql-Loader, UNIX Shell Programming, SQL, PL-SQL, Stored Procedures, Functions and Triggers, TOAD

Confidential, FORT LAUDERDALE, FL

ORACLE DBA

Responsibilities:

• Installation and configuration of Oracle Database Software 9i.
• Creation and configuration of database.
• 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.
• Upgrading database from Oracle version 8i to 9i and migration of data.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL and PL/SQL.
• Worked with UNIX scripts for monitoring and backup of the database.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Identifying issues/ bottlenecks that could potentially cause issues, involving the right teams (such as server admins or application developers) and take a corrective action to rectify the issues.
• Written extensively UNIX Shell Scripts
• Performance tuning for Oracle Day-to-day maintenance and management of the different databases in development, test and production environments.

Environment: ORACLE 9i, AIX 4.3, OEM, RMAN, Tkprof, PL/SQL, UNIX