Skip to main content
Amit Verma

Amit Verma

Database engineering

Talent
Thanra, ShivpuriMember since July 3, 2023
MS SQL ServerT-SQLStored ProceduresFunctionsTriggersViewsJoinsCTEsSubqueriesDynamic SQLDatabase DesignData IntegrityQuery OptimizationIndex TuningExecution Plan AnalysisSQL ProfilerDeadlock ResolutionSSISBCP UtilityBULK INSERTOPENROWSETData MigrationSSRSPower BIPythonPandasNumPyData AnalysisExcelPivot TablesVLOOKUPSQL Server Agent JobsBackup & Restore ScriptsApache SupersetAWS Lambda
·

Hire this person

Send a job offer directly to this candidate

MS SQL ServerT-SQLStored ProceduresFunctionsTriggers

About

Results-driven SQL Developer with 4+ years of experience in SQL Server database development, ETL processes, and performance tuning within enterprise and multi-site environments. Skilled in developing complex T-SQL queries, Stored Procedures, Functions, Triggers, and Views to support business applications. Experienced in query optimization, index tuning, execution plan analysis, and resolving deadlocks to improve database performance.

Proficient in SSIS for ETL development, SSRS for reporting, and Power BI for dashboard creation. Strong expertise in data migration, bulk data operations, and database design using normalization techniques to ensure scalability, reliability, and data integrity.

Experience

Database Engineering at Ventura Securities (2026-02 – 2026-03)

Database Engineering role focused on data visualization and pipeline integration

  • Developed interactive dashboards and data visualizations using Apache Superset to support business reporting and decision-making.
  • Integrated backend data pipelines and automated processing using AWS Lambda to enable efficient data transformation and reporting workflows.

SQL Developer at TechExcel Software Solutions (2023-08 – 2026-01)

SQL Developer responsible for database design, optimization, and ETL development

  • Designed and optimized database tables, stored procedures, triggers, and functions for business applications.
  • Improved query performance by implementing indexing strategies and query optimization techniques.
  • Developed complex SQL queries using Joins, Subqueries, CTEs, Temporary Tables, and Dynamic SQL.
  • Performed high-volume data import and export using BULK INSERT, BCP Utility, and OPENROWSET.
  • Monitored and resolved production issues including deadlocks, blocking, and long-running queries using SQL Profiler.
  • Created and scheduled SQL Server Agent Jobs for automated database maintenance and reporting tasks.
  • Implemented database backup and restore strategies to ensure data reliability and recovery.
  • Supported data migration activities using side-by-side upgrade methodologies.

Software Engineer at Novac Technology Solutions (2022-02 – 2023-08)

Software Engineer focused on database solutions, reporting, and data analysis

  • Collaborated with development and QA teams to implement scalable database solutions aligned with client requirements.
  • Maintained SQL database integrity and monitored performance to ensure system stability.
  • Developed and supported database objects including Tables, Stored Procedures, Functions, Views, and Indexes.
  • Generated management reports using SQL Server Reporting Services (SSRS).
  • Designed interactive dashboards using Power BI to visualize business insights.
  • Performed data analysis and cleaning using Microsoft Excel, including Pivot Tables and VLOOKUP functions.

Education

B.Sc. in IT – Guru Nanak Khalsa College, Mumbai (2018 – 2021)

Skills

Database engineering

Reviews

Related