Designation: SQL Developer

Location: Mohali, Chandigarh

& Responsibilities

- Create and manage data marts, SQL Server Objects, including tables, views, stored procedures, triggers, etc., according to business requirements.
- Architect the database for reporting efficiency, and implement best practices.
- Optimize queries, stored procedures, and indexes to improve reporting performance.
- Participate in design sessions with other developers in the development team. Analyze data and provide recommendations for new reports/dashboards.
- Communicate effectively with different groups, and work as a team-player.
- Perform on-going research to explore new features, versions, and related technologies, and provide recommendations to enhance our offerings.
- Assist with the transfer of knowledge of technical skills.
- Competent to work at the highest level of all phases of software development.
- Performs other duties as assigned.

Education

- BE, B. Tech, M. Tech in Computer Science or equivalent.

Certifications

- Knowledge of CLR(C#) SQL functions.
- Knowledge of Database Replication.
- PagKnowledge of Online Analytical Processing (OLAP)/DataWarehousing.
- Knowledge of Performance Tuning and Optimisation.
- Knowledge of Relational Database Management System (RDBMS).
- Knowledge of SQL. Knowledge of Store Procedure.
- Knowledge of SSIS. Knowledge of SSRS.

Work Experience

- 04 to 12 years of experience as a SQL Developer.




- Experience in Airlines or travel domain is a plus. Skills

Skills

- Excellent problem solving, analytical, and troubleshooting skills.
- Extensive knowledge of T-SQL language.
- Thorough understanding of database schema design and concepts.
- Very strong knowledge of Relational Database Management System (RDBMS) concepts within SQL Server 2005 or above.
- Strong understanding of Online Analytical Processing (OLAP)/DataWarehousing concepts.
- Knowledge of : SQL Server Reporting Services (SSRS) is a huge plus.
- Proficient in data validation, interpreting and displaying data.
- Ability to work and deliver in an environment with little supervision.
- Strong interpersonal skills and ability to communicate effectively.
- Strong desire to explore new features and product capabilities. Knowledge of CLR(C#) SQL functions is a plus.
- Solid knowledge in performance tuning and optimization.
- Strong knowledge of database replication and high-availability solutions.
- Troubleshooting performance with Profiler and Execution Plans.
- Index creation and implementation.
- Strong communication skills.
- Strong organizational, multi-tasking, and time-management skills.
- Possess a strong work ethic and a high level of professionalism

Pay: Up to ₹3,000,000.00 per year

Advantages

- Paid time off

Work Location: In person

📌 SQL Developer (Sahibzada Ajit Singh Nagar)
🏢 Revenue Technology Services
📍 Sahibzada Ajit Singh Nagar