SUMMARY

• Above 13 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals and horizontals.
• Successful background to develop architecture framework on Cloud and Non - Cloud environment that aligns strategy, processes, and IT assets with business goals from Database Perspective for a 40 TB Database
• Extensive experience with Database Design in Oracle and MongoDB with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP Databases.
• Expertise in Oracle Core PL/SQL features such as PL/SQL Tables, Dynamic SQL, DBMS JOB and UTL FILE, UTL HTTP, ACL, Java classes, Advance Queues which we converted 1300 Java webservices to OHS through mod plsql.
• Good knowledge in writing CRUD operations using Advanced MongoDB Queries using Aggregate Pipeline and Projections in the Denormalized data model.
• Exposure in MongoDB Replication setup, monitoring and concepts of Sharding and shard key selection
• Experience in implementing Oracle OLTP/OLAP Data to streaming system using Apache Kafka and Oracle Golden Gate Big Data Adapter.
• Hands on experience to Dev-Ops tools such as GITHUB, Jenkins, Pipeline, Docker and implemented in Database deployment though Pipeline.
• Experience in maintaining Data Lake and creating Data Marts for 50TB Database
• Expertise in Migrating data into Enterprise Data Fabric using Oracle Scripts, SQL*Loader, Data pump and OGG.
• Good understanding of Cassandra database.
• Hands on experience in Oracle Golden Gate and Database Replication Strategies using Classic and Integrated modes
• In-depth knowledge in Oracle performance tuning using AWR and ADDM reports, automated the database tuning for predefined Queries and increased some performance with 200%.
• Good knowledge in maintaining databases like Capacity and Security management.
• Strong knowledge in UNIX shell scripting and written several Automation scripts to reduce the repeated Job.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Experience in leading and managing teams. Handled multiple roles - Project Lead, Software Architect, Developer, DB Admin with Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Executed software projects for Telecommunication, Logistics, Retail, and Service Delivery and Process industry

TECHNICAL SKILLS

RDBMS: Oracle 12c, MS-SQL Server 2000, MS Access 2000, Oracle Golden Gate 12

NoSQL Database: MongoDB, Cassandra

Data Modeling: Erwin, Rational Data Architect, Oracle Data Modeler

Dev-Ops: GITHUB, Jenkins, Pipeline, Docker

Big Data Tools: Apache Kafka, Apache Flume, Oracle GG Big Data Adapter

Development Tools: PL/SQL Developer, SQL Developer, TOAD, Eclipse, Robo3T

Languages: Java, Oracle PL/SQL, HTML, VB

Scripting Languages: Perl, Shell and AWK Scripts

Operating System: Linux, Windows NT/2000 Server, Solaris, AIX

Reports: Crystal Reports XI, Oracle Reports, Business Objects.

SCM Tools: SABLIME SCME, Clear case, Visual Studio SourceSafe. GIT, SVN

Functional Domain: Telecommunications, Logistics

PROFESSIONAL EXPERIENCE

Database Architect/Lead

Confidential, Middletown NJ

Responsibilities:

• Being in part of Enterprise Database Design Team and participated in all technical discussions to choose the right technology for the right data models.
• Initiated and tested several Proof of Concepts (POC) on Oracle, MongoDB and Cassandra for implementing the High availability and horizontal scaling of Databases for the given Data Model.
• Being a Part of Design and development of Event Generation Framework to Support the Real-time Data retrieval for the Next Generation Micro Services
• Design the Data Migration Plan and migrate the Data from each source to the Next Generation Micro Services Database with minimal or zero downtime
• Created PL/SQL Stored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Preparation and review of the Database Sizing document using various techniques and provide the hardware need for the Infrastructure team for the Future Database Growth
• Created Several scripts for Database management, Fine grain Auditing of tables, Database Optimization
• Extensive experience in deploying, managing and developing MongoDB clusters. Experience in creating JavaScript for using DML operation with MongoDB.
• Creation, configuration and monitoring Shards sets. Analysis of the data to be shared, choosing a shard Key to distribute data evenly. Architecture and Capacity planning for MongoDB clusters. Implemented scripts for mongo DB import, export, dump and restore.
• Worked with various dataflow tasks like merge join, merge, aggregate, and conditional split.
• Automated several time-consuming Process to Continuous Development Platform using Dev-OPS Model such as GIT, Jenkins and Pipeline and made ease the code movement across all environments.
• Prepare the Architectural Decision document and review with the technical experts Team using Oracle Data Modeler.
• Interacted with different applications and Vendors as required for a better deployment.
• Subject Matter Expert in the Team with 11 years’ experience in the same project. I do provide technical solutions to projects. I do review all critical projects from Technical and Business perspective

Environment: Oracle 12c, MongoDB, PL/SQL Oracle GG, Apache Kafka, GIT, Jenkins, Pipeline, Docker, Linux, Shell Scripts, Java, J2EE

Lead Oracle DBA

Confidential, Middletown NJ

Responsibilities:

• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• Migrated and transformed more than 300+ schema and their objects with data of 12+ Terabytes of data to Oracle 12C from lower oracle databases.
• Worked and Implemented most of Oracle Golden Gate Topologies such as broadcast, Consolidate, Unidirectional and Bidirectional
• Being a part of Java to PL/SQL code conversion Project which converts 1350 Java web services to PL/SQL for better performance using Oracle Core PL/SQL features such as PL/SQL Tables, DBMS JOB and UTL FILE., UTL HTTP, XML, Java classes, ACL, Advance Queues
• Review the Transformed PL/SQL code, test and deploy it in different environment such as ST/UAT/Stage and support if any issue arises.
• Design the Data Movement Plan each of the schemas well in advance based on their size to migrate to new Database with minimal or zero downtime
• Identifying the Data mart and schemas based on their functionality and Collect, Analyze and Review of the DB Inventory for each schema involved in the DataMart.
• Identifying source and Consumer for each Table under each schema using Audit logs and rationalize wherever applicable.
• Implemented Multilevel data copy from different sources using MVs where Oracle GG or Direct DB access is limited
• Use of SQL diagnostic and tuning tools like AWR/ADDM Reports or DBMS profiler wherever required by Service layer or UI layer or ETL Layer.
• Managed as many as and Design the tables based on the project requirements based on best normalization techniques.
• Review the Deployment Plan for Production Deployment with the Prod DBA Team for smooth and seamless release.
• Design configure and implemented several monitoring tools for DB health management Confidential any instances of time like Long running queries, Connection Leaks, Sessions details, Orphan sessions, tablespace management.
• Interacted with different applications and Vendors as required for better deployments.

Senior System Engineer

Confidential

Responsibilities:

• Oracle DBA for the EFMS Family of Applications (EFMS TP, PM, IOL, FINDIT).
• Managed as many as 15 Databases and Design the tables based on the project requirements based on best normalization techniques.
• Design configure and implemented several monitoring tools for DB health management Confidential any instances of time like Long running queries, Connection Leaks, Sessions details, Orphan sessions, tablespace management, record Counts
• Created several complex PL/SQL codes using PL/SQL tables, Dynamic SQL, UTL FILE packages
• Performed SQL Server-to-Oracle conversion and designed database for EFMS Find-it.
• Design configure and implemented the Automated DB Build for Compiling PL/SQL code from the SCM Tool for different environments
• Suggested and implemented Oracle Best Practice in Performance Tuning for Developers and tester for Better writing the oracle Queries
• Reorg of tables using Partitions
• Presented Oracle Best Practices for developers in the DB SIG forum
• Cloned and renamed databases and retrieved and restored database cold backups when all servers were migrated from one location to other location.
• Performance tuning the application based on the AWR and ADDM Reports for any queries with appropriate indexes and achieved 200% in some cases
• Examine code for Web applications and JDBC connections to the Oracle database.
• Created scripts for easy guess passwords adhere Oracle Security Vulnerable for EFMS family of Applications
• Written Perl code to recreate tables, indexes, views, Functions, procedures and packages and by this used the same to compare the objects from different environments
• Prepare the Deployment Script for all oracle Deployments and supported during all the Sanity
• Oracle DB Migration using the exp /imp, expdp / impdp and SQLLDR tools
• Logically approach and analyze every production issue and provide the best for fixing the issue.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Involving in project time and cost estimation Design, Detailed Design and Test Cases Documents, Implementation and Testing.

Environment: Java, J2EE, Solaris, Oracle 10g, Shell Scripts, Perl Scripts, WebSphere

Analyst Programmer

Confidential

Responsibilities:

• Work with Customers in translating business requirements into Functional Requirements Document and to Detailed Design Documents
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
• Created several complex PL/SQL Procedures packages, Triggers using PL/SQL tables for accounts and Billing Modules
• Integrated the interface between the inbound outbound operations with third party software
• Ensure that development is performed as per requirements
• Communicate activities/progress to project managers, business development, business analysts and clients
• Oracle Reports development using Complex Queries and procedures which takes Dynamic Inputs
• Deployment of deliverable in the production environment.
• Contributed and provided the valuable solutions from client end to persist the data of Customer Service modules using Erwin Data Modeler.
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process
• Integration with DHL Applications.
• One-point contact for Customers.

Environment: RVW 1.43, Oracle 9i, PL/SQL, T-SQL, Oracle Reports, VB, SQL Server, Crystal Reports 8.5, Erwin Data Modeler.

Application Programmer

Confidential

Responsibilities:

• As a Developer in the team of Zee CMS project in Retail Domain for Zee TV UK one of the Client of Confidential Chennai to support the DTH service to its customers.
• Actively participated in Data Model Design to persist the data of Dealer and Customer modules using Erwin Data Modeler.
• Designed and developed Reports to maintain the dealer and customer modules.
• Developed several complex T-SQL Procedures, Functions packages, Triggers for the dealer and customer Management Modules