Database Developer (Sql Server)

ViaPlus; Hyderabad; On-site; INR 2,000,000 - 3,200,000; Full time

Job summary

ViaPlus is seeking an experienced SQL Server Database Developer to join our growing team in India. The role focuses on designing, developing, implementing, and supporting database code in collaboration with the application development team to support our expanding suite of applications.

Ideal candidates will have 8-14 years of database development experience, strong Transact-SQL skills, and a track record of performance optimization and data security.

Qualifications

• 8-14 years of database development experience in a large enterprise environment.
• Strong knowledge of Transact-SQL and database design.
• Experience with tuning, security, and monitoring of databases.

Responsibilities

• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Understand Business Logic and design, develop DB accordingly.
• Optimize database performance and ensure data security and access controls.
• Monitor database health and manage large data sets.
• Develop high-quality database solutions and manage large scale DB systems.

Skills

SQL Server

Transact-SQL

Database Design

OLTP systems

Performance Tuning

SQL Profiler

SQL Server 2012

Communication skills

Education

B.E./B.Tech/MCA

Tools

MS SQL Server

SQL Server 2008/2005/2000

SQL Server 2012

SSRS

Job description

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 system

About 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 Clients

Certifications:

ISO/IEC 27001:2013 | ISO 9001:2015 | PCI/DSS

Job Profile:

PSE – SQL Server

Experience:

8 -14 yrs

Job Responsibilities:

• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Understand Business Logic thoroughly and design, develop DB accordingly
• Should 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

Skill Set:

• Strong communication and problem-solving skills. skills and team work
• Should 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/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 7+ years relevant work experience.