• Optimized the knowledge modules to improve the functionality of the process.
• Fully involvement in every project, resolving issues arise while development and demo.
• Handling the issues and Interact with Client in Mail/ Status Call.
• Coordinated periodic fail over switch exercise to DR environment to test operational readiness of system
• Guided peers/team members
• Have experienced in any kind of issues related to lock escalation, application dependency and resources management across the server, high availability disaster recovery, Primary/Standby servers, 24/7 database up and running and escalation which may impact the business.
• Responsible for maintaining liaison with client DBA teams as and when required.

• Worked on releases 8.x through 12.x of the application.
• Physical modeling of database changes and development of oracle pl/sql packages and Unix shell scripts to implement business functionality.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router. These were
• developed as part of migration of overnight batch processing to Informatica.
• Lead database engineer for the Integrated Development Group which is responsible for Production Support and daily maintenance activities in staging and production.
• SQL/PLSQL tuning and optimization.
• Worked on data center migration effort.

• Handle vast level of DB2 servers for more than 12 countries.
• Data analytical work during the peak sale time based on the customer purchasing using historical trend.
• Build recommendation system using ML and Python and SQL.
• Responsible for generating order calculation and order forecasting for a day.
• Churn Analysis of Tesco online stores based on customers 6 months activities.
• Shell scripting to automate database level backup, tables tuning, performance enhancement, error troubleshooting.
• Worked with application team, to prepare the SQL query based on their requirements.

•   Keeping a company’s database available, secure and stable  
• Integrating new products and software packages into the system 
• Sync Database between Test,sit,development,demo Server using Import and Export Utility.
• Shell Scripts, Cron Jobs for Automated Backup to NAS Drive.

• Responsibilities include guiding peers/team members and mentoring as required. 
• Part of Database professional services and Customer Success Engineering. 
• Designing ,Creating schema according to predefined nomenclature and conventions.
• Expertise in Stored Procedures, Functions, Triggers using Oracle Tools like PL/SQL Developer,MYSQL Workbench.

• Lead database engineer for the Integrated Development Group which is responsible for Production Support and daily maintenance activities in staging and production
• Responsible for the backend health of Production and Staging environments. Cut issue resolution time by 50% by building environment status dashboards, leading to timely insights on status of production data/environments
• Participated in DB capacity planning activities (Disk storage) with the Data Center Group
• Analyzed Database Storage trends and provided estimates to higher management for hardware procurement
• Coordinated overnight operations with offshore team in India
• Took lead in the implementation of database Auditing
• Participated in the planning, creation and setup of DR environments

• Participated in the implementation of database Auditing. 
• Participated in the planning, creation and setup of DR environments. 
• Coordinate periodic fail over switch exercise to DR environment to test operational readiness of system. 
• Responsible for tracking and reporting status of work assigned to the team to higher management. 

• Gained knowledge in how to operate database via Apache Servers.
• Documentation work on projects.
• Worked voluntarily in StoryCycle Project.
• Responsible for applying patches and fixes to the database with prior Approval from Change Control Board. 

• Wrote SQL queries to perform Data Analysis and Data Validation on the daily updated client’s data
• Designed a database for hospital management and presented a prototype version to the client
• Prepared database documentation and participated in unit testing and user acceptance testing for project deliverables
• Active Agile Scrum team member.

• Installing and Configuring database on Linux and DB Creation.
• Maintaining Optimal Flexible Architecture.
• Managing Database Users, Security, Roles, Privileges and managing User Quotas
• Proactive Monitoring and Maintaining database performance via Java melody and percona monitoring.
• Managing backup and recovery strategies using mysqldump, percona xtra backup and Rman utilities.
• Maintaining a list of daily db activities followed for script monitoring and production deployment.
• Creating datamodel documents and various polices(stats,purging).

• Administrating multiple database systems – Oracle/SQL Server/Sybase/SAP Hana/Db2/MySQL.
• Handling operations and solutions related to RDBMS technologies
• Troubleshooting and fixing issues related to Actifio and Database integration.
• Developing scripts(Oracle and Shell) based on project needs.
• In-depth understanding of Actifio and Copy Data Management products.
• Designing Backup and Recovery methodologies for different databases.
• Supporting application development and DevOps teams.

• Worked on releases 8.x through 12.x of the application. 
• Physical modeling of database changes and development of oracle pl/sql packages and Unix shell scripts to implement business functionality. 
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router. These were developed as part of migration of overnight batch processing to Informatica. 
• Lead database engineer for the Integrated Development Group which is responsible for Production Support and daily maintenance activities in staging and production. 
• SQL/PLSQL tuning and optimization. 
• Worked on data center migration effort. 
• Responsible for maintaining liaison with client DBA teams as and when required. 

• Create sql automation by using pandas and accelerate over 5 times speed.
• Responsible for GL and NM in Oracle.
• Write website by Asp.net and Bootstrap.
• Worked on Reference Data Integration Projects on Market Data Domain.

• 11+ Years of Work Experience in SQL Server Development.
• Review, design, and develop data models, data mappings, and stored procedures with technical leaders and developers in support of product needs.
• Develop, test, and implement performance and resource optimization initiatives in consultation with development teams.
• Perform data research in support of data researchers, data analysts.
• Maintain a stable production environment with root cause analysis of production database issues as they arise
• Performance tuning the queries for optimal performance.
• Highly self-motivated and self-directed to solve complex technical problems in SQL Server.