Database Developer - iMPact Business Group
Grand Rapids, MI 49544
About the Job
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 Server
- Experience in ETL design and processing
- Knowledge of formal database architecture and design
- Experience with SQL Reporting Services (SSRS) and SQL Integration Services (SSIS)
- Experience with data archival strategies and reporting optimization
- Experience with database unit testing
- Experience with both normalized and de-normalized data
Desired Knowledge:
- Experience with Azure SQL Managed Instance, Azure Synapse, Azure Storage, C#, and PowerShell beneficial
- Experience with Power BI
- Familiarity of Data Warehouse concepts and load best practices beneficial
- Understanding of modeling data and developing enterprise database architectures
- Familiarity with Agile Methodology beneficial
- An ideal candidate would be a self-starter who is passionate about user experience and driving business value through technology.
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%
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%
Source : iMPact Business Group