Senior Database Administrator

Company Overview

At Opus IVS, our mission is to drive advancement in the automotive industry by assisting customers with complex vehicle repairs. Guided by our core values of Customer Focus, Innovation, Collaboration & Teamwork, and a Results-Driven approach, we continually strive to develop advanced technology that empowers us to fulfill our mission.

Opus IVS technology & products has been a leader in the industry since the late 90’s. Opus IVS offers modern collision shops an integrated platform of leading diagnostics and calibration solutions, anchored by expert technicians and cutting edge, patented technology.

Job Overview

The Senior Database Administrator is a key contributor in developing applications for Opus IVS’s cutting-edge products. Collaborating closely with a skilled team, they maintain and enhance the RAP/Drive/ScanSafe solutions. The candidate will be responsible for maintaining and administering highly available systems in a cloud environment. They will provide effort estimations and contribute to multiple projects simultaneously. Clear communication and documentation are essential aspects of this role, supporting efficient collaboration and the success of our software development initiatives.

Responsibilities:

• Provide technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) to meet shifting organizational demands.
• Partnering with the development teams, you will be responsible for Database Reliability, Performance, and Security.
• Responsible for designing, integrating, and managing enterprise level database systems that are highly available, performant, secure, and scalable.
• Engage in automation to enhance provisioning and operational efficiency.
• Monitor database performance, identifying bottlenecks, and proactively optimizing query execution plans, indexes, and database configurations. This ensures efficient use of resources and enhances overall system performance.
• Manage database resources, such as CPU, memory, and storage, to prevent resource contention and ensure fair distribution among applications and tools.
• Optimize complex queries, identifying, and resolving performance issues. Collaborate with application developers to troubleshoot and resolve database-related problems.
• Implement robust backup and recovery strategies to safeguard data integrity and provide rapid data recovery in case of failures or disasters.
• Provisioning of new databases and scaling existing databases to meet the evolving demands of applications and tools on the shared platform.
• Manage database schema changes and versioning to coordinate updates and ensure compatibility between different applications and tools.
• Partner with IT to configure monitoring and alerting systems to proactively detect issues and promptly respond to potential problems in the shared platform, ensuring observability and quick incident resolution.
• Participate in design reviews to maintain quality and promote team unity.
• Provide detailed effort estimations when necessary.
• Participate in an agile development methodology to support many projects and teams, simultaneously.
• Create and maintain documentation for existing and new implementations.
• Other duties as assigned.

Requirements

Competencies:

• A self-starter with a strong work ethic and a healthy sense of curiosity.
• Clear and concise communication skills, both written and verbal.
• Ability to communicate technical information to non-technical stakeholders.
• Proficient in task estimation, demonstrating the capability to accurately assess project requirements and consistently meet deadlines.
• Excels in a team-oriented workplace.
• Self-motivated, detail oriented, and highly responsible.
• Capable of handling multiple assignments and additional responsibilities.
• Positive Attitude!

Qualifications:

• Must have a bachelor’s degree in computer science, software engineering or a related information technology field.
• A minimum of ten (10) years of successful experience.
• Proficiency in database management systems (e.g., MySQL, SQL Server)
• Strong analytical skills, and knowledge of database security practices
• Experience with scripting languages and a solid understanding of system architecture.
• 3+ years of experience in managing databases in Cloud (AWS and/or Azure) preferably AWS RDS
• Ability to work with Observability tools such as DataDog and AWS Performance Insights.
• Able to work independently or within a team proactively in a fast-paced agile environment.
• The ability to develop ETL data integration processes is a plus.

WHAT WE OFFER:

• Competitive Pay: We know your value and we’re not afraid to pay for it. We offer a competitive total compensation plan including salary, bonuses, tuition reimbursement, and a match contribution to your 401k.
• Time Off: Besides our competitive paid time off package, employees receive paid holidays and floating holidays.
• Benefits: We offer a comprehensive benefits package, including all the necessities such as medical, dental, and vision.
• Opportunity: to be a part of a fast-growing company working to make the world safer!

We are an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, disability status or any other characteristic protected by state, federal, or local law.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of the job, the employee is regularly required to use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; talk or hear. The employee frequently is required to stand, walk and sit. The employee is occasionally required to stoop, kneel, crouch or crawl. Specific vision abilities required by this job include close vision, color vision, peripheral vision, depth perception and the ability to adjust focus.

The above information has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

Job Type: Full-time

Pay: From $100,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Ability to Relocate:

• Dexter, MI 48130: Relocate before starting work (Required)

Work Location: In person