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.

. About the role:

The Senior Database Developer reports to the Database Manager and is responsible for database design, procedural scripting, performance tuning, management, automation tools, database security and integrity, database modernization, back-ups and testing
This position collaborates with the application development, business intelligence, network admin and business analyst teams
They will analyze, design, build, test, implement, support and maintainSQL databases, data warehouses, data exchange/interfaces, and SSIS/SSRS to meet the company's requirements for availability, performance, scalability, and security
They will adhere to established and agreed on best practices and standards
They will maintain awareness of emerging technologies, best practices, and industry trends
Research and evaluate new technologies and practices for applicability

Primary Duties and Responsibilities:

Design, develop, and refactor database physical and logical structures and assess for new application functionality
Work with application developers and stakeholders on overall application design and architecture
Evolve database structures to improve access and maintainability where necessary
Develop and improve server-to-server integration systems and processes with business partners (publications, FTP, web services, .xml interfaces, APIs, etc.)
Tuning queries and stored procedures for scalability and performance
Resolve support issues to maintain data and business integrity
Stakeholder collaboration, task planning, solution delivery and data Project Management
Evaluate, propose and implement appropriate database monitoring and control tools to support and improve overall system security, integrity and health
Maintain plan for back-up, recovery, and high availability. Maintain data availability for applications that are running 24x7

Required Knowledge, Skills and Abilities:

Extensive experience working with MS SQL Server
Experience modeling data and designing enterprise database architectures
Knowledge of formal database architecture and design
Experience with SQL Reporting Services (SSRS) and SQL Integration Services (SSIS)
Experience developing and maintaining data archival strategies and reporting optimization
Experience with both normalized and de-normalized data
Experience with performance tuning

Desired Knowledge, Skills and Abilities:

Experience with Azure SQL, Managed Instance, Data Factory, C#, and PowerShell
Experience with Power BI
Experience with middle tier applications consuming data, specifically .NET and web services
Experience with Agile Methodology, Change Management, and IT General Controls (ITGC)
Experience with database unit testing
Experience with Data Warehouse design and implementation

iMPact Business Group jobs