Senior Database Developer - SQL Server

Job Title: Senior Database Developer SQL Server

Location: Bengaluru (Onsite)

Experience: 5 to 7 Years

Employment Type: Full-Time

Database Development & Engineering:

- Design, develop, implement, and maintain robust database solutions using Microsoft SQL Server.

- Develop and optimize complex SQL queries, stored procedures, views, triggers, user-defined functions, and scripts.

- Build scalable and maintainable database architectures that support business growth and application performance.

- Create reusable database components and coding standards to ensure consistency across projects.

- Develop data validation, transformation, and migration processes for enterprise applications.

- Ensure data integrity, consistency, and reliability across database systems.

Performance Tuning & Optimization:

- Analyze and optimize database performance through indexing strategies, partitioning, query tuning, and execution plan analysis.

- Monitor database health and proactively identify bottlenecks affecting application performance.

- Investigate slow-running queries and recommend performance improvements.

- Optimize database structures and storage utilization to improve efficiency and scalability.

- Implement best practices for database maintenance, statistics management, and resource optimization.

Data Modeling & Database Architecture:

- Participate in database design discussions and architectural reviews.

- Design logical and physical data models based on business requirements.

- Create and maintain database schemas, tables, relationships, constraints, and normalization strategies.

- Ensure database designs align with scalability, security, and performance requirements.

- Support data governance and data quality initiatives.

Production Support & Incident Management:

- Provide L2/L3 production support for database-related issues and incidents.

- Investigate, troubleshoot, and resolve complex database problems within agreed SLAs.

- Perform root-cause analysis (RCA) for recurring database issues and implement preventive measures.

- Support production deployments, release activities, and post-deployment validation.

- Collaborate with support teams to ensure high availability and reliability of database systems.

- Participate in on-call support activities when required.

Application Integration & Collaboration:

- Work closely with application development teams to design efficient data access layers.

- Support API integrations and backend services requiring database connectivity.

- Collaborate with architects and developers to implement optimal database solutions.

- Assist in reviewing application database interactions and recommend improvements.

- Participate in Agile ceremonies including sprint planning, daily stand-ups, retrospectives, and design reviews.

Security & Compliance:

- Implement database security best practices including user access controls, permissions, and encryption.

- Ensure compliance with organizational security standards and data protection policies.

- Support audit and compliance activities related to database systems.

- Maintain backup, recovery, and disaster recovery strategies.

Continuous Improvement:

- Stay updated with the latest SQL Server features, database technologies, and industry best practices.

- Recommend process improvements, automation opportunities, and performance enhancements.

- Contribute to technical documentation, knowledge-sharing sessions, and mentoring activities.

Mandatory Skills & 5 to 7 years of relevant experience as a Database Developer, SQL Developer, or Database Engineer.

- Proven experience working with enterprise-scale database environments.

- Strong experience supporting mission-critical production systems.

SQL Server Expertise:

- Extensive hands-on experience with Microsoft SQL Server.

- Strong knowledge of SQL Server architecture, administration concepts, and database internals.

- Expertise in developing:

1. Stored Procedures

2. Functions

3. Views

4. Triggers

5. Dynamic SQL

6. CTEs (Common Table Expressions)

7. Temporary Tables

8. Advanced Joins and Subqueries

- Strong experience with indexing strategies and execution plan analysis.

- Knowledge of normalization, denormalization, constraints, and database design best practices.

(ref:hirist.tech)