SQL Developer

Senior SQL Developer

• The Senior SQL Developer will primarily focus on development, maintenance, and support of Platform applications.
• This role will be responsible for delivery of critical product requirements and will be interact with a culturally and technically diverse team, which includes .Net developers, SQL developers, QA and product management teams.

Specific Job Skills and Experience:

• 8 or more years of related experience; or equivalent combination of education and experience
• Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns)
• Advance SQL development skills like -
• In-depth understanding of data modeling best practices, normalization techniques, and database design patterns Advanced Knowledge in Always On, Transactional Replication, Clustering and T-SQL
• Proficiency in writing complex SQL queries, stored procedures, functions and triggers.
• Experience with SQL BI stack or SSRS, SSIS and SSAS.
• Must have experience in source controls GitHub and bitbucket.
• Knowledge in scripting/programing languages: PowerShell, Bash, Python.
• High level of knowledge of Windows Server and WSFC with an understanding of things needed to manage HA and DR as well as troubleshoot performance and connectivity.
• Extensive experience with PowerShell and creating your own modules for management and automation in SQL Server environments (beyond basic use of community created modules such as DBA Tools).
• Performance tune complex queries and query optimization.
• Developing Dynamic SQL and stored procedures.
• Using indexes to speed up the SQL queries.
• Experience in creating database schemas that represent and support business processes.
• Extensive knowledge and hands on experience designing and developing objects and components of relational and non-relational database.
• Experience with MSDTC and MSMQ – Triage MSDTC issue Triage private queues of MSMQ issues.
• Developing ERD – both physical and logical.
• Strong experience with Agile methodologies
• Knowledge and understanding of SDLC, with a strong preference for Agile experience.
• Skill for writing reusable functions, views and database objects.
• Excellent written/verbal communication, presentation, and listening skills.
• Excellent collaboration/teamwork skills.
• Understanding of fundamental design principles for building a scalable application
• Familiar with various design and architectural patterns.

Essential Functions/Responsibilities:

• Can help in defining, documenting and developing software, software applications, as well as contributes to architecture and technical design discussions, code reviews and technical design/specifications in collaboration with the project team.
• Independently responsible for development, enhancement, testing, support, maintain and troubleshoot/ debug software applications that support business units or support functions.
• Create thorough, professional quality project documentation and technical specifications.
• Assesses the impact of software changes and new development on other systems; conducts integration tests to mitigate risks.
• Mentor junior team members and participates in and promotes a knowledge-sharing environment.