SUMMARY

• Around 7 years of experience on Oracle (8i/9i/10g/11g) database administration, schema implementation, tuning, backup, recovery, and performance monitoring
• Experience maintaining large production, testing & development environments.
• Experienced with Database Security Administration, system monitoring including adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Experience providing 24x7 production support, troubleshooting / resolving various types of production issues.
• Expertise setting up Replication for Oracle 9i/10g Production databases
• Expertise installing, configuring and maintaining Oracle high availability solutions like Real Application Cluster (RAC) on Oracle 9i & 10g both on Windows and Linux platforms.
• Experienced performing manual recovery using archived logs, RMAN - managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Experienced in Migration and Upgrade of Oracle 8i to 9i, and Oracle 9i to 10g.
• Experienced setting up Data guard for Disaster recovery on Oracle 9i & 10g Production databases.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control.
• Experienced in Database Performance Troubleshoot using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
• Proficient Installing, Configuring, Tuning and Maintaining Oracle 8i/9i/10g/11g under Windows 32/64 bit, Sun Solaris, HP, Unix, IBM AIX and Red Hat Linux platforms.
• Proficient with Tuning, SGA, Buffer Cache, Rollback Segments, and Redo Mechanisms
• Monitored and Detected Alert Log Files, Listener Log, Redo Log status, trace files and Locks for the database.
• Expertise in database and Application performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK and SQL Tuning.
• Used Repository manager to build Repository, User groups, Users and managed users by setting up their privileges and profiles.
• Automated database periodic maintenance and activities using Shell Scripts.
• Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Informatica.
• Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Extensive experience in Migration of SQL Server to Oracle10g.
• Assisted in designing conceptual, Logical and physical data models using Erwin.
• Experienced managing Very Large Scale Databases (VLSD).
• Experience reviewing and documenting system test plans, creation and execution of test cases
• Excellent communication skills, with strong troubleshooting, and problem solving ability

TECHNICAL SKILLS

Database Analysis/Design: Professional database analysis and design based on the normalization rules, Oracle 8i, 9i 10g & 11g database, SQL Server database.

Operating System: LINUX, HP-UX, AIX, Sun Solaris, Windows NT, Windows 95/98/2000/2003, Windows XP, Windows professional 2000.

Database Tools: OEM, Export-Import utilities, SQL* Loader, Recovery Manager (RMAN)

Third Party Tools: ERWIN, TOAD,Smart FTP, Humming Bird, Exceed, F-secure, Putty, fog light, SQL Back-track, Informatica, Dataflux, Data Stage.

Languages: PL/SQL, SQL, UNIX Shell scripting, C and C++.

PROFESSIONAL EXPERIENCE

Confidential, NEWARK, NJ

Oracle DBA

Responsibilities:

• Designed, developed and maintained databases required for development, testing and production servers
• Responsible for the physical database design and new users as required.
• Responsible for capacity planning, database security, recovery planning and installing patch’ Confidential
• Developed UNIX shell scripts for automation of administrative activities, and warning notifications to continuously monitor the database.
• Installed, configured and maintained Oracle 10g and 2 Real Application Cluster (RAC) nodes
• Configured listener and local service names for load balancing, failover, dynamic service registration, and multi threaded architecture for RAC
• Monitored and recovered RAC for high availability and scalability.
• Added new nodes and removed existing RAC nodes as needed.
• Cloning of production database to the test environment using Recovery Manager (RMAN), Datapump with oracle stream technology.
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Worked with backup teams in configuring and implementing backup strategies using RMAN
• Performed automation including Backups, exports & imports, and archiving old records
• Periodic trimming of Oracle system log files and removal of old redo log archives
• Designed and delivered technical presentations on Oracle database operations
• Gathering of cost-based optimizer statistics for tables with stale statistics
• Performed stress test for new database installations
• Gathered performance tuning metrics for both operating system and database
• Installed patch sets on Oracle database binaries that lacked installation programs
• Developed indexes on major database tables for keywords
• Documented Oracle database operations and training manual for backup personnel.

Environment: Oracle 10g/RAC, RMAN, Sun Solaris 10, TOAD, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF

Confidential, Miami, FL

Oracle and MS SQL Servers Database Administration/Support

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux.
• Installed and Configured MS SQL Server 2005 on Windows 2003.
• Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles, groups and granting access permissions to the database.
• Monitored data transfer between the Database servers using DataStage, Oracle Streams/CDC, SQL*Loader, MS SQL Log shipping and DTS packages.
• Upgraded Oracle databases from 9i to 10g.
• Upgraded MS SQL Servers from v .
• Migrated data from MS SQL Servers to Oracle, and vice versa.
• Implemented Oracle Database 10g two node Real Application Cluster (RAC) on a Linux system
• Installed and configured Oracle Enterprise Manager 10g Grid Control.
• Created Oracle Standby databases using DataGuard.
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.

Environment: Red Hat Enterprise Linux 9.0, AIX 5.2, Windows 2003, VERITAS, Oracle 9i/10g and MS SQL Server 200/2003, DataStage.

Confidential, Delray Beach, FL

Oracle Server Sr. DBA/Development/Support

Responsibilities:

• Responsible for Physical database design and development, and backup & recovery
• Performed root cause analysis on database system architecture, and automated database maintenance process
• Involved in reverse engineering existing database during data modeling using Erwin
• Good Understanding of SUN Solaris, VERITAS Volume Manager, and Quick I/O files.
• Performed Data Migration and Replication using Infopump, Informatica and SQL*Loader.
• Performed Disk layout, partition and configuration using Veritas Volume Manager and NT Disk admin utilities.
• Performed Disaster Recovery for all critical database servers.
• Installed and Configured Oracle 9i nodes Real Application Cluster (RAC) on Solaris
• Maintained database - Month end, Quarter end and Year-end reports
• Installed Sybase 12, MS SQL and Oracle databases on various machines for the internal development purpose.

Environment: Oracle 9i, Sybase 12, Sun Solaris 9, Windows 2003, Informatica v7.3, Erwin

Confidential

Developer / DBA

Responsibilities:

• Involved in Oracle 9i Real Application Clusters and patch Installations.
• Oracle 9i RAC Database development on two node cluster.
• Creation & Maintenance of 20 Single Instance and 5 RAC Databases in Development, Test and Production servers.
• Design and development of Database Objects and Users as per the business needs
• Configured and tested Transparent Application failover (TAF) and Load Balancing
• Configured RMAN for database backup to tapes using IBM Tivoli Interface.
• Configured Data guard for Disaster Recovery Site Replication.
• Configured IBM Flashcopy for Database hot backup.
• Designed Logical and physical data models using Erwin Data Modeling Tool.
• Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backup’ Confidential
• Developed PL/SQL Packages to monitor earnings and expenses, for maintaining the general ledger of the organization.
• Maintained control files, log file, data files, table spaces and rollback segments.
• Developed stored procedures and functions using PL/SQL for complex updates.
• Designed Entity-Relationship model and normalized database.
• Performed Database Tuning using statspack and SQL trace utility.
• Scheduled cron jobs and database updates for reports generation, statistics collection and database backups.

Environment: IBM AIX 5.X, Oracle 9i RAC, IBM Tivoli, Data Guard, Erwin 4.2

Confidential

Oracle Developer

Responsibilities:

• Performed Database upgrade of Oracle 9i from existing oracle 8i system
• Involved in analysis of market risk and claims data.
• Worked closely with DBA to understand the business and technical requirements
• Developed entity relationship, data flow and functional diagrams
• Designed database tables, implementing referential integrity.
• Developed triggers which internally called procedures and functions
• Performed complex SQL query tuning, index reorganization, and Rollback
• Developed oracle forms and reports using oracle designer 2000
• Involved in all phases of the software development life cycle
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.
• Designed appropriate backup and recovery procedures to meet the business requirements.
• Involved in documenting the entire system architecture and data flow

Environment: Windows 98/NT / 2000, HP-UX, Oracle 9i/8i/7, TOAD, Database Tools/Utilities, Perl