Responsible for designing, developing, and maintaining advanced T-SQL queries and database solutions, optimizing performance, and collaborating across teams.
ProArch is seeking a highly experienced Sr. T-SQL Developer to join our dynamic team. In this role, you will be responsible for designing, developing, and maintaining advanced T-SQL queries and database solutions that drive our business applications. You will collaborate with various teams to optimize data handling and ensure high performance and scalability of our database systems.
Key Responsibilities:
- Design, develop, and optimize complex T-SQL queries, stored procedures, and functions to support business logic.
- Collaborate with cross-functional teams to gather requirements and convert them into technical specifications.
- Analyze and improve database performance by tuning existing queries and database structures.
- Participate in database design and data modeling efforts.
- Troubleshoot and resolve SQL-related performance issues and errors.
- Conduct code reviews to ensure adherence to best practices and maintain quality standards.
- Document database designs, changes, and procedures clearly for future reference.
- Stay updated on the latest T-SQL and SQL Server features, ensuring our solutions leverage current capabilities.
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 6+ years of experience in T-SQL development and SQL Server management.
- Proficient in writing complex T-SQL queries, stored procedures, and functions.
- Strong experience with SQL Server performance tuning and optimization techniques.
- Familiarity with data modeling and ETL processes.
- Experience with SQL Server integration services (SSIS) is a plus.
- Excellent analytical and problem-solving skills.
- Strong communication and collaboration abilities.
- Ability to work independently and as part of a team.
- Knowledge of version control systems (e.g., Git) is an advantage.
Contract
Remote
Top Skills
Git
SQL Server
Sql Server Integration Services (Ssis)
T-Sql
Similar Jobs
23 Days Ago
Consulting
This role involves designing, implementing, and managing AI infrastructure and networking solutions, creating technical research, and providing actionable advice to clients.
Top Skills:
AICloudDell Ai OfferingsHpe GreenlakeLenovo SystemsNetworkingNvidia
Automotive
This role involves designing interfaces, developing data products, and supporting digital transformations using various programming and database technologies.
Top Skills:
BitbucketCi/CdCSSDockerHibernateHTMLJ2EeJavaJavaScriptJenkinsJIRAJqueryJspKubernetesMs Sql ServerMySQLOracleQuality CenterRestful ApisSpringSpring BootStrutsXML
Software • Business Intelligence
As a Software Engineer for AI Training, you will create technical questions, review AI-generated code, and provide feedback on code quality and debugging strategies.
Top Skills:
C++GoJavaJavaScriptPythonTypescript
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
