OBJECTIVE

Seeking a challenging environment that encourages continuous learning and creativity provides exposure to new ideas and simulates personal and professional growth.

SUMMARY

• Over 7 years of experience as Oracle Data Base Administrator, providing 24/7 support for both development and production 11g/10g/9i/8i databases on Various Platforms.
• Extensive experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g in UNIX/LINUX, IBM-AIX,SOLARIS and Windows environment.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support,Cloning,Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ADDM, Grid Monitoring.
• Experience in Installation, configuration and administration of Oracle 10g RAC.
• Experience in Standby / Data Guard.
• Experienced in setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g Grid Infrastructure configuring SCAN DNS/GNS Services.
• Effective in troubleshooting of database and performance problems.
• Good experience in SQL, PL/SQL.
• Having 3.1 years experience in AIX System Administration.
• Involved in installation, administration, configuration, planning, up-gradation, performance monitoring, backup and recovery on IBM AIX 5.3.
• Installing, configuring and administering AIX ver 5.3 on RS/6000 and Midrange P615/630 series servers.
• Experience with Data Modeling, Logical and Physical database design.
• Worked with development teams and data administration staff to enhance Database and application performance.
• EMC storage area network (SAN) support for 5 terabytes of file system.
• Experience in working on both SAN and NAS.
• Implemented a four node 10g RAC cluster on an Itanium2 platform with Net App SAN storage Management of schemas, objects & Partitioning the tables & indexes.
• Configured Netapp and EMC Clariion and symmetrix san and NAS storage for optimal performance with Oracle RAC.
• Experience in different environments like HP-UX, SUN SOLARIS, Linux and Windows.
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring
• Experience in Database Security and Auditing.
• Worked directly with Engineers on data modeling, logical/physical schema design, SQL query tuning; and the application of data related business rules while assisting in troubleshooting, debugging, and issue resolution.
• Used Grid Control, OracleEnterprise Manager and command line SQL plus and 3rd party administrative tools like Toad.
• Expertise in Replication of Oracle Database using Logical Standby, Streams and Shareplex.
• Fulfilled DBA daily activities including user management, space management,monitoring etc.
• Experience in Data transfer between SQL Server and Oracle.
• Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
• Experience in Microsoft SQL Server 2005 Database Administration including planning, implementing, backup, and recovery strategies
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering Oracle Databases on Oracle 11g/10g/9i.
• Periodic Backup and recovery, using Backup and Recovery Manager (RMAN) and Export/Import Utilities.
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Performed backups and tested crash recoveries using conventional cold, hot & RMAN backups.
• Proficient in performance tuning using Explain Plan,STATSPACK, SQL_TRACE, TKPROF.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools
• Proficient in using OEM and RMAN.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Experienced in cross platform migrations from Windows to Linux, Solaris to Linux.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Knowledge of Data transfer between SQL Server and Oracle.
• Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs,Scheduled Tasks (Windows).
• Periodic Database CLONING from production to Development and QA environments, maintaining Database Standards, Reviews, Documentation, Quality Assurance.
• Expertise in Oracle Golden Gate software.
• Experience in installing and configuring Golden Gate 9.5.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online.

Technical skills

Hardware: Pentium, PC AT-486, IBM, Dell and Apple MAC.
Operating Systems : LINUX (Red hat, SUSE), AIX, Sun Solaris 5.6/5.8/5.9/10, Windows NT, Windows 95, Windows 98, Windows 7, Windows Server2003, HP-UX 11i, AIX 4.33, 5L.
Programming Languages: C, Java, SQL, PL/SQL, Perl Scripting, Shell Scripting.
Databases: Oracle 8/8i/9i/10g/11i/11g, 10g/11g RAC, 10g/11g Data guard, SQL server 2000, 2005
Protocols: TCP/IP, HTTP, LDAP.
Utilities: SQL Loader, Export/Import, Expdp/Impdp, tkprof, statspack
GUI tools: Visual Basic, Developer 6i
Tools: RMAN, SQL*Plus, F-Secure FTP, Oracle Performance Pack OEM, TOAD, Hummingbird.
Database Servers: HP 700 Series, HP Superdome, Sun 3500, 3800, 6800, Sun Enterprise 450 & 880, Sun Fire V1280, Dell PowerEdgeT100, Sun fire 4800, VCS, VCFS, HACMP.

Professional Experience:

Confidential, San Antonio, Texas April 2010 - Till Date

Responsibilities:

• Involved in 24x7 supports for 1 TB 2 Node production RAC database with on-call pager.
• Installation and creation of 11g and 10g databases for Testing, Development and Production.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• Creating and Managing Table spaces with different block sizes to prevent row chaining
• Data Refresh from Production to Test and Development environments using RMAN Duplication
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK
• Design, develop and deploy logical and physical test and production database solutions for Oracle 11g, 10g database and SQL Server 2005 Databases and 2008 Database.
• Experienced in data warehouse, data migration and data quality projects
• Audit the MSSQL Server & Oracle databases and implement security policies.
• Responsible for installing and configuring Golden Gate 9.5 on Oracle Servers
• Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0.
• Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Golden Gate tool.
• Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.
• Involved in implementing Golden Gate Unidirectional and Bidirectional Replication on to Repository Database.
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.
• Deployed Disaster Recovery (DR) solution for Oracle 10g using Data guard.
• Providing 24/7 production DBA support for Oracle, MSSQL Server databases.
• Going through the day-to-day user requests and troubleshooting the database related problems.
• SQL Scripting for MSSQL Server and shell scripting for Linux servers to perform database maintenance operations and as required by the applications.
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Handle and perform clients Service request for Incident Management, Problem Management and Change Management.
• Audit the MSSQL Server & Oracle databases and implement security policies.
• Installed and configured the VERITAS enterprise edition cluster file system for RAC.
• Implemented strategy for partitioning and management of historical data tables in RAC.
• Setup of Standby Database using Data Guard and Replications for faster Disaster Recovery
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & move procedures
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP
• Experience in oracle features Flashback version query, Rollback Monitoring, Table space Management, Oracle Data pump, Flashback Table, RMAN and Auditing
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Scheduling jobs using Oracle Job Scheduler, OEM Grid.
• Expertise on working with different monitoring tools like OEM Grid, Toad, DBArtesian.
• Scripts for Cold Backups, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Installation and configuration of Oracle Client software and Tools
• Monitoring and Optimizing database performance
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• SQL scripts to monitor Table spaces and extent growth

Environment: Oracle 10g, 11g, RAC, RMAN, SQL Server 2000 & 2005, Red Hat Linux, Solaris 9, 10, Database Grid Control, Windows 2003, HP-UX, Data guard, TOAD, VERITAS Net Backup, Sun25k, Sun 10k

Confidential, Bloomington, IL Jan 2009 - March 2010

• 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 10g RAC, Stand by database.
• Experience in configuring Data guard 10g R2 for physical standby database.
• Experience in Installation of Golden Gate on Oracle Servers.
• Expertise in Oracle Golden Gate configuration and troubleshooting GG issues.
• Designing the logical and physical database structure.
• Designing the security and database access strategies.
• Logical and Physical data modeling.
• Enforcing the Null and check constraints.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Installation, Configure, setup of 10g RAC and add new nodes to RAC 10g Cluster to distribute the load.
• Creating and dropping of users, granting and revoking rights as and when required.
• Cloning databases and Disaster Recovery Database.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Using TKPROF, EXPLAIN PLAN and STATSPACK for the Better performance.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self-tuning purposes.
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them.
• Customization and development of Unix shell scripts, Korn and Perl scripts.
• Good Experience tranfering files by using scp, sftp, ftp and pscp.
• Partitioning strategies for very large tables.
• Diagnose and troubleshoot Database problems and failures
• Implementing range, list partitions, hash sub partitions.
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Good working knowledge on TOAD, OEM.
• Monitoring of database for growth and performance
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

Environment: Oracle 10g, Solaris 8, 9, Red Hat Linux 4.x,Oracle Enterprise Manager, Shell, Korn & Perl scripting, RMAN , Data guard, TOAD, OEM, Golden Gate.

Confidential, NY. July 2007 - Dec 2008

Responsibilities

• Involved in the installation of Oracle 9i on Windows and UNIX platform.
• Prepared Backup and Recovery Plan.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Analyze and suggest improvements to SQL queries and statements written by others.
• Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding PL/SQL
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Day to day Performance Monitoring and tuning of database.
• Performed Monthly Cold Backup, Weekly Hot Backup and daily backups using Export. Testing of Backup's and Documenting backup strategies. Created scripts for automating online daily backup for eight databases and for automating data loading from flat files.
• Used TKPROF, EXPLAIN PLAN for the Better performance.

Environment: Oracle Server 10g/9i, SQL, PL/SQL, Windows NT, Linux/Unix, Solaris

Confidential, Bentonville , Arkansas. Jan 2006 - June 2007
Responsibilities

• Installation, Configuration and Administration of Oracle 9i databases on various Operating Systems.
• Provided support for all the databases as an operational database administrator.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company's requirement as necessary, from information given by the application developers.
• Creating and managing users, roles and profiles, auditing and monitoring databases and user access.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Allocated system storage and planned for future storage requirement for the database.
• Responsible for installing, upgrading and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database backup and recovery, monitoring and optimizing database performance.
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Installed and configured SQL Server 2000 in Windows environment.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Creating primary database storage structures (table spaces, rollback segments etc.).
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.
• Supervised the installation and configuration of Oracle databases on Linux and Windows NT.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Created roles, profiles and privileges and assigned roles to users.
• Created primary database storage structure for developers to develop and test the Application.
• Created reverse engineering scripts, scripts for tablespace usage, table sizes and SGA Usage.
• Documenting each and every change in the database.
• Used SQL-Backtrack and NT backup manager for backups.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism.
• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
• Estimating the space requirements for database growth for next 12 months and availability of hardware to support the processes.
• Developing, Implementing and administering database policies and procedures.
• Installed and Implemented Backup & Recovery procedures.
• Proactive database monitoring using automated scripts based on v$views.

Environment: Oracle 9i, Sun Solaris, AIX 5L, SQL Server 2000, Windows NT/2000

Confidential, India. Auguest 2004 - Dec 2005

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment. Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: Oracle 8i, SQL, PL/SQL, Linux, Sun Solaris 2.5 Shell scripting.

Confidential, Hyderabad, India. Jan 2004- July2004

Responsibilities:

• Managed in-house Oracle Databases running on various operating systems like Windows NT and Linux.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Using Enterprise Backup utilities for backup.
• Writing scripts for backup and recovery.
• System tuning for better performance.
• Creating stored procedures, packages and database triggers.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Designing and enforcing standards and naming conventions.
• Writing technical manuals.
• Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
• Writing Unix shell scripts for backup and recovery.
• Supervised the installation and configuration of Oracle databases on Linux and Windows NT
• Supported the implementation of a web based human resources/ Payroll and asset management system for the bank.
• Writing SQL scripts to monitor database performance.
• Writing SQL Loader control files for data loading to the payroll system.
• Problem trouble shooting and resolution.
• Creating PL/SQL packages, procedures and database triggers.
• Database installation and instance creation.
• Creating database triggers, Procedures and packages for the payroll system.
• Database tuning, backup and recovery and general day to day running of the system.
• Systems analysis and design.
• Creating project plans and implementation schedules.

Environment: Linux, Windows, Oracle 8i