Description
Position Summary:
The Senior SQL/Database Developer is a technical leader providing oversight and delivery of technical projects. This role implements architecture-centric solutions in addition to providing guidance to the developers in delivering solutions that adhere to and meets the strategic objectives set by IT Leadership. This position will collaborate with Project Managers/Business Analysts and Web Developers to design and implement database solutions that are critical to the company's growth. The Senior SQL/Database Developer will help mentor junior developers. This position will also participate in architecture and design activities.
Responsibilities:
- Participates in all phases of database SDLC: from business requirements analysis and design thru development and test to deployment and support.
- Provides development estimates and participates in project planning.
- Participates in designing and developing complex systems by writing database design Specifications and interfaces with business components, ie reports, web applications, data extraction to third party vendors.
- Design database structures and use data modelling tools
- Design and development of Table, Schema, Indexes, SQL, Views, Stored Procedures and support database activities, such as data loading and unloading.
- Design and develop custom Data Warehouse solutions, using Multidimensional and Tabular solutions.
- Create reporting solutions using PowerBI or similar technologies.
- Responsible for ensuring quality delivery of code through static and dynamic testing techniques
- Is able to troubleshoot any complex issues as well as provide support to production.
- Keep abreast of the current technologies and technological trends. Ability to learn and prototype new technologies, and recommend their use in the company products.
- May help lead a team of developers to ensure that projects are successfully completed.
- Peer mentoring experience of more junior team members.
- Ensures adherence to standards for self as well as team.
- Other duties as assigned
Skills:
- Must be detail-oriented with the ability to manage multiple assignments effectively
- Ability to adhere to development standards and procedures
- Strong debugging, troubleshooting and analytical skills
- Able to work independently and efficiently to meet deadlines
- Excellent interpersonal, verbal and written communication
- Team oriented
Minimum Job Requirements:
- Bachelor's degree in Computer Science or related field
- Minimum 7 years of experience as a Database Developer
- Minimum 2 years of experience as a Lead or Senior Database Developer
- Minimum 5 years of experience with Transact-SQL using Microsoft SQL Server (2014 or later preferred)
- Minimum 5 years of experience with Microsoft SQL Server Integration Services (SSIS) or equivalent ETL platform; Knowledge of advanced SSIS concepts to handle complex tasks like importing large files, loading data in a transactional database etc.
- Strong working knowledge of SSAS, including Multidimensional and Tabular modelling and experience supporting BI/Data warehousing systems.
- Knowledge of advanced SQL programming concepts like CTE (Common Table Expressions) and windowing functions
- Strong query and database tuning skills.
- Experience with PowerBI, SSRS or similar data presentation and modelling tools
- Experience with Team Foundation Server
- Proven ability to analyze, document, and reverse engineer any type of SQL based applications and processes. Make recommendation on how to rewrite, modify, redesign SQL based application and processes based on analysis.
- Excellent written and verbal communication skills
- Demonstrated experience of estimation and planning
- Understanding of project management concepts and techniques required
- Demonstrated abilities to successfully document and communicate software designs of complex systems.
- Proven history of developing and unit testing complex software components.
- Ability to be flexible, set priorities and meet deadlines in a changing environment for self as well as team.
- Must have decision-making skills for problem identification and solution recommendation.
- Ability to work independently and as part of a team while demonstrating initiative and using good business judgment
- Demonstrated ability to reduce and/or prevent production defects based on the continuous root cause analysis and process improvement
- Ability to maintain effective working relationships across teams and with a diverse workforce