Associate Database Administrator (Aspire)
We’re Aspire, a ServiceTitan company
We’re Aspire, the leading SaaS provider for commercial landscaping, snow and ice removal, and janitorial businesses. Acquired by ServiceTitan in 2021, the world's leading provider of software for the trades, our cloud-based business management system enables contractors to grow their business, streamline operations, provide insights, and ultimately impress their customers. When you join our team, you’ll be a part of one of the fastest-growing companies in St. Louis, with an award-winning culture that’s been celebrated by the St. Louis Business Journal and Inc. Magazine. Trusted by thousands of premier field services leaders in the U.S. and Canada, our solutions empower our clients to make better business decisions for their company. Our partnership with ServiceTitan has enabled us to continue scaling our platform and customer base while maintaining our collaborative, tight-knit culture.
Ready to make your career move?
The Associate Database Administrator is responsible for keeping the company database up and running smoothly 24/7 providing a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.
The Assoc. DBA will work on designing and implementing databases in accordance to end user’s information needs and views. In addition to building database systems for the company of high availability and quality depending on each end user’s specialized role.
What You’ll Do:
Manage data platform and tools (Azure SQL, Azure Data Factory, SSIS, SSAS, Azure Synapse, etc) through multiple product lifecycle environments, from development to mission-critical production systems. Configure and maintain servers / platforms and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, backup / maintenance, and security.
Configure and build out the infrastructure required for optimal read/write storage, extraction, transformation, loading, and retrieval of data from a wide variety of data sources.
Provide expertise into architectural decision making around data platform tools, data modeling, advanced analytics, transactional systems, and reporting layers.
Assemble large, complex data sets that meet functional / non-functional business requirements. Tune and optimize poorly performing queries and stored procedures. Participate in code reviews with infrastructure and engineering teams.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, tuning existing data objects for performance, etc.
Work with various support and development teams to assist with data-related technical issues and support their data infrastructure needs.
Work closely with engineers / product owners to understand data needs and requirements of production environments while also delivering Business Intelligence solutions that are relayed directly to business leaders
Provide proactive and reactive data management support and training to users.
Determine, enforce and document database policies, procedures and standards.
Perform tests and evaluations regularly to ensure data security, privacy and integrity.
What You’ll Need:
Bachelor's degree (B.S/B.A) from four-college or university
2+ years experience in a related role
Experience managing Microsoft SQL Server environments (SQL Skills, Database Server Administration, SSIS, SSAS, SSRS) and Azure SQL (e.g Azure SQL Server, Azure Data Factory)
Expertise creating objects, performance tuning, query optimization, and troubleshooting scalability issues within Microsoft SQL Server or Azure SQL Server (including SSAS or Azure Analytics)
Experience in delivery and optimization of ETL pipelines and processes
Exposure to data repository, data lake, and data warehouse architecture
Demonstrate efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability of data.
* Visa sponsorship not available at this time. Must be eligible to work in the United States. *
Where You’ll Work:
Our headquarters is located in Chesterfield in St. Louis County; however, some local positions will be remote until the time is right to return to the office while other roles are more office-based. Fully remote employees will stay remote.
Be Human With Us:
Being human isn’t about checking every box on a list. It’s about the experiences we have, people we meet, and the perspectives we share. So, if you have the skills but are hesitant to apply because of your background, apply anyway. We need amazing people like you to help us challenge the conventional and think differently about the problems that we’re solving. We’re in this together. Come be human, with us.
What We Offer:
When you join our team, you’re not just accepting a job. You’re making a career move. Here’s how we’ll support you in doing some of the most impactful work of your career:
Flextime, recognition, and support for autonomous work: Flexible time off with ample learning and development opportunities to continue growing your career. We offer a comprehensive onboarding program, leadership training for Titans at all levels, and other programs and events. Great work is rewarded through Bonusly, peer-nominated awards, and more.
Holistic health and wellness benefits: Company-paid medical, dental, and vision (with 100% employer paid options and 90% coverage for dependents), FSA and HSA, 401k match, and telehealth options including memberships to Headspace, Galileo, One Medical, Ginger and more.
Support for Titans at all stages of life: Parental leave and support, up to $20k in adoption reimbursement, on demand maternity support through Maven Maternity, free breast milk shipping through Maven Milk, pet insurance, legal advisory services, financial planning tools, and more.
At ServiceTitan, we celebrate individuality and uniqueness. We believe that the convergence of fresh perspectives and experiences from all walks of life is what makes our product and culture so great. We strongly encourage people from underrepresented groups to apply. We do not discriminate against employees based on race, color, religion, sex, national origin, gender identity or expression, age, disability, pregnancy (including childbirth, breastfeeding, or related medical condition), genetic information, protected military or veteran status, sexual orientation, or any other characteristic protected by applicable federal, state or local laws.