Senior SQL Developer

Irth Solutions, L.L.C.; India; In loco; INR 1.500.000 - 2.300.000; Tempo pieno

Descrizione del lavoro

Irth Solutions, L.L.C. in India seeks a SQL Developer to join a team of Mobile, WPF and .NET developers to administer, develop and maintain large-scale web/database solutions critical to our customers' missions.

The ideal candidate has 6+ years of MS SQL Server experience, expertise in SSRS/SSIS/SSAS, and strong skills in T-SQL, stored procedures, and data security. You will troubleshoot performance issues and contribute to BI reporting with Power BI.

Competenze

• 6+ years of experience with MS SQL Server technologies.
• Experience in performance troubleshooting and tuning of SQL queries.
• Experience in writing complex stored procedures, triggers, views, etc.
• Knowledge of SSRS, SSIS and SSAS; experience with other Microsoft technologies such as Visual Studio, C#.NET, WCF is a plus.
• Strong communication and problem-solving skills; ability to interact with all levels within the company.

Mansioni

• Maintain and enhance a NET/SQL Server based application using latest Microsoft .NET technologies.
• Create and build data stores and queries required for MS Reporting Server.
• Troubleshoot performance, capacity and data security issues.
• Collaborate with business team on impact of database changes and provide guidance.
• Build stored procedures, views, DDL, triggers; may participate in code-based solutions in C# and .NET.
• Perform other duties as assigned.

Conoscenze

MS SQL Server

Performance troubleshooting

Stored procedures

Triggers

Views

SSRS

SSIS

SSAS

Visual Studio

C#.NET

WCF

Power BI

Problem solving

Communication

Project management concepts

Stakeholder communication

Data security

Strumenti

Visual Studio

C#.NET

WCF

Descrizione del lavoro

The SQL Developer will join a team of Mobile, WPF and NET developers to administer, develop and maintain several large-scale Web/database solutions that are critical to our customer's mission and operations. The successful candidate will be passionate about helping organizations achieve transformational results. He or she will be a team player with excellent communication and problem-solving skills.

PRIMARY RESPONSIBILITIES

• Maintain and enhance custom NET/SQL Server application based upon the latest Microsoft NET technologies.
• Create and build data stores and queries required or MS Reporting Server.
• Troubleshoot performance, capacity and data security issues.
• Participate in a collaborative development environment, providing assistance & technical guidance to business team members on impact of database changes.
• Support the development team by building stored procedures, views, DDL, triggers etc. (If experienced with C# and NET, may participate in building code-based solutions.)
• Perform other duties as assigned.

SKILLS/ EXPERIENCE

• 6+ years of experience with MS SQL Server technologies.
• Experience performance troubleshooting and tuning of SQL queries.
• Experience in writing complex stored procedures, triggers, views, etc.
• Proven knowledge in SSRS, SSIS and SSAS, is a plus.
• Experience in or knowledge of other Microsoft technologies such as Visual Studio,
  C#.NET, WCF, is a plus.
• Thorough understanding of systems and developing business application.
• Knowledge of project-management concepts and techniques.
• Ability to analyze complex applications and systems and program with minimal interfaces.
• Strong problem-solving skills to determine programming effects on existing systems.
• Strong decision-making skills for problem identification and solution recommendation.
• Excellent written and oral communication skills to prepare and communicate programming plans and procedures.
• Ability to interact with all levels within the company.
• Should have good knowledge of Power BI and SSRS

• Being an integral part of a dynamic, growing company that is well-respected in its industry.
• Competitive pay based on experience.