With 10+ years of hands on experience on Oracle DBA 8i/9i/10g/11g,Oracle 10g R2/R3 Application Server, Oracle 10g/11g RAC, Oracle 10g GRID, performance tuning, database backup and recovery, Oracle patch sets, Quarterly CPU Patches and programming, cloning and performance monitoring.

SUMMARY

• Obtains strong skills in the development of UNIX Shell scripting, SQL, PL/SQL procedures, functions, triggers and package programs. Expertise in the functionality of Oracle 10g and 11g Real Application Cluster (RAC), 10g AS, SSO-OID integration with Windows AD, testing, and training.
• Specialized in tools such as OEM, TOAD, Erwin, DBCA and Proficiency with utilities such as Export, Import, SQL * Loader, Expdp, Impdp, RMAN and External Tables. Skilled in logical and physical database design.
• Experience in using Data Modeling tool Power Designer and Problem resolution tool Remedy Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Expertise in Oracle Installation, migration, Backup, Recovery, System designing, development, Performance Tuning, Monitoring, Net8 configuration and maintenance of Databases.
• Used the SRVCTL utility to manage, start, stop Oracle Database and services.CRS_STAT to collect statistics of nodes and services running on Clustered Database. Installed Oracle 10g Application Server (Fusion Middle tier) and deployed the EAR and WAR files in OC4J Fusion Middle tier.
• Extensively used Table partitioning using various partitioning methods like Hash, List and Range Partitioning with local indexes. Experience in finding Performance bottlenecks using TATSPACK, UTLBSTAT, and UTLESTAT, EXPLAIN PLAN, SQLTRACE, AWR, ADDM and TKPROFF.
• Involved in Relational and Dimensional Database Design for Warehouse Database and experience in Using ERWIN Tool for Logical and Physical Data models. Created local and physical structures like Database tables, indices, views, table spaces, synonyms, sequences, indexes, constraints and Oracle Jobs.
• Experience in giving software Training. Experience in working independently and as a part of team. Extensive knowledge of multiple databases and RDBMS concepts. Well experienced in Database schema design and Normalization concepts.
• Strong interpersonal and excellent communication skills with the ability to adapt quickly to new and challenging environments, hunger to learn new skills. Provide on call support 24*7*365 for all the production Databases. Proficient in different flavors of UNIX and LINUX, which includes Solaris, HP-UX, Tru64, AIX, Red Hat, Mandrake, Slack ware.
• Proficiency using Flash-Back Recovery, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Experienced in maintaining large Production, UAT, QA, SIT and DEV environments. Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms. Planned and Implemented DR & High Availability oracle solutions using Data Guard, Streams.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups. Implemented data transfer using Export/Import utilities and Data Pump.
• Automated database periodic maintenance and activities using Korn, Perl Shell Scripts, Autosys. Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL. Designed and developed PL/SQL scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems. Worked extensively on Oracle Version Upgradation,Migrations and Patching.
• Configured and implemented different types of Advanced Replication Models/GoldenGate of distributed databases. Used Repository manager to build Repository and managed Very Large Scale Databases(VLSD).Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments. Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Informatica, Data Stage.

Technical Summary

Oracle DBA

Oracle 11g/10g/9i,Oracle Application Server 9iAS/10g R2 iAS,Oracle 10g RAC

ETL Tools

Erwin 4.x, Data Junction 7.5, Informatica and Data stage.

Tools

Crystal Reports, Erwin 4.0/3.5.2, MS-Office, Microsoft Word, Excel, Power Point, , TOAD, Designer 9i/2000, Discoverer 9iAS,Version Manager,PVCS Tracker

Environment

Sun Solaris UNIX 5.9, HP UNIX B.11.00, Windows XP / 2000 / NT, Windows 2000 Advanced Server

RDBMS

 Oracle 11g/10g /9i / 8i , MS Access, SQL Server 2000, ,Teradata,Oracle 10g AS, Oracle9iApplication Server, Application Server 10g

Programming

C, SQL, PL/SQL, VBScript, HTML, DHTML, XML,ASP,JSP, Visual Basic 5.0/6.0

Oracle Utilities

External Tables, Import, Export, Data Guard, RMAN, Oracle Enterprise Manager, Oracle 10g Grid, AWR, Stats pack, Explain Plan.

Reporting Tools

Business Objects,Crystal Reports 8.0,Oracle Reports

Certifications and Education

B.Tech in Engineering
Oracle 10G Certified Professional

Relevant Experience

Confidential February 2007 – Present 
Lead Database Administrator

Installed, configured, migrated, upgraded and conducted troubleshooting of various Oracle products, including Oracle database servers and Oracle application servers. Installed and administered 4- node Oracle10g RAC architecture in Linux. 
Administered database security, user schemas, and database development processes. Installed and administered two servers of Oracle9iAS (Portal) production sites and one Oracle9iAS (Portal) development/test sites on Windows NT, and upgraded them to OracleAS10g. 
Provided technical support for all application administrators and users. Applied critical patches to Oracle databases and application servers. Installed Oracle Cluster ware Software to set up 4-nodes in a production environment. Upgraded an Oracle 10g RAC Release 1 4-node set up to an Oracle 10g RAC Release 2 database and PROD releases.

Implemented the changes to the production environments based on directions received from the development team in order to upgrade the applications from the development/test environment to the production environment. Applied the Quarterly CPU Oracle patches to the development, test and production databases and oracle application servers. Reviewed the application and database design documents developed by development team. Implemented and Monitored RMAN and export/import backups everyday in the production, test and development databases.

Worked in adding in node and deleting node in Oracle 10g RAC. Testing Oracle 11g RAC features in the Sand Box environment and validating compatibility of our applications. Upgrading the Oracle 10g R2 RAC to 11g R2 RAC with ASM database in the Sand Box environment. Worked with Oracle Support (Metal ink) for issues resolutions.

Rebuilt a 2-node RAC databases due to a SAN crash and recovered the 4-node production database after the SAN recovered with latest RMAN backups. Designed, developed, and implemented database security management, backup/recovery strategy, monitoring methods, and performance tuning. Provided technical support for all application administrators and users. Applied critical patches to Oracle databases and application servers. Installed Oracle Cluster ware Software to set up 4-nodes in a production environment. Upgraded an Oracle 10g RAC Release 1 4-node set up to an Oracle 10g RAC Release 2 database.Implemented Oracle Label security by using the row level label security.

Installed the Oracle APEX 4.0 in the LINUX 4.0 and windows standalone machine. Upgraded Oracle 10g R1 to Oracle 10g R2 in the RAC environment. Applied quarterly CPU patches to the DEV, TEST and PROD databases and Application Server. Upgraded the Oracle Application server from 10g R1 to 10g R2. Worked with oracle support if we have any application or database issues.

• Environment: Oracle 11g/10g/9i, Toad, Linux RHEL AS 3/4 Update 4, PVCS, Version Tracker, Oracle 9i/10g AS, Oracle 10g AS(R2/R3), XML-RPC, Oracle Label Security, PROD deployments, Oracle 10g Grid, Oracle 10G R1 RAC, Oracle 10g R2 RAC,Maven, OBIEE, Windows NT, Business Objects, Documentum, J2EE, OID, Apache, Portal, Power Builder, OC4J,Lotus Notes, Oracle APEX, Erwin, Oracle 11g R2 RAC, ASM.

Confidential July 2006 – January 2007
Database Administrator-Federal Client

• Created and maintained all databases required for development, testing, and production usage. Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Provided technical support to application development teams.
• Created several procedures, functions, triggers, and packages to implement functionality in PL/SQL. Created database indexes, integrity constraints, and triggers. Participated in creating a database a model, and normalized and documented using Erwin. Migrated the database from Oracle 8i to Oracle 10g, and created backups by using RMAN. Created user & table spaces, indexes, and database links. Conducted performance tuning, disk space monitoring, and file transferring using FTP.
• Database management include physical storage management such as data files, control files and redo log files in DEV and UAT environment. Good understanding of database cloning using either Oracle export utility or using cold backup.
• Performance Tuning for long running queries using STATSPACK, AWR reports, analyze, DBMS_STATS, SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required.
• Implemented automatic database backup procedures on Windows platform using cold backup strategy as well as using Oracle Export utility. Daily monitoring of Oracle trace files for any Oracle errors, checking and resolving database locks.

Environment: Oracle 8i/9i/10g, TOAD, Linux, Erwin, SQL * Loader, PL/SQL, KSH Script, SQL Server 2000, WS FTP, Windows.

Confidential
Sr. Programmer Analyst.April 2006 – June 2006

Marriott International is a leading lodging company with more than 2,600 lodging properties in the United States and 64 other countries and territories. It is ranked as the lodging industry\'s most admired company and one of the best places to work for by Fortune® magazine.

• Understanding of high level requirements (business & functional), Subject area diagrams related to Next Generation System, Sales Decision Support, Pricing Revenue Opportunity Model, Event Satisfaction Survey.
• Developed shell scripts and Oracle PL/SQL procedures for generating .zip files and automatically populating data in to the tables as and when requested.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL. Created SQL Load Scripts to load data from flat files to ORACLE 10g.Created Indexes, Integrity constraints, Triggers on the database. Used EXPLAIN Plan, TKPROF, SQL * Trace for tuning SQL Queries.
• Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots. Writing the Perl scripts to load the data from upstream system to oracle. Creating the jobs and process new files to main frame system by using the Unix Shell Scripts.
• Walked through the Logical and physical Data Models of all source systems for data quality analysis. Extensively used Erwin forward engineering of the data models to create DDL scripts for the purpose of generating metadata, keys, constraints, indexes of the existing database for the purpose of data analysis and mining.
• HTML scripting, including the ability to run Oracle stored procedures from passing and returning parameters. Analyzed on database structure, space requirements, data growth, delta of Change and Generated database minimum requirements. Conducted meetings and reported projects status to Manager and Business Leads.

Environment: Oracle 8i/9i/10g, TOAD, HP/UX, Erwin, SQL * Loader, PL/SQL, KSH Script, Oracle XML, UNIX Shell Scripting, Teradata, Perl Scripting, Informatica 7.1

Confidential; Memphis- TN
Sr. Programmer Analyst April 2005 – March 2006

Responsibilities:

• Understanding of high level requirements (business & functional), Subject area diagrams related to Customer management, marketing, sales and forecasting. Involved in creating database model, normalizing and documenting using Erwin.
• Wrote Fast Load scripts, SQL Queries to extract large volume data (ETL) from NCR Teradata Box. Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.
• Created SQL Load Scripts to load data from flat files to ORACLE 9i.Created Indexes, Integrity constraints, Triggers on the database. Used EXPLAIN Plan, TKPROF, SQL * Trace for tuning SQL Queries. Database involved minimum of 8 Gig of data in the smallest table and at least 30 mil rows in volume and maximum of 100 Gig of data in a table and at most 405 mil rows in volume for history of 24 months.
• Creating the tables and loading the data by using SAS from Teradata to oracle and oracle to Teradata.Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots.
• Developed some reports by using the oracle reports 6i.Writing the Perl scripts to load the data from upstream system to oracle. Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots.
• Analyzed on database structure, space requirements, data growth, delta of Change and Generated database minimum requirements. Conducted meetings and reported projects status to Manager and Business Leads.

Environment: Oracle 9i, Teradata, DB2, Sun OS 5.8,LINUX, Query man 6.0, Erwin, Fast Load, KSH Script, SAS 9.1.0, Toad, SQL * Loader, BTEQ, RMAN, ORACLE 9iRAC, Oracle XML, Oracle Tools.

Confidential
Database Administrator April 2004 – March 2005

Job Responsibilities:

• Understanding of high level requirements (business & functional), Subject area diagrams related to portfolio management, loans processing/monitoring, credit management, risk management and underwriting segments for decision making and reporting in the design of an integrated credit reporting system.
• Performed extensive data mining and analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized credit monitoring system from several heterogeneous source systems. (Loans in Process, Risk Management, Commercial, Real Estate and Financial Analyzer systems).
• Creating and managing database objects such as tables, views, materialized views and indexes. Finding and re-validating invalid database objects using scripts. Involved in the design of tables, forms and reports. Extensively used Forms 5.0 used for designing Screens and Reports 3.0 for generating reports.
• Implemented business logic by PL/SQL Stored Procedures/Functions in the backend. Designer 2000 was used to business process modeling. Walked through the Logical and physical Data Models of all source systems for data quality analysis.
• Extensively used Erwin forward engineering of the data models to create DDL scripts for the purpose of generating metadata, keys, constraints, indexes of the existing database for the purpose of data analysis and mining.
• Extraction of Source systems tables (5 Oracle and 2 SQL servers) and data into DQI environment for quality analysis and anomaly detection. Worked on data mining to alleviate data inconsistencies and data anomalies issues with validations of the keys, constraints, indexes and potential joins across schemas.
• Performed DBA activities includes creation of users & table spaces, indexes, Creation of database Links, performance tuning, disk space monitoring and File transfers using FTP.

Environment: Oracle 9i (9.0.1)/8i (8.1.7.0.0), Teradata, Windows2000, Erwin 3.5.2, TOAD, Data Quality Inspector 2.13,MS PowerPoint, Excel, SUN Solaris 2.7, PL/SQL Developer, Unix Shell Scripting, Ascential Data Stage 7.0, Linux.

Confidential
Database Administrator – APTransport.GOV.IN Feb 2000 – Mar 2004

Obtained an understanding of high level requirements (business & functional), portfolio management subject area diagrams, loans processing/monitoring, credit management, risk management, and underwriting segments for decision making and reporting in the design of an integrated credit reporting system.

Performed extensive data mining and analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized credit monitoring system from several heterogeneous source systems (Loans in Process, Risk Management, Commercial, Real Estate and Financial Analyzer Systems).

Participated in the design of tables, forms, and reports. Extensively used Forms 5.0 for designing Screens and Reports 3.0 for generating reports. Implemented business logic PL/SQL stored procedures and functions in the system backend. Created user & table spaces, indexes, and database links. Conducted performance tuning, disk space monitoring, and file transferring using FTP.

Conducted new technology evaluation. Managed DBA training requirements and the promotion of cross-divisional synergy. Assisted with resource planning, interviewing, personnel reviews, and arranging DBA coverage throughout the organization. Mentored and tutored junior DBAs and provided assistance to developers. Maximized Oracle skills in order to publish best practices for the organization.

Participated in gathering system user requirements, data modeling, and data development. Created E-R and data flow diagrams. Created functional and technical specifications for data entry screens and reports. Assisted with the creation of schemas, database triggers, and stored procedures.

Environment:Oracle 9i(9.0.1)/8i(8.1.7.0.0), Teradata, Windows2000, Erwin 3.5.2, TOAD, Data Quality Inspector 2.13,MS PowerPoint, Excel, SUN Solaris 2.7, PL/SQL Developer, Unix Shell Scripting, Ascential Data Stage 7.0, Linux., Developer 2000, SQL *LOADER, Visual Basic 6.0, SQL, PL/SQL, UNIX, Windows 95/98/NT, RMAN, Toad.