Primary Skills: SQL, SSDT, SSIS package
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 Couch base or similar key/value or document data store for high performance cache layer
Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects
Skills Required
- 5-7 years of experience in SQL Server development, with emphasis on transactional systems
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related subject area
- Proficiency in T-SQL and stored procedure development
- Experience with database optimization and troubleshooting for performance problems
- Strong understanding of the SQL Server database engine, including index tuning, physical database design, and query plan optimization
- Experience with SQL Server partition tables, Change Data Capture, and replication
- Experience developing SSIS packages, including control flow containers, data flow, data transformation controls, and package configurations
- Experience with code management, source control, code deployments, and SQL object versioning
- Experience with large databases of one terabyte or more
- Advanced degree
- Experience using Visual Studio SSDT
- Experience with NoSQL data platforms, Hadoop or Redshift, MapReduce, and Couchbase or similar technologies
What We Do
Maganti IT Resources is an IT engineering and software-delivery firm serving manufacturers, regulated enterprises, and other organizations. It provides custom software development, application modernization, cloud and DevOps services, software testing, AI solutions, cybersecurity, and technology staffing. The company helps clients modernize systems and scale execution while emphasizing predictable delivery, built-in quality, security, and compliance. Its work supports reliable software and technology operations from development through production.







