SUMMARY:

• Sr. Oracle Database Administrator / DeveloperA dynamic Oracle Certified Professional Having More than 11 years of strong experience in requirement gathering, analysis, design, development, testing, implementation, support and maintenance of client/server applications using Oracle PL/SQL/ SQL Server. Currently working as a Sr. Oracle Database Administrator at Santander Bank, Greater Boston, MA. Core competence in Oracle Technologies including Informatica and Developer tools, Administration and Performance Tuning. Good in Oracle Back - End Programming and Relational Database Management System concepts. Developed complex business logic using Oracle PL/SQL (Functions, Procedures, Packages, Cursors and Triggers) and good in UNIX Shell Scripting. Possess very fair understanding of ETL Process. Strong interpersonal skills in interacting with End-Users, Excellent work ethics, self-motivated, quick learner, team player and team oriented.
• Over 11 years of experience in Application and Product development using Oracle PL/SQL as Oracle Database Developer.
• More than 5 years’ extensive experience as Database Administrator. Working extensively on maintaining highly transactional, highly available, large Oracle Database.
• More than 5 years of experience in leading the team which includes assigning the task, assist the team technically and functionally.
• Expertise in RDBMS Concepts, Oracle SQL, PL/SQL, Store procedures, Functions, Packages, Triggers, Cursors.
• Expertise in Data modeling by identifying tables needed for the project based on the requirement and creating related tables with required relationship.
• Expertise in Oracle Materialized Views, Bulk operations, Collections, Dynamic SQL, Object Types, Records and Exception Handling.
• Expertise in table partitioning, sub-partitioning, creating local index for the partition and managing the partition like drop, truncate, move.
• Expertise in Explain plan, Performance tuning, Query Optimization, TKPROF and passing hints and analyzing the table to collect table statistics for improving performance.
• Expertise in Oracle table indexing by analyzing various fields will be used to query the table and creating unique, non-unique, bitmap, b-tree, function based indexes as required.
• Extensively worked on Oracle Advanced features ACS, Histograms, Baseline Plan and pinning SQL.
• Expertise in creating and maintaining large Tables, Views, Synonyms, Sequences, Global Temporary Tables, Oracle Jobs, Scheduler, DB Links, EXPDB, IMPDB, External Tables, Java Objects and XML.
• Schedule and manage Oracle RMAN incremental and full backups and recovery, proactively maintain and manage OS, DB and Tablespace storage, Create, alter, and drop users and roles, Monitor and audit database access.
• Develop, implement, and manage a security strategy (or security policy), including use of users, roles, privileges, and authentication.
• Implement the physical database from the logical design, create and maintain database.
• Allocate and manage physical storage structures (data files, redo logs, control files), Allocate and manage logical storage structures (tablespaces, schemas, extents). Perform capacity planning, tuning and troubleshooting.
• Performing Exports and Imports of database objects as required, Backup and recovery of mission critical databases.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports, v$ Dynamic performance view and providing recommendations.
• Assist in the configuration and manage oracle databases in data guard environment
• Good experience in using SQL Loader for loading millions of records. Experience in working Database of size more than 5 terabytes
• Migration of database from one server to another server. Good experience working with various FTP protocols like FTP, SFTP, LFTP and SCP
• Good experience managing files in UNIX Shell Script and batch processing, CronJob, Autosys, and controlM
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Extensively worked on data replication tool to load large volumes of data from source to target data warehouse.
• Hands on experience in developing ETL mappings using tools like Informatica Power Centre consisting of data sourcing, transformation and loading into OLAP systems.
• Developed various mapping using ETL Informatica Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sorter and Sequence Generator transformations.
• Extensively used Agile Methodologies, it helps teams respond to unpredictability through incremental, iterative work
• Experience in Production on call 24/7 Support and working as BAU
• Over 5 years of experience in Banking and Financials domain, around 4 years’ experience in Telecom and more than 1 Year experience in Healthcare Domain.
• Experience in Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools like TOAD, SQL Develop, PL/SQL Developer, SQL Tools
• Thorough experience on software development methodology, worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation.
• Created and Scheduled Weekly QlikView reports

TECHNICAL SKILLS:

Operating Platforms: Window NT/2000, Windows XP, Unix, Linux

DBMS/RDBMS: Oracle 9i, 10g, 11g, 12c, DB2, SQL SERVER, MySQL, TSQL, Teradata, Sybase

Programming Languages: SQL, PL/SQL, Advance PL/SQL, JAVA, J2EE, JAVA Script, HTML, HTML5, CSS (2.1/3), XHTML, JQUERY, ANGULAR, BOOTSTRAP, JSON, XML, XML, C, C++, Putty, WinSCP

ETL Tool: Informatica, ODI

Scripting: Shell Scripting, Perl Scripting, Control-M

Configuration Management Tool: SVN, CVS, JIRA, GIT

Case Tools: TOAD, PL/SQL DEVELOPER, SQL DEVELOPER, SQL*Loader, SharePoint, ERWIN, Qlikview, Tableau, SAS

SDLC: Agile Methodology, Waterfall Model

WORK EXPERIENCE:

Confidential, Boston, MA

Senior Oracle Database Administrator

Environment: Oracle 12c, Forms 10g & Reports10g, ASP, SQL PLUS, PL/ SQL, Pro*C, SQL*Loader, UNIX Shell Scripts, Data Stage, Business Objects, SQL Navigator, TOAD, JAVA, J2EE, JAVA Script, HTML, HTML5, CSS (2.1/3), XHTML, JAVASCRIPT, JQUERY, ANGULAR, BOOTSTRAP, JSON, XML

Responsibilities:

• Working in the financial domain, as database administrator to create, validate and deliver monthly, quarterly and annual CCAR (FR Y-14) reporting requirements with Moody’s Analytics Regulatory Reporting Module.
• Interacting with business users in understanding business application, business data flow, data relations and the various logistics processes.
• Arranged meeting with business/Business analyst to understand application requirement and provided provided suitable technical solution for development.
• Strictly followed Agile method for software development and attend scrum call and sprint planning meeting.
• Tuned SQL queries / PLSQL code using various tuning techniques to make it perform as per the application requirement.
• Analyzed Explain plan / access path of SQL query to understand the query execution to make it performance effective.
• Used Oracle 12c features to limit query up to specified limit and faster execution.
• Extensively used BULK COLLECT /FORALL and collection for faster PLSQL processing.
• Worked on Database Links and Bulk Collections to perform bulk data loads into database tables from upstream application.
• Analyzed database table partitioning strategy to create better access path for the SQL query depending on column used to fetch application data.
• Performed DBA activities like, creating table, indexes, sequences, views, triggers, materialized views, grants, impdp/expdp utilities in Oracle Database12c/Exadata.
• Worked on table partitioning (Range and List) and deploying local indexing on partioned tables.
• Wrote PL SQL query for investment management section to retrieve data from the database create report for the executives.
• Developing Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, SQL scripts to facilitate the functionality for various modules.
• Experience in loading data from Flat files and XML files into database, performing business validations on the data using PL/SQL Procedures, SQL*Loader.
• Created Materialized Views, Tables, Complex SQL queries, and Correlated Sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Tuned database SQL statements and procedures by monitoring run times and system statistics and Optimized existing complex SQL queries using utilities like Hints, Explain Plan, SQL Trace and TKPROF, improve Query Cost and CPU Utilization.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Holding teleconference calls with offshore team at nights to explain the requirements and providing technical guidance.
• Used packages, functions and procedure for investment management, capital market and fixed income system database to improve system performance.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Performance Tuning and Optimization to improve the performance of the system using view, Materialized view, local and global Partition, Index, Index rebuild.
• Regular investigation on high Load, locks, blocks, deadlock using OEM, ASH, ADDM and AWR.
• Troubleshooting database using Alert log and Trace file processing.
• Migration script checking, preparing and running in production including downtime estimation.
• Data Backup, Restore and Recovery using Oracle DataPump, Hot/Cold Backup and RMAN.
• Database Replication Maintenance using Oracle GoldenGate and DataGuard.
• Data warehouse implementation, R&D on developing ETL system.
• Implement data storage, archiving, database/Schema comparison.
• Data conversion, mapping and related coding (java). Data migration from excel to oracle database.
• Implementing Database security. Hands on experience with Oracle Database 12c with Oracle Advanced Security, Database Vault, Audit Vault, Key Vault and Database Firewall.
• Responsible to unload data from client secured database using sftp and other secured utilities; ETL
• Load data using Oracle SQL*Loader and other utilities
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, STATSPACK, and manual scripts
• Experience and responsible for Backup / Disaster Recovery, Replication using Oracle Data Pump, RMAN and other utilities
• Knowledge in deploying, maintaining Oracle in a Data Guard configuration
• Knowledge in implementing RAC (using raw devices, ASM) for test environment using Oracle clusterware
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 10g database.
• Involved in designing and implementation of pre and post processing Pro*C programs for the ETL process.
• Created Stored Procedures, functions and Packages in Oracle 12c using SQL and PL/SQL for the Audit Trail using Oracle 12c as backend.
• Increased efficiency of code, by using bulk collection techniques to handle large amounts of data
• Involved in the Data Modeling phase of the application.
• Developed ETL processes extracted data daily from Mainframe DB2, SAS, Teradata, File Systems, SQL Server, TSQL and MYSQL Databases, and loaded data into ORACLE based Decision Support Warehouse.
• Created and Scheduled Weekly QlikView reports
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created UNIX shell scripts to automate the process and scheduling using Control-M, Autosys, Cron Job Utility.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production Severity Issues in time and meeting the SLA.
• Involved in front-end development including creation of Terms and agreement related functionalities using AngularJS, HTML5, Bootstrap
• Developed HTML pages from functional specifications & wire frames also validated designs in different browsers
• Applied AngularJS to achieve front-end MVC.
• Applied Bootstrap to achieve Responsible Web Design.
• Developed re-useable components using Angular Such as directives, factories & services.
• Used Angular UI grids for list out term & agreement related data from database also used other useful functionality such as sorting, filtering, pagination & export etc.
• Used AngularJS Interceptors for communicate to remote HTTP server.

Confidential, Irving, TX

Senior Oracle PL/SQL Developer

Environment: Oracle 12c/11g, PL/SQL, SQL, T-SQL, MS SQL Server, PostgreSQL, SQL Loader, IBM Data stage, UNIX, JAVA, J2EE, TOAD, SVN, JAVA, J2EE, JAVA Script, HTML, CSS, Angular JS

Responsibilities:

• Created business rules, functional and technical design, test cases and user guides and worked on Database design with the team
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms
• Created stored procedures, functions, packages, data base triggers and cursors based on requirement.
• Created various indexes for faster access of data partitions for performance improvement of queries. Passing hints, analyzing the table to collect table statistics for improving performance.
• Managed performance and tuning of SQL queries and fixed the slow running queries with utilities like Explain Plan, Auto Trace, TKPROF and Hints
• Developed complex queries to generate reports for both ad-hoc analysis and scheduling reports.
• Extensively used bulk collect to fetch large volumes of data from the table.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL, Cursor Variables, Object Types and Records.
• Used Pragma Autonomous Transaction, Pragma Exception INIT and all Pragma Inline for performance improvement.
• Extensively used Oracle Advanced features like ACS, Histograms, Baseline SQL, PIN the plan
• Created Materialized Views using Partition and Sub Partitions template and refresh the large volumes of data within stipulated timelines with tremendous performance measures.
• Designed and successfully implemented new everyday reporting application using external tables scheduled jobs and shell scripts
• Analyze and choose the best fit technology and solutions to meet application development and testing requirements
• Performed detailed code review of all the requirements of the peers to ensure normal implementation
• Extensively used logical modeling and physical modeling to create database objects like table’s relations, and data process flows.
• Utilized in-house wiki to document data model, business rules, projects, and other information.
• Involved in developing logical and physical database, Normalization, Dimension Modeling and Enterprise Manager.
• Worked on SQL Tuning, Query Optimization Techniques for complex SQL Statements.
• Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.
• Used Oracle features like Global Temporary tables, Analytical function and Table functions.
• Experience with Oracle Fine Grain Access Control (FGAC) development, configuration, and troubleshooting, and implemented VPD contexts.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Extensively worked on data replication tool to load large volumes of data from source tables to target data warehouse.
• Worked on Job scheduling to tool to create schedules and make modifications as per the requirement.
• Extensively used Agile Methodologies, it helps teams respond to unpredictability through incremental, iterative work
• Detected and corrected bugs during system integration and user acceptance testing.
• Created UNIX shell scripts from FTP batch jobs, creating SQL reports and email notifications.
• Developed various mappings using Informatica Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sorter and Sequence Generator transformations
• DBA activities such as Regular Backup's, Replication, Tuning, and troubleshooting performance issues.
• Interacted with front end JAVA team and provided required database objects and SQL queries.

Confidential, Florida

Senior Oracle DBA

Environment: Oracle 11g, PL/SQL, UNIX Shell Scripts, SQL Plus, TOAD, PL/SQL Developer, PUTTY, WinSCP, Visio, JAVA, J2EE, Informatica, SVN, SQL Server, JAVA, J2EE, JAVA Script, HTML, CSS

Responsibilities:

• Lead team of around 10 members at onsite and offshore very effectively.
• As a team lead responsible for preparing requirements document and design document.
• Responsible for gathering requirements from user for reports development and interface program customizations and in analyzing business process.
• Created and maintained Oracle Database Objects like tables, views, materialized view, indexes, constraints, sequence, synonyms and database link using SQL
• Worked with Data Architects and ETL Developers in data warehouse design, data management, data quality, and ETL architecture.
• Worked to create and maintain data warehouse management principles, understand relevant technologies, and utilize the best methods for constructing and supporting a large data factory.
• Developed technical infrastructure designs, data mappings, flows and report dissemination mechanisms.
• Created numerous complex queries involving joins, correlated sub-queries diverse business requirements.
• Plan, design, and implement application database code objects, such as stored procedures and views, indexes.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Created Global temporary tables, packages and procedures using SQL developer.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Analyzing performance of database objects and suggesting DBA for indexes, schema gathering, partitioning, explain plan.
• Involved in coordination between development teams, business analysts, QA, internal stakeholders, vendors and the Production support organization.
• Worked on SQL Tuning, Query Optimization Techniques for complex SQL Statements.
• Used revers-engineering on JAVA codes from legacy system and re-wrote them in PL/SQL, TSQL for the purpose of data comparisons.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like SQLTRACE, TKPROF and DBMS PROFILER.
• Atomized routine jobs using DBMS Scheduler. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL and trigger other processes.
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Created External table functionality from scratch creating DB folders, table structure and ETL scripts.
• Improved Performance by tuning using Hints, Indexes, Explain Plan, and TKPROF.
• Wrote SQL Loader control file for flat file data load and scheduled then in UNIX to load every night in Production Environment.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder and Oracle Forms builder respectively.
• Wrote UNIX Shell scripts invoke all the stored procedures, parse the data and load into flat files.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repositary Manager and Informatica Workflow Manager with multiple data sources.
• Generated reports and worked extensively in developing, deploying, and testing of Oracle Forms and Oracle Reports using Oracle.
• Worked with various Informatica power center transformations like connected & unconnected lookups, Router, Expressions, aggregators, filters, sequence Generator, Joiner etc. and developed complex business logic.
• Developed many workflow sessions, monitored the workflow runs and debugged if any errors.
• Involved in Implementing effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Worked with ClearSQL audit tool for providing software quality metric report for internal/external auditing.
• Maintaining different source code versions using Tortoise SVN.
• Testing and debugging of the applications. Implementation and end user training.
• Analysis and fixing of the defects/bugs in production with high priority.
• Interaction and coordination with various application teams for resolving issues, patch movements.

Confidential, Irving, TX

Senior Oracle DBA

Environment: Oracle 11g, PL/SQL, MS SQL Server, Oracle Forms and Reports, UNIX Shell Scripts, SQL Plus, TOAD, PL/SQL Developer, PUTTY, WinSCP, Visio, JAVA, J2EE, Informatica, SVN, SQL Server.

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Analyzed database design requests and Created databases according to client needs
• Write SQL scripts to create or modify database objects like (tables, views, synonyms, sequences etc.) to implement the business rules.
• Developed Stored Procedures, Functions, Triggers and Packages using PL/SQL.
• Performance monitoring and Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
• Used Global Temporary tables, Collections, Analytical Functions, Materialized Views and Query Re-write.
• Tuned SQL queries and performed code debugging using TOAD.
• Worked extensively on performance Tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of HINTS, and Statistics.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Union, Union all, Intersect and Minus
• Involved in database cloning for development, testing from production. Analyzed and computed statistics to improve response time for queries.
• Partitioned large Tables for better performance and manageability
• Ensure data quality and integrity in databases. Implemented security logging for all the important Tables.
• Written backend Procedures for Dashboard metrics.
• Database creation on different servers and data moved using expdp/impdp utility.
• Monitor and report status of databases (capacity planning, size/limit, performance, etc.) backup and restoration of schema. Monitoring alert log on daily basis and fixing if an error occurred in daily basis.
• Schema refresh, data replication & migration
• Killed inactive sessions to reduce unnecessary load on the server.
• Creation of table spaces, User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Ensure space management on servers and user management at the database level.
• Performing database Health check-ups. Decommissioning of Schema's as per approved requests.
• Distribution of Table spaces among different Disks and creation of Database objects.
• Performing backups using RMAN, Oracle import/export as a method of recovering data/individual objects.
• Taking backups using RMAN, export/import and data pump.
• Generating ADDM and AWR report for DB performance issue.
• Troubleshooting DB remote connectivity issue.
• Responsible for Monthly report generation, validation and delivery.
• Identify any issues related to database performance and provide corrective measures.
• Troubleshoot database related issues in a timely fashion

Confidential

Senior Oracle PL/SQL Developer

Environment: Oracle 10g / 9i, PL/SQL, All-Round Automations PL/SQL Developer, TOAD, Control-Excel 2010, Git, Agile methodology, HP Quality Center, Crucible, Sonar.

Responsibilities:

• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL/SQL packages and procedures to perform data loading, error handling and logging, used procedures into an existing ETL process.
• Used Bulk Collect feature to improve performance.
• Experience in application development using various features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types, Records and External tables.
• Created Cursors and Ref Cursors in the PL/SQL Blocks.
• Worked extensively with Composite data types, Cursors and Dynamic SQL.
• Worked with Dynamic SQL, Global Temporary Tables.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used standard packages like UTL FILE, DBMS SQL, and PL/SQL Collections and used BULK Binding.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Worked in Oracle reports and forms version 6i and 10g.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Improved performance by tuning SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Configured, developed, tested, implemented, supported, and maintained AutoSys JIL scripts.
• Created technical design document based on business requirements.
• Worked on the bulk uploading of huge amounts of statistical data to the database.
• Wrote loader scripts using SQL Loader/External tables to load large tables.
• Developed Reports and forms using Oracle Designer.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using oracle hints.
• Involved in analysis, development, testing, and 24 x 7 production support.