Principal SQL Developer

ViaPlus is seeking a passionate, innovative, and results-driven Principal Software Engineer with deep expertise in database technologies to join our dynamic Database Development and Administration team. In this strategic role, you will lead the design, development, and support of robust database systems that power our growing suite of applications. Collaborating closely with the application development team, you will drive the delivery of high-performance SQL Server solutions in a fast-paced, agile environment. Your leadership and technical skills will be instrumental in setting best practices for database design, performance optimization, scalability, and system integration.Job Responsibilities: Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.Understand Business Logic thoroughly and design, develop DB accordinglyShould possess practical workings with large data sets and DB volumes.Should also be able to optimize database performance, ensure data security and access controls, and monitor database health.Development of high-quality database solutions & managing large scale database system is a plus.Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).Strong experience in developing complex database code with T-SQL, SSRS and SQL Server following best practices to support UI, Middleware and Batch applications.Candidate should be strong in Transact-SQL i.e. writing Stored Procedures, UDF and Triggers.Proficient in Tuning T-SQL queries to improve the database performance and availability.Monitoring Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary/Foreign Keys.Providing production support of related systems and operations.Working knowledge of Power BI is a plus.Develop SSRS Reports and dashboards using Microsoft Reporting Services platform (SSRS), Microsoft SQL, MS Excel, pivot tables and other tools Analysis Services Cubes and relational databasesCreating SSRS reports for different departmentsAbility to work in Agile development environment and work effectively in a fluid/changing environment.Adhere to project timelines and deliverable, effective communication of changes or disruptions to the schedule with a focus on expectation alignmentExperience in architecture and design of high-Volume transaction processing database systems.Experience in Data Transformation Services like SSIS will be an added advantage. Provide regular and effective progress updates to and work closely with Development Project Managers to ensure the management of any delivery risks or issues.Responsible for managing technology in projects and providing technical guidance / solutions for work completion and able to lead and inspire their team, delegate tasks effectively, and provide guidance and mentorship to junior developers.Ensure process compliance in the assigned module and participate in technical discussions/review.Provide technical root cause analysis and mitigation planShould be able to create technical documents and diagrams

Skill Set:

Strong communication and problem-solving skills. skills and team workShould have minimum 7+ years of experience in database development in a large enterprise environment.Proficient in Relational Database Management Systems (RDBMS)Familiar and expert in Database Design, Development & Support of MS SQL Server 2008/2005/2000for Production/development.Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.Very good experience and understanding of database design/modelling, OLTP systems.Experience with either SQL 2005 or SQL 2008 R2 is a must.Working Knowledge on SQL 2012 is an added advantage.Performance tuning of database objects.Working knowledge in Database Administration & SQL Server Reporting.Ability to prioritize tasks effectively and reprioritize on short notice.Strong knowledge and understanding of RDBMS development techniques.Should be well versed with all phases of the SDLC.Software Development Process, Software Requirements, Software Architecture.Agile/Scrum project development.Strong problem-solving skills required.Have strong and confident communication skill set in customer support and presentation.Excellent Team Management skills should have experience in handing a team (5-9).Experience in communicating with engineering leadership to understand requirements describing software product features, technical designs, and product strategy