Summary

• Over 12 years of professional DBA experience along with ETL/Data warehouse experience
• Provided excellent database support for Dev, Test, Acpt and 24/7 Production environment

Provided applications and administration and of Oracle,SQL Server, Sybase and Teradata databases Experienced in supporting databases on Solaris, HP-UX, Linux, AIX and Windows platforms Experienced in Relational Database Modeling and Database Design, using ERWIN and ERStudio Installed and Configured of Oracle databases 11g, 10g and 9i on different operating systems. Worked on oracle database migration/upgrade (11g, 10g, 9i, 8i and 7.x)

• Experienced in Lead, Design and Develop the ETL processes for Data Warehouse systems

Experienced in design, architect, support of data warehouse. Experienced in Informatica ETL and assist Business Objects report team to tune and write better queries and join the objects Hands on experience on Very large databases (VLDB). Support OLTP & DSS systems. Broad-based expertise in the areas of Oracle database administration with in-depth hands-on in Real application clusters (RAC & ASM), Performance Optimization, Partitioning, Advanced Replication, Database Security, RMAN Backup and Recovery, Grid Control, Data guard, PL/SQL and Shell scripting. Expertise in oracle database, query tuning using OEM and Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Active Session History (ASH) and Explain plan. Excellent applications, database support in Oracle, SQL Server, Teradata and Sybase in creating Tables, Stored Procedures, Views, Indexes, Triggers, functions and user creations and security settings.

• Experienced in T-SQL Programming, query optimization & performance tuning in Sqlserver in Profiler, Performance Monitor and DBCC Commands
• Good knowledge in Replication, Mirroring, Snapshot in SqlServer.

Experienced in Teradata application support and usage of BTEQ ,FastLoad ,MultiLoad ,Tpump,Fast Expert and Queryman. Create and Maintain Teradata Users, Tables, Views, Stored Procedures and Macros

• Optimized bcp for large data loads in sybase. Analyzed the DBCC output.

Performed scheduling of jobs using oracle scheduler and AutoSys Automation using UNIX Shell scripts and Perl Scripts Monitored OS performance using PS, VMSTAT, SAR and SAM utilities Self-motivated, goal-oriented team player with excellent communication skills

Education

Master of Computer Applications (MCA)

Technical Skills

Databases : Oracle 11g/10g/9.i/8i/7.x, SQLServer 2008, Sybase,Teradata, DB2, MySQL
Oracle Features : RAC, DATAGUARD, OEM, ASM, RMAN, AWR, DATA PUMP
Terdata : BTEQ, MLOAD,FastLoad,TPUMP,FAST EXPORT
Data warehouse/ETL : Informatica, Business Objects
Application Tools : SQL*Loader, SQL*PLUS, PLSQL, Erwin, ERStudio, Exceed, TOAD and Putty
Symantec Indepth, Embarcadero, TextPad, Remedy
Operating Systems : SUN Solaris, HP-UX, AIX, Linux and Windows NT, 2000
Programming Languages : SQL, PL/SQL and T-SQL
OS Tools : Sh, Ksh, Perl scripts, Cron scheduling, Autosys, Vi Editor

Confidential,Washington DC Sep 11 to Till Date
Sr.DBA/ETL/Data warehouse

Environment Production Agency (EPA), Office of Chief Financial Officer (OCFO), EPA-OCFO proposes to create a Superfund Consolidated Data Source (SFCDS). The Superfund Consolidated Data Source provides Repository of Comprehensive Superfund Cost Recovery Data including legacy data NEIS. It has Detail-level, post Momentum go-live Superfund Data, converted and non converted data within Functional Data Warehouse. Sources of SFCDS comes from the various applications SCORPIOS, CERCLIS, MOMENTUM, IFMS.NEIS and FMS

Responsibilities:

• Design, development, testing, performance tuning, deployment, and support in Data warehouse system.
• Worked with various Sources such as Oracle, SQL Server,DB2,Teradata and Flat/Excel files
• Developed strategies for data extraction from various source systems, transformation and loading into data warehouse target systems.
• Participated and architected in schema, object design discussion.
• Worked to improve the efficiency of data warehouse application through the use of indexes, compression, materialized views and other techniques
• Define and implement ETL development standards and procedures for data warehouse environment.
• Lead the design of the ETL solution; oversee the ETL low-level design and design phase deliverables
• Developed and assisted the team to develop Informatica scd type 1 and type 2 mappings, sessions, worklets and workflows as per the business rules and loading requirements.
• Worked with functional analyst to prepare the Source Target mapping specs with the business logic and also helped in data modeling
• Used Informatica ETL debugger and breakpoints to view transformations output and debug mappings.
• Created Workflows using various tasks like sessions, control, decision, e-mail, command, worklets and assignment and worked on scheduling of the ETL workflows.
• Verified the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.
• Worked in data model using Erwin.
• Database and oracle Query performance tuning using OEM, AWR, ASH, ADDM, Explain Plan.
• Developed and assisted developers of writing SQL, PL/SQL, stored procedures and triggers.
• Provided applications support in teradata, sqlserver environment. Tables, Stored Procedures, Views, Triggers, Rules, Defaults, macros and functions
• Usage of BTEQ, MLOAD, Fast Load utilities, Performance tuning of queries in teradata.
• Setup and Manage backups in sqlserver. Wrote and Assisted the developers to write TSQL
• Tuned the SQL queries in Sqlserver using SQL Profiler, Performance Monitor and DBCC Commands
• Experienced in data migration from Oracle/Access/Excel Sheets to SQL Server/Teradata

Environment: Linux, AIX, Oracle 10g/11g,SQL Server 2008,T-SQL,Teradata,DB2,Informatica Power center 9, OEM, Data guard,PL/SQL, TOAD, Erwin, Putty,

Confidential,Herndon, VA Sep 08 to Aug 11
Sr.DBA

CLM (Credit Loss Management) is the system to handle the delinquency, foreclosed properties and managing maintenance of foreclosing properties. QAS (Quality Assurance System) is a web based application that tracks the status of loan files for those particular loans that Fannie Mae has selected for quality assurance underwriting review. GFAS (Guarantee Fee Accounting System) records issuances, amortizes items at CUSIP level, records various Impairments and calculates periodic Fair Value/MTM and LOCOM adjustments. SIR (Servicer and Investor Reporting) SIR reports Loan activity. Remits cash for Fanni Mae Loan Assets. Reconciles Fannie Mae and Servicer Records. Validates pool balances for Mortgage Backed Securities and distributes payments to investors for MBS.

Responsibilities:

• Participated on design, architecture review meetings and provided suggestions, improved qualities
• Worked on physical model using ER Studio.
• Deployed schema builds scripts; maintained db baselines, support application requirements.
• PL/SQL code development, analyze and provide recommendation for performance tuning.
• Supported Sybase databases. Performed Application development in it.
• Installed and supported 11gR2 RAC, Grid Infrastructure, databases, patches,created service.
• Experienced with OEM, Oracle Grid Control, supported RAC and non RAC databases.
• Managed ASM disks and disk groups
• Experienced in configuring and managing Oracle standby database and data guard
• Performed Backup and recovery operations using RMAN. Wrote & troubleshoot RMAN Scripts
• Supported the dev, test, acceptance, integrated and production environment
• Managed data warehouse projects improvement and growths.
• Query and Instance tuning using OEM, AWR, SQL Access Advisor, ASH, ADDM, Explain Plan.
• Used 11g features of data pump utilities including compression, remapping data, renaming tables
• Loaded flat file data into oracle using sqlloader.
• Created materialized view, materialized view log external tables for optimization
• Monitor dumps, DBCC, update stats task run to completion. Handling DBCC output and troubleshooting
• Performance monitoring Memory, CPU utilization, disk utilization, locks, deadlocks, queries in sybase
• Using sp_sysmon to evaluate server level performance. Data migration using BCP utility
• Maintaining user, group, assigning privileges in sybase
• Used data pump for data and metadata movement.
• Write SQL/PLSQL/Unix handy scripts for performance analysis, proactive measure.
• Automated the jobs using Unix Shell scripts and troubleshooted.
• Monitored the jobs scheduler using AutoSys.

Environment: SunOS, Linux, AIX, Oracle 10g/11gR2, RAC, ASM, OEM, Data guard, Sybase, PL/SQL, DBArtisian, ERStudio, Putty, Remedy, Clear case, Abinitto, Autosys, Clear Quest

Confidential,Purchase, NY Sep 06 to Sep 08
DBA

Licensing MPI application has been identified as the central location to store relationship information for organizations related to MasterCard. Relationship includes Principle, Affiliate Members, Third Party Processors and Independent Sales Organizations. B-SMART is MasterCard\'s business Sales Management and Reporting Tool. It is the central repository for customer management related data including account plans, forecasts, call reports, agreement compliance. Member Risk Monitoring System (MRMS) application is used globally by Risk Managers as they determine the potential risk a member may present to MasterCard. Executive Dashboard provides a strategic, corporate-wide approach for communicating and management of performance and risk metrics. It includes financial, operational, organizational, and strategic information.

Responsibilities:

• Participated on design, architecture review meetings.
• Worked on model using Sybase Power Designer.
• Supported functional data warehouse projects.
• Created databases using the database configuration assistant (DBCA).
• Configured network configuration using TNS, LISTENER, Net Configuration Assistant.
• Managed disks and disk groups using ASM.
• Involved in implementing 10gR2 RAC three node cluster.
• Tuned database and queries with AWR, OEM, Data pump utility, flashback query.
• Configured and maintained logical and physical Data guard
• Performed apply process, Detection and resolution of archive gap sequence in Data guard.
• Implemented RMAN strategy for Backup and recovery using RMAN and troubleshoot.
• Cloned of production database to test environment using Recovery Manager (RMAN)
• Supported the dev, test, performance and production environment
• Migrated the Lotus Notes application backend data to Oracle Db.
• Wrote PLSQL and Sqlloader scripts to load the legacy data from the old to new system.
• Developed PLSQL Code (Packages, Functions, Procedures, Triggers) and reviewed with business team
• Setup proxy enabled in DB to ensure the single sign on in the application
• Audited user activity to ensure integrity of the database. DML audit capture on high profile tables.
• Used external tables to handle the external data into oracle database.
• Wrote Shell scripts for automation and troubleshoot

Environment: HP-UX, IBM-AIX, SunOS, Linux, Windows, Oracles 9i/10g, RAC, DATAGUARD, OEM, PL/SQL, Sybase Power Designer, TOAD, Putty, Textpad, indepth

Confidential,Herndon, VA Mar 06 to Aug 06
DBA Support

RFDW - (Restatement Financial Data Warehouse)

This warehouse project is to for re-submitting the statement for the last 15 years of Fannie Mae accounts to government, which includes stocks, investment, loans and general ledger of about size of 6 terabytes. Sources of the table data would come from various databases of Sybase, oracle and sqlserver, getting populated into the system using sqlloader utility using abinitto tool

Responsibilities

• Supported the test, dev, acceptance, integrated and production env
• Gathered AWR (Automatic Workload Repository) is to collect for problem deduction and tuning
• Handled Data Pump utility for the high speed infrastructure for data and metadata movement
• Used Flashback Query feature for recovery operations.
• Managed dynamically SGA using Automatic Shared Memory Management feature of SGA_TARGET
• Reconfigured the table spaces and objects. Handled the partition tables, Indexes
• Implemented the resource management for efficiently using the resources in the system
• Automated database tuning scripts using shell scripts.
• Identified top resource consuming sql and their physical/logical reads, undo, table space usage
• Tuned Query using explain plan, hints. Rewrite the query.

Environment: SunOS, Oracle 9i/10g, SQLServer, DB2, Sybase, PL/SQL, Erwin, ERStudio, Putty, Remedy, Clear case, Clear quest, Abinitto, Autosys

Confidential,Washington DC Oct 05 to Mar 06
DBA

The District of Columbia Child and Family Services Administration is an agency that oversees cases of abused and neglected children in the District. Deloitte worked with the agency to build a customized case management client/server application and an extensive line of management reports. Deloitte is engaged in modernizing and enhancing the web interface system using Microsoft’s .NET technologies with backend Oracle on HP-UX.

Responsibilities:

• Installed Oracle 9i software, Applied latest Patches and OPatch on HP-UX
• Implemented Oracle Data Guard for High availability of database
• Tuned SGA, PGA, Indexing, Hash join using STATSPACK
• Implemented Logical and Physical Design using Erwin
• Written, troubleshoot and optimized the PL/SQL objects using TKPROF, TOAD, Auto trace
• Written shell scripts and sql scripts for monitoring the database activities
• Planned & administrated the backup strategies and Using RMAN for backup & recovery
• Handled performance tuning with utilities like vmstat, glance, top, sam
• Performed OS Backup & Restore using HP OpenView OmniBack

Environment: Oracle, HP-UX, Windows, Erwin, TOAD, Putty, Microsoft.NET Framework, C#,

Confidential,Ann Arbor, MI Mar 05 to Sep 05
DBA

BGI Retek Data Conversion project is the conversion of the existing mainframe data of merchandise system to oracle database according to retek merchandising system. RMS includes modules item master, item supplier, item relationship, and item stock in hand, sales history, stock ledger, purchase order, stock order, price history and sales history.
Responsibilities:

• Supported Oracle 9i/10g databases on IBM AIX 5.2
• Automated the entire loading process of external data, using shell scripts
• Worked extensively on partitioning of the tables and indexes. Handled sqlloader for inserting external data
• Handled Space management activities in the environment of 5 TB in size
• Tuned SQL, stored procedures and instance using TKPROF, STATSPACK
• Planned & administrated the backup strategies and Using RMAN for backup & recovery
• Worked with PL/SQL features like dynamic query, bulk collect, collections and records

Environment: AIX, Oracle 9i/10g, DB2, RETEK, STATSPACK, RMAN, TOAD, LeechFTP, Exceed

Confidential,Bangalore, India Mar 04 to Feb 05
Application Support DBA
Uebill is a Universal electronic billing application, which is designed for the AT & T telecom billing customers. Customers can view billing information for current month as well as past twelve months. Electronic bill payment can also be done using this application.
Responsibilities:

• Handled Database Creations and Upgrades of 8.1.7.4 to 9.2.0.4 on Sun Solaris 2.8
• Month data loaded into the database using Sql loader utility
• Handled Space management activities as part of 24*7 Production support of 4 TB in size
• Tuned the database using TKPROF, STATSPACK for performance
• Calculated available space within an object and predicted the level of object growth
• Planned & administrated the backup strategies and Used RMAN for backup & recovery
• Written and troubleshoot Unix shell scripts and Perl scripts

Environment: Solaris, Linux, Oracle 8i/9i/10g, RMAN, HP-UX, VERITAS, NETBACKUP, TIVOLI
Confidential,India Oct 03 to Feb 04
DBA
Handled the complete administration and support of oracle server for Saint-Gobain Glass (largest modern glass plant) and Dynamic logistics (largest cargo company having worldwide network).
Responsibilities:

• Installed Oracle 9i/8i/7.3. Applied patches for the Oracle Server
• Implemented Oracle Data Guard for High availability of database
• Provided 24*7 Production supports of multiple instances of size 80GB. Prepared space summary report
• Tuned the database using Explain Plan, TKPROF, and STATSPACK for performance.
• Used RMAN for backup & recovery

Environment: True 64/Windows 2000/Linux/Oracle 9i/8i/7.3, PostgreSQL, RMAN, Shell scripts and Exceed
Confidential,India Apr 03 to Oct 03
DBA
Maintenance of the backend production servers of the organizations - Commercial tax offices, BSNL and HAL. The data comes from each branch offices and loaded into the central server located in the head quarters.
Responsibilities:

• Performed DB Creation and Maintained Oracle as well as SQL Server databases
• Monitored the production database of size 1 TB. Mentored and trained the junior DBAs
• Tuned the database using TKPROF, STATSPACK for optimum performance
• Interacted with User Groups/Corporate Testing Groups/Business analysts
• Effectively handled Backup & Recovery operations

Environment: HP-UX/AIX/Windows 2000/Linux/Oracle 9i/8i/7.3 /SQL Server
Emsons Radio Corp Jun 99 to Apr 03
PLSQL Developer/Development DBA
Management Information Systems (MIS) automates entire product development cycle. The development cycle includes gate, inventory, tax, dispatch, human resources and production modules.
Responsibilities:

• Installed oracle software in server and client systems. Configured Oracle Network Products
• Involved in Analysis, Design and Project Management. Co-ordination of Database design, Normalization
• Performed database creation and Creation of User, Role and system privileges
• Handled offline and online Backups of databases and planned for Recovery
• Effectively handled User administration and Performance tuning of database and applications

Environment: Windows NT/Oracle 8