SUMMARY:

• Result oriented, analytical and self - driven professional seasoned with 8+ years of working in a dual role of design/architecture and production support.
• Experienced with all phases of SDLC using Agile/Scrum framework, Waterfall, and Iterative approach.
• Experience in designing & creating Oracle 11g, 10g, 9i, 8i, AWS Cloud (RDS, Dynamo DB, and Redshift) databases of varying landscapes and sizes.
• Lead and supported migration of monolithic platform to AWS cloud/ Micro services.
• Excellent hands-on experience on database administration, data center configuration, and migration
• Extensive experience with implementation of Oracle Advance security option (ASO).
• Experience of implementation of DR (Disaster Recovery) plan with different approach like Dataguard / Oracle streams and AWS cloud.
• Experience with implementation of Audit and security implementation on oracle databases.
• Experience in Migration of Oracle database from Data Center to AWS Cloud
• Experience using OEM, Grid control, Erwin, Toad for database administration, monitoring and design.
• Experience on Performance Tuning & Capacity Planning pro-active and re-active actions for optimal performance complying with business SLA’s.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views and Table Partitioning.
• Excellent communication, interpersonal and leadership skills along with very good understanding.
• Excellent trouble shooting, debugging and error trapping skills.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, and 11g ( EXADATA and RAC), AWS RDS, Dynamo DB, Redshift

Languages: Oracle SQL, Oracle PL/SQL, Java

Management Tools: SQL * Plus, SQL Loader, PL/SQL Developer, Toad, AWS console, Direct connect, Jira

Project Methodologies: Waterfall, Agile, Spiral, SDLC, and UML

Business Modeling Tools: Rational Rose, MS Visio

Requirement Management Tools: Rational Requisite Pro

Business Modeling Tools: Rational Rose, MS Visio

Business Applications: MS Office Suite

Networking: LAN/WAN Environments, TCP/IP Suite, Router & Switch Configuration.

AWS Services: Dynamo DB, RDS, Redshift, Cloud Watch, Cloud Trail, SNS, SQS, Kinesis, Lambda

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Lead Oracle DBA / Architect

Responsibilities:

• Ensured and Implemented the DMF Guiding principles (Meta Data Driven Approach, Standardization across multiple feeds, Error and Logging Framework).
• Lead the Migration of Oracle databases from Data center to the AWS Cloud databases.
• Lead database design patterns to support DMF 2.0 cloud based architecture.
• Leveraged CI/CD process to expedite delivery of features in an automated fashion.
• Collaborated with Analysts, Developers, Architects, Business representatives, Operations, and other support team.
• Lead/Mentored multiple resources to follow enterprise guidelines.
• Implemented micro services by using Lambda functions to support logging of activities via SNS and SQS in addition to Cloudwatch and CloudTrail.
• Leveraged AWS step functions to orchestrate processing.
• Provided Support as part of AR OTW to mitigate/remediate any issues during production executions.
• Worked on XDB concepts to ensure standardization.
• Involved in writing SQL queries (Sub queries, Nested queries and Correlated), PL/SQL
• Programming using analytical functions likes ROW NUMBER, Pivot/Unpivot, List/Lag, LISTAGG etc. to meet business requirements.
• Extensively used regular expressions (REGEXP) for validating incoming data and making sure it meets Confidential specifications before loading the data downstream.

Environment: s: Oracle 11g (EXADATA), Toad, SQL * Plus, Appian, SVN, SoapUI, ClearQuest, Dyanodb, RDS, Redshift, Jenkins, Oracle VM Virtual Box, Java, Python, Lambda, Step Functions, SNS, SQS, GitHub, Source Tree

Confidential, Pittsburgh, PA

Oracle PL / SQL Developer

Responsibilities:

• Actively participated in different phases of development like Requirements gathering, Design, Coding, Implementation and maintenance using primarily PL/SQL batch processing.
• Designed the DDL (create Tables, indexes, truncate, etc.) as well as analyzed, developed and tuned the DML (Update, Insert, Delete) of the daily and monthly ETL.
• Wide variety of applications housed by the different departments of the university needed data in a structured fashion as per their requirements. Gathered requirements, analyzed them, and designed and implemented a secure way to transfer sensitive and non-sensitive data to various departments of the University for their Individual Application Needs
• Provided 24*7 application support for mission critical applications
• Also provided critical nightly support for the daily and monthly ETL throughout the night usually after any issues with ETL or change management
• In order to facilitate the end user reporting of different data as presented through conformed dimensions, Materialized views were designed, developed, implemented and optimized.
• Extensively involved in writing SQL queries (Sub queries, Nested queries and Correlated), PL/SQL
• Programming using analytical functions likes ROW NUMBER, Rank, Dense Rank, Pivot/Unpivot, List/Lag, LISTAGG etc.
• Used the advanced features of PL/SQL like collections, nested table, vary and dynamic SQL
• The PL/SQL code was developed in development environment moving it to testing and then after the extensive testing to production. As per university’s standard SDLC practices were used to move the code between environments
• Worked extensively with DBAs to gather requirements and resources on the Real Application Cluster (RAC) database running on oracle 11gR2 (11.2.0.4)
• Tested new enhancements and bug fixes before deployment into the production environment

Environment: s: Oracle 11g (RAC Environment), Toad, SQL * Plus, SQL developer, Talend, Win XP

Confidential, Pittsburgh, PA

Oracle PL / SQL Developer

Responsibilities:

• Worked with the Business Analysis team to define requirements
• Developed a proof of concept data models to validate request were attainable
• Created a number of adhoc data pulls to review with the business to validate the data
• Conformed to Confidential PL/SQL coding standards
• Followed and enforced Confidential data governance policies
• Designing of Data Modeling the design specifications and to analyze Dependencies
• Responsible for creating and maintaining the Packages, Stored Procedures, Functions and Cursors
• Maintaining the Database changes according to the client’s requirements
• Created Database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database links as well as custom Packages Tailored to business need
• Created External tables that are receiving data files from source systems which are then utilized for the ETL processes within the DW
• Developed various ETL processes extracting data from different sources using db link and performed transformations using PL/SQL to load them into the various DW environments
• Developed various complex PL / SQL Packages, using Oracle’s latest features such as Nested Objects, VARRAYS, Materialized Views
• Optimized the SQL Query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes.
• Performance Tuning of SQL and PL / SQL objects
• Participated in day time batch support for the Data Warehouse
• Creating the Control files to implement the latest database changes in the existing database
• Involved in Unit level Testing, Module level Testing and System Testing
• Wrote Documentation for implementing Packages & jobs to run daily and weekly
• Tested new enhancements and bug fixes before deployment into the production environment
• Developed UNIX Script to create FTP Jobs
• Worked as part of a team to launch new application releases under strict time deadliness
• Designed database tables using various normalization techniques and database rules
• Developing Control files using SQL Loader to perform bulk data loads into database tables from external data files

Environment: s: Oracle 11g (EXADATA), SQL Loader, SQL * Plus, Harvest, SVN, Autosys, Win XP