SUMMARY

• Experienced Database/Information Architect with 20 years of IT experience working across industries.
• Extensive knowledge in planning IT strategic directions, design of DB environments for key business information storage, Cloud based and centralized Data Governance solutions.
• Strong information technology professional skilled in designing, tuning, migrating and Scalable Databases on Oracle, MS - SQL Server, IBM DB2 and NoSQL, AWSRDS databases.
• Skilled in Architecting Oracle Fail safe environments for site critical databases, including configurations, migrating, failover testing, tuning, creating standards etc.
• Highly skilled in determining suitability of new technologies through research, user group discussion, proof of concepts, and pilot programs.
• Key player in the end- end delivery execution of the Store POS system after 7-years of multiple execution challenges in its build and deployment phase
• Played a key role in designing/Modelling/tuning the Database to convert the Legacy Application to the new POS system.
• Worked on designing a “Common Data Framework” that helped in migration of the Legacy system to the new system. This greatly helped in seamless cutover of the systems.
• Played a Lead role in developing and Implementing Store Rollout Automation programto deploy all the database related activitiesfor the POS implementation.
• Architected and Implemented Data Archiving/Purging Process from the Main POS databases by keeping all the Business Needs and Legal Rulesintact.
• Played a key role for developing and executing anAWS cloud Based solution“SWIFT” as “an alternate path” to avoid POS challenges.
• Architected and deployed Oracle Database consolidation and migration to cloud based AWS RDSMySQL Databases using AWS DMS.
• Responsible for Database Migration from Oracle to AWS RDSthereby freeing up oracle Core’s in multiple environments which turns saves huge license cost.
• Mentored a team of data architects at RAC and implemented Data Ingestion Pipelines - moving POS data from SIMS data and batched data to AWS.
• Architected, Designed an LOB migration from Oracle Database to AMAZON S3 service to improve POS Application performance.

TECHNICAL SKILLS

Programming Languages: C, SQL, PL/SQL, Visual Basic 5.0/6.0 and VB.NET

Databases: Oracle, SQL, Enterprise NoSQL, MYSQL, Microsoft SQL Server, PostgreSQL

GUI: Visual Basic 5.0/6.0,Developer2000 (forms4.5/5.0/6.0,6i&9i,10g), Discoverer 2000

Scripting Languages: PERL, Python, Shell Programming, and Java Script.

Reporting Tools: Oracle Reports2.5/6.0), SQR, VB Data Reports, Crystal Reports and Pro*c

Operating Systems: UNIX, Linux, MS DOS, Windows 2012, 2008 Server

Web/App Servers: Web logic, Web Sphere, Apache Tomcat

SCM Tools: CVS, SVN, ClearCase, GitHub

Cloud Platform: Amazon Web Services (AWS)

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Played a key Role in Redesigning the Database to convert the Legacy Application to the new POS system.
• Played a key role in partnering with architects of different other application teams to engineer palpable business solutions to various business divisions as a part of Database engineering project activities.
• Hands-on involvement in evaluation of technology needs for the implementation of the all the projects
• Strategies around Virtualization, AWS Cloud and Oracle EXADATA Technologies to handle the magnitude of the deployment
• Researched new technologies, established market-level pilots, published results upon completion of evaluation period to help analyse the rollout strategy and the potential business impact,
• Worked on designing a “Common Data Framework” that helped in migration of the Legacy system to the new system. This greatly helped in seamless cutover of the systems.
• Played a key role along with Primary DBA team in Providing tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.
• Designed, developed, tested and implemented the whole Migration Database objects and scripts which enabled the deployment in a parallel process to save and time and Resources.
• Designed, Developed and tested the well planned automatedprocess for the Data purging as per the Legal Requirements.
• Expert in identifying, Researching and providing Database Performance solutions using Oracle AWR as Basis.
• Extensively worked on root cause analysis on failures and resolving performance tuning related issues and queries.
• Worked on extensive research on Explain Plan usage, Oracle hints and creation of partitions, Indexes to improve the performance of SQL statements.
• Lead the Effort of Performance tuning by working with Primary team on the AWR Reporting there by identifying the Bottlenecks at all levels of Parameters.
• Played a key role as bridge between the Application Teams and the Primary DBA/ Implementation Partner of Oracle Golden gate Solution to implement the solution from conceptualizing to deployment.
• Played a Key role in fine tuning and re-writing of the application queries so that they can utilize the strength of Exadata’s key features like Smart Scan, Flash Cache, etc.
• Played a key role in Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• To mitigate the challenges caused due to POS Application outages - strategized and implemented micro-services enabled, Cloud based platform within 4 weeks. SWIFT an AWS based cloud solution was built on angular deployed on AWS S3 with a Cloud Front CDN and interacting with an Amazon Aurora database. The API is based on serverless architecture and deployed on Amazon Lambda with an API Gateway interface.
• Architected and implemented the project of migrating 3 oracle Databases to AWS RDS (Aurora) with minimal code changes in the Applications that are using the Databases. Successfully migrated 37 Applications as a part of this Project using AWS DMS service.
• Architected, Designed an LOB migration from Oracle Database to AMAZON S3 service to improve POS Application performance involving Byte stream Conversion to PDF’s in PL/Sql, UNIX shell scripts moving from Oracle Directory to create proper folder structure to migrate to AWS Snow Ball there by to AWS S3 bucket, Reconciliation and due Diligence back in Application.
• Played a key role in building an ELK stack which includes reading Application logs from over 3000 VM’s and then ingestinginto Amazon Kinesis Shards which then via Lambdas posted them to our Kibana ELK stack.
• Architected single purpose SPAs (Single Page Applications) that were deployed Angular 7 applications on an AWS S3 bucket with a CloudFront CDN which interact with the on-Prem Oracle DB or Amazon data systems via API Gateway interfaced Lambdas that also invoke the enterprise shared services.
• Worked on AWS performance Insights to solve critical performance issues on the RAC E-Commerce site right before the 2018 Thanks giving, which was very handy and critical for the business.

Confidential

DatabaseTeam lead

Responsibilities:

• Involved in the Re-architecture and database migration of the AD applications Database.
• Played a key role in migrating the AD Database into DARS Database.
• Played a key role in migrating the AD Database From 10g/11g.
• Played a Team Lead for Internal and External Audits on the Database.
• Played a role of DBA in the development and QA databases in order to reduce the work Load from the Primary DBA”s.
• Involved in massive Employee number conversion which has an impact on 900 Million records 400 Tables and 60+ applications.
• Wrote technical documentation for the proposed changes in the application.
• Designing, Coding enhancements and customizations to the application in accordance with the System requirements.
• Involved in gap analysis for the monthly release changes that effects the business functionality of the application
• Played lead role in identifying the bottle necks for the Database performance issues and provided solutions to put the database performance in par with industry standards
• Lead the team for performance Tuning effort which required DB architecture and Back end code changes,Load testing.
• Lead the team in Design, development, Test, Implementation and post Production for the enterprise wideLoan renumbering (UNO) which had major impact on the overall system.
• Lead the team in Design, development, Test, Implementation and Post Production for the enterprise wideLoan renumbering (ER112) which had major impact on the overall system.
• Lead the team in Data Masking Project which Masks the PI information when Production data is copied into Non Prod Environment for testing and various Simulations.