02 Aug
|
Important Business
|
Chennai
02 Aug
Important Business
Chennai
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, energetic SQL, MERGE).
- Experience with the full software development lifecycle, including design, testing, deployment, and documentation activities.
- 6+ years of experience designing and implementing MS SQL Server database objects.
- 6+ years of full software development lifecycle experience, including independent analysis, coding, testing, and deployment.
- 6+ years of experience working with SQL Management Studio.
- Experience with ETL/ELT (SSIS or modern alternatives) and scheduling/orchestration.
- 6+ 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.