PROFESSIONAL SUMMARY

• Over Ten years of experience in Oracle Database Administration. Experience in Data Modeling, Design, and Testing & Production support
• Managed Installation, Configuration and Administration of Oracle 9i/10g/11g Databases.
• Created database, database objects like table, index, DB Link, table space, rollback segments, and views and analyze relevant objects to collect statistics to tune the system performance.
• Tested and Implemented different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import using Data pump, imp/exp utility (command line as well as interactive mode), Toad.
• Defined backup procedures, alert checking, and Remote archive copying, monitoring and tuning database using CRON jobs.
• Backup and recovery using RMAN, Netbackup, automated backup and recovery using scripts.
• Tuned application with EXPLAIN PLAN and TKPROF, analyzing database objects, maintaining the security of the databases.
• Participated in the development and testing of backup and restore strategies for development and production system.
• Applied Oracle Software patches whenever required.
• Worked on Database Sizing, Rollback Segments and Queries. Performed STATSPACK tuning.
• Created and maintained UNIX scripts for Oracle maintenance and statistics.
• Altered, modified, Partitioned, dropped, created database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM (Oracle Enterprise Manager).
• Implemented multiplexing of control files and redo - logs for disaster recovery scenario.
• Monitored Rollback segments and its Space management.
• Installed, configured and administered Data Guard Environment, creating clone databases.
• Developed the scripts for creating the Users and allocation of rolls to the users and maintaining system security.
• Checked Alert files and Trace files regularly.
• Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, patch runs, monitoring, performance tuning, restructuring of databases, trouble shooting.
• Good knowledge in design, development and testing of backup and recovery to ensure complete recoverability.
• Skilled in logical and physical database design. Experienced in logical data modeling including business rules.
• Highly skilled in disaster recovery, routine maintenance for Oracle databases.
• Experienced in advanced replication, & one physical standby database using Data Guard.
• Oracle Data Dictionary and Tunable init.ora parameters.
• Database migration from 9i & 10g to 11g using FTP for file transfer, SQL Loader, Toad export feature.
• Wrote UNIX K-Shell scripts for hot backups, SQL Loads, export and import of database.
• Strong knowledge of Oracle 10g. Perform Database Sizing, Object Sizing and planning adhering to Oracle OFA.
• Perform Daily Monitoring of Oracle Instances using Oracle Enterprise Manager, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Excellent interpersonal and strong analytical, problem-solving and conceptual skills.
• An Oracle DBA with rich experience maintaining Databases of different sizes and voluminous transactions on 24/7 basis
• Create databases on a four (4) nodes RAC that uses automatic storage management (ASM)
• Added disk to disk groups in ASM Drop disk group from the ASM storage
• Did a rolling patch on a four (4) nodes RAC
• Upgrade database on a RAC environment from 9i to 10g
• Migrate databases from sun server to RAC environment on Linux (RHEL)

TECHNICAL SKILLS

Operating Systems: Windows NT/2003, Sun-Solaris, HP UNIX, AIX, Linux Redhat

Databases: Oracle 8.x/9.x/10g, Ms- Access, SQL-Server

Tools & Utilities: RMAN, Quest.com, Oracle Enterprise Manager.ASM, RAC

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Oracle/APPS DBA

Roles and Responsibilities:

• Perform production activities 24 x 7 support as on call member of a DBA team.
• Implement and maintain database security (create, and maintain users and roles, assign privileges)
• Good troubleshooting abilities, good understanding of oracle application, knowledge of managing distributed architectures, good knowledge of windows environment and supported software databases.
• Control of database operating environment, including allocation of space for users, tuning shared memory parameters and maintainance of logical and physical logs.
• Reviews and implement application builds, releases into production, Training and pre-production environment.
• Experience in oracle 11.5.10.2 E-Business suite application and 10G Release 2, 11gR1 database version.
• Experience in patching, installs, upgrade and perform standard database operations including export, table restoration and re organisations appropriate for support level.
• Experience using monitoring tools such as Grid Control/foglight to monitor the databases/applications.
• Creating and managing standby database.
• Experience with backup and Recovery strategies (RMAN, cold backups, hot backups exports, datapumps) Dataguard.
• Experience with BEA web logic, Java, J2EE.
• RAC, ASMCreate databases on a four (4) nodes RAC that uses automatic storage management (ASM)
• Added disk to disk groups in ASMDrop disk group from the ASM storage
• Did a rolling patch on a four (4) nodes RAC
• Upgrade database on a RAC environment from 9i to 10g
• Migrate databases from sun server to RAC environment on Linux (RHEL)

Environment: Oracle 9i/10g/11g, E - Business suite, 11i application, OEM (grid control) STIP application, Data guard, web logic, windows, TOAD, SQL - LOADER, PL/SQL.RAC, ASM.

Confidential, MN

Oracle DBA

Roles and Responsibilities:

• Configured Oracle servers, Installed Oracle on the server and clients
• Upgraded Oracle server as well as client from 9.2.0.1 to 9.2.0.6 and oracle 9.2.0.6 to 10.2.0.1 with proper patches, PL/SQL
• Installed and configured I-many applications on clients.
• Enforced Database Security by Managing user privileges and efficient resource management by assigning profiles to user domains. Data partitioning to improve i/o access, availability.
• Monitoring Memory, CPU utilization using VMSTAT,IOSTAT, SAR
• Performing Database Refreshes for testing and development, cold and hot backups and also used Recovery Manager (RMAN) utility to back up, restore, and recover data files, control files, and archived logs.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis
• Developed shell scripts and PL/SQL procedures and scheduled Cron Jobs and DBMS SCHEDULER to monitor the database performance and for user management.
• Monitoring and tuning of the database performance using STATSPACK, Explain Plan and TKPROF.
• Optimized tuning of user sessions and system level performance using SQL TRACE and gathered statistics using DBMS STAT.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.

Environment: Oracle 10g/9i, VERITAS, Windows 2003, OEM, Toad, Korn shell, Medicaid, Reporting and CARS Connector Applications, SQL Server 2008, RAC, ASM.

Confidential, Chanhassen, MN

Oracle DBA

Roles and Responsibilities:

• Configured Oracle servers and optimized initialization parameters in INIT.ORA (DB Block Size, DB Block Buffers, Shared Pool Size, and Sort Area Size) and adjustment of OS Kernel parameters.
• Diagnosed and tuned databases for performance problems and lock conflicts using monitoring and diagnostic tools, shell scripts and dynamic performance V$ views.
• Refreshed development and test databases from production database using Exp/Imp to provide the latest data is available in the development/test database for the developers.
• Executed file system, server based (RMAN) backups and logical (exp) backups. Executed complete and incomplete media recovery procedures (Time/Change/Cancel-based).
• Installed, configured and administered Standby Database. Cloned databases for testing.
• Loaded data from flat files to Oracle databases and migrated from older Oracle versions.
• Managed Users access control and security by creating appropriate roles and profiles.
• Implemented and configured Oracle Net and resolved connectivity issues.
• Contributed in Database Installations.
• Database Recreations, Restoration Space Management
• Moving the database on the network 24 x 7 support on pager call duty,
• Troubleshooting and Problem resolution Exports/ Imports,
• Hot and Cold Backups AIX shell scripting for automation of import/export, cloning, backups.
• Tuning Memory, SGA, I/OSecurity Management, Oracle Streams
• Objects sizing Strategizing Backups including usage of RMAN Database Recovery, Involvement in Database Migrations, Snapshots creations, Strategizing and troubleshooting.

Environment: Oracle 9i, 10g, VERITAS, AIX, Linux, Brightstor, Autoloader, OEM, Toad, Netbackup

Confidential, Columbus, GA

Oracle DBA

Roles and Responsibilities:

• Installation, configuration and Upgrading Oracle 8i to Oracle 9i from one server to another with minimum down time and applied patch set on development & production server.
• Setup the advanced replication for a single master site & a snapshot site in development & production.
• Perform Daily monitoring of instances by database auditing, alert log and trace file checking and automatic script scheduling.
• Set up OMS & configured RMAN for backup & recovery of existing instances on development & production servers.
• Applied Oracle Software patches when required.
• Planned and implemented archival, backup / recovery of databases.
• Export and Import of databases from one database to another database.
• Fine tuned the memory & init.ora parameters for databases.
• Performed application, SQL, and database instance tuning using a wide range of technologies including Statspack, SQL Trace (Event 10046 trace files), OEM Performance Manager, and custom scripts.
• Implemented 9i new features like Undo tablespace management, reusable space management features.
• Create databases on a four (4) nodes RAC that uses automatic storage management (ASM)
• Added disk to disk groups in ASM
• Drop disk group from the ASM storage
• Did a rolling patch on a four (4) nodes RAC
• Upgrade database on a RAC environment from 9i to 10g
• Migrate databases from sun server to RAC environment on Linux (RHEL

Environment: Oracle 8i/9i, Windows, AIX, Designer Flavors, Developer2000, Standby, Replication, Windows, 3Tier Architecture, VERITAS HA Cluster, Oracle Warehouse Builder, EMC Timefinder, RAC, ASM

Confidential, TN

Oracle DBA

Roles and Responsibilities:

• Installed database in Sun Solaris on staging server.
• Tuned database parameters and applications for optimal performance.
• Responsible for support of the databases and database servers which includes performance monitoring, performance tuning, optimize programming code/ SQL, troubleshooting and client support.
• Actively involved in archival, backup / recovery, import / export (SQL Loader) of relevant data.
• Used Toad and SQL Plus for executing PL/SQL procedures, packages for business.
• Wrote shell scripts to backup, restore database and automate daily activities.
• Installed Oracle RAC with Data Guard implementation for disaster recovery.
• Used Erwin for physical data model design.
• Database Design, Backup & Recovery,
• Tuning the Database and Analyzing the Database,
• Coding PL/SQL & Shell Scripts,
• Database Design, Database Maintenance,
• Software design of medium/large business applications

Environment: Oracle 9.x, HP-UX, Shell Scripts, SQL-Loader

Confidential, Memphis, TN

Oracle DBA

Roles and Responsibilities:

• Managed Installation, Configuration and Administration of Oracle 8i/9i Databases.
• Created database, database objects like table, index, DB Link, table space, rollback segments, and views and analyze relevant objects to collect statistics to tune the system performance.
• Tested and Implemented different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import.
• Tuned application with EXPLAIN PLAN and TKPROF, analyzing database objects, maintaining the security of the databases.
• Participated in the development and testing of backup and restore strategies for development and production system.
• Worked on Database Sizing, Rollback Segments and Queries. Performed STATSPACK tuning.
• Created and maintained UNIX scripts for Oracle maintenance and statistics.
• Altered, modified, Partitioned, dropped, created database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM (Oracle Enterprise Manager).
• Implemented multiplexing of control files and redo-logs for disaster recovery scenario.
• Monitored Rollback segments and its Space management.
• Installed, configured and administered DataGuard Environment.
• Developed the scripts for creating the Users and allocation of rolls to the users and maintaining system security.

Environment: Oracle 8.x, SUN-Solaris, Shell Scripts, DataGuard, Replication, Developer 2000, web servers, discoverer

Confidential, MO

Oracle DBA

Roles and Responsibilities:

• Installed and migrated Oracle Servers on Sun Solaris, Linux and Windows. Created databases, storage structures and database objects.
• Managed databases including space management, Rollback segments and Extents management, tablespaces and datafiles management, monitoring and resizing. Multiplexed control files and redo groups’ members and replicated data using snapshots and db links.
• Performed Performance monitoring and tuning through Alert and Trace logs for problem queries, tuned Shared Pool size, Library Cache, Buffer Cache, used oracle database block size efficiently, optimized sorts operations, monitored tablespace I/O, tuned rollback segments and monitored and detected locks and latch contentions and eliminated the dead locks.
• Installed, configured and maintained hot standby database for high availability. Cloned databases for developers testing. Loaded data SQL*Loader. Executed hot, cold and logical backup and restore procedures. Managed system resources creating user profiles and roles.
• Developed shell scripts to carry out routine checks on databases. This included checking whether all databases are running, listener is up, UNIX error messages, disk space availability, segments nearing max extents, checking regularly the alert logs and trace files for errors.
• Coordinated with database administrators, application developers and support personnel to ensure that applications code and databases were configured for optimal performance.
• Load data using SQL*Loader
• Scripts for Complete and Hot backup, Tuning the database, SGA sizing,
• Give technical guidance to team members.
• Create snapshots, views, remote procedure calls on the remote databases,
• Security Management using roles and privileges,
• Developing stored procedures, packages, functions and database triggers.

Environment: Oracle 9.x, RAC, HP-UX, Shell Scripts, Replication, DataGuard