Database Architect/lead Resume
Middletown, NJ
ASUMMARY
- 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 Gloden 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 Gloden 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 Gloden 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. me do provide technical solutions to projects. me 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, J2EELead 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 TEMPthan 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 Gloden 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 at 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 Confidential Family of Applications ( Confidential 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 at 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 Confidential 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 Confidential 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
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 Ramco Systems 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
Technology: VB.Net, ASP.Net, RVW2.0, SQL Server 2000, Crystal Reports XI on Windows 2000