Job Description :
Job Title: SQL Developer
Location: Atlanta GA
Duration: Long term
Direct client: Yes
Interview type: In-Person Only
Local candidates strongly preferred
ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions
State Experience Highly Preferred
Education/Experience:
Description
This individual will support development of projects in full lifecycle. The ideal candidate will be experienced in writing SQL Stored Procedures, Query Performance Tuning, 24/7 high availability and Large Volume Handling of Data, in Large scale SQL 2014/2016 Enterprise servers in a multiple server.
Required
8+ years of professional development experience with SQL Server and Oracle databases.
Highly proficient with TSQL and PLSQL and related tuning with indexes and database parameters
Practical experience developing a data warehouse using dimensional modeling techniques
Proficient with developing methods of loading large volumes of data automatically into a database
. Experience in converting functional requirements into technical Specifications for Development
Experience with table partitioning strategies and related implementation
Proficient with interpreting query explain plans, reviewing data within tables and recommending indexing strategies
Experience with establishing methods for base-lining database performance and measuring improvements with changes
Capable of setting up database servers and instances from scratch on Windows
Experience in recommending and configuring optimal hardware solutions including storage area networks
Experience with Agile development practices and Scrum methodology
Preferred
. Strong knowledge of SQL Server system objects, DMV, and DMF T-SQL tuning, debugging, profiling, and troubleshooting skills using Performance Monitor, SQL Server Profiler, and Activity Monitor.
. Experience in design, deploy and manage SSIS and SSRS packages
. Experience with source control and change control and be able to generate creation, upgrade, and maintain scripts
Familiarity with data modeling design (CASE) tools (Erwin, Toad Schema Modeler, etc)