Full Job Description
Primary Location: 195 Technology Dr, Irvine, CA, USA
Division: Cox Automotive
Job Level: Individual Contributor
Shift: Day Job
Requisition Number: 202000673
The Database Administrator is responsible for recommending, implementing and supporting current and new SQL Server DB technologies, as required, to support the technical capabilities of Cox Automotive Inc (CAI). To be successful in this role one must be able to work effectively in a fluid, fast-paced environment. This role requires good communication skills, both with team members and business contacts. In addition, the successful Database Administrator must be able to work with minimal supervision on multiple concurrent projects.
Diagnose and Resolve problems around database performance, capacity, replication, T-SQL, etc.
Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all CAI environments DEV/QA/PROD.
Coordinate and schedule DB downtimes to perform DB maintenance procedures. i.e. DB patching, upgrades, etc.
Define Backup and Recovery strategies using technologies used at CAI: Netapp Snapshots, SnapManager for SQL, Idera SQLSafe or Native SQL Server Backup/recovery Tools.
Perform advanced database administration activities including but not limited to: DB Performance Tuning, T-SQL tuning, Backup and recovery and DB disaster recovery solutions.
Communicate effectively with other CAI groups gathering requirements for new instance build outs or supporting existing applications.
Analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, disaster recovery or high performance.
Work independently or with other CAI teams to design or participate in functional/performance tests.
Create/update CAI’s database documentation about standard procedures, DB technology features, or production issue troubleshooting.
Stay current with changes in the technical area of expertise.
Design and implement highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, Availability Groups.
Review scripts submitted by the Development team for performance and standard adherence.
Work with development teams to deploy code in production when needed.
Participate in on-call rotations.
Bachelor’s degree or equivalent work experience
5-7 years’ experience in Microsoft Windows/ SQL Server Technologies, .Net development.
Experience working on 24x7 environments oriented towards a zero downtime target.
Working knowledge or previous administration of SQL 2008R2-SQL 2019 and Windows Server 2003+.
Experience with ETL, DTS, T-SQL and SSRS, SSIS.
Ability to work with minimal direction, in a team environment.
Performance tuning for SQL server, queries, stored procedures, views, etc.
Hands on experience with configuring and administering Log Shipping and SQL Availability Groups.
Experience with SQL in virtual, physical and cloud-based environments.
Proven ability to quickly learn and implement new technologies
Experience with, or interest in learning, Oracle, mysql, Netezza, Hadoop database platforms, a significant plus.
Experience with SentryOne a plus.
Ability to code Powershell commands a plus.
Who We Are
About Cox Automotive
There’s nothing ordinary about Cox Automotive. We are people of every background driven by our passion for mobility, innovation, client success and community outreach. We make buying, selling and owning (or simply using) cars easier for everyone. Touching more than 40,000 clients across five continents, we bring together the best brands and the best teams to propel the automotive industry forward. Some of those team members work for our iconic consumer brands like Autotrader and Kelley Blue Book, while others are creating the future of automotive at industry-facing brands like Dealer.com, Manheim and vAuto.
We are the Cox family of businesses. We’ve been making our mark since 1898 by building and evolving world-class businesses, staying true to our values, and encouraging top talent to always look for growth and impact while building a career with us. Our primary divisions – Cox Communications and Cox Automotive – are driving a new wave of innovation, powering smart cities with powerhouse broadband communications and pioneering greener, more progressive transportation alternatives for individuals and fleet operators. We’re also expanding into new spaces like cleantech and healthcare to rev up our momentum toward building a better future for the next generation. We’re looking for the talent today who will be our leaders tomorrow. Sound intriguing? Learn more about where we are today, where we hope you’ll be going with us, and the common purpose that unites us at coxenterprises.com.
Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law.
Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.