Aezion - Lead SQL Developer

Role : Lead SQL Developer

Location : 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 :

Good to have :

(ref : hirist.tech)