Sign In
 [New User? Sign Up]
Mobile Version

Database Administrator II

Cox Automotive


Location:
Sacramento, CA
Date:
11/20/2017
2017-11-202017-12-19
Job Code:
1714338
Cox Automotive
Apply on the Company Site
  •  
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

Company Cox Automotive
Title: Database Administrator II
JobID: 1714338
Category: Information Technology
Industry: Cox Automotive
Job Type: Full-time

Description

Job Summary:
The Database Administrator is responsible for installing, configuring, upgrading, administering, monitoring and maintaining databases to keep them in a usable state, ensuring they are available and accurate at all required times. The Database Administrator is involved in database and repository design, managing the availability of databases to agreed operating levels, installing database software, and providing database support.

Key Responsibilities

Vision and Direction
  • Develops, documents, communicates, and enforces database standards, policies, and procedures for standardizing database assets.

Design and Builds
  • Designs and builds new database solutions based on requirements from project initiatives.
  • Implements data models and database designs into physical databases.

Availability & Operating Level Management

  • Performs root cause analysis, resolves problems and recommends solutions.
  • Maintains and performs preventative database maintenance to provide availability, capacity, integrity, and security against operating level agreements.
  • Establishes guidelines and standards for capacity management review and establishes standards for database operations.
  • Monitors and plans capacity of all databases to plan for future growth.
  • Analyzes and optimizes database performance. 

System Installation/ Decommissioning
  • Installs and maintains database software.
  • Manages database configuration including installing and upgrading database and applying patches.
  • Conducts multiple levels of testing prior to release of new and upgrades systems, products or services.

Support
  • Ensures that backup and recovery plans are tested regularly and backup and recovery procedures are implemented.
  • Performs business continuity and disaster recovery testing.
  • Develops automation scripts and programs to streamline manual operations and reduce manpower requirement in maintenance and monitoring activities.
  • Performs troubleshooting and issue resolution and escalate issues to appropriate 3rd party vendor if needed.
  • Provides technical support and consultation to colleagues and customers as needed.


Qualifications

Knowledge, Experience & Qualifications
  • Bachelor’s degree in Computer Science or related field or equivalent combination of industry related professional experience and education
  • 3-5 years hands-on working experience administering Microsoft SQL Server databases and clusters in a SaaS production environment
  • Working experience writing T-SQL triggers and/or procedures
  • Working experience with configuring and managing advanced queues
  • Working experience configuring and managing replication
  • Working experience with stored procedures, triggers, functions, packages, partitioning, streams and indexes
  • Working experience with Amazon Web Services, including Amazon Relational Database Service systems
  • Working experience with PowerShell scripting
  • Working experience with automation tools such as Terraform, Chef, Puppet, Anisible or Salt Stack
  • Experience working in a software development environment
  • Experience with Microsoft SQL SSIS

Organization: Cox Automotive

Primary Location: US-CA-Sacramento-9750 Goethe Rd

Other Locations: 3268 Progress Way,US,OH,Wilmington,45177

Employee Status: Regular

Job Level: Individual Contributor

Shift: Day Job

Travel: Yes, 5 % of the Time

Schedule: Full-time

Unposting Date: Ongoing
Apply on the Company Site
Powered ByLogo

Featured Jobs[ View All ]

Featured Employers [ View All ]