Senior Database Developer-MS SQL

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.. 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,
• 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

Job Requirements

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
18 days ago