Job 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. AutoAlerts 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 implementation
- Create and maintain tables, views, SQL Queries , and stored procedures and develop new ETL processes and data hygiene methods to meet business needs
- Perform data administration tasks, Backups, DR/Failover, Automation, Monitoring, Maintenance and Tuning Tasks
- Troubleshoot and correct data performance issues
- Troubleshoot data correctness issues
- Research new technologies, methodologies, and techniques
- Scale out and scale up our existing products
- Maintain a high level of code integrity by writing clean and testable code and following established lifecycle methodologies
- Build reusable and scalable code using established design patterns
- Collaborate with other team members and product stakeholders
- Assemble and model industry best-practices in order to foster best-in-class software development within and across departments
- Other duties as assigned
Your Experience and Impact - Bachelors degree in Computer Science, Software Development, or other technical discipline preferred
- 7+ years hands-on experience with MS SQL Server
- Strong database design and development experience
- 2+ years of Replication, Log Shipping, Database Mirroring, T-SQL Queries and stored procedures
- Experience with optimizing database design, analyzing data, queries & DDL
- Ability to tune Indexes and perform maintenance
- 2+ years experience in various ETL approaches
- Exposure to Amazon Web Services (AWS)
- Working knowledge of Agile SDLC methodologies (Agile, Waterfall, Scrum, Kanban, etc.)
- Basic knowledge of Microsofts Unit Testing Framework using Visual Studio test tools
- Skilled at adapting to a fast-paced and quickly changing environment, multi-tasking, and managing competing priorities with multiple deadlines
- Strong 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 Model
- Be Passionate About our Partners Success
- Own Working Together
- Deliver 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.
Job Tags
Remote job,