Senior SQL Database Administrator

Job Overview

The Opportunity:

As a Senior SQL DBA with TeamRoehl, you make a difference by designing, developing, and implementing SQL Server data platform architectures and relational data model designs that provide sustainable, secure and high performing data solutions for Roehl data applications in our clustered Operations and Business Intelligence SQL Server 2022 environments. Additionally, you will support our cloud SQL Server platform databases. You will be on the front lines of protecting sensitive data and securing Roehl data assets.  You will partner with application architects and developers to provide OLTP and analytical data designs for a myriad of data-driven solutions that provide the foundation for customer and driver success at Roehl.   

Roehl Transport is a data rich environment! Our 2,000+ tractors and 5,000+ trailers are generating hundreds of data points per mile. Our proprietary customer and driver management systems and sophisticated communications systems are full of data just ready to be explored and leveraged. We can provide you with a rewarding and challenging work environment, collaborative team culture, and the opportunity to have a meaningful impact. This position has a high level of interaction with leadership in all parts of the organization and will give you the ability to create and maintain purposeful products that make a difference!

You create Driver Success by using your technical skills and abilities to create purposeful database solutions that help us improve driver productivity and satisfaction.

The Fit:

At Roehl Transport we value Mutual Support & Teamwork, Respect, Making a Difference, Honesty, Integrity, Accountability, Customer Care, Driver Success, and our Cornerstone Value: Safety! These values guide our daily interactions with each other and our customers. We are looking for an individual who shares our values, someone who is looking to grow and develop professionally with a team who is committed to their success! We work hard and we have fun collaborating together as we accomplish our goals!

Do you love solving problems?  Do you want to know that your contributions directly affect business success?  Do you enjoy communicating, collaborating and building relationships with a diverse group of people?  Do you like defining and implementing technical strategy? How about designing information architecture and data pipelines in a tier-3 data center or in the cloud? Well, as a Senior BI Architect with TeamRoehl you will work very closely with business analysts, data owners, BI Developers and other architects to design frameworks and create solutions and use your business and technical experience to analyze a variety of organizational needs and provide effective data patterns and engineering solutions that meet the needs of our changing analytical landscape.   Your solutions will be utilized at every level of the organization!  Become a member of one of the top Technology departments in WI!

The Experience:

This is a senior-level opportunity. This generally means that you have:

• Expert level SQL and T-SQL Skills
• Expert level SQL Server performance tuning
• Expert level SQL Server troubleshooting
• Experience working in a clustered, high-availability environment
• Experience working with Microsoft security and identity solutions
• Experience with Microsoft Replication and CDC strongly preferred
• Multiple years working in a senior technical role, designing DBMS solutions and implementing core architecture for SQL database platforms
• Deep understanding of relational and dimensional data models and metadata practices
• Deep understanding of data governance practices
• Understanding of secure data handling practices
• Cloud Experience is strongly desired, Azure preferred
• Experience with Azure Monitor is preferred
• Experience with Snowflake is preferred
• Experience with Comvault is preferred
• Experience with Redgate tools is a plus
• Experience with Azure DevOps is a plus

Additionally you have experience in:

• Visio