Jobs
>
Hartford

    Senior sql developer local - Hartford, United States - V Group

    V Group
    V Group Hartford, United States

    2 weeks ago

    Default job background
    Description

    Client:
    State of Connecticut

    Job Title:
    SeniorSQL Developer

    Duration:

    12+ Months

    Start Date:

    ASAP
    Location:

    505 Hudson Street Hartford, Connecticut Hybrid)

    Position Type:
    Contract

    Interview Type:
    In Person/Web Cam

    Working Hours:

    40 Hours per Week

    Ceipal ID:
    STN_SQL703_IK

    Requirement ID:

    62703

    Department of Children and Families


    Responsibilities:
    Develops general and detailed design specifications for moderate to complex systems.

    Assist in the design and development of the database architecture including relational data structures, data marts, data dictionaries and logical and physical data models.

    Develop strategies for data acquisitions, data quality and data discrepancy.
    Assist in migration and integration of data and processes from legacy systems to new applications and new technologies.

    Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development.

    Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans.

    Recommend query and index improvements to increase performance.

    Must have the ability to access data stored in a variety of database management systems such as DB2, SQL Server and other.

    Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution.
    Implementing Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions.
    Coordinate with Business Analyst and users to validate requirements.
    Implementing solutions to integrate external data with inhouse data.
    Perform tests and validate data flows and prepare ETL processes according to business requirements.
    Designing and implement a data conversion strategy from legacy to new platforms.
    Perform design validation, reconciliation and error handling in data load processes.
    Optimize SSIS Package execution and SQL execution to optimize data load performance.
    Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer. Ability to import and export files from FTP/SFTP.

    Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, Troubleshooting, documentation, performance optimization and maintenance.

    Development of different kind of reports using SSRS as per user requirement and deploying to report server/ integrated SharePoint report server.

    Experience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating cross tab reports highlighting key summary information.

    Use Microsoft Team Foundation Server (TFS) and/or Azure Dev Ops to manage changes to code

    Required Skills:
    10+ Years of prior experience demonstrating the following knowledge and skills:

    Experience in the analysis and design of application solutions within appropriate standards.
    Ability to write complex SQL queries
    Expertise with TSQL, SSRS, SSIS required and Power-Bi, SSAS a plus
    Experience with debug and improve query performance
    Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.
    Significant experience in real-time, multi-tiered data processing systems
    Experience with Transact-SQL and stored procedures desired.
    Experience with creating, deploying and maintaining of SSRS reports.
    Experience with code control/version Team Foundation.
    Experience with enterprise data integration technologies including Java, SQL, XSLT, Graphical, and XML
    Strong problem solving, cross-functional analysis and forward-thinking abilities
    Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines
    ________________________________________________________________________________________________________________________________
    V Group Inc.

    is an IT Services company that supplies IT staffing, project management, and delivery services in software, network, help desk, and all IT areas.

    Our primary focus is the public sector including state and federal contracts.

    We have multiple awards/ contracts with the following states:
    CA, FL, GA, MD, MI, NC, NY, OH, OR, PA, SC, VA, and WA, CT, TN.

    If you are considering applying for a position with V Group or partnering with us on a position, please feel free to contact me with any questions you may have regarding our services and the advantages we can offer you as a consultant.

    Report this job


    Dice Id:
    a


    Position Id:
    #J-18808-Ljbffr
  • RapidIT, Inc

    Net Developer with Microsoft BizTalk- Candidate Must Be Local to CT-

    3 weeks ago

    RapidIT, Inc Hartford, CT, United States

    An experience professional with 10 or more years of prior experience demonstrating the following knowledge and skills: · ***Must HaveMicrosoft BizTalk Server years' experience) Orchestrations, Maps, Pipelines, Port Configuration, XSLT, XML, XSD, as well as performance and scalabi ...

  • KSN Technologies, Inc.

    Direct Client: Power Apps Developer @ Hartford, CT Hybrid Only Locals

    1 week ago

    KSN Technologies, Inc. Hartford, United States

    Power Apps Developer Hartford, CT Hybrid Only Locals One Year Contract · We are looking for candidates who can work on our W2. · Under broad supervision, designs, codes, tests, modifies and debugs computer software. · Hybrid role, 3days on-site/2days telework. · Summary/Objecti ...

  • ELG Utica Alloys (Hartford), Inc

    Environmental, Health and Safety

    3 weeks ago

    ELG Utica Alloys (Hartford), Inc Hartford, United States

    ELG is a global leader in the trading, processing, and recycling of raw materials for the stainless-steel industry and high-performance materials such as super alloys and titanium. At more than 50 global locations in North America, Europe, Asia, Australia, and South Africa, aroun ...

  • Young Life

    Newtown, Pa Staff Associate

    1 week ago

    Young Life Newtown, United States

    **Summary** · Young Life's Staff Associate role requires a dynamic, vibrant personality that will lead Young Life ministries in area schools. This person is a self-starter with a high sense of drive and a missional mindset. They love the Lord and have a growing spiritual life out ...

  • Performance Foodservice

    Outside Foodservice Sales Hartford County

    3 weeks ago

    Performance Foodservice Hartford, United States

    **Company Description** · Performance Foodservice, PFG's broadline distributor, maintains a unique relationship with a variety of local customers, including independent restaurants and hotels, healthcare facilities, schools, and quick-service eateries. A team of sales reps, chefs ...

  • The City of Hartford

    Director of Planning

    2 weeks ago

    The City of Hartford Hartford, United States

    **Description**: · **Distinguishing Characteristics** · - This position reports to the Director of Development Services. This position works directly with Department leaders and City staff as needed. Incumbent performs and oversees the most complex planning tasks requiring a high ...

  • RMS Companies

    Assistant Property Manager/leasing Manager

    3 weeks ago

    RMS Companies Hartford, United States

    RMS Companies, a Connecticut based real estate development company, is seeking a full-time Assistant Property Manager/ Leasing who is self-motivated, enthusiastic and customer service oriented. This is an exciting opportunity to work in a fast-paced environment of a new community ...

  • Young Life

    Newtown, Pa

    3 weeks ago

    Young Life Newtown, United States

    **Summary** · Young Life's Area Director role requires a dynamic, vibrant personality that will help helm Young Life for a specific area of schools. This person is a self-starter with a high sense of drive and a missional mindset. They love the Lord and have a growing spiritual l ...

  • Lowe's

    HR Advisor

    3 weeks ago

    Lowe's Hartford, United States

    Key Responsibilities: · - Promotes the value of the HR function and focuses on delivering business outcomes by building collaborative relationships across the organization. Works closely with Leadership to align HR strategy with business plans and help implement within the specif ...

  • OEM Logistics LLC

    Aerospace and Defense Supplier Specialist

    2 weeks ago

    OEM Logistics LLC Hartford, United States

    OEM Logistics, LLC was founded in January 2023 by two industry veterans with a proven track record of success identifying outside the box niche opportunities and solutions that address the supply chain challenges within the aerospace industry. Our mission is to manage our custome ...

  • Oak Hill

    Director Education

    3 weeks ago

    Oak Hill Hartford, United States

    Oak Hill has been enhancing the lives of people with disabilities since 1893 We invite you to join our team of highly committed professionals. Founded in 1893 by trailblazer and visionary, Emily Wells Foster, Oak Hill has over 129 years of experience providing the highest quality ...

  • Oak View Group

    Union Lead Facility Worker

    3 weeks ago

    Oak View Group Hartford, United States

    Oak View Group: · Oak View Group (OVG) is the world's leading arena development, management, and hospitality company founded in 2015 by Tim Leiweke and Irving Azoff to disrupt business as usual. As the largest developer of sports and entertainment facilities in the world, OVG pri ...

  • Aceolution

    Car Driver

    3 weeks ago

    Aceolution Hartford, United States

    We are hiring Drivers... · We will provide you the Car & the Training required for this project. This is a contract based job (40Hrs/Week - Monday to Friday). · Qualifications: · - Must successfully pass the Driver Training Program after the 2 days training. · - Fluent in English ...

  • Consigli Construction Co Inc

    Quality Co-op, Fall 2024 Ct

    2 weeks ago

    Consigli Construction Co Inc Hartford, United States

    Interested in an outstanding opportunity to become part of a team with a stellar reputation as a community engaged Employer of Choice? · Established in 1905, Consigli has grown over the last 100 years from a local fourth generation family business into one of the largest construc ...

  • Automotive Search Group

    Corporate Fixed Operations Director

    2 weeks ago

    Automotive Search Group Hartford, United States

    Growing automotive dealer group in the CT market is seeking a highly experienced and motivated Corporate Fixed Operations Director to oversee and manage the fixed operations (service and parts departments) for multiple locations within the dealership group. This is a rare opportu ...

  • GSK Solutions Inc

    Lead Salesforce Developer

    2 weeks ago

    GSK Solutions Inc Hartford, United States

    **Job Title: Lead Salesforce Developer (Hybrid Onsite - Locals Only - USC / GC Only)** · **Location: Hartford, CT** · **Client: State of CT** · DCF Information Systems provides technology expertise and services as well as an information systems infrastructure to the agency and it ...

  • GSK Solutions Inc

    Lead Salesforce Developer with .NET Exp

    2 weeks ago

    GSK Solutions Inc Hartford, United States

    **Job: Lead Full Stack.Net Developer with Salesforce exp (Hybrid Onsite - Locals Only)** · **Location: Hartford, CT** · **Client: State of CT** · DCF Information Systems provides technology expertise and services as well as an information systems infrastructure to the agency and ...

  • GalaxEons

    Service Desk Agent Trainee

    2 weeks ago

    GalaxEons Hartford, United States

    What You Will Do: · **Position Overview**: · GalaxE.Solutions and its Outsource to America(O2A) workforce development program is building the next generation of IT engineers by providing training to non-IT professionals to fill in-demand roles that are currently being outsourced ...

  • StretchLab

    Fitness Coach

    3 weeks ago

    StretchLab Hartford, United States

    **PERSONAL TRAINER AT ANYTIME FITNESS** · **Locations**: West Hartford, Glastonbury, Cromwell, Ellington, Somers, Farmington, Granby, Newington, Windsor, Southington, Wilton, and Canton, CT. · Are you looking to make a meaningful impact in people's lives? Are you seeking a fulfil ...

  • Oak Hill

    Assistive Technology Coach

    2 weeks ago

    Oak Hill Hartford, United States

    Oak Hill has been enhancing the lives of people with disabilities since 1893 We invite you to join our team of highly committed professionals. Founded in 1893 by trailblazer and visionary, Emily Wells Foster, Oak Hill has over 129 years of experience providing the highest quality ...