SQL Developer

Job Description

Greetings from Colan Infotech!! Designation - SQL Developer Experience - 7+ Years Job Location - Chennai Notice Period - Immediate to 15 Days Key Responsibilities: Manage and maintain high-performance SQL Server databases supporting critical capital markets applications Perform backup, recovery, high availability (HA), and disaster recovery (DR) planning and implementation Optimize SQL queries, indexes, and database performance for large datasets typical of trading and market data systems Ensure data integrity and security in line with regulatory and compliance requirements Work closely with application development and infrastructure teams to support database integration and deployment Monitor database health, generate reports, and provide proactive solutions to potential issues Lead database upgrade and migration projects Support real-time data flows and batch processes used in trading, settlements, and market data analysis Implement and maintain replication, clustering, log shipping, and Always On availability groups. Required Skills & Qualifications: 7+ years of experience as a MS SQL DBA Strong knowledge of SQL Server 2016/2019/2022, including internals, query tuning, and HA/DR features Experience working in Capital Markets, with understanding of trading systems, order management, or market data Solid understanding of T-SQL, performance tuning, and execution plans Familiarity with financial data handling, compliance (e.g., MiFID, FINRA), and low-latency data operations Experience with automation and scripting using PowerShell Strong troubleshooting and problem-solving skills Knowledge of data warehousing, ETL processes, and reporting tools (SSIS, SSRS) Ability to work in fast-paced, high-pressure financial environments Preferred Qualifications: Experience with cloud-based SQL solutions (Azure SQL, AWS RDS, etc.) Exposure to DevOps practices and CI/CD for databases Certification in Microsoft SQL Server (e.g., MCSA, MCSE) Show more Show less