Summary

• Around 4 years of experience with Oracle Database Administration such as Database Installation, Upgrade, Maintenance and support of Oracle Database Server on UNIX flavors (Linux, Solaris, and AIX).
• Extensive experience in Writing Shell scripts (Korn, Bash)
• Experience in upgrading database from 9i to 10g and 11gR1/R2.
• Experience in using Oracle 10g Flashback database/drop/table features.
• Audited databases for statements, DMLs, privileges, and schema objects.
• Experience in creation and maintenance of standby databases using DATAGUARD.
• Good experience Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Excellent expertise in Data Loading Techniques using SQL* Loader, PL-SQL Collection.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Worked on export/import, data pump and SQL- loader, cross platform transportable tablespaces.
• Proficient in Oracle DBA activities including installation, migration, configuration, backup, recovery, tuning, design of oracle databases.
• Replicated databases from multiple sources to multiple destinations using Oracle Schema and Table level Streams.
• Handling day-to-day DBA activities using Oracle utilities and tools, Checking Alert Logs, Archive logs, Trace files and backup verifications.
• Created user assigned Profiles-Resource limits, maintained Security with Roles/Privileges granting and revoking upon requirements.
• Refresh test and development databases with production data on a regular basis OR as and when required by the development and testing teams and database cloning.
• Extensive working knowledge of Database Objects like Views, Materialized views, Stored Procedure, Triggers, Cursors, Procedures & Packages.
• Good working knowledge of SQL, PL/SQL, and shell scripting.
• Supported the system 24x7. Ability to work beyond regular hours.
• Proficient and prompt in learning and adapting to new technologies.
• Excellent interpersonal communication clubbed with good analytical, logical and problem solving techniques, Rapid-learning ability with aptitude for challenging tasks, ability to work collaboratively and commitment to achieving corporate goals.
• Strong priority setting skills with demonstrated ability to manage multiple assignments simultaneously.

TECHNICAL SKILLS

Operating Systems : Window Advance Server, HP-UX, AIX, Redhat Linux.
Programming Languages: SQL, PL/SQL, SQL Tuning, Java, shell
Databases System : Oracle 11g/10g/9i.
Database Tools : Golden Gate, Physical/Logical Standby Database using Oracle’s Data Guard, SQL*Loader, ASM, RMAN, Streams, data pump exp/imp, crontab, Materialized Views.
Documentation Tools : MS Word 2000, MS Excel 2000, Power point.

PROFESSIONAL EXPERIENCE

Confidential - Vernon Hills, IL Jan 2011-Sep 2012
Confidential, headquartered inVernon Hills, Illinois, is a leading provider of technology products and services for business, government and education. The project involves working with DBA team of 6 administrating around 100+ databases. Daily task including checking health of instances, cloning, refreshing, executing scripts, troubleshooting backup errors and coordinating with development team.
Role: Oracle Database Administrator
Responsibilities:

• Installed and Monitored the Oracle database on 10g and 11gR2 in RHEL 5.
• Extensive performance tuning, specialized in performance tuning, Operating System tuning, database/instance tuning.
• Install and configured Golden gate for replication.
• Applied patches in various environments and upgraded database from pi to 10g and then to 11g.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Used Oracle 10g Flashback database/drop/table features.
• Worked on import/export and datapump export/import.
• Creating and managing table spaces, tables, indexes, users, etc
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Working and monitoring tickets assigned to DBA group in remedy.
• Troubleshooting and solving complex problems working with Oracle support.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Cloning the production databases to development and QA for various testing teams.
• Upgrade and Migration of Database in 11g and applying patches whenever required.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Security Administration including the management of profiles, roles, users and their privileges.
• Data refresh in Test and Development using Data Pump import/export and cross platform transportable table spaces.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• General database administration including the management of instances, redo logs, temp space, rollback and schema management.
• Implemented Backup & Recovery procedures using RMAN. Implemented Hot, Cold and Logical backup plans.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Designed and implemented of backup strategy for the production databases using RMAN BACKUP with input and output storage.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Experience with Oracle partitioning and table partitioning.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: Oracle 10g/11g RAC, SQL plus, RMAN, Import/Export Data pump and Linux, Oracle Streams, Dataguard, partitioning, upgrades, patching, AWR report, Golden Gate.

Confidential, NJ Jan 2010 to Dec 2010
Confidential, is amobile network operatorthat offers wireless voice, messaging and data products and services to customers in the United States. The duties include checking tablespaces for space requirements, reviewing tuning opportunities, security policy violations, checking logs for errors, archive all alert log to history.
Oracle DBA
Responsibilities:

• Installation, configuration and maintenance of oracle 10g on AIX.
• Creation of roles and profiles to secure the database from illegal access.
• Created Users and Granting/revoking the privileges to/from the Users.
• Applying upgrade patches, maintenance and interim patches on databases.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Develops and executes a backup / disaster recovery plan for all databases and performance tuning of the database as and when required.
• Good experience Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Supported testing team in the process of testing business requirements developed in house or from outside.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Implemented backup/recovery procedures using RMAN, Data Pump, performed database recoveries.
• Created Procedures, Functions, Packages and database Triggers using PL/SQL and monitored the Tables and Indexes growth
• Replicated databases from multiple sources to multiple destinations using Oracle Schema and Table level Streams.
• Handling day-to-day DBA activities using Oracle utilities and tools, Checking Alert Logs, Archive logs, Trace files and backup verifications.

Environment: Oracle 10g/11g, AIX, UNIX Shell Scripting, RMAN, Export/Import using Data pump, Data guard, Replication using streams.

Confidential, Hyderabad, India Jan 2009 to Dec2009
Confidential is asoftware companythat provided a web-based platform for realtime,rich-mediacollaboration and meetings. Confidential provided free web conferencing service where users could share desktops, show slides, collaborate, chat, talk and broadcast via webcam.It has been compared to theWebEx2.0 web conferencing application.
Jr. DBA
Responsibilities:

• Migration of databases from Oracle 9.2.0.8 to Oracle 10.2.0.2. on Linux.
• Configured Standby database for production and reporting.
• Developed strategies for database backup and recovery using RMAN utility.
• Created and Scheduled daily backup and recovery scripts through Cron jobs.
• Used exp/imp utility and Sql loader for transformation of data.
• Created Users, Roles and Profiles and Granting/revoking the privileges to the Users.
• Created Procedures, Functions, Packages and database Triggers using PL/SQL and monitored the Tables and Indexes growth.
• Creation of roles and profiles to secure the database from illegal access.
• Responsible for creation of tablespaces, and management of storage space.
• Coordinated with the developers in process of developing any business requirement.
• Executed Scripts provided by development team.
• Write pl/sql quires as required.

Environment: Oracle 9i/10g, Linux, RMAN, TOAD, OEM, GRID CONTROL, Data guard, Cron tab, exp/imp data pump.

EDUCATION:

• Bachelors of Technology (Computer Science)

Certification: Oracle Certified Professional Database Administrator (OCPDBA)