Aezion.Inc
Location
Mysore | India
Job description
Role : Lead SQL DeveloperLocation : Bengaluru/Coimbatore/MysoreFull timeResponsibilities :- 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 projectsMinimum 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 (ref:hirist.tech)
Job tags
Salary
