AutoAlert
Database Administrator
AutoAlert, Kansas City, Missouri, United States, 64101
Description
Database Administrator
Location - Remote
Working Group - 1
Travel Required - No
Salary Range$130,000 to $165,000 + Discretionary Bonus
Classification - Exempt
Leadership Level - GS 7 to GS 8
AutoAlert is the original disruptor in the automotive software space. Our Customer Experience Management (CXM) platform is revolutionizing the dealership-customer relationship, creating direct opportunities for meaningful connections and seamless experiences both online and offline.
About AutoAlert
AutoAlert offers a portfolio of innovative solutions that maximize dealership profitability by focusing on customer relationships and creating direct opportunities for meaningful data-driven connections. Founded in 2002, AutoAlert is the leading automotive software and data mining provider, enhancing customer relationships that lead to repeat sales, service, and increased loyalty. AutoAlert's mission is to empower innovative automotive partnerships to improve data-driven customer experiences. AutoAlert is proud to lead the industry in data security, with independently audited high-level security in place via Soc 2 Type 2 and ISO/IEC 27001:2013 certifications.
Role Description
At AutoAlert, the Senior Software Business Analyst/Database Administrator is responsible for developing and maintaining our database infrastructure, incoming and outgoing data feeds, and applications to support the growth of the business. You will promote a highly available, scalable, and stable data platform in a cloud computing environment. You will contribute to the overall engineering, design, build and high level support of all existing and new Microsoft SQL Server systems. You have high level technical detailed knowledge of SQL server architecture (2014, 2019).
You are a team player with strong problem-solving skills and an innovative mindset. You are part of a creative, diverse, collaborative team of hardworking individuals with the goal of increasing brand favorability, customer engagement and advocacy, and revenue growth.
Responsible for database design, normalization and implementationCreate and maintain tables, views, SQL Queries, and stored procedures and develop new ETL processes and data hygiene methods to meet business needsPerform data administration tasks, Backups, DR/Failover, Automation, Monitoring, Maintenance and Tuning TasksTroubleshoot and correct data performance issuesTroubleshoot data correctness issuesResearch new technologies, methodologies, and techniquesScale out and scale up our existing productsMaintain a high level of code integrity by writing clean and testable code and following established lifecycle methodologiesBuild reusable and scalable code using established design patternsCollaborate with other team members and product stakeholdersAssemble and model industry best-practices in order to foster best-in-class software development within and across departmentsOther duties as assigned
Your Experience and Impact
Bachelor's degree in Computer Science, Software Development, or other technical discipline preferred7+ years hands-on experience with MS SQL ServerStrong database design and development experience2+ years of Replication, Log Shipping, Database Mirroring, T-SQL Queries and stored proceduresExperience with optimizing database design, analyzing data, queries & DDLAbility to tune Indexes and perform maintenance2+ years experience in various ETL approachesExposure to Amazon Web Services (AWS)Working knowledge of Agile SDLC methodologies (Agile, Waterfall, Scrum, Kanban, etc.)Basic knowledge of Microsoft's Unit Testing Framework using Visual Studio test toolsSkilled at adapting to a fast-paced and quickly changing environment, multi-tasking, and managing competing priorities with multiple deadlinesStrong understanding of the Software Development Life Cycle (SDLC)
Supervisory Responsibilities
This position has no direct supervisory responsibilities but works with other team members inside and outside of the department
Across all teams, we look for the following Values:
Be a Role ModelBe Passionate About our Partners' SuccessOwn Working TogetherDeliver Results
Living the AutoAlert values is core to all team members' success. We welcome and encourage all people of diverse backgrounds, experiences, abilities, and perspectives. We are an equal opportunity employer, focused on providing a positive place for you to grow your career.
Accommodations
If you require assistance applying for open positions, please reach out to Human Resources at hr@autoalert.com.
Benefits
AutoAlert provides a robust benefits package to eligible employees. Eligibility requirements apply to all plans in the United States and Canada. AutoAlert reserves the right to alter benefits offerings at will.
Posting Statement
AutoAlert is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status.
AutoAlert does not accept unsolicited headhunter and agency resumes. AutoAlert will not pay any third-party agency or company that does not have a signed agreement with AutoAlert.
We are unable to sponsor H1-B Visas at this time.
Database Administrator
Location - Remote
Working Group - 1
Travel Required - No
Salary Range$130,000 to $165,000 + Discretionary Bonus
Classification - Exempt
Leadership Level - GS 7 to GS 8
AutoAlert is the original disruptor in the automotive software space. Our Customer Experience Management (CXM) platform is revolutionizing the dealership-customer relationship, creating direct opportunities for meaningful connections and seamless experiences both online and offline.
About AutoAlert
AutoAlert offers a portfolio of innovative solutions that maximize dealership profitability by focusing on customer relationships and creating direct opportunities for meaningful data-driven connections. Founded in 2002, AutoAlert is the leading automotive software and data mining provider, enhancing customer relationships that lead to repeat sales, service, and increased loyalty. AutoAlert's mission is to empower innovative automotive partnerships to improve data-driven customer experiences. AutoAlert is proud to lead the industry in data security, with independently audited high-level security in place via Soc 2 Type 2 and ISO/IEC 27001:2013 certifications.
Role Description
At AutoAlert, the Senior Software Business Analyst/Database Administrator is responsible for developing and maintaining our database infrastructure, incoming and outgoing data feeds, and applications to support the growth of the business. You will promote a highly available, scalable, and stable data platform in a cloud computing environment. You will contribute to the overall engineering, design, build and high level support of all existing and new Microsoft SQL Server systems. You have high level technical detailed knowledge of SQL server architecture (2014, 2019).
You are a team player with strong problem-solving skills and an innovative mindset. You are part of a creative, diverse, collaborative team of hardworking individuals with the goal of increasing brand favorability, customer engagement and advocacy, and revenue growth.
Responsible for database design, normalization and implementationCreate and maintain tables, views, SQL Queries, and stored procedures and develop new ETL processes and data hygiene methods to meet business needsPerform data administration tasks, Backups, DR/Failover, Automation, Monitoring, Maintenance and Tuning TasksTroubleshoot and correct data performance issuesTroubleshoot data correctness issuesResearch new technologies, methodologies, and techniquesScale out and scale up our existing productsMaintain a high level of code integrity by writing clean and testable code and following established lifecycle methodologiesBuild reusable and scalable code using established design patternsCollaborate with other team members and product stakeholdersAssemble and model industry best-practices in order to foster best-in-class software development within and across departmentsOther duties as assigned
Your Experience and Impact
Bachelor's degree in Computer Science, Software Development, or other technical discipline preferred7+ years hands-on experience with MS SQL ServerStrong database design and development experience2+ years of Replication, Log Shipping, Database Mirroring, T-SQL Queries and stored proceduresExperience with optimizing database design, analyzing data, queries & DDLAbility to tune Indexes and perform maintenance2+ years experience in various ETL approachesExposure to Amazon Web Services (AWS)Working knowledge of Agile SDLC methodologies (Agile, Waterfall, Scrum, Kanban, etc.)Basic knowledge of Microsoft's Unit Testing Framework using Visual Studio test toolsSkilled at adapting to a fast-paced and quickly changing environment, multi-tasking, and managing competing priorities with multiple deadlinesStrong understanding of the Software Development Life Cycle (SDLC)
Supervisory Responsibilities
This position has no direct supervisory responsibilities but works with other team members inside and outside of the department
Across all teams, we look for the following Values:
Be a Role ModelBe Passionate About our Partners' SuccessOwn Working TogetherDeliver Results
Living the AutoAlert values is core to all team members' success. We welcome and encourage all people of diverse backgrounds, experiences, abilities, and perspectives. We are an equal opportunity employer, focused on providing a positive place for you to grow your career.
Accommodations
If you require assistance applying for open positions, please reach out to Human Resources at hr@autoalert.com.
Benefits
AutoAlert provides a robust benefits package to eligible employees. Eligibility requirements apply to all plans in the United States and Canada. AutoAlert reserves the right to alter benefits offerings at will.
Posting Statement
AutoAlert is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status.
AutoAlert does not accept unsolicited headhunter and agency resumes. AutoAlert will not pay any third-party agency or company that does not have a signed agreement with AutoAlert.
We are unable to sponsor H1-B Visas at this time.