Algorithms is looking for a dynamic and highly motivated individual who would be responsible for accomplishing the project objectives within the constraints of the project (Scope, Time, Resources, and Performance Specifications).
His / her responsibilities would include:
Gaining an in-depth understanding of the modules assigned in terms of their features, design, architecture and capabilities.
Analyzing new requirements / modifications as specified in the product backlog.
Proficient in analyzing and troubleshooting Queries using Query Plan, Wait Stats, Perform, Extended Events, Profiler, DMVs, Indexing etc.
Reviewing existing Procedures code and rewrite Optimized code, if required.
Responsible for designing SQL queries, writing complex procedures, scripts, Materialized views etc.
Designing new tables and other objects using best practice
Come up with effective solution to replace Cursors and Triggers in existing environment.
Good understanding of Transaction management, Concurrency and Lock management.
Use coding standards to avoid or minimize Blocking and Deadlock, Utilizing proper Indexes for Optimal Query Performance.
Well aware of the hardware resource usage of the underlying Database Queries and write code for efficient resource utilization
Good knowledge about the SQL Server and Database level settings for Optimal performance
Analyzing and applying new features introduced in SQL 2014 and SQL 2016 for new development
Well versed with Creating and Deploying SSIS packages
Knowledge about Database Documentation
Clearly articulating timelines for work assigned.
Developing and testing the program/unit in the time projected.
Adhering to the following Processes and new Processes that will be introduced during the course of the year in the true spirit.
Daily Planning Sheet
Completing the Issue Completion Checklist by following the Checklists & Guidelines for Software Development & Testing.
Software Pre-Release and Post-Release Activities
Co-coordinating with testers to ensure that the program / unit developed is bug-free.
Co-operating with the team leader especially in stressful situations, to ensure that the release is made on time and to the quality expected.
Imparting training to new joiner’s and colleagues.
Strong Communication Skills
Sound knowledge of RDBMS concepts
Proficient in latest SQL Server Versions say SQL 2016, SQL 2014
Working knowledge of SSRS, SSAS and TFS (Desired)
Self-motivated with a great ability to find solutions to complex problems.
Interpersonal skills in building trustful relationships with peers are key to succeed.
Any B.E /B.Tech/MCA/BCA /B.Sc (B.Com Graduates preferred).
The ideal candidate must have an experience of around 2-5 years handling projects and/or product development or similar experience.
As per company standards
Subscribe to your Newsletter
Would you like to receive emails from Xpedeon about our products and services?
Yes I Would
Please see your inbox to confirm your email preferences.