SUMMARY

• An Oracle Certified Professional Database Administrator, with over 7 years of experience in Database administration, analysis, design, development, testing, in Client - Server environment.
• Experience inconfiguration, maintenance and support in Oracle 11i/10g/9i/8i Database Administration.
• Worked extensively on PL/SQL, SQL* Loader, RMAN, Oracle Enterprise Management tools (OEM), Data Guard.
• Used Data Pump Export and Import to move data between Oracle databases.
• Database Performance Tuning using AWR, Explain Plan, SQL TRACE, STATSPACK and different OEM utilities and SQL Tuning
• Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Data Guard).
• Configured Logical and Physical Database design in 10g & 11Gg.
• Worked on database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Successfully migrated Oracle database from 9i to 10g and 10.1 to 10.2 by using Oracle Scripts, export & Import utilities and copied data from an earlier version of Oracle to Oracle 10g.
• Excellent noledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods.
• Experience in trouble shooting RMAN issues in performing teh Backup and Recovery process.
• Evaluate Oracle features & related product’s, setup and maintain documentations and standards.
• Performed Database Refreshes. Written shell scripts to enable general users to startup, shutdown databases, automate export, backups.
• Experience on Data guard configuration for disaster recovery.
• Good experience in Oracle Streams, Gloden Gate.
• Evaluate Oracle features & related product’s, setup and maintain documentations and standards
• Well versed with client server environment & tools like SQL*LOADER. Toad, Oracle Sql Developer.
• Planning hot and cold backup strategies. Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Good experience on Oracle Support processes for technical requests through Metalink and other Support Procedures
• Good Understanding of IMS and Data guard infrastructure.

TECHNICAL SKILLS

Oracle: 8i,8.1.7,9i, 10g,11g, SQL Server 2008/2005/2000

Tools/Utilities: ERWIN, ETL Tools, Toad, Formatter Plus, PLSQL Developer and SQL Tools.

Operating System: UNIX (HP-UX, IBM AIX, Sun Solaris), Red Hat Linux, Oracle Enterprise Linux, and Windows

Reporting Tools: Business Objects 5.X/6.X/R2, Web Intelligence 2.X, Reports 2.5

Oracle Tools: Oracle Enterprise Manager, Grid Control, StatsPack, AWR, ADDM, Export/Import, Data Pump, RMAN, Toad, SQL Navigator,Quest Spotlight, BMC Patrol,, Veritas NetBackup, IBM TSM, Peoplesoft etc.

Languages: SQL, PL/SQL, Shell Script, Java, C, C++

Replication: Oracle Transactional Replication with Gloden Gate Replicator, Oracle Streams, Shareplex

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Oracle DBA

Responsibilities:

• Installing, upgrading and maintaining Oracle RDBMS on Linux & Windows platforms.
• Created instances and databases with appropriate initialization parameters and database structures (i.e., data files, rollback segments, table spaces, etc.)
• Experience in 11gR2 Real Application Clusters (RAC) Installation, Configuration, and Administration with Oracle file system.
• Reviewing and monitor system and instance resources to insure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention).
• Involved in RAC administration including cloning, tuning, patching and monitoring etc.
• Installation & Configuration of Standby Database for faster Disaster Recovery
• Expertise on moving, rebuilding and changing database objects as required in production
• Developed & managed naming standards for database objects such as table spaces, tables, indexes & views according to application requirement and organization policies.
• Implemented schema replication using Oracle streams.
• Configuration, Modeling, Administration and tuning of Gloden Gate.
• Monitor Gloden Gate processes and GG cleanup scripts function properly
• Configured and managed Physical standby databases.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Applying patches and works closely with Oracle to make Application environment Up to date.
• Typically involved in database designing, creation and maintenance.
• Good working noledge of SQL, PL/SQL, and shell scripting.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ADDM, and Grid Monitoring
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS JOBS to monitor teh database performance and for user management.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Experience on migrating Sql server database to Oracle 10gdatabase.
• Involved in creating Tables, Indexes, Triggers, Sequences, Procedures and Packages.
• Responsible for setting and managing user accounts, Granting required privileges to users, Auditing Users.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required
• Provided System support for both development and 24*7 production environments.

Environment: Oracle 11g,10g &9i, Oracle 10g Rac with ASM, Red Hat Linux, SOLARIS 9/10, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Data pump, STATSPACK.

Confidential, NYC NY

Oracle DBA

Responsibilities:

• Analyzed requirements and prepared system flows, specifications, and database designs.
• Implemented and maintained database through DBA activities include database backup (Cold, Hot, Import/Export), database recovery, tuning, installation, database creation, logical and physical databases design.
• Creation of application users, responsibilities and granting privileges to them.
• Supporting, monitoring & tuning teh database subsystems & instance.
• Worked on starting and stopping teh instances, listeners and intelligent agents.
• Participate in selecting database management support tools
• Developing & implementing database administration policies & procedures including subsystem or instance security guidelines
• Monitoring database performance and tuning .
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Experienced in using utilities like Export/Import and SQL Loader.
• Developed PL/SQL packages, procedures, functions and triggers.
• Coordinated with other team members in establishing tasks and deadlines.
• Provided 24*7 System support.

Environment: Oracle 10g,9i and Oracle 10g RAC, Sun Solaris, UNIX, SQL*Loader, PL/SQL, SQL, TOAD, SQL*PLUS.

Confidential

Oracle DBA

Responsibilities:

• Installed, configured and upgraded Oracle server software and related products.
• Deciding teh location of data, index, rollback, redo log and control files on teh disks.
• Creating, checking, extending table space. Administered database security, created users, granted/revoked roles, privileges, extended databases storage capacity.
• Monitored and reduced database fragmentation, managed data files, rollback segments, extents, segments, re-indexing, monitor storage, backup & restore/recover database, export/import database objects.
• Extensively used SQL Loader to load data from flat files to teh Oracle Database.
• Knowledge of data warehousing methodologies and techniques using star schemas, caching Techniques, DB loads, indexing, Physical and Logical data modeling etc
• Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation. Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and Separating of tables and indexes on different locations.
• Reduced Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization.
• Wrote shell scripts to automate teh processes.
• Developed back-end routines using Oracle SQL, PLSQL, Stored procedures, Packages, Triggers.
• Identified common functionalities, implemented them using PL/SQL, Stored procedures, Packages, Triggers, form Libraries.
• Maintained Integrity and Security, Schema Design, Created & Managed users, roles, permissions, schema objects such as tables, views, snapshots, indexes etc

Environment: Oracle 9i/10g, SUN SOLARIS 8, Import/Export, SQL* LOADER, STATSPACK, EXPLAIN PLAN, TKPROF, SQL, PL/SQL, TOAD, Windows 2000, Shell Scripts, Cron Scripts.

Confidential

Jr.Oracle DBA

Responsibilities:

• Installation and tuning of oracle 8i/9i database and testing on Sun 450 and Windows 2000.
• Successfully built and administered teh production and development application infrastructure.
• Consistently optimize database performance, troubleshooting user problems and upgrading teh environment periodically with new software releases.
• Planned for contingencies, security, risk assessment and standard operating procedures for mission critical systems.
• Coordinated database setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Developed automated functions and processes.
• Creating users, assigning roles, privileges for applications .
• Firing of database job stored procedures, functions, packages and UNIX scripts (Cron jobs).

Environment: Oracle 8i/9i, Siebel, SUN 450/E10K, Windows 2000, Toad, SqlServer2000, Perl Scripting