SQL Developer

Company: Hunter Gibbons
Location: Towson
Posted on: August 1, 2020

Job Description:

Our Client is seeking a SQL Developer to add to the team. The ideal candidate is not just the cookie cutter type but someone who can think creatively, has strong analytical skills, and can present to large groups. Moreover, BS Degree is required with technical concentration and Client has great working environment with challenging projects and innovative technology. Due to Pandemic, the position will start remote but will eventually go back to onsite in MD in the future. SQL Developer ndash Baltimore, MD Responsibilities Design, develop, and execute ETL packages to convert client data using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment. Responsible for Development Maintenance of Microsoft Azure Cloud and On Premise Data Warehouse. Develop ETL processes using the Microsoft BI stack (SSIS, SSAS, SSRS) and Astera. Perform data analysis to identify data patterns and anomalies. Perform basic troubleshooting of conversion logic. Create and update conversion logic to resolve client issues in test and production environments. Engage in query performance tuning. Develop and modify stored procedures and T-SQL scripts in response to validation exceptions. Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion projects. Perform SQL Server administration activities (backup, restore, DBCC commands, indexing, shrink). Stay current with Microsoft SQL Server technologies and current database concepts Qualifications Bachelorrsquos Degree in Computer Science or Management Information Systems (MIS) 5 years of experience. Ability to work well within deadline-oriented development structure. Ability to work well both independently and collaboratively within a team environment. Strong technical abilities and desire to learn new things. Excellent interpersonal skills including verbal and written communication skill, teamwork, and customer service skills. Technical knowledge requirements Proficiently use Microsoft SQL Server Management Studio (SSMS) 2008 R2 and 2012 Write and maintain stored procedures and functions using T-SQL and SSMS Use aggregate functions in Microsoft SQL Server Create and maintain complex queries in Microsoft SQL Server using T-SQL Understand and use database schemas, tables, relationships, and constraints Develop, maintain, and troubleshoot conversion packages using SQL Server Business Intelligence Design Studio

Keywords: Hunter Gibbons, Towson , SQL Developer, Other , Towson, Maryland