Search for Cloud Database Administrator roles in Lansing, MI, focusing on Azure services, with 10+ years of experience in SQL Server, requiring strong ETL skills, and including remote work options.

Okay, I've searched for Cloud Database Administrator roles in Lansing, MI, emphasizing Azure services, with a requirement of 10+ years of SQL Server experience, solid ETL skills, and remote work options. I found 57 suitable positions for you.

Cloud Database Administrator

Lansing, MI

10 years + Experience

ETL

Remote

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The Cloud Database Administrator role at ServiceMaster Brands is focused on strategizing, managing, and optimizing the company's database architecture as they transition to Azure cloud services. The primary responsibilities include administering on-premises SQL Server environments, deploying and managing Azure SQL databases, and developing ETL pipelines to support data warehousing. Candidates will encounter challenges such as ensuring the performance and security of databases across both cloud and hybrid infrastructures and navigating complex data integration across various platforms. Success in this role will be measured by the candidate's ability to maintain high availability, optimize performance, and implement data governance in compliance with enterprise policies while effectively collaborating with cross-functional teams. The emphasis on agility and adaptability as a core company value suggests that candidates should be prepared to respond quickly to changing technologies and business needs, making their decision-making skills crucial.

Company Analysis:

ServiceMaster Brands occupies a significant position in the franchise sector, offering essential residential and commercial services with a commitment to integrity and customer service since its inception in 1929. With a diverse portfolio, including several well-known brands, the company is positioned as both a leader and an innovator in its industry. The culture at ServiceMaster seems to emphasize teamwork, accountability, and personal growth, as highlighted by their core values. This suggests that the organization values individuals who can genuinely contribute to a collaborative atmosphere, making the role of Cloud Database Administrator integral not just technically but also in fostering a supportive and innovative team environment. The organization is currently in a growth phase, positioning this role as essential for scaling their cloud capabilities and further developing their data infrastructure, which aligns with their broader strategic aims of enhancing operational efficiency and customer service.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Describe a time when you had to troubleshoot a complex database performance issue. What steps did you take, and what was the outcome?
Can you provide an example of how you managed a migration from an on-premises SQL Server to Azure SQL Database? What challenges did you face?
Tell me about a project where you had to collaborate with cross-functional teams to achieve a common goal. How did you ensure alignment and communication?
How do you stay up to date with the latest trends and technologies in cloud database management, and how have you applied new learnings to your work?
What strategies do you use for optimizing ETL processes? Can you walk us through a specific approach you've taken?
Describe your experience with database security best practices. How have you ensured compliance in your previous roles?
Imagine you find that a cloud-based database is experiencing performance bottlenecks affecting application responsiveness. What steps would you take to diagnose and resolve the issue?
If you are tasked with designing a scalable database architecture for a new service offering, what key considerations would you keep in mind?
Why are you interested in the Cloud Database Administrator position at ServiceMaster Brands specifically?
How do you see your values aligning with ServiceMaster’s commitment to integrity and customer service?
What excites you about the opportunity to work in a fast-paced and agile environment at ServiceMaster Brands?
How would you describe your experience working within agile methodologies? Can you provide an example?
What questions do you have about our current database systems and how they integrate with our business operations?

Job Details

Overview Company

Cloud Database Administrator

ServiceMaster® Brands

2 days ago

Highlight

HybridFull-time10+ yearsSenior

Summary

ServiceMaster® Brands is seeking a Cloud Database Administrator to join their team in Lansing, MI. The role involves managing on-premises SQL Server environments and Azure cloud services, focusing on cloud migration and performance optimization.

About the Role

As a Cloud Database Administrator, you will administer and maintain on-prem SQL Server environments, design and manage Azure SQL databases, and lead the architecture of scalable cloud databases. You will build and maintain data warehouses, develop ETL pipelines, and collaborate with cross-functional teams. Monitoring database performance, ensuring security, and supporting cloud migration are key responsibilities.

About You

Required:

10+ years of experience with Microsoft SQL Server administration (on-prem).
5+ years of hands-on experience with Microsoft Azure, particularly in Azure SQL Database, Azure Data Factory, and Azure Synapse.
Proven experience in database schema design, data modeling, and normalization/denormalization techniques for cloud databases.
Strong understanding of ETL processes and tools (e.g., ADF, SSIS, custom pipelines).
Solid experience with data warehousing concepts and implementation.
Proficiency with T-SQL, PowerShell, Terraform and scripting for automation and orchestration.
Familiarity with cloud security best practices, governance, and compliance frameworks.
Experience with performance tuning, indexing strategies, and query optimization.
Excellent problem-solving, analytical thinking, and communication skills.

Preferred:

Microsoft certifications such as Azure Database Administrator Associate or Azure Solutions Architect.
Experience with DevOps for databases, CI/CD pipelines, and Infrastructure as Code (IaC).
Exposure to NoSQL databases, Big Data tools, or Python for data manipulation.

Benefits

Medical, Dental, and Vision starting the first day of the month following your date of hire.
401(k) match.
15 days paid time off and paid holidays, including 2 floating holidays.
Career growth and advancement.

ServiceMaster® Brands

ServiceMaster® Brands is a leading franchise provider of needs-based residential and commercial services in the restoration, cleaning, moving, and bioremediation industries. Founded in 1929, today the company is home to over 3,500 franchisees across 4,900+ locations serving over 1M homes and businesses each year.

Our Brands and Purpose ServiceMaster was founded with a deep commitment to integrity, customer service and developing people and does business under seven brands today across 50 states and nine countries that generate more than $3.7B in system-wide sales: ServiceMaster Restore®, ServiceMaster Clean®, Merry Maids®, TWO MEN AND A TRUCK®, TWO MEN AND A JUNK TRUCK, ServiceMaster BioClean™, Indoor Science. While each brand maintains a distinct identity, we share a commitment to our purpose to Be there when you need us™.

Our Core Whether helping a family recover their most precious items and return to their homes following a fire, enabling a business to provide a clean, welcoming work environment to their employees, or moving a young couple to their first home, our Core guides our actions:

• Do what’s right. We show leadership and courage by demonstrating integrity and doing what’s right for our teams, partners and customers.

• Take care of each other. We put others first and create a safe environment for people to be successful and supported.

• Think like an owner. We are passionate about our work, empowered to make decisions and accountable to each other to achieve results.

• Bring out the best in others. We include all voices, seek out different points of view and invite healthy conflict to find the best ways to reach our goals.

• Act with agility. We stay nimble, continuously listen and learn, and take smart risks to innovate and deliver long term success.

• Play to win. We come prepared, stay on offense and stretch ourselves to deliver our commitments to all stakeholders.

Lansing, MI