Description
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 remediation.
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
HealthEdge provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Full Job Description About DebtHammer DebtHammer is a dynamic technology startup located in USA with founders who have experience working...
Apply For This JobFull Job Description Urgently hiring for Purchase Manager…!!! Years of Experience: 7 – 10 yrs. Job Location: Chennai Industry: Construction,...
Apply For This JobUrgently required OT Technician for Rama Super Specialty Hospital Desired Candidate Profile Diploma in OT Prior Experience Perks and Benefits...
Apply For This JobAbout this role: Project Admin We’re hiring Project Admin for one of our Leading MNC in Oil and Gas to...
Apply For This JobJob Description If you have the Skills To Sell & Zeal to become Sales Samurai and passionate about Sales then...
Apply For This JobJob Description Roles & Responsibilities: Project Execution – Business System (Oracle & JDE) Create new projects, agreements & baselining as...
Apply For This Job
“`
Search qualified candidates by skills, location, experience, education, and more.
“`