Job Description

We are looking for a SQL lead with minimum 10 years of experience to develop MS-SQL and MySQL queries and procedures, create custom reports, and modify ERP user forms to enhance organizational productivity. You will be responsible for designing databases and ensuring their stability, reliability and performance.

Education : Any Graduate

Location : Hyderabad

Desired Candidate Profile

• Ability to create database design
• Help create Tables, SQL statements for data presentation and further automation
• Setting up and monitoring routine maintenance SQL jobs and developing / maintaining an alert strategy's for failed jobs and database problems and/or failures
• Good knowledge of implementation SAAS architecture
• Automatic deployments using CI/CD
• Good knowledge of deployment to multiple databases with zero downtime
• Ability to handle team, estimations and delivery
• Modify / update T-SQL scripts for importing and organizing data
• Work closely with analysts and other department personnel in advising best SQL coding practices
• Ability to manage multiple projects simultaneously within time and budget constraints
• Responsible for data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
• Ability to implement SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services)
• Strong data management skills
• Good understanding of indexing, querying, and normalization
• Good understanding of relational database management system
• Good understanding of database integrity and security
• At least 5 years using MS SQL, data modelling, including an understanding of all normalized forms, design and development of stored procedures, views and triggers
• At least 5 + years of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services
• Excellent attention to detail, ability to detect and correct problems within SQL scripts
• Sense of ownership and pride in your performance and its impact on company’s success
• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills

Roles and Responsibilities

• Designing, testing, and debugging software applications using SQL Server
• Collaborating with cross-functional teams to gather and analyse requirements
• Help write and optimize in-application SQL statements
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders