As a SQL Developer, with 5 to 8 yrs of experience, you will play a crucial role in designing, implementing, and maintaining the MSSQL database for our organization
This role involves working with other teams to understand their database requirements, writing and optimizing SQL queries, and ensuring data integrity and performance
The MS SQL Developer will also be responsible for database administration tasks, such as backups, security, and troubleshooting
Skills: MS SQL Server, SSIS, SSRS, Azure SQL
Others: Communication Skills
Education: Bachelors degree in Computer Science, Information Technology, or a related field (or equivalent experience).
Key Accountabilities: 1. Design, Develop, test and maintain our Database based on product/ projects requirement. 2. Develop new features directly impacting the future of our products/ projects. 3. Work with a small team(s) of experienced and talented developers to design and develop Databases with a focus on scalability, performance, and usability. 4. Take ownership of assigned tasks, features, and any other development activities in the product lifecycle from early conception to post-deployment in a fast-paced environment. 5. Employ best practices for code sharing and development to ensure common code base abstraction across all applications. 6. DB design /Stored Procedures/ Triggers / Tables /Query plan. 7. Good understanding on SQL Queries / Joins / Indexes / Jobs etc. 8. Analyze slow or poorly performing queries and optimize them for improved database efficiency. 9. Stay Updated with the latest MS SQL developments, trends, and best practices.
Knowledge, Skills & Attributes
1. Proven experience as a SQL Developer or similar role. 2. Strong knowledge of SQL and database design principles and data security best practices. Familiarity with data modeling tools. 3. SQL: Create, maintain, and manage SQL databases and should have worked on Complex Queries, Stored Procedures, Indexing, Database Schema, Query Optimization/ Performance Tuning. 4. Database design: Creating database tables, structures, schemas, and dictionaries based on user requirements. 5. Database development: Planning, developing, and implementing databases. 6. Database management: Ensuring databases are stable, reliable, and perform well. 7. SQL queries: Proficiency in writing and optimizing complex SQL queries, analyzing existing queries for performance, and suggesting new queries. 8. Reporting: Reviewing business report requirements, creating custom reports, and providing scheduled management reporting using SSRS. Having experience in Power BI will be an added advantage. 9. Data migration: Developing procedures and scripts for data migration. 10. Troubleshooting: Investigating exceptions and resolving database issues and errors. 11. Experience with version control systems (e.g., Git) is a plus. 12. Excellent problem-solving and communication skills.
Leadership: The Database Developer is expected to provide guidance, mentorship, and leadership to the development team, ensuring alignment with project goals and adherence to best practices.
Team Management: Responsible for overseeing the performance and productivity of the development team, fostering a collaborative and positive work environment, and facilitating effective communication within the team.
Deliverables: Accountable for the timely delivery of high-quality software solutions, coordinating with cross-functional teams as necessary to meet project deadlines and objectives.