Sahil Ahuja
Specialist, Database Developer
Noida
Summary
SQL Developer with 7+ years of progressive experience in PLSQL, Snowflake, MySQl, MS-SQL Server databases and application programming. Dedicated to building customized technical solutions and Snow pipelines in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
3
3
Certificates
2
2
Languages
Work History
Specialist Software Engineer
Fiserv India Pvt Ltd
03.2021 - Current
- Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Participated in requirement gathering and implementing SnowFlake.
- Using SnowSQL, I helped in migrating on-prem databases to cloud.
- Developed snow pipe for continuous data ingestion from S3 bucket to Snowflake database.
- Also familiar with PUT, GET, COPY commands in Snowflake.
- Wrote Snowflake stored procedures using Snowflake SQL scripting.
- Dynamically create and execute SQL statements.
- Also took part in developing ELT jobs for reporting purposes using Matillion.
Senior Development Associate
Decimal Technologies
03.2019 - 02.2021
- Conducted tests to identify issues and make necessary modifications.
- Implemented security measures to protect vital business data.
- Evaluated, designed, implemented and modified databases and database applications.
- Created and updated database designs and data models.
- Set up and controlled user access levels across databases to protect important data.
- Built databases and table structures for web applications.
- Created technical documentation for database technologies, providing updates.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Identified issues within databases, performed troubleshooting and implemented effective solutions.
- Developed scripts and processes for data integration and maintenance.
- Developed custom database objects, stored procedures and delivered application support.
- Designed and implemented SQL queries for reporting and complex solution development.
Software Engineer
Skil Lotto Solutions Pvt Ltd
01.2016 - 03.2019
- Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
- Accepted agile methodologies and development best practices to division to enhance product development.
- Worked with customers for needs analysis.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed custom database objects, stored procedures and delivered application support.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
QA Intern
07.2015 - 10.2015
- Responsible for Manual Testing, Test Case Designing, Test Case execution,
- Regression Testing, Functional Testing, Improvements and enhancements in application, Quality Assurance.
Education
B.Tech - Information Technology
04.2012 - 04.2016
Skills
PLSQL Development
Solutions deployment
SnowSQL
Snowpipelines
Code versioning
Contiguous integration systems
Project Deployment Devops
Maintenance and troubleshooting
Linux Operating System
Continuous Integration Systems
Performance Evaluation and Optimization
Certification
SQL (Basic) Certificate Hackerrank
Timeline
Specialist Software Engineer - Fiserv India Pvt Ltd
03.2021 - Current
Senior Development Associate - Decimal Technologies
03.2019 - 02.2021
Software Engineer - Skil Lotto Solutions Pvt Ltd
01.2016 - 03.2019
QA Intern -
07.2015 - 10.2015
ITS Engineering College - B.Tech, Information
Technology
04.2012 - 04.2016
Languages and Tools
- Languages: Snowflake SQL, PLSQL, MySQL, Oracle, MS SQL Server
- Tools: MySQL Workbench, SnowSQL CLI, Snowflake WEB UI Putty, Winscp, SSMS (SQL Services Management Studio), SQL Developer, Microsoft Visual Studio, Matillion ELT, DBT
- Versioning: GitLab, Github.
- CI/CD Tools: Ansible, Jenkins, Octopus.