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
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Lead architectural design and innovation for aerospace tooling solutions within the ANTHEM platform. Collaborate with business and technology leaders to align architecture with strategic goals, ensuring scalable, secure, compliant, and reliable solutions. Guide software development, system integration, validation, and engineering productivity initiatives. Build and support a strong technical team through recruiting, talent development, succession planning, retention, and inclusive leadership.
Top Skills:
.NetAvionics Communication ProtocolsBambooC#C++Ci/CdCloud ComputingGenerative AiGrafana LokiLaunchdarklyMicroservicesOctopusOpenshiftPythonService-Oriented Architecture (Soa)
Digital Media • Information Technology • News + Entertainment
Develops and optimizes data structures, ingestion frameworks, ETL pipelines, warehouses, and data lakes. Ensures data quality, governance, lineage, and compliance while supporting analytics and machine learning initiatives. Designs storage solutions across on-premises and cloud platforms, manages migrations, develops APIs, monitors data flows, collaborates with technology and analytics teams, and participates in code reviews and model deployments.
Top Skills:
Amazon RedshiftAPIsAws S3DatabricksETLKubernetesMinioTeradata
Digital Media • Information Technology • News + Entertainment
Develop and maintain secure native iOS applications for the Xfinity App using Swift, SwiftUI, Objective-C, and iOS SDKs. Responsibilities include technical design, feature development, API and SDK integration, coding, unit testing, debugging, code reviews, CI/CD, crash monitoring, and App Store releases. The role also contributes to mobile SDK architecture, troubleshooting, risk communication, and Agile delivery.
Top Skills:
AnalyticsApp StoreCi/CdConcourseCrash MonitoringFrameworksGitIos SdkJenkinsMvvmObjective-CRestful ApisSdksSwiftSwiftuiUnit TestingXcode
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.
