Job for Database (SSIS/SSRS) Developer

1 Open Positions | Logo Urgent

Queens, NY
Estimated Best In Industry
12 Months
Posted on: 03/26/2024
Job Description:

  • 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

 

Requirements:

MANDATORY SKILLS:

  • 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 SKILLS:

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

Copyright @2023 RighTalents. All Rights Reserved by RightTalents LLC | Developed by devGroves Technologies