Role : Lead SQL Developer

Location : Bengaluru/Coimbatore/Mysore

Full time

Responsibilities :

- Develop stored procedures, functions, packages, triggers, views, CTEs using T-SQL.

- Design logical and physical data models along with collaring, preparing, and presenting statistical information for both internal and external use.

- Ensure database optimization, integrity, consistency, security, and privacy.

- Providing support, guidance and collaborating with Application Developers to implement database design, and review developer's work to ensure correct implementation.

- Create scripts to build new database objects.

- Perform schema design, code review and SQL query tuning using execution plans and other audit mechanisms to find the bottlenecks in the Query execution.

- Participate in SQL code reviews, write and deploy SQL Objects in production and implement HA/DR using SQL Server Always-on Availability Groups.

- SQL server administration experience, including knowing the basics of running Microsoft SQL Server - users, permission, backups, recovery, monitoring, and more.

- Continually evaluate software components and tools for software applications, making recommendations for system improvements as required.

- Work in conjunction with the service layer to resolve issues, evaluate software modules, and develop appropriate specifications.

- Ability to work with a team in an Agile environment-you can address bugs with QA, plan schemas with engineering, and respond quickly to other business needs.

- Provide input guidance on the design and implementation of data solutions to team

- Review and evaluate the performance of the development team and of the individuals on the team

- Remain accountable for project deliverables, schedules and quality Serve an interface with IT and business partners on database side of projects

Minimum Requirements :

- 6+ years working as a database developer, database engineer with Microsoft SQL Server as primary DBMS.

- Bachelor's degree in engineering or computer science.

- Ability to create BI Solutions both (ETL and Reporting).

- Highly organized and self-motivated with the ability to prioritize projects, meet deadlines, and make room for emergencies, as needed.

- Great Communication skills needed to interact with US customers

- Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.

Good to have :

- Hands-on experience with python pandas and DBMS systems MySQL and Postgres SQL databases is a plus.

- Databricks/Snowflake/Azure/AWS/GCP