Jobs
>
New York City

    Database Services Consultant - New York, United States - Judit Inc

    Default job background
    Description

    Job Description

    Job Description

    JOB TITLE:

    Database Services Consultant

    LOCATION:

    New York, NY

    JOB TYPE:

    Contract

    RESPONSIBILITIES:

    Our client is currently in the process of transitioning from its older, decentralized systems to a more efficient centralized cloud-based system. This shift necessitates an expansion of responsibilities and skills within the Database (DB) team. As part of this transition, the team will be required to validate and rebuild up to 40 reports once the new system is implemented.

    • Another significant initiative involves the real-time upload of trip data. To support this, we are seeking services to assist in establishing and maintaining the new Azure infrastructure.
    • Additionally, there is a need for expertise in creating additional reports using Power BI.
    • Furthermore, they are actively working on enhancing its systems to accommodate the rule changes set to take effect in 2024. This involves developing and implementing updates to ensure compliance with the revised regulations.

    REQUIREMENTS:

    Required:

    • Experience writing SQL Server Integration Services (SSIS) packages for ETL.
    • Experience in data modeling, database design and well versed with DBMS best practices. Experience optimizing and tuning queries.
    • Experience with SQL Server Reporting Services (SSRS) and Power BI. Experience with Informatica is a plus.
    • Ability to see tasks through to completion without significant guidance. Strong issue resolution and investigation skills.
    • Ability to articulate and document the steps taken to resolve an issue.
    • Strong oral and written communication skills and the ability to clearly articulate to all project members and stakeholders.

    Preferred:

    • Informatica Microsoft DevOps
    • Conceptual knowledge of CRM Systems (Salesforce, MS Dynamics etc.)

    Preferred Certifications:

    • CRM SQL
    • Services Desired

    Consultant that will be expected to:

    • Identify/resolve/prioritize mission critical production issues. Provide technical documentation as needed.
    • Prepare data migration plans including migration risk, milestones, and quality details.
    • Develop and maintain technical documentation such as design documents, specifications, software/stored proc/DB Jobs documents and instructions.
    • Develop scripts and solutions to automate data aging process to move data that meets the aging criteria out of production.
    • Perform data cleanup by performing data merges, deactivation/deletion of duplicate records using logic for exact matches as well as high probability fuzzy matches.
    • Be creative in providing new ideas and potential technical solutions including reviewing new features as they are planned for release.
    • Have thorough understanding and experience of development, deployment, and maintenance of SSIS packages.
    • Have thorough understanding and experience of development, deployment, and maintenance of reports in SSRS.
    • Design advanced SQL queries, stored procedures, triggers, and scripts.
    • Create SQL Server databases and database components utilized TLC applications.
    • Collaborate with applications developers and other key team members (Business Leads, Vendors, and Stakeholders) on data modeling and E-R diagrams.
    • Manage database performance, capacity, replication, backup, and security.
    • Develop, implement, and maintain data backup strategy and data retention policies.
    • Perform database migrations from unsupported OS/database servers to supported versions including cloud-based solutions.
    • Assist business analysts and end-users with reporting needs.
    • Develop reports, views, charts, and dashboards to assist program staff with monitoring the outcomes of Agency initiatives.
    • Work with external entities to facilitate secure data transfers.
    • Have exceptional communication skills, including effectively communicating with and possibly interpreting between technical and non-technical team members.

    Note: The Main work location shall be 33 Beaver Street, Consultant on occasion may be expected to travel to College Point Facility located at: th, Avenue Long Island City, NY 11101 and/or our Woodside Facility located at: 24-55 Brooklyn-Queens Expressway West Woodside, NY 11377



  • Cascade Enterprises Manhattan, NY, United States Freelance

    **Sales Consultant Customer Service (m/f/d) in Full or Part Time**: · **Responsibilities**: · - Continuous development of sales and marketing strategies · - Support and consultation of existing customers · - Creation of customer offers and sales of premium products · **Profile**: ...


  • Preferred Chevrolet Buick GMC Holland, United States

    **Average Earning Potential of $60,000 per year and more** · We're seeking a Service Advisor to join our Service Team. · If you have the drive to perform, exceed and excel as a SERVICE ADVISIOR then we want you to come work with us · **Service Advisor Benefits** · - Top brands to ...


  • beBee Handyman Bridgeville, DE, United States Freelance

    I am in need of a Nutritionist service with the following characteristics in Bridgeville, DE:What is the age of the patient? · 31 to 40 years old · On average, how many homemade meals do you eat per week? · Most of my meals are homemade · What is the main goal in seeking a nutrit ...


  • Stellar Enterprises Amsterdam, United States

    About the Company · We are an internationally oriented partnership of lawyers, auditors, and tax consultants founded in 2006. Today, we have around 380 employees at our locations in Hamburg, Berlin, Bochum, Hanover, Dortmund, Munich, and Bielefeld. · Through our own company and ...

  • Engel North America

    Service Consultant

    1 day ago


    Engel North America York, United States

    Job Description · Job DescriptionENGEL embodies a spirit of innovation, built on decades of experience. With a dynamic workplace, ENGEL is the injection molding industry leader in technological advancements, ensuring sustainable global growth. The ENGEL company history is a succe ...


  • beBee Handyman Ocean View, DE, United States Freelance

    I am in need of a Nutritionist service with the following characteristics in Ocean View, DE:What is the age of the patient? · Between 51 and 60 years old · On average, how many homemade meals do you eat per week? · The majority of my meals are homemade · What is the main goal in ...


  • beBee Handyman Kent Acres, DE, United States Freelance

    I am in need of a Nutritionist service with the following characteristics in Kent Acres, DE:What is the age of the patient? · Between 51 and 60 years old · On average, how many homemade meals do you eat per week? · The majority of my meals are homemade · What is the main goal in ...


  • beBee Handyman Viola, DE, United States Freelance

    I am in need of a Nutritionist service with the following characteristics in Viola, DE:What is the age of the patient? · From 41 to 50 years old · On average, how many homemade meals do you eat per week? · Most of my meals are homemade · What is the main goal in seeking a nutriti ...


  • beBee Handyman Odessa, DE, United States Freelance

    I am in need of a Nutritionist service with the following characteristics in Odessa, DE:What is the age of the patient? · Between 41 and 50 years old · On average, how many homemade meals do you eat per week? · The majority of my meals are homemade · What is the main goal in seek ...


  • Asana New York, United States

    We're looking for a detail-oriented, cross-functional consultant who can help lead Asana deployments to our enterprise customers. You will be part of our Professional Services team, and committed to helping customers adopt Asana as both a technology platform and a holistic approa ...


  • Comcast Corporation New York, United States

    FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and s ...


  • Titan Industries Empire, United States

    Are you passionate about embracing technological progress? Do you want to be a part of making innovations a reality? At FERCHAU, we are looking for individuals who share our ambition: as ambitious colleagues who, like us, want to take technologies to the next level. We realize ex ...


  • Clearwater Analytics Holdings Inc. New York, United States

    Job Summary: · The Professional Services division is responsible for delivery of change/transformation/advisory services to existing clients on Clearwater's SaaS platform. We work in conjunction with Client Services to identify opportunities around value-added services to steady ...


  • Infosys New York, United States

    Infosys is seeking a · ServiceNow ITOM Lead Consultant . This role requires close partnership and collaboration with other Business Stakeholders and Subject Matter Experts. Essential Job Duties include working on complex ServiceNow ITSM deployments including Incident, Problem, C ...


  • Comcast Corporation New York, United States

    FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and s ...


  • SimilarWeb New York, United States

    At Similarweb, we are revolutionizing the way businesses interact with the digital world by revealing to them everything that happens online. Our unique data and solutions empower over 4,300 customers globally, including industry giants like Google, Advisor, Consultant, Service, ...


  • Comcast Corporation New York, United States

    FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and s ...


  • Comcast New York, United States

    FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and s ...


  • SimilarWeb New York, United States

    At Similarweb, we are revolutionizing the way businesses interact with the digital world by revealing to them everything that happens online. · Our unique data and solutions empower over 4,300 customers globally, including industry giants like Google, eBay, and Adidas, to make g ...


  • Comcast Corporation NEW YORK, United States

    FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and s ...