Senior SQL Developer

8 - 12 years

0 Lacs

Posted:1 day ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Role Overview: As an experienced Database Developer, you will be responsible for designing databases and ensuring their stability, reliability, and performance. Your role will involve designing, creating, and implementing database systems based on end user requirements. You will take on technical leadership responsibilities for database projects across various scrum teams and will be capable of designing, coding, and maintaining SSRS/SSIS packages. Additionally, you will be expected to improve application performances, prepare documentations for database applications, and ensure data quality and integrity in databases. Key Responsibilities: - Design databases and ensure stability, reliability, and performance. - Design, create, and implement database systems based on end user requirements. - Take on technical leadership responsibilities for database projects across various scrum teams. - Design, code, and maintain SSRS/SSIS packages. - Understand and assist in AlwaysOn, Disaster Recovery, and High Availability. - Improve application performances. - Prepare documentations for database applications. - Manage memory for database systems. - Develop database schemas, tables, and dictionaries. - Ensure data quality and integrity in databases. - Fix database performance issues and provide corrective measures. - Create functions, scripts, stored procedures, and triggers to support application development. - Perform regular database backups. - Test databases and perform bug fixes. - Provide authentication and authorizations for the Database. - Develop best practices for database design and development activities. - Analyze existing T-SQL code and make improvements to enhance performance, security, robustness, and maintainability. Qualification Required: - 8-12 years of experience in SQL Development. - Knowledge of Cursors, Functions, Batch Operations, XML Parsing, Stored Procedures, Triggers, Error Handling, and Views. - Experience in Physical Design including Partitioning Views, Vertical Partitioning, and Horizontal Partitioning. - Proficiency in Performance Tuning with Temp Tables, CTE, Execution Plan, Indexing Strategy, Data Access Pattern, Isolation Levels, Indexed Views, and Statistics KPI. - Familiarity with Administration tasks such as Always On, High Availability Strategies, SSIS, SSRS, Backup and Restore, Auditing, Partitioning Tables, Monitoring Environments, Troubleshoot Outages, and Install Config Environments. - Understanding of SQL security techniques including data encryption, Transparent Data Encryption (TDE), signed stored procedures, and user permissions. - Knowledge of data modeling, SSRS reports, and Continuous Integration and Continuous Delivery (CI/CD) application deployment cycle. Please send your resume to careers@savitr.com.,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

hyderabad, telangana, india

hyderabad, pune, bengaluru

hyderabad, telangana, india

hyderabad, telangana, india

noida, uttar pradesh, india