Drag

SQL Developer

Location : ,

Job Description

VBA/SQL Developer

3-5 years of experience in SQL, VBA (MS Access, MS Excel), stored procedures, ETL processes, database optimization, T-SQL, and database migration from Access to SQL Server.

Skills and Qualifications:

  • Strong proficiency with SQL and its variation among popular databases
  • Proficient developing in VBA (MS Access and MS Excel) and adhering to coding best practices
  • 2-4 years in general database development preferred MSSQL.
  • Advanced level of writing stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks.
  • Skilled at optimizing large, complicated SQL statements
  • Knowledge of best practices when dealing with relational databases
  • Capable of configuring popular database engines and orchestrating clusters as necessary
  • Ability to plan resource requirements from high level specifications
  • Capable of troubleshooting common database issues
  • Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Proficient understanding of code versioning tools such.
  • Visual Studio, ASP.Net, VB.Net, SQL Server Management Studio, Python.