SUMMARY

• Over 7 years of experience in Oracle Database Administration, Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management Systems for Business solutions which involves Oracle 8i/9i/10g RAC/11g RAC, Grid Control, Data Guard, Data Pump, RMAN, Red Hat Enterprise Linux, Oracle Enterprise Linux, UNIX, HP - UX, Sun Solaris, IBM AIX and Windows.
• Oracle Database Administration on 24x7 critical production and large databases using Oracle 10g,11g,11g RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, Data Guard.
• Proven ability to adapt to demanding schedules and changing priorities.
• Strong experience with project management methodologies.
• Installation, configuration, upgradation and performance tuning of Oracle Databases.
• Database upgrades from Oracle 9i to 10g, Oracle 10g to 11g.
• Database migrations from Sun Solaris to AIX, Windows to Linux.
• Migrated single instance databases to multimodeRAC databases for high availability, Scalability and Load balancing.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Experience in hot/cold backup mechanisms i.e. User managed backups, RMAN backups and Snapshots backups.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Applied critical patches and patch sets whenever required.
• Excellent experience with SQL and PL/SQL (Stored Procedures, Functions, Packages, Cursors and Triggers).
• Excellent experience in Database Performance Monitoring and Tuning using STATPACK, TKPROF, SQL TRACE, Explain Plan, ASH, AWR, ADDM.
• Expertise in maintaining Database Security, Data Integrity and Gathering Statistics.
• Extensive performance tuning experience, specializing in instance tuning, Oracle10g and 11g RAC tuning and SQL optimization.
• Good experience managing OLTP and DSS environments.
• Working knowledge on Business continuance volumesBCV’S, SRDF, and managing of partitions and clustering of tables.
• Extensive experience with designing and implementing Oracle databases, cloning of databases and setting up RAC database and Standby Database in Active mode using Real Time Apply for 100% Availability, Disaster Recovery and Reporting.
• Excellent knowledge in Hot/Cold Backup and Recovery. RMAN incremental backups.
• Cloning of databases using manual method and RMAN
• Migrated Non ASM databases to ASM databases.
• Created Users, Profiles, Passwords and assigning Roles, Grants.
• Extensive experience in developing SQL, PL/SQLStored Procedures, Functions, Packages and Triggers.
• Experience in UNIX shell scripting.
• Created Materialized views for table replication.
• Knowledge of OEM, TOAD, Oracle Grid-Control.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Experience in replication and integration of database objects and Schemas between databases using Oracle Streams, Golden Gate.
• Excellent written and verbal communication skills plus sound judgment and use of initiative.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g RAC/11gRAC, SQL Server, MySQL

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, 11, AIX 5.3.6.1, 7.1 RHEL 4.x, 5.x, 6.x and Windows 95/98/ME/NT/2000/XP/Vista/7.

Languages: SQL, PL/SQL, Unix Shell, Perl, JAVA, Visual Basic, .Net

Hardware/Storage: Sun E4500, Sun E10K, HP9000, RS6000, NetApp, EMC Veritas NetBackup, Tivoli Storage Manager(TSM)

Data Modeling: ERWIN

Tools: RMAN, ASM, OEM/Grid Control, SQL*Loader, SQL Developer, Oracle Streams, Golden Gate, Data Guard, Data Pump, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, Configuration and Maintenance of Oracle RAC, Stand by Databases (Active Data Guard) for High Availability, Disaster Recovery and Reporting.
• Created Physical Standby Databases, Performed SWITCHOVER, FAILOVER.
• Upgraded databases from Oracle 10g to 11g
• Database migrations from Sun Solaris to AIX, Windows to Linux.
• Applied CPU patches.
• Proactive database monitoring using OEM/Grid Control.
• Performed performance monitoring and tuning by using Oracle utilities like SQL TRACE, TKPROF, STATSPACK, Explain Plan, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and used different dynamic performance views for addressing performance bottlenecks.
• SQL SETS, SQL PROFILES for AUTOMATED SQL Tuning.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Export/Import using datapump utility.
• Cloned/Refreshed Oracle Databases for development and testing.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Involved in Logical & Physical database design
• Defining and Implementation of backup and recovery strategies.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented Hot, Cold and Logical backup plans.
• Customization and development of KornShell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using AWR, ADDM reports.
• Code review to ensure that the new customizations were developed within corporate programming standards.
• Oracle Database monitoring, troubleshoot and resolve the issues.

Environment: Oracle 10g RAC, Oracle 11g RAC, RMAN, ASM, OEM/Grid Control, SQL, PL/SQL, DataPump, SQL*Loader, HP-UX, Sun Solaris, IBM AIX, RedHat Linux, Windows, SQL Developer, Golden Gate

Confidential, Toledo, OH

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, Configuration and Maintenance of Oracle RAC, Stand by Databases (Data Guard) for High Availability, Disaster Recovery and Reporting.
• Created and Configured Database Servers, Physical Schemas, Logical Schemas, Models, Interfaces for source and target Data Mapping and Packages.
• Oracle RDBMS Database Administration / Application Design and Development Design, Administration, Disaster recovery, Performance Tuning, Cloning, extent/space management.
• Conceptual data modeling, logical and physical data modeling.
• Cloning and Patching.
• Created and running the shell scripts to run the Processes at time schedule according to business rules.
• Cloned databases for development and testing from production.
• Performed performance monitoring and tuning by using Oracle utilities like SQL TRACE, TKPROF, STATSPACK, Explain Plan, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and used different dynamic performance views for addressing performance bottlenecks.
• Set new, change parameters in SP file as recommended or required.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via Materialized Views (replication).
• Performed database upgrades 9i to 10g and 10g to 11g.
• Review current database monitoring process/scripts that run to alert DBAs of database incidents after hours and provide improvements where applicable
• Creating and maintaining user access, space management, database refreshes, and database security.
• Planning and Administration of backup and recovery strategies.
• Performed Hot/Cold backups, RMAN incremental backups (Differential, Cumulative).
• Performed recoveries
• Performed datablock recovery
• Creating Application Users, Profiles, and Responsibilities for the user.

Environment: Oracle 10g RAC, Oracle 11g, RMAN, ASM, OEM/Grid Control, SQL, PL/SQL, DataPump, SQL*Loader, IBM AIX, RedHat Linux, Windows, SQL Developer, Oracle Streams

Confidential, St. Louis, MO

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, Configuration and Maintenance of Oracle RAC, Stand by Databases (Data Guard) for High Availability, Disaster Recovery and Reporting.
• Install, upgrade and configure Oracle RDBMS Software (9i, 10g& 11g) and applying patches.
• Performed performance monitoring and tuning by using Oracle utilities like SQL TRACE, TKPROF, STATSPACK, Explain Plan, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and used different dynamic performance views for addressing performance bottlenecks.
• Oracle Enterprise Manager (OEM) 10g Grid Control for various database activities like monitoring Target databases & servers, scheduling jobs, monitoring performance issues & implementing suggestions, setting up alerts, patch implementation, Data Guard management.
• Provide recommendations and solutions for business needs regarding capacity planning, data archiving, flash back technology, database and data migrations, and partitioning.
• Upgraded as well as migrated Oracle Databases across different platforms. Worked on conversion from NON-RAC to RAC
• Partitioned (Range, List, Hash) large tables for better performance and manageability.
• Configured KEEP POOL, RECYCLE POOL as part of instance tuning.
• Performed Hot/Cold backups, RMAN incremental backups (Differential, Cumulative).
• Performed recoveries
• Configured and maintained disaster recovery site database using standby database
• Used DBMS SCHEDULER and CRONJOB to schedule jobs.
• Sound troubleshooting, root cause analysis and performance tuning skills at database and OS levels with database backup & recovery skills including hot/cold/storage backups, complete/point in time recoveries
• Create database schemas, tables, indexes, tablespace, data objects, packages, procedures and functions.
• Managing standby databases using Data Guard and performing failover and switchover.
• Experience in handling Oracle Metalink service requests and bug patching/implementation

Environment: Oracle 10g RAC, Oracle 9i, Oracle 8i RMAN, ASM, OEM/Grid Control, SQL, PL/SQL, Data Pump, SQL*Loader, IBM AIX, Sun Solaris, RedHat Linux, Windows, SQL Developer

Confidential

Oracle DBA

Responsibilities:

• Created, monitored, tuned and maintained production, development and test databases.
• Installed oracle software 10g
• Migrated multiple databases from 8i, 9i to 10g version
• Created tables, table spaces, indexes, profiles, triggers, procedures etc.
• Implemented triggers to enforce integrity constraints.
• Monitored databases using OEM/Grid Control.
• Written PL/SQL procedures, functions packages and triggers
• Conducted meetings with clients about migrating database information.
• Worked extensively with offshore team members.
• Created different users, schema and grant restricted privileges using roles.
• Performance Tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Created Partitions by range, list, hash methods

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RMAN, ASM, OEM/Grid Control, SQL, PL/SQL, DataPump, SQL*Loader, Sun Solaris, RedHat Linux, Windows

Confidential

Oracle Developer/DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Health Check of the Database and Performing Database backup as per schedule.
• Shell Scripting, Automation of clonig and backup
• PL/SQL programming, writing Packages, Procedures, Functions and Triggers.
• Space management, adding space to Database as per requirement.
• Taking backups
• Database monitoring
• Creating users, roles, granting privileges
• Creating table spaces, tables, indexes, views, synonyms, materialized views
• Performance monitoring and tuning
• Applied RDBMS patches.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily Maintenance tasks and interacting with Oracle Customer service as and when required.

Environment: Oracle 9i, Oracle 8i, SQL, PL/SQL, SQL*Loader, Sun Solaris, RedHat Linux, Windows