Summary:

• Certified Project Management Professional PMP
• nearly 17 years professional experience in information technology
• Over 12 years' experience in oracle database administration.
• Expertise in Data mapping, ETL Extraction, Transformation and Load process from different data sources to centralize Database.
• Experience in Data Architecture, design, development for various application interfaces.
• Expertise in Data Cleaning, establishing the data Validation process and database standard.
• Worked as Development and Production DBA.
• Experience in developing change management process, re-engineering process and project management.
• Expertise in Data Modeling .It includes logical and Physical Data modeling.
• Experience in Process orientation and Technical Documentation. This includes creating of process flow, Data flow diagram, Data Quality validation and automation.
• Two years plus experience as Oracle Apps DBA for Oracle Financial application..
• Team lead for various projects.

Technical Skills:

• Database
• Oracle 7.3, 8.0, 8i, 9i, 10g,11g,Universe
• Software
• Microsoft Project, Platinum Erwin 5.0, ,Mercator 5.0, Oracle Developer 2000, 6i, Toad, Oracle Application express, Oracle Discoverer, Crystal Report, Microsoft SharePoint ,Visio's developer, SEER case tool .
• GUI/Languages
• UNIX Shell Scripting, SQL, Oracle PL/SQL, C, Pro C
• Enterprise Application
• Oracle EBusiness Suites 11i, Master pack
• Environments
• HP-UX, Sun Solaris, Windows 2000/NT/XP/2003, Linux, SCO UNIX,SAN architecture
• Hardware
• HP 9000 Servers, Sun Enterprise 6500, Sun Enterprise 10000, Fujitsu Prime Power 1500

Professional Experience

Confidential

Sr. Oracle DBA

• Responsible for consolidating the databases, create University's centralized database environment, installing, configuring, maintaining oracle databases, oracle Binary patching, database cloning , Database upgrades, Backup, Recovery, tuning, creating secure database environment as per APA and VITA security policy guidelines.
• The responsibility also includes for working on process improvement, technology improvement and creating better coordination among our DBA team members, developers, users, vendors and other stake holders.
• As a part of DBA, responsibility involves - 24 7 on call support based on rotation, support and work with team members to make sure that objective can be achieved within planned and approved downtime. Document the issues, fixes and update those solutions as a part of process improvement.
• As Database architect, responsible to perform impact analysis for various interface programs, data sources, review existing application's Data model, propose required changes in the data model to development team, provide required help in various ETL process, maintain application and database related other components, doing proper impact analysis before database upgrades or application migration.
• The complete process goes through various testing cycle in development, preproduction and production environments. Hence as a DBA, I am also responsible to support Production, Preproduction and Development environment.
• Mar2009 Sept2011 DEQ- Department Of Environmental Quality.

Confidential

Sr. Database Administrator

• Patching , Cloning ,Backup and recovery , Performance Tuning , Data Purging and supporting oracle Discoverer Reporting, Customization oracle Forms and Report , writing various interface program to integrate oracle E-business application to other applications, Data Loading using Oracle APIs as well as with other utility .
• Customization and development of various programs, so that user should be able to access the consistent information from various data sources. Automated various processes.
• Upgraded all the non e-business databases from 9i to 10g .Upgraded some of the databases from 10g to 11g.
• Upgraded e-business databases from 9i to 10g with all the required application components.
• Regular maintenance and developing and maintaining custom oracle forms and reports for oracle financial, Oracle HR.
• Maintenance of non ebiz oracle Databases which include, creation of databases, backup and recovery, performance tuning, upgrade, patching and provide 24 7 supports.
• Provided DBA support for SQL server databases.

Confidential

Senior Oracle DBA

• Involved in identifying and recommending infrastructure needs
• Contribute to the design and implement of a disaster recovery plan to support mission critical databases
• Coordinate with development team and business users to establish service level agreements
• Install, configure and maintain Oracle software across the organization
• Establish and implement backup and recovery procedures
• Support a 2-teir server framework with an isolated development/test and production tier
• Plan and design the layout to automate various processes, application interfaces with the help of the Development team.
• Provide 24 7 on call Database support.
• Document and test high availability of the databases and related processes
• Develop processes to monitor data quality
• Design and maintain logical and physical data models.
• Identify and resolve database administration, integration and security issue

Confidential

Data Warehouse

• Developed and maintained project plan
• Extensive database extraction, data mapping from hierarchical database design to relational design, logical and physical Data modeling.
• Oracle database administration
• 24x7 on call support
• Data conversion and cleansing
• Database migration
• End user support and training
• Logical and physical modeling
• Report design and development

Confidential

Senior Oracle DBA/ Oracle Consultant

• Physical and logical data modeling using ERWIN
• Database analysis and design, configuration and setup
• Understand source applications and analyzing the data and provided required information to various levels of users
• Involved in ETL process and successful completion of data conversion of very large application. Writing PL/SQL scripts and SQL loader scripts for transferring data
• Developed database backup recovery scripts
• Developed scripts for proactive database monitoring
• Involved in development of the data warehouse for the transportation system
• Performed the tuning of resource intensive queries, application tuning as well as database tuning
• Involved in development of Data Marts with ETL tool Mercator 5.x
• Database cloning for various development and test initiatives
• Troubleshooting various database issues like archive errors, memory issues, connectivity
• Data Provider to Development and testing team for various testing purposes
• Continuous database support to Development and testing Team
• Requirement gathering from business users, analyzing and development of the reports
• Defining Partition strategy for tables
• Data extraction/Transformation/Cleaning/Loading using SQL Loader and PL/SQL
• Automated Extraction and loading process
• Granting the proper roles and privileges to the related users
• Used UTL File to transform data from many flat files to single table
• Created materialized views, written scripts for refreshing the Materialized views
• Tuning Oracle Database memory such as buffer cache and share pool

Confidential

Senior System Officer

• Developed predefined 'canned' reports using Oracle SQL ReportWriter 1.1/2.5
• Created front-end analytical applications using Oracle Forms 3.0/4.5/5.0
• Established, monitored, and forecasted database space requirements
• Assisted developers in designing physical and logical data models
• Implement Oracle instances based on the access characteristics and user expectations response time, OLTP vs. Batch Processing vs. DDS/OLAP
• Installed, configured and maintained Oracle software across a variety of platforms
• Coordinated and contributed to end-user training
• Assisted in the migration and testing of a number of Oracle tool version upgrades
• Developed UNIX shell scripting to perform routine tasks
• Developed extraction, transformation, validation and load programs
• Provided technical support for end-user connectivity issues
• Established and implement backup and recovery procedures
• Coded PL/SQL store procedures, packages, functions, and triggers
• Performed periodic and critical on-demand database performance tuning
• Managed user provisioning