Database Development Engineer

Maganti IT Resources LLC; Atlanta (GA); On-site; USD 80,000 - 110,000; Full time

Job summary

Maganti IT Resources LLC is looking for a skilled SQL Server Developer to join their Atlanta team. The ideal candidate will have 5-7 years of experience in SQL Server development with a strong focus on transactional systems and optimization techniques.

Preferred qualifications include a BE or BS degree in Computer Science or related fields, proficiency in T-SQL coding, and experience with large databases. Familiarity with NoSQL data platforms and data analytics is a plus.

Qualifications

• 5-7 years of experience in SQL Server development, focusing on transactional systems.
• Understanding of SQL Server database engine and optimization techniques.
• Experience with NoSQL platforms and data analytics tools like Hadoop.

Skills

SQL Server development

T-SQL coding

Optimization techniques

Large databases

SSIS package development

Code management tools

NoSQL data platforms

Education

BE or BS Degree in Computer Science, Information Technology, or Engineering

Tools

Visual Studio SSDT

Job description

Desired Skills & Experience

• 5-7 years of experience in SQL Server development with emphasis on transactional systems
• BE or BS Degree in one of the following subject areas: Computer Science, Information Technology, or Engineering. Advanced degrees preferred.
• Proficient in T-SQL coding for Stored Procedure development
• Experience with optimization and troubleshooting techniques to address performance problems
• Experience with large databases (terabyte +) is preferred
• Must have a strong understanding of the SQL Server database engine including but not limited to: Index creation and tuning, Physical database design best practices, Query Plan Optimizer
• Experience with advanced SQL Server features including: Partition tables, Change Data Capture, Replication
• Experience with SSIS package development
• Experience with various control flow containers: For Loop, For Each Loop, Sequence
• Experience in data flow and data transformation controls
• Package configurations
• Experience with code management tools and techniques
• Experience with source control tools
• Experience performing code deployments and keeping SQL objects in the correct version
• Use of Visual Studio SSDT a plus
• Additionally, experience with NoSQL data platforms to support specialized application services
• Hadoop/Redshift or similar for large scale data analytics utilizing Map Reduce, Couchbase or similar key/value or document data store for high performance cache layer