Database Developer

Viaplus

The Role

Overview

Develop and maintain SQL Server databases, design, code, optimize, and support.

Key Responsibilities

  • database optimization
  • data security
  • performance monitoring
  • sql profiler
  • feature development
  • it infrastructure

Tasks

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 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 -Should also be able to optimize database performance, ensure data security and access controls, and monitor database health. -Monitoring Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

Requirements

  • sql server
  • t-sql
  • ssrs
  • db design
  • 2+ years
  • graduate

What You Bring

Any Graduate with B. E / B. Tech, MCA or equivalent degree with more than 2+ years relevant work experience. 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. Experience: 2 -4 yrs -Experience with either SQL 2005 or SQL 2008 R2 is a must. -Should have minimum 2+ years of experience in database development in a large enterprise environment. -Proficient in Relational Database Management Systems (RDBMS) -Proficient in Tuning T-SQL queries to improve the database performance and availability. -Candidate should be strong in Transact-SQL i.e. writing Stored Procedures, UDF and Triggers. -Strong experience in developing complex database code with T-SQL, SSRS and SQL Server following best practices to support UI, Middleware and Batch applications. -Have strong and confident communication skill set in customer support and presentation. -Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers -Understand Business Logic thoroughly and design, develop DB accordingly -Working Knowledge on SQL 2012 is an added advantage. -Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on). -Should possess practical workings with large data sets and DB volumes. -Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures. -Strong communication and problem-solving skills. skills and team work -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. -Familiar and expert in Database Design, Development & Support of MS SQL Server 2008/2005/2000for Production/development. -Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

The Company

About Viaplus

-is a leading player in the infrastructure and technology services industry, known for its innovative approach to solving complex challenges. -has been at the forefront of delivering large-scale infrastructure projects that span a variety of sectors including energy, utilities, and water resources. -specializes in creating sustainable, efficient, and scalable solutions tailored to its clients' needs. -has a commitment to leveraging cutting-edge technology and engineering expertise, making it a trusted partner for both public and private sector clients. -is recognized for its dynamic and agile approach to delivering projects on time and within budget, ensuring high-quality standards and client satisfaction. -has grown steadily, earning a strong reputation for its ability to integrate technological innovation with infrastructure expertise, ensuring future-ready solutions. -has become synonymous with excellence in large-scale infrastructure development, from complex transportation systems to sustainable energy projects.

Sector Specialisms

Electronic Toll Collection

Traffic Enforcement

Parking Management

Fare Collection

Smart Cities

Big Data Analytics

Customer Service Operations

Image Review Services

High-Volume Transaction Processing

Back Office Systems

Mobility as a Service

Revenue and Services Management Solutions

Transportation Industry Solutions

Mobility Back Office

Digital Payment Network

Data Analytics

Multimodal Mobility

Transportation Transaction Processing

Transit Industry Solutions

Customer Account Management

Mobility Ecosystem Solutions

Operational Excellence in Mobility

Traffic Systems

Free-Flow Traffic Systems

Transportation Infrastructure