"Sr Database Engineer"

Overview

Sr. Database Engineer and below are the mandate pointers -

• Advanced proficiency in T-SQL, including complex queries, stored procedures, triggers, Functions and experience with SQL Server tools (e.g., SSMS, Profiler, SSIS).
• Solid experience with ADF ETL processes, data warehousing, and reporting services (SSRS). (preferably Azure cloud)
• Knowledge of performance tuning and query optimization techniques.
• Proficiency in SQL, NoSQL, and NewSQL databases (e.g., MySQL, PostgreSQL, MongoDB, Cassandra).
• Shift Timings - 3 PM to 12 AM
• Preferably candidates from Bangalore Location
• 10+ years of experience
• Individual Contributor Role
• Excellent Communication

Please note there are some changes in the JD which have been marked with Bold and underlined. Request you to share profiles accordingly.

Job Summary:

We are looking for a Senior MS SQL Developer to lead our database development efforts, optimize SQL Server databases, and support data-driven projects across the organization. The ideal candidate should have extensive experience with Microsoft SQL Server technologies, a strong focus on database performance and scalability, and the ability to design efficient data solutions that meet complex business requirements, and the ability to work collaboratively in a fast-paced environment.

Details on the desired Candidate Profile:

Responsibilities:

1. Database Management and Development

1. Design and develop complex SQL queries, stored procedures, triggers, views, and functions.

2. Create and optimize database schemas, tables, and indexes to improve data access and performance.

3. Develop and maintain Cloud ETL processes to support data integration and migration projects. (preferably Azure Cloud)

4. Perform data modelling, schema design, and indexing to enhance query performance.

5. Implement data security best practices and compliance with relevant standards (e.g., GDPR, HIPAA).

6. Oversee data backup, restoration, and recovery procedures.

2. Performance Tuning and Optimization

0. Monitor and troubleshoot database performance, identifying bottlenecks and implementing solutions.

1. Optimize queries, indexing, and data storage to ensure efficient data retrieval and minimize response time.

2. Implement database tuning recommendations and review execution plans to maximize performance.

3. Use SQL Server Profiler, Execution Plans, and Index Tuning to troubleshoot slow-running queries and improve query performance.

3. Cloud Technologies

0. Design and manage cloud-based database systems (e.g., AWS RDS, Azure SQL, Google Cloud SQL).

1. Collaborate with DevOps and IT teams to automate deployments and manage cloud environments.

4. Data Quality and Integrity

o Ensure data quality, consistency, and integrity through validation checks and error-handling mechanisms.

o Develop and enforce data governance policies, data validation, and integrity checks.

o Design and implement error handling, logging, and auditing for data processes.

o Design scalable database structures and schemas to support high-volume transactions and data growth.

5. Technical Leadership and Collaboration

1. Mentor junior engineers and support cross-functional team members in database and front-end development best practices.

2. Conduct code reviews, enforce standards, and lead efforts to optimize database and application performance.

3. Collaborate with business analysts, application developers, and stakeholders to gather requirements and design solutions.

Technical Skills:

• Advanced proficiency in T-SQL, including complex queries, stored procedures, triggers, Functions and experience with SQL Server tools (e.g., SSMS, Profiler, SSIS).
• Solid experience with ADS ETL processes, data warehousing, and reporting services (SSRS). (preferably Azure cloud)
• Knowledge of performance tuning and query optimization techniques.
• Familiarity with version control (e.g., Git) and Agile methodologies.
• Experience with cloud databases (e.g., Azure SQL, AWS RDS) is an advantage.
• Proficiency in Python, Java, or similar languages.
• Proficiency in SQL, NoSQL, and NewSQL databases (e.g., MySQL, PostgreSQL, MongoDB, Cassandra).

Requirements

Soft Skills:

· Strong analytical and problem-solving skills.

· Excellent communication skills, with the ability to explain technical details to non-technical stakeholders.

· Ability to work independently as well as collaboratively within a team.

Preferred Skills:

· Experience with big data platforms and data warehousing solutions. Solid experience with ETL processes, data warehousing,

· Knowledge of data visualization and reporting tools.

· Microsoft SQL Server certifications, such as Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics, Azure Database Administration etc.

· Experience with BI tools (Power BI, Tableau).

· Familiarity with NoSQL databases.

· Certifications related to SQL or database management (e.g., Microsoft Certified: Azure Database Administrator Associate).

· Familiarity with database automation and DevOps practices (e.g., CI/CD for databases).

· Experience with Azure SQL Database, Azure Data Factory, or similar cloud database technologies.

Education:

Bachelor’s degree in engineering (BE), Bachelor of Technology (BTech), Computer Science, Information Technology, or a related field.

Mandate * Notice Period : Immediate to 15 Days Time** ( Immediate Hiring) - High Priority **

Job Types: Full-time, Permanent

Pay: ₹1,549,384.96 - ₹2,050,349.68 per year

Benefits:

• Flexible schedule
• Health insurance
• Internet reimbursement
• Life insurance
• Provident Fund

Schedule:

• Evening shift
• Monday to Friday

Supplemental Pay:

• Performance bonus
• Yearly bonus

Education:

• Bachelor's (Preferred)

Experience:

• Microsoft SQL Server: 10 years (Required)
• Cloud Azure: 8 years (Required)
• ETL Process: 6 years (Required)

Work Location: Remote

Application Deadline: 20/03/2025
Expected Start Date: 25/03/2025