Senior Database Engineer

Cox Automotive

(Sandy, Utah)
Full Time Travel Required
Job Posting Details
About Cox Automotive
Cox Automotive Inc. is transforming the way the world buys, sells and owns cars with industry-leading digital marketing, software, financial, wholesale and e-commerce solutions for consumers, dealers, manufacturers and the overall automotive ecosystem worldwide. Committed to open choice and dedicated to strong partnerships, the Cox Automotive family includes Autotrader®, Dealer dot com®, Dealertrack®, Kelley Blue Book®, Manheim®, NextGear Capital®, vAuto®, Xtime® and a host of other brands.
Summary
Your essential responsibilities as the DBE are to assist with the design and build of databases, both relational and non-relational. You will be expected to resolve database performance issues, database capacity issues, replication, and other distributed data issues. You will also implement strategies for data acquisitions, archive recovery and the implementation of a database. Ensure a clean and accurate database by maintaining and removing old data. You also will administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the company databases. These responsibilities include patching, upgrading, and installing of new databases. In the role of DBA, you will optimizes the data environment by keeping databases finely tuned (queries/tables/indexes), automating incoming and outgoing data feeds, and troubleshooting of any data access problems. A DBE should also support Software Developers with best practice SQL database operations and efficiencies. Work with other departments to streamline data processes.
Responsibilities
* Lead in all phases of database design and management including performance, data integrity, security, and capacity planning. * Support teams with best practices in SQL coding techniques and optimized statement solutions. * Review and develop new stored procedures for developers. * Troubleshoot production and related database issues. * 24/7 on call rotation. * Install, maintain, upgrade and manage business critical database components for both production and non-production environments including MySQL, SQL Server, and Oracle, * Responsible for patch management, customized implementations, version control user management, service-level monitoring, and release methodologies. * Define, implement, and continuously improve database administrative policies for all database environments. * Analyze, implement, and manage database and application monitors for business critical services. * Implement and manage disaster recovery strategies, including clusters and redundant services, for all database based critical systems. * Administer databases in a production and application development environment * Monitor and maintain database integrity ensuring backups, updates, and changes are working properly. * Create new database schemas and enhance performance of these databases. * Install and replicate servers. * Keep current on emerging database, storage and virtualization technology trends.
Ideal Candidate
* B.S in Computer Science, Information Technology, Electrical Engineering or equivalent technical training and experience * 7+ years of database engineering experience (SQL / MySQL) * 5+ years of experience in managing all aspects of database administration including installation, configuration, capacity planning, and incident resolution. * Extensive experience in supporting several database technologies, i.e.: SQL Server, MySQL, and Dynamo DB or any other non-relational databases * Cloud experience preferred - releasing / deploying to Cloud, Aurora experience a plus * Experience in troubleshooting and resolving database integrity issues, performance issues, connectivity and security issues. * Strong background in DB performance, tuning, and replication * Strong knowledge of database theory and best practices * DB2 experience a plus * SQL proficiency * Excellent written and oral communication skills * Ability to effectively work in a team environment characterized by rapid change and high availability targets.
Compensation and Working Conditions

Working Conditions

Travel: Yes, 5 % of the Time

Questions

Answered by on
This question has not been answered
Answered by on

There are no answered questions, sign up or login to ask a question

Want to see jobs that are matched to you?

DreamHire recommends you jobs that fit your
skills, experiences, career goals, and more.