Database Architect / Developer

Michigan, Grand Rapids-Muskegon-

Posted: 09/10/2019 Industry: IT Job Number: 13566

Sr. Database Architect / Developer

Located in Grand Rapids Michigan

Our client, the nation s largest provider of services in their area of expertise, is seeking a Database Architect / Developer that will lead database design, optimization, maintenance and SQL development and solution design of new applications and complex modifications to existing Web and eCommerce applications.
Our client s company was founded in 1994 to help families raise money for the non-profit organizations that matter to them, and has been growing by this mission ever since. The beliefs of the company are exceptional customer service, supporting the community, and embracing change. We also believe in potluck lunches, bagel breakfasts, and developing our family culture. Individuals must believe in the company as a family and at times going outside of their work area and assisting in company where required. The work environment and culture is one where jeans, shorts and flip-flops are considered everyday attire!

DUTIES AND RESPONSIBILITIES:

Analyze and optimize existing SQL Server data structures used by a set of mission critical applications including batch jobs, e-commerce websites, web-based APIs and thick client applications
Identify poor performing queries and work with application development team to identify optimizations for application code generating SQL as well as stored procedures
Work with business stakeholders and application developers to identify requirements for new software development and be able to design highly performant and highly flexible database designs
Work with application development team to identify optimal migration strategies for new projects
Continually monitor the health of critical databases and proactively identify recommended areas for change in order to ensure high levels of reliability and performance
Develop database development standards for existing systems and new systems (naming conventions, data type usage, indexing / optimization usage, data traceability usage)
Implement archiving schemes and ETLs for existing and new systems to allow for data audits while keeping database systems performant
Work with application development team on building one time and continuous migration systems between on premise and cloud-based databases
Review existing database system security implementation and implement necessary changes to reduce risk
Work with application development team to implement queries to be used in reporting systems

REQUIREMENTS:
Minimum of 10 years' experience in database design, optimization, maintenance and SQL development
Hands-on experience designing, maintaining and optimizing large, high volume transactional databases
Hands-on experience with cloud-based databases (Azure SQL Server, AWS RDS etc.)
Hands-on experience managing and maintaining database migration systems for development, QA and production application environments
Hands-on experience will widely-used database administration and development tools (RedGate Suite, Azure Data Studio, SSMS, SQL Server profiler etc.)
Hands-on experience managing low impact data migrations on mission critical database systems
Hands-on experience building ETL or other data migration applications
Additional Highly Desired Skills:
Hands-on experience optimizing non-relational databases (CouchDB, DynamoDB etc.)
Hands-on experience optimizing SQL generated by ORMs like Entity Framework, Hibernate etc.)
Hands-on experience designing and optimizing data warehouses, data lakes or similar large-scale data storage systems
Hands-on experience architecting redundant database systems (on premise clustering / mirroring and cloud based geographically separated clustered / mirroring)
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.