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