iMPact Business Group
Database Developer
iMPact Business Group, Grand Rapids, Michigan, us, 49528
Job Description
This is a Direct Hire opportunity.
Location: Grand Rapids, MI - Hybrid (GR office one/two days per week)
Work Hours: Monday thru Friday, 8 - 5 EST; occasional weekends or evenings for production release support or off-hours processing.
Position Summary:The primary role of the Database Developer is to build, implement, and maintain SQL databases, data warehouses, interfaces, and SSIS/SSRS to meet the company's requirements for availability, performance, scalability, and security. They will maintain awareness of emerging technologies, best practices, and industry trends. Research and evaluate new technologies/practices for applicability. Coordinate activities with Network Admins, Application Developers, Business Analysts and outside vendors.Required Knowledge:
Minimum of 2 years experience working with MS SQL ServerExperience in ETL design and processingKnowledge of formal database architecture and designExperience with SQL Reporting Services (SSRS) and SQL Integration Services (SSIS)Experience with data archival strategies and reporting optimizationExperience with database unit testingExperience with both normalized and de-normalized dataDesired Knowledge:
Experience with Azure SQL Managed Instance, Azure Synapse, Azure Storage, C#, and PowerShell beneficialExperience with Power BIFamiliarity of Data Warehouse concepts and load best practices beneficialUnderstanding of modeling data and developing enterprise database architecturesFamiliarity with Agile Methodology beneficialAn ideal candidate would be a self-starter who is passionate about user experience and driving business value through technology.Job Requirements
Primary Duties and Responsibilities:
Develop, improve, and maintain server-to-server integration systems with business partners and internal groups (publications, FTP, web services, .xml interfaces, APIs, etc.). Provision data for business web applications, business intelligence & analytics, internal operations, and departmental reporting . - 40%Help design and develop new database physical and logical structures and assess for new application functionality. Work with senior database developers, business analysts, application developers on overall application design and architecture. Evolve database structures to improve access and maintainability where necessary. -
15%Support day-to-day operations and resolve support tickets. Maintain data availability for applications that are running 24x7. Monitor and improve system health. -
20%Support infrastructure changes and work with network administrators to plan for back-up, recovery, and high availability. -
5%Document database processes and follow GDPR/PII and ITGC compliance requirements. Utilize database source control tools and best practices in both design and development of databases and processes. -
20%
This is a Direct Hire opportunity.
Location: Grand Rapids, MI - Hybrid (GR office one/two days per week)
Work Hours: Monday thru Friday, 8 - 5 EST; occasional weekends or evenings for production release support or off-hours processing.
Position Summary:The primary role of the Database Developer is to build, implement, and maintain SQL databases, data warehouses, interfaces, and SSIS/SSRS to meet the company's requirements for availability, performance, scalability, and security. They will maintain awareness of emerging technologies, best practices, and industry trends. Research and evaluate new technologies/practices for applicability. Coordinate activities with Network Admins, Application Developers, Business Analysts and outside vendors.Required Knowledge:
Minimum of 2 years experience working with MS SQL ServerExperience in ETL design and processingKnowledge of formal database architecture and designExperience with SQL Reporting Services (SSRS) and SQL Integration Services (SSIS)Experience with data archival strategies and reporting optimizationExperience with database unit testingExperience with both normalized and de-normalized dataDesired Knowledge:
Experience with Azure SQL Managed Instance, Azure Synapse, Azure Storage, C#, and PowerShell beneficialExperience with Power BIFamiliarity of Data Warehouse concepts and load best practices beneficialUnderstanding of modeling data and developing enterprise database architecturesFamiliarity with Agile Methodology beneficialAn ideal candidate would be a self-starter who is passionate about user experience and driving business value through technology.Job Requirements
Primary Duties and Responsibilities:
Develop, improve, and maintain server-to-server integration systems with business partners and internal groups (publications, FTP, web services, .xml interfaces, APIs, etc.). Provision data for business web applications, business intelligence & analytics, internal operations, and departmental reporting . - 40%Help design and develop new database physical and logical structures and assess for new application functionality. Work with senior database developers, business analysts, application developers on overall application design and architecture. Evolve database structures to improve access and maintainability where necessary. -
15%Support day-to-day operations and resolve support tickets. Maintain data availability for applications that are running 24x7. Monitor and improve system health. -
20%Support infrastructure changes and work with network administrators to plan for back-up, recovery, and high availability. -
5%Document database processes and follow GDPR/PII and ITGC compliance requirements. Utilize database source control tools and best practices in both design and development of databases and processes. -
20%