SUMMARY

• Over 9+ years of experience as Database Administrator, Architect and Developer in Production, Development and Testing Environments.
• Good experience in 24/7 Production Environment Support.
• Handled (Full Life Cycle implementation) of back end database configuration (Installation, Setup, Tune, Backups, Patching) and provide the full database tier support to all phases of software development (Development and Production).
• Responsible for , both manage and support all Production, Development and Staging instances of Oracle Version 8i, 9i and 10g.
• Solid experience inmanaging Oracle inHigh Availability environments using Real Application Cluster (RAC), Failovers, Data Guard and Cloning technologies.
• Managing Very Large Database with size up to 8 Terabyte size.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Database Performance Tuning using dynamic performance views, AWR, Explain Plan, SQL TRACE, STATSPACK and different OEM utilities.
• Proficient in developing PL/SQL program units using Stored Procedures, Functions,Packages and Triggers.
• Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Well versed with client server environment & tools like SQL*LOADER and TOAD.
• Extracted data from Oracle Database using XML Publisher into Excel spreadsheets, Word or HTML format.
• Upgrading of Database from lower version to higher version.
• Installation of Patch and fix bugs.
• Worked on Database Performance Tuning, SQL Tuning and Optimization.
• Worked on New Environments setups includes ASM, RAC Databases Installations and Oracle 11i Applications Installations and Middleware Installations.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
• Development and Production Support for Oracle Database.
• Involved in all the database activities such as creating tables, databases, backup, recovery, replication.
• Working experience with SQL, PL/SQL, Toad & other tools including creating database objects like tablespaces, tables, views, indexes, constraints, sequences, functions, procedures, trigger, partition tables.
• Mentored and provided oversight and backup for the production Databases.
• Administrating Database in various platforms like WINNT / 2000/ 2003, SUN SOLARIS 8/9 , HP UNIX , Red Hat Enterprise Linux .
• Maintaining data integrity and tune database for optimum performance and availability.
• Excellent in troubleshooting Oracle Network issues.
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS:

OPERATING SYSTEMS:

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS:

Oracle11g, Oracle 10g/9i/8.x/7.x, Oracle 10g Real Application Clusters (RAC). MSSQL Server 2000/2005/2008

SQL, PL/SQL, JAVA, JSP, C#, C, C++, XML, UNIX Shell Scripting, Perl.

SOFTWARE APPLICATIONS/ TOOLS:

Srvctl, Crsctl Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, IBM RSA, Clusters, Veritas Backup, , SQL Loader, SSIS, SSRS, SSAS, FTP, TOAD 7.6/7.5, Oracle Enterprise Manager, DGMGRL., ERWIN 4.0, Rational Rose, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

WEB TOOLS

HTML, XML

EDUCATION & CERTIFICATIONS:

• Bachelors in Computer Science and Information Technology
• Oracle Certified Professional (DBA) 9i.

Confidential, CA Oct 2009-Present
Oracle DBA

Responsibilities:

• Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups.
• Planning, Implementing and Validating various versions of Oracle Databases to 10G Release upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of backout procedures like downgrades/building parallel environments .
• Importing data using SQL*Loader, Monitoring the database performance and providing assistance to development teams. Constantly monitored the performance of the database using V$ dynamic performance views at peak load and by viewing Alert log files & Trace files.
• Extensively used Explain Plan, ADDM reports and Oracle enterprise manager.
• Daily monitoring like alerts checking, log checking, fixing space issues, fixing application connectivity issues, tuning databases, tuning application related queires, indexing tables, gathering statistics for optimum results, recommend workarounds/changes in application queries, partitioning maintenance.
• Planned and implemented backup strategy of data in both archive and non-archive mode.
• Granting privileges to users to access systems and databases.
• Performing cloning of a database to generate reports.
• Worked with the High availability environments using RAC , Data Guard and cloning.
• Working experience with SQL, PL/SQL, Toad & other tools including creating database objects like tablespaces, tables, views, indexes, constraints, sequences, functions, procedures, trigger, partition tables.
• Oracle Database Administration activities such as starting and shutdown of Databases. Creation of Databases whenever necessity arises. Security administration by creating users with appropriate Roles and Privileges.
• Managing redo log files in archive log mode for online backup.
• Resizing and Renaming data files if required.
• Setup the DR with Physical Standby Data Guard at Co-Location.
• Daily, weekly system and DB server maintenance like cleaning the old archives, validating the backups, monitoring Alert Logs & Trace file and Application Logs , managing the security at user level and at application level.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Worked on large set of performance monitoring skills like Oracle , Solaris etc.
• Shell scripting for automating, monitoring and performing routine database jobs.
• Worked on Database Performance Tuning, SQL Tuning and Optimization.
• Provide development and production support related to database.
• Evaluated new features and enhancements in later versions of Oracle (10g) for possible implementations like Data Pump (Expdp/Impdp), Transportable Tablespaces, Cross-Platform Transportable Tablespaces, External Tables, and Partitions.
• Using OEM to manage multiple instances and Toad for development and reporting.
• Involved in Functional Design Review and preparing the Detail Design Document.

Environments:

Oracle 9i/10g, Oracle10g AS, Windows 2003, Red Hat Linux 3.0/4.0, Veritas NetBackup, RAC, Export/Import, RMAN, SQL * Loader, SQL, PLSQL, SQLTRACE, STATSPACK, SQL Tuning Advisor, Data guard, Replication, Data Grid Control, Materialized Views, Snapshot, Migration, upgradation, installation

Confidential, Alpharetta, GA Apr 2008 - Sep2009
Sr.Oracle DBA

Responsibilities:

• Worked on oracle 9i, oracle 10g and RAC databases.
• Installation, Upgrade and Configuration of Oracle (9i, 10g).
• Configured the Oracle 10g RAC on windows environment.
• Installed and configured RMAN for 9i and 10g.
• Worked on Oracle10g application server.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins,
• password (security).
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Taking Hot and Cold Backups, Logical backups (Export) on specified databases.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions .
• Good understanding of the Oracle Administration and familiar with ETL .
• Daily, weekly system and DB server maintenance like cleaning the old archives, validating the backups, monitoring Alert Logs & Trace file and Application Logs , managing the security at user level and at application level.
• Solid experience inmanaging Oracle inHigh Availability environments using Real Application Cluster, Failovers, Data Guard and Cloning technologies.
• Implemnting Physical and Logical Standby setups Data guard Configurations.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Prodcution to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Capacity Planning for all the Production and Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management and Grid Implementation).
• Tablespace Management, objects creation, and user management.
• SQL and PL/SQL Scripting (Writing Stored Procedures and triggers for internal usage for monitoring and auditing).
• Used various data movement utilities like export, import and Load, Planning.
• Worked with development team to analyze and support production database performance and third-party resources to create, manage, and tune information feeds from various sources.
• Handled the Back up and Restoration Strategy, Executed Shell Scripts using Cron jobs, Planned and scheduled Backups, took Logical Backups (with Export / Import utilities).

Confidential, Seattle, WAAug 2007 - Apr 2008
Oracle DBA

Responsibilities:

• Provide Primary DBA support for Oracle Applications and Administration, Configuration and Maintenance of RAC (Real Application Cluster) and Non-RAC Databases
• Work within the production support team and maintain operational consistency and efficiency
• Provide input to the Project and Enhancement teams to define database storage structures (tablespaces) after application developers have designed an application
• Implementation of reviewed changes to the production databases
• Provide primary DBA support to Production support developers
• Provide application DBA skills to identify and focus on strategic opportunities
• Creating primary objects (tables, views, indexes, snapshots, database links, etc) once application developers have designed an application
• Modifying the database structure as necessary, from information given by application developers
• Maintain system security
• Database backups and recovery usingRMAN, Import/Export, Hot/Cold Backups, Data Pumptools.
• Controlling and monitoring user access to the database ,Monitor and optimize the performance of the database and Maintaining archived data.
• Collaborate with Enhancement and Production support teams to verify all instances are healthy and up
• Verify success of database backup (Maintaining RMAN Backups and Logical Backups)
• Implemented database refresh with the hot backup using DUPLICATE or full export
• Monitoring security policy violations
• Tune SQL, I/O, Application and Database
• Review Data Fragmentation
• Development/Test Instances Creation
• Refresh Databases and Schemas with Production Database
• Migrating data from development data to Stage and then Stage to production SQL/PLSQL and UNIX Shell Scripting for monitoring space and extent growth.

Environment: Oracle databases 8i/9i/10g, router, switches, SQL*Loader, Sun Solaris 8, download router, switches (third party tools), scripts, procedures, functions, Dataguard, SQL Tuning Advisor, ERWIN, Hot backup, Export/Import, RMAN, Veritas NetBackup, Statspack, Replication (Materialized views and snapshots), upgradation, Migration.

Confidential, McLean, VA Aug 2006 - Jul 2007

Oracle DBA

Responsibilities:

• Provided 24 * 7 on-call Production support for Oracle 9i and 10g
• Installed and implemented the Oracle Database creation
• Gathered Statistics and monitored TOP SQL's for performance.
• Completed database Cloning and Database Up gradation from old version
• Maintained Version Control for Production Environments
• Take care of the Database design and implementation
• Setup and maintain documentation and standards
• Plan growth and changes (capacity planning)
• Implemented physical and logical database design.
• Created Service Request to Oracle for performance problems.
• Provided continuous feedback and support for PLSQL and SQL Performance turning to developers and Code review.
• Assisted code writing in development using PL/SQL Block, Procedures, Functions Database Triggers and Packages
• Maintaining 9i RAC and 10g RAC databases and Dataguard.
• Writing Oracle Procedures and functions
• Identified Worst Queries in development and fine tuned
• Worked with development team to analyze and support production database performance and third-party resources to create, manage, and tune information feeds from various sources
• Ensure data security by establishing and enforcing proper access policy managed Database structure in SAN
• Shell scripting in csh, ksh (KORN) for automating startup/shutdown of databases, getting system alerts etc
• Handled the Backup and Recovery using RMAN
• Did SQL tuning and Instance tuning.
• Rollback segments, Constraints, Database Access, Roles and Privileges.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions etc..
• Used various data movement utilities like export, import and Load, Planning
• Handled the Back up and Restoration Strategy, Executed Shell Scripts using Cron jobs, Planned and scheduled Backups, took Logical Backups (with Export / Import utilities).

Environment: Oracle databases 8i/9i/10g, , router, switches, SQL*Loader, Sun Solaris 8, download router, switches (third party tools), scripts, procedures, functions, Dataguard, SQL Tuning Advisor, ERWIN, Hot backup, Export/Import, RMAN, Veritas NetBackup, Statspack, Replication (Materialized views and snapshots), upgradation, Migration.

Confidential, HYD, INDIA Feb 2002 - Aug 2006

Oracle DBA/Developer

Responsibilities:

• Responsible for Oracle 8/8i logical and physical databases design, implementation and maintenance on UNIX and NT
• Creating Users and Maintaining Security of the Database
• Moved database Schema changes to stage or production
• Developed some Unix Shell scripts to automate database operation and database monitoring
• Used EXPORT/IMPORT to do table level and full database defragmentation
• Provided on-call production database support
• Creating Indexes and Monitoring Performance
• Data loading using SQL Loader (from Text files to Database)
• Perform Daily Logical backups using exp
• Perform RMAN operations (Incremental Backups)
• Coding PL/SQL, SQL and Unix Scripts
• Server and Clients Installations for New Clients
• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC
• Performed SQL Tuning by using explain plan and TKPROOF
• Daily Monitoring Database and Tablespaces Growth and Monitoring Space Availability at Operating System
• Trained a new DBA in our environment
• Environment: Oracle 8i/9i, PL/SQL, SQL Navigator, Erwin, Toad, Forms, Reports, and Windows NT