Skip to Main Content
← Back to Jobs

Database Administrator

ALLDATA Sacramento ,CA
  • Posted: over a month ago
  • Full-Time
  • Benefits: life_insurance, medical, vision, 401k, dental
Job Description

Job Description

ALLDATA LLC, the leading provider of automotive business solutions, is seeking an experienced Mid-Senior Database Developer/Administrator to join its Technology team. 

 

Position Summary

As a member of a lean and high-performing team, you will be responsible for providing second-level support for our IT operations, product engineering, data services, and data analysis teams; responsible for managing RDMS and DBMS (relational, data warehouse, data lake, data mart, and operational data stores) services hosted in multiple datacenters. Areas of coverage include but are not limited to MySQL, Oracle, MS SQL Server, and multiple common document-oriented databases. This position reports to the Senior Database Administrator.

 

Job Duties

  • Technical elaboration and enablement during application planning and engineering agile exercises

  • Workload performance profiling and optimization

  • Design/implement/maintenance of blue-green production environments

  • Query optimization

  • After-hours on-call support.

  • Work closely with the IT operations, product engineering, data services, and data analysis teams to provide database development/administrative technical enablement

  • Provide advice/recommendations on database architecture, design and implementation

  • Establish database design conventions in best practice, assure conventions and standards are compliant and fully documented

  • Work with data modelers to review and optimize logical data models and implement them in physical database schemas using data modeling tools

  • Communicate with non-technical users and technical personnel on business and product delivery teams

  • Support and participate in the database change management and deployment processes

  • Develop and implement stored procedure verification tools that assist developers in troubleshooting and performance improvement

  • Develop and implement procedures for the synchronization between different database environments

  • Provide training and documentation for knowledge transfer to other database team members

 

Breakdown of job duties (approximate)

  • 50% - Database development and administrative technical enablement, and collaboration with application team members, assigned to Agile story work, elaboration exercises
  • 30% - ITOPS duties: Ticket handling, audit, plan, patch, test, and implementing of  changes
  • 15% - Document processes, procedures, configuration settings and infrastructure design for business continuity and disaster recovery
  • 5% - Includes on-call activities

 

Technical Qualifications

The Mid-Senior Database Administrator shall possess 7+ years of technical knowledge, and experience with most of the following systems, platforms, and/or applications:

  • Hands-on/applied experience in database development/administration using MySQL, Oracle, common document-oriented databases; including performance monitoring, capacity and multi-site disaster planning, transaction workload balancing, and performance tuning

  • Oracle 19C: Real Application Clustering, ASM, Data Guard, or GoldenGate

  • MySQL 5.7, 8: NDB, Multi-master, or Circular Replication, or Group Replication

  • Common document-oriented databases: MongoDB, CouchDB, Couchbase

  • Experience with Java ORM is a Plus: Spring JDBC, Spring Data, or JPA, JDBC

  • Extensive knowledge with complex SQL and PL/SQL programming, and optimization

  • Experience in Agile database development and administration

  • Proficiency with Linux running in converged or hyperconverged environments - VMWare & physical

  • Experience in database schema design including logical and physical for large scale, highly available application systems

  • Good writing skills to provide documentation for DBA and software development teams

  • Strong knowledge/understanding of ITSM/ITIL support processes and methodologies, incident management, change control management, problem management

 

Desired Skills

  • Apply strong technical problem-solving skills daily

  • Be proactive with a focus on constant improvement and follow through at all levels

  • Demonstrate your ability to work in a fast-paced environment while balancing multiple priorities 

  • Provide excellent oral and written communication skills

  • Analyze/troubleshoot all levels of server, application and network issues.

  • Document, track and monitor technical issues to ensure timely resolution

  • Provide timely and thorough input for regular status reporting

  • Take ownership of issues, work independently or escalate as needed, and find creative ways to resolve problems

  • Perform other duties and special projects as required or assigned

Company Description
ALLDATA – Taking Automotive Intelligence to the Next Level

ALLDATA®, an AutoZone® company, is the automotive industry’s #1 choice for OEM-direct diagnostic and repair information, both mechanical and collision. Founded in 1986, the company has more than 130,000 subscribers in North America who rely on ALLDATA for cloud-based, OEM-accurate automotive service and repair data, shop management software, training, and customer relations tools.

ALLDATA® is building a team that will develop a complete suite of mobile-enabled products and services for all of our products. Be part of a talented team working with the latest technology to create world-class software products.

We are looking for individuals committed to maintaining our position as the leader in our market.

ALLDATA® is an Equal Opportunity Employer.

ALLDATA

Why Work Here?

Competitive pay & flexible work schedules, Full Benefits (Medical, Dental, Vision, 401k, STD, LTD, Adoption assistance)

ALLDATA – Taking Automotive Intelligence to the Next Level ALLDATA®, an AutoZone® company, is the automotive industry’s #1 choice for OEM-direct diagnostic and repair information, both mechanical and collision. Founded in 1986, the company has more than 130,000 subscribers in North America who rely on ALLDATA for cloud-based, OEM-accurate automotive service and repair data, shop management software, training, and customer relations tools. ALLDATA® is building a team that will develop a complete suite of mobile-enabled products and services for all of our products. Be part of a talented team working with the latest technology to create world-class software products. We are looking for individuals committed to maintaining our position as the leader in our market. ALLDATA® is an Equal Opportunity Employer.

Address

9650 West Taron Drive
Sacramento, CA
USA

What email should we contact you at once we get salary info from the hiring manager?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.

Our qualification feature is only available to registered members - what email address would you like for us to keep on file?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.