Job Description

OverviewSUMMARYSoftware Engineer II (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.
• Develop SQL DB objects as per the design and defined standards.
• Maintain SQL database schemas and scripts, including views, stored procedures, and triggers.
• Good understanding of indexes, isolation levels, transactions, exception handling.
• Create technical documentation such as schema documents, ER diagrams, data flow diagrams.
• Identity performance bottlenecks, provide solutions to resolve.
• Provide support, guidance and collaborate with Application Developers to implement database design & solution.
• Ability to unit test Stored Procedures, User Defined Functions.
• Strong analytical skills and troubleshooting skills.
• Ability to analyze the performance issue and able to provider remediations.
• 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.
• Excellent communication skills, highly motivated, and self-directed.
• Good knowledge on Redgate tools, Bitbucket like version control system, DevOps concepts.
• Regularly communicate project progress, issues, and risks to the team and managers.
• Added Advantage

• Ability to Identity performance bottlenecks, provide solutions to resolve.
• Ability to handle data migration/upgrades either using custom scripts or ETL packages.
• Basic programming knowledge on any NoSQL database.

SUPERVISORY RESPONSIBILITIESSoftware Engineer II is not a supervisory role. You will revive general instructions on routine work, detailed instructions on new projects or assignments.EDUCATION QUALIFICATION

• Bachelors or masters degree in Information Technology, Computer Science, or a related field
• 3-5 years of related experience.

PREFERRED SKILLS AND COMPETENCIES

• Hands-on working experience with T-SQL programming
• Experience with SQL Server and relational databases is a mandate.
• Should have development experience on SQL Queries, Stored procedures, Functions, Views, etc.)
• 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.
• Experience in unit tests - Stored Procedures, User Defined Functions.
• 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.

HealthEdge