Software Engineer - II - DataBase · Remote only · 5 - 7 years · Remote only · Posted 13 Sep 2023

Software Engineer - II - DataBase
Must have Expert level (5-7 years of development and maintenance experience) in MS SQL Server
· Excellent skills in writing Stored Procedures, functions, triggers, queries, scripts, etc.
· Excellent in troubleshooting, performance tuning, debugging, and query optimization
· Excellent in indexing, finding and resolving potential for database deadlocks
· Strong in database migrations and upgrades.
· Has experience with analytics and reporting.
· 3+ years of experience with SSIS, SSRS.
· Has experience with Access DB.
· Have a MS SQL Server certification OR are willing to obtain in a short time frame.

Similar jobs (1)
Position : SQL Database Developer
Experience : 10+ Years
Domain : Mutual Fund / Capital Markets
Location : Noida
Work Mode : Hybrid
Role Overview :
We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.
Mandatory Skills :
- SQL Server & T-SQL
- Stored Procedures, Functions, Triggers, Views & SQL Jobs
- Complex SQL Queries & Data Manipulation
- Query Performance Tuning & Optimization
- Indexing, Execution Plans & Partitioning
- Data Migration, Porting, Transformation & Validation
- Database Troubleshooting
- SQL Server Performance Monitoring
- Version Control / Git
- Database Security & Data Integrity
Domain Knowledge :
- Mutual Fund / Capital Markets experience preferred.
- Understanding of financial transactions, reporting, reconciliation, and business processes.
Key Responsibilities :
- Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
- Perform query tuning, indexing, execution plan analysis, and performance optimization.
- Handle data migration, transformation, porting, validation, and reconciliation.
- Troubleshoot database and production/UAT issues.
- Ensure data accuracy, integrity, consistency, and security.
- Work with developers, BAs, QA teams, and business stakeholders.
- Independently own database development and optimization activities.
- Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.







