Highlights
Develop complex queries, optimize database performance, collaborate with application developers.
Description
Job Summary
pWe are currently seeking a highly skilled MS SQL Developer to join our dynamic team. The ideal candidate will possess extensive experience in database design and optimization. This role involves developing complex SQL queries, managing databases, and ensuring data integrity. Responsibilities include designing stored procedures, optimizing T-SQL queries, and collaborating with application developers for seamless integration.
Responsibilities
- Design, develop, and maintain stored procedures, functions, triggers, views, and indexes
- Write optimized T-SQL queries for reporting and business logic implementation
- Perform query tuning and database performance optimization
- Aid in ETL processes and data migration activities
- Support application developers to integrate databases with business applications
- Manage security, backup, and recovery procedures for databases
- Monitor database performance and troubleshoot issues effectively
- Maintain documentation of all database-related processes and structures
Required Skills
- Proficiency in MS SQL Server (2016/2019/2022)
- T-SQL, stored procedures, views, triggers, and indexing strategies
- Experience with query optimization and execution plans
- Familiarity with SSRS, SSIS, or other ETL tools
- Knowledge of database backup and recovery techniques
Required Skills Explained
- Strong knowledge of Microsoft SQL Server (2016 / 2019 / 2022)
- Proficiency in T-SQL, stored procedures, views, triggers, and indexing strategies
- Experience with execution plans and performance tuning
- Hands-on experience with SSRS, SSIS, or other ETL tools
- Knowledge of database backup and recovery strategies
- Understanding of transactions, locking, isolation levels, and deadlock handling
- Strong analytical and problem-solving skills
Who is this for
pThis position is ideal for individuals who have a strong background in MS SQL Server development. Candidates should possess excellent analytical skills and the ability to work effectively both independently and as part of a team.
Why This Job is a Good Opportunity
ulliPotential for hands-on work with complex SQL queries and performance optimization techniques.liOpportunity to collaborate with application developers and integrate databases with business applications, enhancing your technical skillset.liResponsibility in managing database security and ensuring data integrity, offering a chance to make significant contributions to the company's data management.liPotential for career advancement within an organization that values skilled professionals in database development and maintenance.
Interview Preparation Tips
- Review common SQL queries and performance tuning techniques thoroughly.
- Be prepared to discuss your experience with ETL processes, data migration activities, and SSRS or other reporting tools.
- Discuss specific examples of how you have optimized database performance in previous roles.
- Bring up any relevant experience with cloud-based databases such as Azure SQL.
Career Growth in This Role
pThis role offers a pathway for advancement in the field of database management and development. With experience, you can specialize further or transition into leadership positions where you could oversee teams of developers or manage large-scale data projects. The opportunity to work on high-availability solutions and other advanced techniques will also help build your expertise and make you a valuable asset to any organization.
Explore More Opportunities
Skills
Frequently Asked Questions
What is the working location for this role?This position requires an in-person work location.
Is there any flexible working arrangement available?Unfortunately, this role does not offer a remote or hybrid working option. The job is based on-site.
What are the benefits offered with this position?Benefits include health insurance and provident fund for permanent employees.
