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.