Role description
Job Title : SQL DBA
Exp : 7-10 Yr's
Primary Skills : SQL Server, OOPs, schema design, index strategies, performance tuning, data modeling
Job Description :
Candidate should have experience on SQL Server and advanced knowledge of OOPs, schema design, index strategies, performance tuning, and data modeling.
Seeking an experienced and driven Senior Database Developer with a strong focus on SQL Server and advanced knowledge of Object-Oriented Programming (OOPs) concepts.
This role requires a seasoned professional with 7–10 years’ experience, adept at designing and maintaining complex database systems. The ideal candidate will also have the flexibility and willingness to work with backend languages such as Java or .NET as business needs arise.
Job Description: Design, develop, and optimize complex SQL Server databases, including schema design, index strategies, performance tuning, and data modeling. Author, review, and maintain complex stored procedures, functions, triggers, and views for mission-critical applications. Implement database best practices for security, integrity, backup/recovery, and high availability. Collaborate closely with backend development teams to bridge application and database logic, leveraging solid OOPs knowledge and working comfortably with Java or .NET-based applications as needed. Participate in system design sessions, architecture reviews, and integration discussions to influence application and database design using OOPs principles. Analyze, troubleshoot, and optimize slow-performing queries and processes in high-volume/transactional environments Skills & Qualifications: 7–10 years of hands-on experience as a Database Developer with deep expertise in SQL Server (2016/2019 or higher). Strong command of T-SQL, query optimization, and transaction management. Proven experience in database schema design, normalization/denormalization, indexing, and data integrity enforcement. Advanced understanding of OOPs concepts and practical ability to apply them when integrating with backend applications. Working experience and flexibility in developing/supporting backend logic using either Java or .NET (C#, ASP.NET), or both. Exposure to ETL processes and data migration, preferably using SSIS or equivalent tools. Proficient with source control (Git, TFS) and SDLC best practices. Excellent analytical, problem-solving, and troubleshooting skills
Skills
SQL Server, OOPs, schema design, index strategies, performance tuning, data modeling, SQL DBA