PROFESSIONAL SUMMARY:

• Having 11 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 AWS EC2, RDS Instances, S3 Bucket and Cloud Berry and Data Modeling and Golden Gate
• Involved with installation and maintenance of Oracle 12c RAC /Oracle 11gRAC / Oracle 10g RAC and standby database for High Availability and Disaster Recovery purpose.
• Wide experience in infrastructure layout, provisioning. Extensive experience in Amazon AWS cloud infrastructure with RDS, EC2 Instances and particular reference to provisioning, security, and management.
• Experience in managing Oracle databases running on MS - Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 12c/11g/10g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Clusterware administration, Configuration and Patching.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Streams, GoldenGate Replication.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring/performance/diagnostics.
• Experience in software architecture, analyzing, design, development, research, implementation, Migration of (Non Oracle to Oracle) and Support. 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
• 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 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.
• Capacity planning, capacity monitoring and management.
• Perform general technical troubleshooting and give consultation to development teams and 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 and System support modifications according to the user request.
• Integrated testing of application, Implementing and Managing RAC.
• 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 and Experience on Using Benthic Software Tools.
• Experience on Migrations from Non-Oracle to Oracle Databases using SQL Developer migration tool (SQL Server 2005 and 2008 to Oracle database 11g and Understanding Sybase Code.
• Excellent knowledge using Oracle Forms Developer 6/6i and Reports 6/6i.
• Experience on Database architects, designers developers to translate data requirements into the physical schema definitions for Oracle.
• 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).
• 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.
• Facilitated data requirement 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.
• Experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers 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.
• Established and maintained comprehensive datamodel documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Good Experience in writing Cursors, Function, Procedures, Packages, Triggers and PL/SQL Performance Tuning, Fixing the Bugs in PLSql Code.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.

TECHINICAL SKILLS:

RDBMS: Oracle 12c, Oracle 11g RAC, Oracle 10g RAC, oracle 9i, SQL Server

Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows 2003/2005.

High Availability, Tuning& Monitoring Products: Oracle 10g RAC, Oracle 11g RAC

Tools: & Utilities: ASM, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump (expdp/impdp), SQL Loader.

ETL & Reporting Tools: Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS

Backup Tools: Veritas NetBackup, NetApp, HP

Programming Languages: SQL, PL/SQL,C,C++, XML, Java.

ERP: Oracle Apps 11i & R12

PROFESSIONAL EXPERIENCE:

Confidential, MA

Environment: Oracle 12C /11g RAC, Redhat Linux, Oracle Linux, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate, AWS EC2, RDS, S3 Bucket and Cloud Berry

Responsibilities:

• Created, implemented and managed custom Oracle databases on Linux and windows platforms
• Provided Oracle database administrative support to various user groups (application developers, data managers etc); created and maintained Oracle database objects (schemas, tables, indexes etc)
• Analyzed and tuned voluminous SQL code
• Performed capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance
• Performed backup and recovery tasks on Oracle database using RMAN and cold back -ups using shell scripts
• Installed and configured Oracle 12C databases
• Using RMAN to restore and recover control and data files respectively
• Performed a flashback and point in time recovery
• Creating a database recovery catalog and registering databases to the recovery catalog database
• Scheduling backups using the crontab utility
• Supported system administration groups with maintaining oracle database servers and in pre-production, test, training, and development environments
• Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing
• Database design, database systems design, architects the full SDLC complaint database infrastructure.
• Designed AWS infrastructure to move our local applications to hybrid cloud, as an intermediate stage and then it will all public cloud.
• Provisioned servers, involved in setting up VPNs, VPCs, and provisioned database servers include RDS instances.
• Established Standards of Operating Procedures to migrate, and manage applications to cloud.
• Established security policies in the AWS cloud.
• Provided disaster recovery processes in the hybrid and public cloud.
• Also quite involved with other cloud architectures not just AWS. Actively participate in development efforts, application design, and QA activities.
• Provided Development and operations lead role for Oracle based applications.
• Provisioned EC2 instances in the AWS cloud, Patching EC2 servers and databases in AWS cloud
• Allocate S3 buckets and create databases on AWS cloud
• Create roles, groups, multi user authentication with (IAM) AWS services
• Control and monitor user access to the database using roles, and profiles
• Strong knowledge in Database Monitoring and Performance Tuning by using AWR Statspack, ASH Report and Explain Plan.
• Strong knowledge in Database Security and User Management through Authentication, Auditing, Encryption and Enterprise Security for availability, liability and integrity for the organization.
• 24hrs on call rotation
• Performed data migration from a database in one server to a database housed on another server using database link
• Migrated data using the data pump export (expdp) and import (impdp)
• Have dealt with both Agile and Waterfall applications

Confidential, FL

Environment: Oracle 11g RAC/10g RAC, HP-UX, Redhat Linux, Sun Solaris, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader

Responsibilities:

• Installation & configuration Oracle Grid Software 11g database/software on Windows boxes.
• Involved with installation and maintenance of ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• 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), writing 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 (More than 100 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.
• 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.
• Performed Oracle upgrades, creation of standby database and database tuning. Established and implemented policies, standard operation procedures pertaining to database security, maintenance and use.
• Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.
• Code review and looking into the Performance Tuning possibilities of SQL and PL/SQL code
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• 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.
• 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
• 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 Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Confidential, PA

Environment: Oracle 11g RAC/10g RAC, HP-UX, Redhat Linux, Sun Solaris, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

Responsibilities:

• Installation & configuration Oracle Grid Software 12c and Oracle 11g database/software on Windows boxes (DHS - Pennsylvania application).
• Involved with installation and maintenance of ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• 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), writing 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 (More than 100 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.
• 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.
• Performed Oracle upgrades, creation of standby database and database tuning. Established and implemented policies, standard operation procedures pertaining to database security, maintenance and use.
• Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.
• Uploading the Data through OWB using Admin Tool
• Resolved replication issues in Goldengate and Implemented flatfile load into HBase using Goldengate and Flume
• Code review and looking into the Performance Tuning possibilities of SQL and PL/SQL code
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• 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.
• 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
• 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
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Confidential

Environment: Oracle 12/Oracle 11g RAC, REDHAT LINUX, ASM,OEM (Grid Control), IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, AWR, ADDM

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

Environment: SQL Server 2005, Oracle 11g, SQL, PL/SQL, SQL Loader and SQL 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

Environment: Sysbase v11, Oracle 10g, SQL, PL/SQL, SQL Loader and SQL 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:
• 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.
• Managed database remodeling and interface development during migration from Sysbase to Oracle 9i and then to Oracle10g
• 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 SQL Loader Scripts for Data Loading. Creating the Database Objects. 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