Lead Database Developer & Data Business Analyst

Note: IT consultants are required to attend their first two days in person in Glastonbury, CT. Thereafter, consultants are currently allowed to work remotely 100% with the project manager's approval

Scope of Services:

• The Client is looking to engage the services of a Lead Database Developer & Data Business Analyst. This role acts as Single Point of Contact (SPOC) between Business, App Dev, BI, and DBA teams to streamline communication, manage dependencies, and ensure the successful end-to-end delivery of joint initiatives. The scope of services required for the role includes:

Core Technical Skills

• 10+ years of experience with SQL Server, must include version 2014 through 2022.
• Tooling Requirements: Experience with tools (Visio/similar, Redgate, SQL Server Data
• Tools (SSIS, SQL Server Management studio (SSMS), Microsoft Visual Studio) is MUST. Azure DevOps/ Git, SQL Server Agent, Microsoft Service Broker experience is recommended.
• Requirements Gathering & Translation: Collaborate directly with Business Teams to elicit data storage and analytics needs, converting complex business logic into clean, structured relational table designs
• Cross-Team Schema Management:

• Serve as the proactive coordinator and gatekeeper for all data architecture updates. Ensure schema modifications are clearly communicated to the App Dev and BI teams to avoid application crashes or breaking downstream ETL/reporting pipelines
• Primary contact person to DBA team to coordinate planned database downtime window, manage access rights/ permissions and validate backup/restore to ensure uninterrupted database availability

• Visual Data Modeling: Build, iterate, and strictly maintain logical and physical entity- relationship diagrams (ERDs) and workflow mappings utilizing Microsoft Visio or similar tool.
• Advanced T-SQL Development & Data Optimization:

• Troubleshoot performance issues using indexing and query tuning.
• Knowledge and experience in the design and creation of tables, views, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
• Significant experience of advanced SQL and T-SQL development, including designing and writing complex queries, data fix scripts, stored procedures, triggers, and user-defined functions

• Deployment & Release Guardrails: Utilize Redgate deployment suites to perform database schema comparisons, manage source control integrations, and safely package release scripts across Dev, QA environments
• ETL & SSIS Core:

• Must demonstrate knowledge of ETL (Extract-Transform-Load) concepts and SSIS Tasks. Experience in incorporating requirements into technical flow chart highlights Control Flows, Data Flows, parameter/ variable configuration, error handling and deployment configurations
• Knowledge and experience in the design and creation of XML schema, XML data storage and transformation

Soft Skills

• Strong analytical and problem-solving skills.
• Ability to effectively manage time, prioritize tasks, and have a basic understanding of
• project management.
• Proactive in leading communication across teams.
• Excellent verbal communication skills to explain and transfer knowledge both informally
• and at design and code review meetings.
• Excellent written communication skills to prepare regular periodic status reports and documentation.
• Knowledge and experience of Microsoft Office Tools

Minimum Qualifications

The minimum skills and experience levels required for a candidate to be considered for this position include:

• Minimum ten (10) years of development experience coding applications using SQL Server 2014 through 2022.
• Collaborate with all teams to review database requirements and maintain finalized documentation.
• Work closely with DBA team during release and post release activities.
• Knowledge and experience in the design and creation of tables, indexes, foreign keys,
• including the use of appropriate data types, default constraints, etc.
• Knowledge and experience of advanced SQL and T-SQL development, including designing and writing complex queries, stored procedures, triggers, and user-defined functions.
• Perform field mapping (mapping between the source and target structure with data cleansing, if necessary).
• Define the migration process (automated and manual).
• Develop data extractors and loaders.
• Responsible for data management and conversion activities such as Data Assessment,
• cleansing, extracting, migrating and reconciliation of data.
• Knowledge and experience in the design and creation of XML schema, XML data storage and transformation.
• XML knowledge is required for legacy data conversion into XML-based structures.
• Knowledge and experience in performance tuning techniques.
• Manage the data conversion process and data push process to the various environments.
• Create and maintain technical documentation.
• Provide management level statistics and reports to monitor data migration progress.
• Investigate, analyze and document reported defects
• Investigate and rectify technical issues within the ETL process.
• Proven ability to work independently with minimal supervision.
• Ability to work well with a team of developers and business analysts