SQL Database Solutions Specialist

ViaPlus is actively searching for a passionate, innovative, and results-oriented DB technical professional with a profound commitment to success to join our database development team. In this role, you will contribute to the development of database systems that support information systems. This involves studying operations, designing, developing, and installing software solutions, as well as providing support and guidance to the software team. If you are enthusiastic about driving success in the realm of database development, we invite you to be a part of our dynamic team at ViaPlus.As a database developer, you will play a key role in delivering SQL Server database solutions to support an expanding suite of applications. Thriving in a fast-paced environment, you will need to quickly grasp new concepts with minimal guidance. Your responsibilities will encompass the design, development, implementation, and support of database code. Working closely with the application development team, you will also be engaged in database engineering tasks, including data conversions, process optimization, and overall database development. Your contribution will be essential to the seamless functioning of our database systemAbout Viaplus:ViaPlus is a global mobility company in the Intelligent Transportation Systems (ITS) market, specializing in revenue and services management solutions for the transportation industry. Our customer operations, data analytics, and full-featured single-account back office technology facilitate the high-volume transactions, required for seamless multimodal mobility. As a VINCI Concessions subsidiary, we are committed to technical innovation and to promoting a positive mobility experience for all. We are pioneers in the transportation transaction and mobility industry, with a decade of proven global experience in providing solutions focused on the tolling and transit industries.ViaPlus is headquartered near Dallas, Texas and maintains offices across the United States and in France, India, and Ireland. We are part of the global network of VINCI Concessions, an international player in transport infrastructure with projects in 23 countries. Our vision has evolved to provide a fully automated, end-to-end transportation solution that significantly improves revenue collection and efficiency while effectively lowering costs for our agency clients.We serve enterprises that require high-volume, real-time transactions processing with the highest levels of accuracy, especially where revenue reconciliation and customer account management are key deliverables to the customer experience. Our flagship back office system (BOS) enables Mobility-as-a-Service (MaaS) with a “one account” feature that supports multimodal transportation solutions. In a rapidly-changing environment, ViaPlus maintains a strong focus on technology and continuous R&D to improve agency efficiencies, reduce operating expenses, and maximize revenue – all while providing exceptional customer service.About Indian Operations:Plan, Design and Develop New Features for our Products | Customize our product on request from our premium Clients | Provide end-to-end IT Infrastructure set-up and Maintenance for global Clients | 24/7 Support and provide services to our ASP ClientsCertifications:ISO/IEC 27001:2013 | ISO 9001:2015 | PCI/DSSJob Profile: Software Engineer – SQL Server Experience: 2 -4 yrsJob 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 TriggersSkill Set:Strong communication and problem-solving skills. skills and team workShould have minimum 2+ 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/modeling, OLTP systems.Experience with either SQL 2005 or SQL 2008 R2 is a must.Working Knowledge on SQL 2012 is an added advantage.Have strong and confident communication skill set in customer support and presentation.Qualifications:Any Graduate with B. E / B. Tech, MCA or equivalent degree with more than 2+ years relevant work experience.