Intermediate Database Administrator

Autodata Solutions is looking for an Intermediate Database Administrator to join their team!

Position Overview:

As a part of a technical team, the Intermediate DBA focuses on automating workload into repeatable and consistent processes leveraging appropriate tools. Builds should be scripted as much as possible, and these scripts are managed in a source control system. You will design, implement, administer and maintain databases including monitoring, backup and recovery procedures, performance tuning and implementing database change management. This role requires strong familiarity with both MySQL and MSSQL database systems on Linux/Unix/Window based environments. The person promotes teamwork between Development and Operations teams. The Intermediate DBA ensures principals with data design, stewardship and acts as a data guardian.

Key Responsibilities:

• Works with Development resources in partnership to Codes, tests, and implements database solutions
• Coordinates physical changes to relational and non-relational databases
• Experience working with case tracking tools (i.e. JIRA)
• Designs logical and physical databases and reviews database design to understand how changes that are made will affect physical databases (how data is stored in terms of physical characteristics such as location, amount of space, and access method)
• Establishes physical database parameters, codes database objects/queries and specifies database identifiers to DBMS or guide others in coding best practices
• Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve
• Tests and corrects errors (queries, views, stored procedures/functions, triggers etc.), and refine changes to database configuration
• Interact with developers to effectively explore, investigate and implement requirements as they apply to database technology
• Ensures that database systems are available, secure, and that production support procedures are well documented and leverages scripting and automation technologies to improve speed of delivery (i.e. GIT, Ansible)
• Other duties as required by the position

Qualifications:

• A degree or diploma in Computer Science
• 5+ years’ experience in relational database technologies such as MySQL, MS SQL Server, Postgres, Oracle
• Familiarity with non-relational database such as Cassandra, MongoDB, Solr is a plus
• Demonstrable expertise with performance tuning, replication and data warehousing
• Experience with Data modeling tools
• Experience with developing stored procedures/queries/triggers/views etc. using various SQL scripting languages
• High availability experience with MySQL replication (master-slave, master-master) and SQL Server Always On Availability Groups (AOAG)
• Expertise with Windows/Linux Operating Systems and cloud hosting providers (Azure/AWS etc.)
• Automation and configuration management tools
• Backup and recovery
• Security and Monitoring applications
• Knowledge of development process, tools and technologies
   

For more information about Autodata Solutions, check out our website at www.autodatasolutions.com

When you work for an Autodata Solutions company, you join a team of dedicated professionals who are always looking for new ways to raise the bar. It takes talent, ambition and forward thinking to meet the challenges of our exciting and rapidly evolving market.

Autodata Solutions is the industry leader of technology, merchandising and sales solutions for the automotive industry. We have set the industry standard by providing the most up-to-date and innovative data, content, and platform capabilities – all the essentials to create and manage engaging digital experiences for consumers and end users.  We are committed to transforming the customer journey through a better vehicle consideration, purchase, and ownership experience.

We thank all applicants for their interest, however, only those selected for an interview will be notified.  Autodata Solutions is an equal opportunity employer.  We are compliant with AODA legislation; if you require work-related accommodations, please specify.

Apply now