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