India onlyKeyResponsibilities:
- Strong proficiency with T-SQL, SSIS.
- Strong experience with Microsoft SQL Server.
- Knowledge of ETL processes and tools.
- Skilled at creating and optimizing complicated SQL statements, stored procedures, and views.
- Knowledge of best practices when dealing with relational databases.
- Ability to plan resource requirements from high-level specifications.
- Capable of troubleshooting common database issues.
- Familiar with tools that can aid with profiling server resource usage.
- Proficient understanding of code versioning tools such as Git.
- Excellent problem solving and analytical skills.
- Strong communication and collaboration skills.
- Proficiency in T-SQL and Microsoft SQL Server.
- Database Design & Schema Development.
- Design efficient, normalized relational schemas for new applications and analyse/refactor legacy models.
- SQL Development & Query Optimization
- Write, optimize, and support complex SQL (SELECT, INSERT, UPDATE, DELETE), stored procedures, functions, views, triggers. Use execution plans, DMVs, profiling tools for tuning
- Performance Tuning & Troubleshooting
- Identify and resolve bottlenecks (deadlocks, long-running queries). Tune TempDB, indexes, partitioning on heavy workloads.
- Security, Backup & Recovery
- Set up role-based access, encryption, auditing. Perform backups, disaster recovery drills, and restore operations.
- Data Warehousing & Reporting Support
- Collaborate to meet data business needs.
- Database Lifecycle Management
- Oversee upgrades, migrations, version control.
- Help write and optimize in-application SQL statements and ETL processes.
- Ensure performance, security, and availability of databases.
- Prepare documentation of existing and new database structures
- Profile server resource usage and optimize and tweak as necessary.
- Collaborate with other team members and stakeholders.
- Identify and implement optimizations to improve database performance, such as index tuning and query optimization.
- Maintain documentation of database configurations, procedures, and troubleshooting steps.
- Apply patches and updates to SQL Server instances in a timely manner to address security vulnerabilities and ensure compliance.
- Good understanding of database design – physical and logical schemas, and database modelling.
- Collaborate with developers to design and optimize database schemas
- Experience in query optimization and writing complex SQL queries.
- Experience in troubleshooting and resolving database integrity issues, blocking, and deadlocking issues, as well as performance issues.
- Strong knowledge of indexes, index management, and configuration management.
- Work on projects as needed in close coordination with Architects, Project Managers, Application Architects, and Development teams.
- Ensure team collaboration using Jira, Confluence, and other tools.
- Good to Have: ETL / Data Integration
- Design, implement, and optimize ETL pipelines (SSIS, Azure Data Factory, Informatica, Python scripts) ensuring clean data movement.
- The essential scope of the role is balancing hands-on SQL expertise, database operations, performance tuning, and cross-team collaboration.
