Summary:

• Over ten years of professional experience in Oracle Database Administration and over six years in Sql Server Administration and Informatica.
• Extensively worked with database development writing stored procedures, functions, packages and database triggers using SQL & PL/SQL coding.
• Good interaction with Business Analyst, Managers, Developers, QA and End Users.
• Proficient in DBA activities such as Database Creation, Database Maintenance, Database Backup and Recovery, Database Tuning, Application Tuning, Security, Migration.
• Extensive experience in design and Implementation of database backup and recovery.
• Very good knowledge of Software Engineering and exposed to all phases of Software Development Life Cycle (SDLC).
• Applying Oracle security patches.
• Involved in regular data monitoring, data backup/recovery processes.
• Duties involve regular maintenance, monitoring, performance analysis, trouble shooting, problem resolution, and user assistance, user testing.
• Knowledge on Data warehousing concepts like OLAP Architecture, Star Schema, Snowflake Schema, Dimension Tables, Fact Tables.
• Worked on different types of transformations like Expression, Filter, Aggregator, Rank, and Look Up, Update Strategy, Sequence Generator, and Joiner.
• Possess strong analytical and problem solving skills coupled with very good communication and interpersonal skills.

Education:

• Bachelor of Engineering Degree in Computer Science

Training and Certification:

• Oracle 9i Certified Professional
• Microsoft Certified Professional
• ITIL training

Technical Skills:
Operating Systems: UNIX, Solaris and Linux, Windows 95/98/2000/NT/XP/2008
RDBMS : Oracle 8i, 9i, 10g,11g, MSSQL Server 2000/2005/2008
Front Ends : Forms 3.0/4.5, Visual Basic 3.0/4.0.
Database Tools : Oracle Enterprise Manager, SQL Navigator, TOAD, Erwin, DBArtisan, OEM 10g Grid Control,Tidal Enterprise Scheduler,MFT ( Managed File Transfer),
SCOM for SQL Server.
ETL TOOLS : Informatica 8.1.1,Informatica 9.0
Reporting Tool : Cognos 7.0

Professional Experience:

Confidential,
Parsipanny, NJ Oct ’06 –Till date
Database Administrator

Database Administrator with extensive experience in Oracle enterprise and Sql Server environements.

Responsibilities:

• Performed Installations, upgrades, monitor, performance tune and support operations in the Oracle and SQL Server environments.
• Monitored Databases for Government Pricing/Rebate Systems, Supply Chain, Documentum, Web applications implemented on Liferay and Business Objects Applications.
• Loading data in to the database using SQL*Loader, developed pl/sql scripts.
• Performed logical backups using Export/ Import utilities.Refreshing databases from production to test/dev environments.
• Working in a team to set up the in-house datawarehouse.
• Proactive Measures -- Tablespace estimates, benchmarking of databases, health check scripts, cache hit ratio monitoring and space analysis using OEM Grid Control.
• Built the Database Operations Guide and procces documents to install, create, upgrade databases. Manage other database activities like Backups/Recovery/Security etc.
• Developed solid test documentation and created and maintained comprehensive test plans and test cases

to support UAT and QA Testing.

• Invlolved in the team to set up the Sql Server 2005 clustred environment for all the enterprise application Databases
• Worked with EDI Transaction Data Sets 852 and 867, Wholesaler Data,Customers Data etc.
• Implementing backup strategies -- RMAN and User managed Backups.Involved in building a test server environmnt using RMAN Backup.
• Applied patches and service packs to keep the database at current patch level.
• User Management and Security in Oracle/SQL Server Databases.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Extensively used SSMO, Query Analyzer, and SQL Server Profiler.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SSIS.
• Experience in failover clustering ,worked using the Windows Cluster administrator.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Good knowledge in developing and designing reports through SSRS.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system using ERWIN, relationship Diagrams.
• Clone/Refresh of Production databases to Testing and training environments.
• Application tuning using Explain Plain, Tkprof and SQL Tracing.
• Maintaining transaction logs and Maintainance Plans in Sql Server.
• Provided technical assistance to vendors in development and implementation of packaged applications
• Working closely with the business users, application teams to understand the requirements and converting them into project level technical capabilities.
• Involved in writing shell scripts/Perl Scripts to extract data for performance, to automate database operations.

Environment: Windows 2000/2003/2008, Unix, Red Hat Linux,Oracle 9i/10g/11g,SAN, RAC, SQL, PL/SQL, TOAD, Oracle 10g Grid Control, Veritas Netbackup, ERWIN, Enterprise manager for SqlServer, SCOM (Systems Configuration Operations Manager), Sql Server Clustering, Windows Cluster Administrator, Aqua Data Studio 6.0, Informatica8.1, Informatica 9.0, Tidal Enterprise Scheduler, MFT (Managed File Transfer)/VLTrader.

Confidential,
Database Administrator.

Providing support for all the production, development and QA environments. I was in a team of 4 DBA’s.
Managing and coordinating all database activities. Administering, maintaining, developing and implementing policies and procedures for databases while ensuring the security and integrity of those databases.

Responsibilities:

• Provided 24 by 7 on call support.
• Installing & upgrading ORACLE database software.
• Updating, migrating, and refreshing database environments.
• Production Support of daily DBA sanity checks, space and health checks on Production and QA Databases.
• Reorg of the Databases.
• Monitoring memory, CPU utilization, disk utilization (I/O usage) and locks using OEM 10g Grid Control.
• Monitoring Tablespaces, alerts and other Metrics using OEM ORACLE 10g Grid Control.
• Involved in applying Oracle security patches to reach the Oracle standards using the OPATACH utility.
• Supported changes for all the audit trails.
• Application tuning using Explain Plan, TKPROF.
• Involved in writing shell scripts to extract data for performance.
• Created indexes, re-building indexes for performance improvement.
• Created, maintained ORACLE Database Import/Export scripts
• Granted DML privileges/roles for users, issuing quotas for tablespace/schema access.
• Created Stored Procedures, Functions, and Packages using TOAD.
• Using RMAN for backup and recovery methods

Environment: Sun Solaris, Oracle 9i/10g, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, OEM 10g Grid Control.

Confidential,
EzPay Systems
Database Administrator

Navy/Marine Cash was a highly successful pilot program deployed on 88 U.S. Navy ships. The new financial cash management system allows afloat Sailors and Marines to conduct personal banking and purchasing electronically while deployed. The system consists of an "electronic purse" on a commercial debit card, which utilizes both stored-value chip and magnetic strip technology. Navy/Marine Cash reduces the need for cash aboard the ship and significantly reduces workload afloat.

Responsibilities:

• Performing evaluations of potential tools & utilities.
• Installing and upgrading ORACLE databases.
• Automating database tasks via scripting or through the use of tools.
• Updating, migrating, and refreshing ORACLE database environments.
• Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues.

• Tuning and troubleshooting software & database performance issues.
• Data modeling, normalization, de-normalization, physical database design, relational models for

Several web-based applications.

• Ensuring database recoverability within the constraints of any application, project and other requirements.
• On-going SQL tuning using Explain Plan and SQL Trace
• Support UAT and QA testing.
• Involved in writing shell Scripts for Backup and recovery methods
• ORACLE Database maintaining including backups, restores, imports, exports
• Data migration, loading with SQL Loader
• Providing input to and/or producing metrics reports.
• Was a Production support DBA.
• Responding quickly to requests; even if only acknowledging receipt, providing an estimated time frame and/or gathering additional information.
• Producing and/or updating documentation and Standard Operating Procedures (SOPs).
• Providing input regarding ORACLE database standards and best practices.
• Advocating the upgrade of ORACLE database products to the latest standard versions.
• Performing multiple tasks and adjusting to changing priorities and deadlines. Negotiating deadlines with customers and keeping them informed of changes to manage their expectations.
• Working collaboratively with the project team and involving management only when necessary.

Environment: Sun Solaris 8, Oracle 9i/10g, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, ERwin Data Modeler.

Confidential,
Portfolio Management
Database Administrator

Portfolio Management (PM) is an enhancement project of the existing web based Portfolio Management (EQAccess). The Application server primarily contains EJBs, Business Object, Business Object Helpers, Data Access Objects and Web Service Client to get real time policy data from the legacy system, mainframe. EQAccess stores all pending transactions in the local Oracle database for a business day. Batch process kicks off at the end of the business day and extracts them into a formatted file with a header and footer. It also sends the formatted transaction file to MQ Series.Group transactions xml file will be received by the Group Message Driven Bean, which creates group transactions in the local Oracle database through the Group Stateless Session Bean with the help of Data Access Objects and its helper classes.

Responsibilities:

• Used Toad for Oracle to create Tables, Views, Synonyms and Stored Procedures.
• Improved performance of existing Queries and Stored procedures.
• Participated in database design sessions.
• Written shell script to extract daily transactions from Oracle database into flat files.
• Wrote stored procedures to insert data into archive database from production database and maintained archive database.
• Developed interfaces to transfer data from different applications using Oracle SQL*Loader,PL/SQL procedures.
• Worked on indexes on tables to create useful indexes and dropping some unnecessary indexes.
• Monitored memory, CPU utilization, disk utilization (I/O usage), locks/deadlocks and runtime of queries.
• Transformed and Loaded data from text files (from mainframe) to MS SQL Server 2000 database.
• Installed, configured and administrated Oracle9i in the integration and production environment.
• Applying Oracle security patches.
• Extracted, transformed, and loaded data from Oracle database to Microsoft SQL Server 2000 database using ODBC and Data Transformation Services (DTS).

Environment: Oracle9i, Toad, Microsoft SQL Server 2000/2005, PL/SQL, Microsoft Data Transformation Services (DTS), Microsoft SQL Enterprise Manager, UNIX Shell Scripts, Sun Solaris, Windows XP

Confidential,
Financial Analyzer
Database Administrator

Wells Fargo Financial Analyzer is a tool to analyze the day-to-day transactions and generates the reports.
Responsible for maintaining multiple instances Databases using SQL Server 7.0/2000 on Windows NT/Windows 2000 in Cassie Hill Data Centre.

Responsibilities:

• As a DBA responsible for installation, configuration, and setup various monitoring and support of more than 20 production, QA and development Database servers on 24/7 basis in banking environment.
• Developed and implemented Database Security, Security Lockdown, Backup & Recovery strategies
• Developed various TSQL, Stored Procedures, Triggers for Database monitoring
• Extensively worked on Backup and Recovery, Sizing, Database Optimization, SQL tuning and code optimization
• Experience in using ER-WIN
• Extensively worked on Server Hardware configuration and hardware upgrades
• Implemented automated scripts using WINBATCH for managing group of SQL Agent Services
• Experience in configuring Alarm and Alerts using Perl script, SQL Mail.
• Developed and implemented Business related Batch Job using Visual Basic
• Setting up Business resumption databases using DTS, BCP, Replication, Log shipping
• Experience in creating a SQL server Data warehouse and managing Cubes, Dimensions, Measures and handling MDX, ADO MD queries.
• Handling ETL tools like Act Works, Sagest and performance monitoring tools like Patrol, I Watch
• Developed an Infrastructure Database front-end using ASP, IIS, MS-SQL SERVER which contain Hardware/Software details of all Servers/Projects and linked the front-end to IBM Director Database.
• Experience in Change control Environment involving diversified Group of peoples

Environment: MS SQL Server 7.0/2000, Oracle 9i, MS-Access, Windows NT v4.0, Windows 2000, ASP, VB, IIS, Sybase, Unix, MTS, R-Admin, IWATCH, Patrol, DB Artisan, Crystal Reports, Win Batch, IBM Director.

Confidential,
Database Administrator

Manhattan project involves building both production and development instances. This project requires having two instances in same oracle home as both the databases are dependent. This environment is same in both production and development. Needs to create Manhattan database with another reporting database as Cognos reporting DB is present on both Production and development environment. Informatica is been used in various transformations for processing data from OLTP to OLAP. The project also involves applying security guidelines and patches for the new instances created on both the servers.

Responsibilities:

• Created test database and its application tablespaces. Created admin users and granted the role to the users with high level security to protect the database from unauthorized access.
• Implemented Index organized tables to improve the performance.
• Tuning of INIT parameters to improve the performance during data loading.
• Designed and mapping steps of daily and weekly ETL processes for reports.
• Generating the Dataflow Diagrams and ER Diagrams Using Erwin,
• Creating the Database Schema, converting VIEWS specific to database.
• Creating roles and users
• Applying Oracle security patches.
• Providing input regarding database standards and best practices.
• Advocating the upgrade of database products to the latest PwC standard versions
• Loading data from different sources to Target Data warehouse.
• Using RMAN for backup and recovery methods.
• Involved in writing Shell Scripts for Backup methods.
• Performing multiple tasks and adjusting to changing priorities and deadlines. Negotiating deadlines with customers and keeping them informed of changes to manage their expectations.
• Working collaboratively with the project team and involving management only when necessary.
• Monitoring and performance tuning.
• Recommend upgrades to software and hardware as it relates to the server and the client
• Installation of patches and enhancements to both clients and servers
• Participate in beta testing of new releases
• Create/maintain system documentation.
• Involved in ETL methods using Informatica.
• Generating reports using Cognos.
• Migrating Databases from Oracle 9i to MS-SQL Server 7.0/2000, IBM DB2 UDB8.1
• Creating DB Links in Oracle for communicating with external databases.
• Extracting data from different databases and maintaining.

Environment:
Sun Solaris 9, Oracle 9i, SQL Server 2000, SQL, PL/SQL, Cognos , Informatica , TOAD, Oracle Enterprise Manager, ERwin Data Modeler.

Confidential,
Management Report Generator (MRG)
Database Administrator

The MRG allows all the Team Members, Technical Leaders and Project Managers of a Project to update project status, review status, review logs & test cases online. It generates reports, graphs of defect measurement throughout the Project development life cycle. There are different levels of access depending on the role in the project. These reports/graphs were used for various level of assessment of the organization. The application was hosted on intranet to be accessed across all the branches of the organization. System also consists of auto mail generation with the report and log information, etc.; Report generation (server side data collection and manipulation) was speeded up with server side scripting using Perl/CGI.

Responsibilities:

• Developed server side Perl Scripts for data collection and manipulation for the reports
• Developed various stored procedures, triggers on MS SQL Server database
• Created many TSQL batch scripts for backend work.
• Design and developed DBI/DBD and DB Library connection Scripts for the data retrieval and data manipulation
• Designed and developed many Perl modules and package
• Design documents (Low & High Level Design, Design Level Document)
• Developed many HTML pages for data presentation and collection
• Participated in Unit/System testing
• Took part in project documentation

Environment: Perl, Java, CGI, Html, JavaScript, MS SQL Server 2000, DBI/DBD, DB Library, Apache Web Server, HPUX, Windows NT