PROFESSIONAL SUMMARY:

• Having 10 Years of experience in Information technology with a strong success record in Database Administration, System Analysis & Design, SDLC, Software Development and Expert in Trouble shooting of Oracle Applications Patching and Performance issues. Good experience in writing PL/SQL code, Performance tuning of PL/SQL and good experience in Data Modeling
• Demonstrated skills include: Confidential management, requirements analysis, Installation and Configuration, ETL design, Cubes, Metadata modeling, Report development, enhancement and performance tuning and workload automation. OWB 11g and Data Stage 8.0.1 & 7.5.
• Experience in software architecture, analyzing, design, development, research, implementation, Migration of (Non Oracle to Oracle) and Support.
• Strong knowledge and experience with Oracle 11g/10g/9i/8i/8.x/7.x RDBMS on UNIX/Linux/ Windows environment and 8 months experience on 12c database
• Experience on GoldenGate
• Ability to grasp and adapt new technologies and systems quickly. A committed team player.
• Knowledge and proven domain expertise in Energy & Utility areas and Policing.
• Worked on more than 1 TB of Data.
• Installation, up gradation and maintenances of Oracle RDBMS on UNIX/Linux and Windows platforms.
• Backup of database Logical and Physical (hot and Cold) Procedures and also using RMAN.
• Recovery of database in case of database crash, disk /media failure etc.
• Database design and Implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database tuning, application tuning and performance monitoring using STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ASH, ADDM report.
• Create and maintain documentation and standards.
• Capacity planning, capacity monitoring and management.
• Work as a part of team and provide 24x7 supports when required.
• Perform general technical troubleshooting and give consultation to development teams.
• User requirement study
• Creating libraries for standard reusable procedures & functions.
• Prototype development based on the design specification.
• Installation and setting up the software for run time environment.
• Training the end users.
• System support modifications according to the user request.
• Writing data conversion procedures.
• Integrated testing of application.
• Implementing and Managing RAC.
• Good interpersonal skills, committed, result oriented hard working with a quest and zeal to learn new technologies.
• Strong Exposure to SQL queries.
• Having Good Experience in writing Cursors, Function, Procedures, Packages and Triggers.
• Having Good Experience in Fixing the Bugs in PLSql Code.
• Having good experience with TOAD and SQL * Loader to load data from flat files Creation of Tables, and Control files, PL/SQL Stored Procedures, SQL*Plus
• Having Good Knowledge on Using Benthic Software Tools.
• Experience in handling customer queries and providing support.
• Involvement in requirements analysis and software design phase and written detailed design documentation.
• Involved Client meetings
• Having Good Experience in PL/SQL Performance Tuning.
• Having Good Knowledge on Using Oracle SQL Developer Tool for Migration Purpose.
• Done Migrations from Non - Oracle to Oracle Databases using SQL Developer migration tool.
• Experience in Migration projects (SQL Server 2005 and 2008 to Oracle database 11g).
• Good Experience in Migrating SQL Server Database object to Oracle Database Objects
• Experience in Migration projects (Sybase 11.5 to Oracle database 10.2).
• Having Good experience on Migrating Sybase to Oracle.
• Having Good Knowledge on Understanding Sybase Code.
• Good Experience in Migrating Sybase Database Objects to Oracle Database Objects
• Having Good experience on converting the Sybase Scripts to Oracle Scripts.
• Experience in formulation of quality code review process and implementing it.
• Experience in handling Database Team
• Testing and Code walkthrough of migrated scripts.
• Involved in Documentation of Confidential related
• Good Knowledge on Installing Database, Creating Table Space and Creating User's
• Maintained Database Server's our end.
• Excellent knowledge using Oracle Forms Developer 6/6i and Reports 6/6i.
• Load and extract formatted data in and out of database (ETL).
• Experience on architects, designers developers to translate data requirements into the physical schema definitions for Oracle.
• Good experience on analysis of database deadlocks and database performance tuning.
• Thoroughly analyze and understand internal systems from a database perspective
• Perform detailed analysis of the database for areas of optimization (e.g. tablespace, flashback log, undo, redo and archive log management, compression and partitioning techniques).
• Develop robust and complex PL/SQL applications to solve business problem
• Evaluate database for performance (latency, throughput, SQL) and makes/recommends changes where appropriate
• Act as a primary point person to support both development and operation concerns.
• Assist with implementation by working closely with developers, resolving questions and issues around business/functional requirements
• Provide critical production support, resolve production problems.
• Enforce appropriate database standards are adhered to by development team.
• Encourage and train development personnel on database concepts and Oracle technologies
• Adhere to corporate and department standards, policies and procedures. Contribute to the development and refinement of department standards, processes and procedures
• Expertise in development, care, and maintenance of logical and physical ERWin data models, along with corresponding metadata.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitateddatarequirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository.
• Established and maintained comprehensivedatamodel documentation including detailed descriptions of business entities, attributes, anddatarelationships.
• Developed mapping spreadsheets for (ETL) team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, and corporate meta-datadefinitions.
• Exceptional communication and presentation skills and established track record of client interactions

TECHNICAL SKILLS

RDBMS: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g and 12c

OS: Windows XP, 2000, Dos and Unix

Reports: Reports6i

Languages: SQL, PL/SQL

Tools: Toad, FTP, SQL*Loader, SQL Developer, Winscp, Putty and OEM

PROFESSIONAL EXPERIENCE

Confidential, PA

Senior DBA/Developer

Platforms:Oracle 11g, SQL, PL/SQLSQL Loader, Toad and SQL Developer

Responsibilities:

• Installation & configuration Oracle Grid Software 12c and Oracle 11g database/software on Windows boxes (DHS - Pennsylvania application).
• Designed logical and physical data model using Erwin 8.2.05 includes 11 interfaces.
• Designed Application user access security including security schema data model and Pl/sql packages.
• Production support, upgrades, patching software and performance monitor production DBs.
• Support to Application development team (SDLC) for new application releases. Design database schema structure for database objects (Table, View, Synonyms, and Sequence), database code (procedure/function and packages), and Reference tables for XML and application access user.
• Design and implement database standards like Table/Column/Seq/Proc/Func/Package naming convention and pl/sql coding standards.
• Design/Develop application release deployment playbook/steps and perform production go live.
• Monitoring Production database for ora error, locks, wait events, Latches, scattered read, locks, blockers.
• Responsible for SQL and PL/SQL tuning and full support to development/application team (35 developers) for various tasks.
• Monitoring load testing, capture CPU stats, high execution/time taking queries and perform performance improvement task.
• Support conversion process from legacy system to OLTP systems.
• Database development/Application support for application patches/versions/builds, perform complete database production go-live for CHATS including playbook design and implementation.
• Perform QA check on team’s Subprograms like Procedure, Functions, Triggers and Packages.
• Responsible for writing ksh shell scripts and setting cronjobs for space alerts, CPU idle, long running SQL and locks.
• Index monitoring (usage), designed new Indexes by monitoring performance of existing code and new development code before deployment on production db.
• Responsible for regular O/S Administration like CPU load, IDLE CPU %, time taking session/processes, Disk and Memory usage, and File system monitoring.
• Responsible for backup and restore process for all the environments.
• Configured RMAN backup process for production database.
• Configured export backup for lower environment database backups.
• Refresh database/schema using old baseline database snapshot timely basis.
• Actively interfaced with other internal organizations to anticipate the support needs of the application areas.
• Assisted in developing the Disaster Recovery and backup procedures along with the system administrators.
• Directed and administered database planning and development.
• Performed Oracle upgrades, creation of standby database and database tuning.
• Established and implemented policies and standard operation procedures pertaining to database security, maintenance and use.
• Set standards and advised management on database concepts, importance and pitfalls.
• Set up and maintaining Oracle Datamarts (ETL process)
• Instance management: experience in managing and maintaining multiple instances of various Applications with scheduled and ad-hoc requests for instance cloning and refreshes.
• Interaction with business users and helping with the requirements..
• Responsible for effective business communications with analysts, users and the technical staff.
• Created Tables, Views and Indexes
• Developed Stored Procedures, Packages, Functions and Triggers
• Participated in the evaluation of the appropriate use of technologies, including hardware, utilities, purchased software and data access.
• Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.
• Uploading the Data through OWB using Admin Tool
• Uploading the PL/SQL Code in Client System
• Coordinating with Onsite Team about the Maintenance Issues
• Fixing the Bugs in PL/SQL code
• Fixing the Bugs in ETL Tool OWB
• Resolved replication issues in Goldengate
• Implemented flatfile load into HBase using Goldengate and Flume
• Develop and provide support to all system interfaces and coordinate with all Confidential managers to provide specifications for all core modules.
• Coordinate with various developers, Confidential managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
• Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.
• Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution.
• Design and analyze all computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics.
• Collaborate with various departments and perform research on all data processing functions.
• Developing Packages, Stored Procedures, Functions, Cursors, Triggers, and Views etc.
• Code review and looking into the Performance Tuning possibilities of SQL and PL/SQL code
• Analyzed database requirements in detail with the Confidential stakeholders by conducting Joint Requirements Development sessions
• Developed a Conceptual model using Erwin based on requirements analysis
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards for data warehouse
• Exhaustively collected business and technical metadata and maintained naming standards
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement

Confidentia

Application DBA

Responsibilities:

• My role involved handling escalated issues and mentoring all the team members.
• 40 closure provided every week, and single handedly resolve 10 Sev1 at least per day
• Customer escalations of the team were handled very smoothly and quick resolutions provided.
• Have to my credit 30+ Meta link notes that have been published over the years on Payables.
• Providing quality solution to numerous technical and functional issues for Payables module and General Ledger module in R11 & R12
• Provided training in 11i Data model, Issue diagnostics - General issue as support point of view, Performance issues, upgrade issues and also for support process, Orion access, defect creation & OD SR handling.
• Several Customer exceptional service nominations received and have got 10/10 rating.
• Looking into the Performance Tuning possibilities of the application PL/SQL code after generating the various reports

Confidential

DBA/Developer

Responsibilities:

• Installation of Oracle 11g Database Instance and SQL Server 2005
• Table Space Creation
• User’s Creation
• Database Creation.
• Naming Conventions
• Creation of Migration Checklist.
• Data Loading through Loader scripts.
• Conversion of SQL Server Data types to Oracle.
• Conversion of SQL Server T-SQL functions to Oracle
• Using SQL Developer Tool for Database Automatic Migration
• Conversion of SQL Server Hash Tables to Oracle Temporary Tables.
• Creating prototypes and Test Suit.
• Testing and Code work through of migrated code.
• Migrating SQL Server Procedures and Functions to Oracle Plsql Procedures.
• Developing the Scripts Called SQL Loader Scripts for Data Loading.
• Maintained Overall Database Migration Plan Doc’s
• Code review and looking into the Performance Tuning possibilities of SQL/PL/SQL code

Confidential

DBA/Developer

Responsibilities:

• Responsible for Oracle 9i/10g/11g logical and physical databases design, implementation, and maintenance
• Implemented backup and recovery procedures of databases in Sun Solaris and Red Hat Linux environment:
• Managed database remodeling and interface development during migration from Sysbase to Oracle 9i and then to Oracle10g
• Oracle High Availability using Veritas.
• Actively interfaced with other internal organizations to anticipate the support needs of the application areas.
• Assisted in developing the Disaster Recovery and backup procedures along with the system administrators.
• Directed and administered database planning and development.
• Performed Oracle upgrades, creation of standby database and database tuning.
• Established and implemented policies and standard operation procedures pertaining to database security, maintenance and use.
• Set standards and advised management on database concepts, importance and pitfalls.
• Instance management: experience in managing and maintaining multiple instances of various Applications with scheduled and ad-hoc requests for instance cloning and refreshes.
• Interaction with business users and helping with the requirements..
• Responsible for effective business communications with analysts, users and the technical staff.
• Created Tables, Views and Indexes
• Participated in the evaluation of the appropriate use of technologies, including hardware, utilities, purchased software and data access.
• Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.
• Naming conventions, Creation of Migration checklist, Data Loading through Loader scripts, Conversion of Sybase data types to Oracle.
• Use of the Oracle SQL Developer Tool.
• Conversion of Sybase Hash Tables, Creating prototypes and Test Suit, Testing and Code work through of migrated code.
• Migrating Sybase Start Load and Post Load Scripts to Oracle.
• Migrating Sybase Code to Oracle Plsql Procedures.
• Migrating Sybase Code to Oracle Functions.
• Developing the Scripts Called SQL Loader Scripts for Data Loading.
• Creating the Tables.
• Converting the Sysbase Scripts to Oracle Scripts
• After migration looking into the code review and looking into the Performance Tuning possibilities of SQL/PL/SQL code

Confidentia

Responsibilities:

• Responsible for Oracle 9i/10g/11g logical and physical databases design, implementation, and maintenance
• Implemented backup and recovery procedures of databases in Sun Solaris and Red Hat Linux environment:
• Managed database remodeling and interface development during migration from MS SQL to Oracle 9i and then to Oracle10g
• Oracle High Availability using Veritas.
• Actively interfaced with other internal organizations to anticipate the support needs of the application areas.
• Assisted in developing the Disaster Recovery and backup procedures along with the system administrators.
• Directed and administered database planning and development.
• Performed Oracle upgrades, creation of standby database and database tuning.
• Established and implemented policies and standard operation procedures pertaining to database security, maintenance and use.
• Set standards and advised management on database concepts, importance and pitfalls.
• Set up and maintaining Oracle Datamarts (ETL process)
• Instance management: experience in managing and maintaining multiple instances of various Applications with scheduled and ad-hoc requests for instance cloning and refreshes.
• Interaction with business users and helping with the requirements..
• Responsible for effective business communications with analysts, users and the technical staff.
• Created Tables, Views and Indexes
• Developed Stored Procedures, Packages, Functions and Triggers
• Participated in the evaluation of the appropriate use of technologies, including hardware, utilities, purchased software and data access.
• Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.
• Uploading the Data through OWB using Admin Tool
• Uploading the PL/SQL Code in Client System
• Coordinating with Onsite Team about the Maintenance Issues
• Fixing the Bugs in PL/SQL code
• Fixing the Bugs in ETL Tool OWB

Confidential

Responsibilities:

• Develop and provide support to all system interfaces and coordinate with all Confidential managers to provide specifications for all core modules.
• Coordinate with various developers, Confidential managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
• Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.
• Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution.
• Design and analyze all computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics.
• Collaborate with various departments and perform research on all data processing functions.
• Developing Reports by using Reports6i.
• Developing Packages, Stored Procedures, Functions, Cursors, Triggers, and Views etc.

Confidential

Responsibilities:

• Responsible for Oracle 9i logical and physical databases design, implementation, and maintenance
• Implemented backup and recovery procedures of databases in Sun Solaris and Red Hat Linux environment:
• Managed database remodeling and interface development during migration from MS SQL to Oracle 9i and then to Oracle10g
• Oracle High Availability using Veritas.
• Actively interfaced with other internal organizations to anticipate the support needs of the application areas.
• Assisted in developing the Disaster Recovery and backup procedures along with the system administrators .
• Directed and administered database planning and development.
• Performed Oracle upgrades, creation of standby database and database tuning.
• Established and implemented policies and standard operation procedures pertaining to database security, maintenance and use.
• Set standards and advised management on database concepts, importance and pitfalls.
• Instance management: experience in managing and maintaining multiple instances of various Applications with scheduled and ad-hoc requests for instance cloning and refreshes.
• Interaction with business users and helping with the requirements..
• Responsible for effective business communications with analysts, users and the technical staff.
• Participated in the evaluation of the appropriate use of technologies, including hardware, utilities, purchased software and data access.
• Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.