Overview:Quantam Solutions provides IT solutions and consulting for various clients. We offer competitive hourly wages, health benefits, paid time off, and a 401(k) plan. We are currently seeking a
Lead Database Developer. This position requires two days of onsite training (in Glastonbury, CT) and then allows for a fully remote work schedule.
Overview:Our 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.
Responsibilities: - Collaborate directly with Business Teams to elicit data storage and analytics needs, converting complex business logic into clean, structured relational table designs
- 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.
- 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.
- 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.
Minimum Qualifications: - 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.
- Tooling Requirements: (Visio/similar, Redgate, SQL Server Data Tools (SSIS, SQL Server Management studio (SSMS), Microsoft Visual Studio) are a MUST. Azure DevOps/ Git, SQL Server Agent, Microsoft Service Broker experience is recommended.
Additional Information: - Candidates are required to attend their first two days in person in Glastonbury, CT. Then can work either a hybrid or remote schedule.
Skills:Visio,RedGate,SSIS,SSMS,SQL,Azure DevOps,Microsoft Service Broker,T-SQL
