JAISON JOSE
MAMANKARA,Kerala
Summary
Senior database developer with over 10.5 years in IT, and 10+ years specializing in SQL Server and MySQL. Expertise in Azure Data Factory, ETL processes, and SQL query optimization. Proven track record in database design, reporting, and integration across banking, healthcare, and financial sectors. Experienced in team leadership and application improvement, ensuring high standards and effective collaboration.
Overview
11
11
years of professional experience
1
1
Certification
Work History
SENIOR DATABASE DEVELOPER
ANALYTIX BUSINESS SOLUTIONS PVT LTD
08.2021 - Current
- Design and develop databases, tables, views, functions and stored procedures made to support various applications while ensuring quality performance, reliability, and security.
- Create ADF Pipeline to load the Client data to product.
- Migrate the on premise SSIS packages to ADF pipeline in cloud environment.
- Created SSRS reports based on the requirements.
- Onboard the new client locations and loaded the historical data using the SSIS packages.
- Review stored procedures/SQL scripts and optimized before release in production.
- Worked on SQL jobs/ADF triggers to load the data at scheduled time.
- Lead a team of developers and successfully solve issues and make improvements to databases, while ensuring all work meets the necessary requirements.
- Maintained backup and recovery procedures, ensuring data availability and minimizing downtime in the event of a disaster.
SENIOR SOFTWARE ENGINEER
NEST DIGITAL PVT LTD
02.2020 - 07.2021
- Database administration activities, Database maintenance, Backup activities and Health check DB.
- Designing tables, views, functions and stored procedures.
- Optimizing procedures, functions and resolving deadlock issues.
- Worked in UAE based banking domain.
- Migrate the Oracle database data to MySQL DB.
DATABASE DEVELOPER
BUSINESS DNA INDIA PVT LTD
08.2019 - 01.2020
- Gathered business requirements and design database tables, views, develop the SQL stored procedures UAE based retail supermarket project.
- Develop the labour module to track the employees in the retail supermarket.
- Develop the different reports for future analysis the sales data.
SOFTWARE ENGINEER
WILLIAM O'NEIL INDIA PVT LTD
11.2017 - 07.2019
- Gathered business requirements and converted it into SQL stored procedures for database specific projects.
- Created and scheduled SQL Agent jobs and automated the manual processes.
- Develop new SSRS reports and configure SSRS subscriptions as per specifications provided by internal users.
- Modified and maintained SQL Server stored procedures, views, SSRS reports, and SSIS packages as a part of bug fix.
- Integrated SQL with Power BI to automate data extraction processes, saving 15 hours of manual work per week.
- Created SSIS package to extract, validate and load data into Data warehouse.
SOFTWARE ENGINEER - TEAM LEAD
SESAME SOFTWARE SOLUTIONS PVT LTD
06.2016 - 11.2017
- Designed and implemented stored procedures views and other application database code objects.
- Handle team members in projects and co-ordinate smooth delivery of the project.
- Ensured team members stayed on task and assigned tasks to various team members also regularly monitored work and cut problem members before issues became large.
- Planning and implementing the Core Banking Solution in various banks.
- Converted traditional report solutions into Power BI report solutions.
- Product customize based on the client requirement and clear the bugs if reported.
- Coordinated with the management to discuss business based on security needs in banking area and designed database solutions accordingly.
- Organized training to improve the performance of the team members who were lagging performance level in domain, module, reports and SQL logic levels.
- Work with marketing team responsible for software demo in various Banks.
JR. SOFTWARE ENGINEER
SESAME SOFTWARE SOLUTIONS PVT LTD
09.2014 - 06.2016
- Develop SSRS reports based on the bank requirements.
- Maintained SQL scripts indexes and complex queries for analysis and extraction.
- Developed various SQL servers and ensured that they were properly maintained and supported.
- Migrate bank data from source to intermediate and intermediate to destination using queries and stored procedures.
- Handled client interaction, business analysis, requirement gathering, and requirement design.
- Providing Training to the Clients in banking domain, Module and Reports levels.
SOFTWARE ENGINEER TRAINEE
SESAME SOFTWARE SOLUTIONS PVT LTD
02.2014 - 08.2014
- Performed onsite and remote database administration including backups, restores, disaster recovery, database creation & configuration, installation of SQL Server 2000-2016.
- Troubleshoot various type of software/database related issues.
- Provided on call support as needed.
Education
Master of Science - Computer Science
AMAL JYOTHI COLLEGE OF ENGINEERING
Kanjirapally, Kottayam, India10-2013
Bachelor of Science - COMPUTER SCIENCE
MARY MATHA ARTS AND SCIENCE COLLEGE
Mananthavady, Kerala, India05-2010
Skills
- Database design & development
- SQL development
- Microsoft SQL
- MySQL
- Team leadership
- Performance tuning
- Data migration
- ETL processes
- SQL database administrator
- Azure data Factory(ADF)
- Power BI
- SSRS
- Report generation
- SSIS
- BI developer
- Stored procedures
- Database administration
- Data migration planning
- T-SQL development
- Performance issue diagnosis
- Database objects creation
- Query optimization
- Database security best practices
- Database performance tuning
- Data visualization techniques
- ETL development
- Stored procedures development
- Database backup and recovery
- Leadership skills
- SQL development
- Problem solving
- Analytical skills
- Problem identification
- Problem resolution
- Time management
- Banking domain
- Stock market domain
- ERP domain
Custom
Sr. DATABASE DEVELOPER
Hobbies and Interests
- Learning new technology
- Listen music
- Watching TV
- Playing Badminton
Languages
- English
- Malayalam
- Hindi
Affiliations
Leadership skills
Strong skills in SQL development
Great problem-solving and analytical skills
Able to identify and resolve intricate problems
Disclaimer
I hereby declare that the information given above is true to the best of my knowledge and belief.
Place: Nilambur,
Jaison Jose
Certification
Database Design and Programming with SQL: Oracle Academy
Languages
Malayalam
First Language
English
Proficient (C2)
C2
Hindi
Elementary (A2)
A2
Tamil
Elementary (A2)
A2
Timeline
SENIOR DATABASE DEVELOPER
ANALYTIX BUSINESS SOLUTIONS PVT LTD
08.2021 - Current
SENIOR SOFTWARE ENGINEER
NEST DIGITAL PVT LTD
02.2020 - 07.2021
DATABASE DEVELOPER
BUSINESS DNA INDIA PVT LTD
08.2019 - 01.2020
SOFTWARE ENGINEER
WILLIAM O'NEIL INDIA PVT LTD
11.2017 - 07.2019
SOFTWARE ENGINEER - TEAM LEAD
SESAME SOFTWARE SOLUTIONS PVT LTD
06.2016 - 11.2017
JR. SOFTWARE ENGINEER
SESAME SOFTWARE SOLUTIONS PVT LTD
09.2014 - 06.2016
SOFTWARE ENGINEER TRAINEE
SESAME SOFTWARE SOLUTIONS PVT LTD
02.2014 - 08.2014
Master of Science - Computer Science
AMAL JYOTHI COLLEGE OF ENGINEERING
Bachelor of Science - COMPUTER SCIENCE
MARY MATHA ARTS AND SCIENCE COLLEGE