SQL Developer


City: Remote, VA, Canada
Title: SQL Developer
Category: IT
EmploymentType: Temp
Description:
This role will support existing SQL databases, SSIS package scheduling and automation to ensure accurate and timely transfer of data. Candidate should become familiar with business requirements and translate them into SQL/SSIS development work for both new and existing functionality.

**Applicants must be located in Texas**


SQL
• Query and View Creation / Troubleshooting / Optimization (SQL, DAX)
• Stored Procedure Creation / Troubleshooting / Optimization
• Automation Jobs Scheduling and Maintenance
• Performance testing and monitoring
• Ability to review existing queries, views, and stored procedures and quickly understand their purpose
• Documentation of interdependencies and impact analysis

SSIS / Visual Studio
• Data Flow Task (DFT) creation / maintenance / troubleshooting
• Familiar with creating connectors for various sources (DAX, OLE DB, Excel, SharePoint, etc.)
• Check-In process, promoting changes to Git Hub
• Error troubleshooting and resolution

Visualizations (nice to have, but not required)
• Tableau
• Power BI
• Upkeep / refresh of existing dashboards
• Changes to existing visualizations

 
Company:
Staffmax Staffing & Recruiting