C

SQL Server Developer

Capco
NewPosted today

LOCATION

Bengaluru · Onsite

EXPERIENCE

6 - 12 Years

SKILLS REQUIRED

SQL ServerSQL DevelopmentT-SQLPerformance TuningDatabase DesignData ValidationAgile Methodology

Job description

Overview

Capco is hiring a SQL Server Developer to design, develop and maintain SQL Server database objects, optimise performance, and support data integration and ETL processes for client engagements.

What you'll do

  • Design, develop, test and maintain SQL Server database objects, including stored procedures, functions, views, triggers, and complex SQL queries.
  • Develop and optimise T-SQL code to support application functionality, data processing, and reporting requirements.
  • Design and implement efficient database schemas, tables, indexes, and relationships.
  • Troubleshoot and resolve database-related issues, ensuring reliability, performance, and data integrity.
  • Conduct code reviews and adhere to established development standards and best practices.
  • Analyse and optimise SQL query performance using execution plans, indexing strategies, and SQL Server performance monitoring tools.
  • Identify and resolve database performance bottlenecks.
  • Support database performance tuning, capacity considerations, and query optimisation activities.
  • Apply appropriate database design principles to ensure scalability, maintainability, and efficiency.
  • Develop and maintain data integration and ETL processes using SQL Server Integration Services (SSIS) or equivalent technologies.
  • Support data extraction, transformation, migration, and loading activities across multiple systems.
  • Implement data validation, reconciliation, and quality checks to ensure accuracy and consistency.
  • Collaborate with upstream and downstream application teams to support reliable data flows.
  • Participate in the full software development lifecycle, from requirements analysis and technical design through development, testing, deployment, and support.
  • Work within Agile delivery teams, contributing to sprint planning, daily stand-ups, retrospectives, and technical discussions.
  • Develop unit tests and support system integration testing, regression testing, and defect resolution.
  • Use source control and deployment tools to manage database code changes across environments.
  • Produce clear technical documentation covering database designs, data flows, and implementation decisions.
  • Collaborate with client stakeholders to understand business requirements and translate them into technical solutions.
  • Communicate technical concepts clearly to both technical and non-technical audiences.
  • Provide regular updates on delivery progress, risks, issues, and dependencies.
  • Take ownership of assigned deliverables, ensuring they are completed to agreed quality standards and timelines.
  • Contribute to continuous improvement initiatives and share technical knowledge with colleagues.

What you'll need

  • Hands-on experience in SQL Server development or a closely related database development role.
  • Strong proficiency in Microsoft SQL Server and T-SQL.
  • Demonstrable experience developing complex stored procedures, functions, views, and SQL queries.
  • Good understanding of relational database design, normalisation, indexing, and data modelling.
  • Practical experience in SQL query optimisation, execution plan analysis, and performance tuning.
  • Experience developing and supporting ETL processes, ideally using SSIS.
  • Understanding of database transactions, concurrency, locking, and data integrity.
  • Experience with Git, Azure DevOps, or equivalent source control and delivery tools.
  • Familiarity with database testing, debugging, troubleshooting, and production support.
  • Understanding of Agile software development methodologies.
  • Strong analytical and problem-solving capabilities.
  • Ability to work independently on defined technical deliverables with appropriate guidance.
  • Effective written and verbal communication skills.
  • Experience collaborating with cross-functional technology and business teams.
  • Ability to manage competing priorities and deliver within agreed timelines.
  • Proactive approach to identifying technical risks and recommending improvements.
  • Willingness to learn new technologies and adapt to different client environments.

Nice to have

  • Experience working within banking, capital markets, insurance, or other financial services environments.
  • Exposure to AWS, Java, Spark, Scala.
  • Experience with SQL Server Reporting Services (SSRS) or Power BI.
  • Familiarity with data warehousing concepts, dimensional modelling, and analytical databases.
  • Experience with CI/CD pipelines and automated database deployments.
  • Knowledge of Python, PowerShell, or other scripting languages.
  • Understanding of data governance, security, access controls, and regulatory considerations in financial services.
  • Exposure to cloud migration, database modernisation, or large-scale data transformation programmes.
  • Familiarity with high-availability and disaster recovery concepts.

Details

  • Location: Bangalore, Pune.
  • Experience: 6-12 years.

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

SQL Server Developer