Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

Senior SQL Developer

Tamil Nadu, India (On-site)

Senior SQL Developer

1 Month ago • 7 Years + • Administrative

About the job

9 skills required for this role

Add these skills to join the top 1% applicants for this job

ci-cd

github

azure

aws

sql

git

powershell

communication

agile-development

Job Description

As a Senior SQL Server Database Developer, you will design, develop, and maintain SQL Server databases. Responsibilities include optimizing complex T-SQL queries, designing data models, developing ETL processes using SSIS, and performing database maintenance tasks like backups and restores. You will collaborate with developers, data analysts, and stakeholders to ensure data integrity, performance, and security. The role requires proficiency in T-SQL, database design, normalization, and data modeling, along with experience in performance tuning, database security, and version control systems like Git. Troubleshooting database issues, ensuring data compliance, and creating comprehensive documentation are also key aspects of this position.

Must have:

7+ years SQL Server experience
Proficient in T-SQL
Database design & modeling expertise
SSIS experience for ETL
Performance tuning skills
Database security knowledge
Version control (Git)

Good to have:

SSRS & SSAS experience
Cloud SQL Server knowledge
PowerShell scripting
Agile methodology
DevOps for database CI/CD

Project description

As a SQL Server Database Developer, you will play a key role in building and optimizing database systems based on SQL Server. You will collaborate with developers, data analysts, and stakeholders to ensure data integrity, performance, and security, as well as provide efficient database solutions that align with business needs.

Responsibilities

Database Development: Design, develop, and maintain SQL Server databases, tables, views, stored procedures, functions, and triggers to support application development.

Query Optimization: Write and optimize complex T-SQL queries for performance, ensuring efficient data retrieval and manipulation.

Data Modeling: Design logical and physical data models, and create efficient database schemas to meet business requirements.

Data Integration: Develop ETL processes to import, export, and transform data between systems using SQL Server Integration Services (SSIS) or other data integration tools.

Performance Tuning: Analyze and optimize database performance, including indexing, query tuning, and database configuration for optimal performance.

Database Maintenance: Perform database management tasks, including backups, restores, index maintenance, and database monitoring.

Collaboration: Work closely with software developers, data analysts, and business stakeholders to gather requirements and develop database solutions that meet business needs.

Troubleshooting & Debugging: Identify, troubleshoot, and resolve database issues such as performance bottlenecks, query inefficiencies, and data inconsistencies.

Security & Compliance: Ensure database security, manage user permissions, and implement encryption and other security measures to protect sensitive data.

Documentation: Create and maintain documentation for database schemas, processes, and procedures.

Skills

Must have

7+ years of experience in SQL Server Database Development.

Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).

Proficiency in T-SQL, with the ability to write and optimize complex queries, stored procedures, and triggers.

Experience with SQL Server 2016/2019 or later versions.

Strong understanding of database design, normalization, and data modeling.

Experience with SSIS (SQL Server Integration Services) for ETL processes.

Proficiency in performance tuning, including query optimization and indexing strategies.

Experience in database security, including role-based permissions and data encryption.

Familiarity with database backup, restore, and disaster recovery procedures.

Experience with version control systems like Git for managing database scripts.

Strong analytical and problem-solving skills.

Excellent communication and teamwork skills.

Nice to have

Experience with SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).

Knowledge of cloud-based SQL Server (Azure SQL Database, AWS RDS for SQL Server) and related technologies.

Familiarity with PowerShell scripting for database automation.

Understanding of Agile methodologies and experience working in an Agile development environment.

Experience with DevOps tools for database CI/CD automation.

Other

Languages

English: B2 Upper Intermediate

Seniority

Senior

View Full Job Description

Upload your resume, increase your shortlisting chances by 80%

About The Company

Luxoft

1110 Active Jobs

Luxoft, a DXC Technology Company (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Acquired by U.S. company DXC Technology in 2019, Luxoft is a global operation in 44 cities and 21 countries with an international, agile workforce of nearly 18,000 people. It combines a unique blend of engineering excellence and deep industry expertise, helping over 425 global clients innovate in the areas of automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications.

DXC Technology is a leading Fortune 500 IT services company which helps global companies run their mission critical systems. Together, DXC and Luxoft offer a differentiated customer-value proposition for digital transformation by combining Luxoft’s front-end digital capabilities with DXC’s expertise in IT modernization and integration. Follow our profile for regular updates and insights into technology and business needs.