Summary
Senior Software Engineer (SQL/DB) will be working with a team of developers and business analysts to develop new products /enhance existing systems in place. To be successful in this role, one must demonstrate their knowledge of critical thinking and problem solving.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Essential Duties and Responsibilities
Very good understanding of database Normal forms.  
Design Database solution along with the required objects.
Develop SQL DB objects as per the design and defined standards.
Maintain SQL database schemas and scripts, including views, stored procedures, and triggers.  
Solid understanding of indexes, isolation levels, transactions, exception handling.  
Identity performance bottlenecks, provide solutions to resolve.
Ability handle data migration/upgrades either using custom scripts or ETL packages.
Ability to unit test Stored Procedures, User Defined Functions.
Create technical documentation such as schema documents, ER diagrams, data flow diagrams.
Provide support, guidance and collaborate with Application Developers to implement database design & solution.
Ability to analyze the performance issue and able to provider remediations.
Strong analytical skills and troubleshooting skills.  
Having a good understanding of the OOPS concept will be an added advantage.  
Continually evaluate concepts and tools for database transaction, day-to-day operations and make recommendations.  
Having knowledge of Redgate tools, Bitbucket like version control system, DevOps concepts will be an added advantage. 
Good to have basic knowledge of any of the NoSQL databases. 
Excellent communication skills, highly motivated, and self-directed.  
Regularly communicate project progress, issues, and risks to the team and managers. 

Supervisory Responsibilities
Senior Software Engineer is not a supervisory role.  You will revive general instructions on routine work, detailed instructions on new projects or assignments.

Education Qualification
Bachelor’s or master’s degree in Information Technology, Computer Science, or a related field
5-8 years of related experience.

Preferred Skills and Competencies
Strong working experience with T-SQL programming, SQL Server and relational databases is a mandatory.
Should have strong development experience on SQL Queries, Stored procedures, Functions, Views, Indexes.
Should have good development experience on SQL Server SSIS.
Should have experience in Stored Proc, User Defined Function’s performance tuning.
Should have experience in data migration and upgrade activities.
Experience in unit tests - Stored Procedures, User Defined Functions.
Should be know the latest features available in SQL Server 2017 and higher versions and should demonstrate the ability to use them as per the need basis. 
Should have worked on versioning like Tortoise SVN/Team Foundation Server/GIT/BitBucket
Strong background in Software Development Life Cycle required
Zeal to work on innovative products and technologies.
Ability to work independently as well as small teams.
Ability to adapt to fast paced environment and keen in updating with the latest trends. 

Location/Travel
This position is located at Hyderabad office, India.