Designs and develops Microsoft SQL Server database objects, including schemas, tables, views, stored procedures, functions, and ETL/ELT pipelines. Tunes queries, indexes, and execution plans to meet performance SLAs; implements data quality, governance, auditing, and transactional integrity. Maintains system integrations, collaborates with application engineers and analysts, participates in reviews, and resolves production issues. Requires expert T-SQL, full software development lifecycle experience, SQL Server expertise, version control, scripting, debugging, and database development experience.
Duties & Responsibilities
- Design & development: Build robust schemas, tables, views, stored procedures, functions, and ETL/ELT pipelines in Microsoft SQL Server (Azure SQL, Managed Instance).
- Performance & reliability: Profile and tune queries, indexes, and execution plans;
- come up with solutions to improve the performance to meet SLAs.
- Data quality & governance: Implement constraints, validation, and auditing; contribute to data standards, naming conventions, and documentation.
- Integration: Build and maintain integrations with upstream/downstream systems and ensure transactional integrity.
- Collaboration: Work with application engineers and analysts to translate requirements into scalable database solutions; participate in code/design reviews.
- Support: Respond to any production issues with urgency.
Requirements
Basic Qualifications
- Bachelor’s degree or equivalent work experience.
- Proficient in SQL programming.
- Expert TSQL skills (set-based programming, window functions, CTEs, error handling, dynamic SQL, MERGE).
- Experience with the full software development lifecycle, including design, testing, deployment, and documentation activities.
- 8+ years of experience designing and implementing MS SQL Server database objects.
- 8+ years of full software development lifecycle experience, including independent analysis, coding, testing, and deployment.
- 8+ years of experience working with SQL Management Studio.
- Experience with ETL/ELT (SSIS or modern alternatives) and scheduling/orchestration.
- 8+ years of combined experience developing solutions with relational database technologies.
- Proficient understanding of code versioning tools, such as Git.
- Ability to debug complex stored procedures.
- Knowledge of file transmission methods such as SFTP.
- Understanding of batch command /PowerShell scripts.
Preferred Qualifications
- Ability to understand C# code.
- Exposure to NoSQL stores (e.g., Cosmos DB, Redis, Couchbase)
Similar Jobs
Digital Media • Information Technology • News + Entertainment
Designs, implements, and maintains secure enterprise and data center network infrastructure. Manages Fortinet, Palo Alto, and F5 firewalls and load balancers; supports routing, switching, high availability, disaster recovery, monitoring, incident response, compliance, documentation, and automation. Collaborates with infrastructure teams and vendors, resolves complex production issues, performs root cause analysis, and mentors junior engineers.
Top Skills:
AnsibleBgpF5 Big-IpF5 DnsF5 GtmF5 LtmFortinetGitHsrpIgmpLacpMlagMulticastOspfPalo Alto FirewallsPimPort-ChannelPythonRest ApisStpVpcVrfVrrp
Digital Media • Information Technology • News + Entertainment
Build, maintain, and improve a software automation platform, including workflows, CI/CD pipelines, and Go- or Python-based tools. Collaborate with stakeholders to identify automation opportunities, troubleshoot incidents, improve reliability, and participate in on-call support. The role also involves system design, technical documentation, mentoring junior staff, software releases, performance analysis, and cross-functional collaboration with quality assurance.
Top Skills:
ArgocdAWSCi/CdDockerGoInfrastructure As CodeJenkinsKubernetesPythonTerraform
Digital Media • Information Technology • News + Entertainment
Builds, configures, maintains, and tests cybersecurity systems and infrastructure. Conducts security assessments, vulnerability testing, audits, and technical analysis across networks, applications, operating systems, and network devices. Supports security architecture, develops policies and documentation, recommends vulnerability remediation, and troubleshoots network stacks at scale. Requires knowledge of secure routing, DNS/DNSSEC, SDN, automation, high-availability architectures, and varied network platforms. Variable schedules, including nights and weekends, may be required.
Top Skills:
Antivirus SystemsCmtsCybersecurityDnsDnssecDocsisFirewallsIntrusion Detection SystemsNetwork AutomationNetwork MonitoringNetwork SecurityOperating SystemsOptical DevicesPonRoutersSdnSecure RoutingSwitchesTcpVcmtsVulnerability Assessment
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
