Job Description

Job Description

Albertsons Companies is one of the largest food and drug retailers with 2,300+ stores. The Albertsons Companies family of brands includes some of the most prominent brands in food retailing, with a growing base of loyal shoppers. Thanks to the professionalism, diversity, spirit and friendliness of our people, we have locations across the U.S.

The Digital DevOps Information Technology Department has an opening for a DevOps Database Engineer. This position is located in Pleasanton, California.

Position Purpose

The Loyalty and Digital Marketing programs provide cutting edge solutions to engage and delight our customers in their online experience across multiple brands within the Albertson's, Inc. companies. The ideal candidate will be passionate in growing and leading the DevOps team to support the Digital programs. The Loyalty and Digital Marketing applications aim at improving the digital experience for 20M+, and growing, customers in our online channels. Working in a fast-paced agile development environment, this position will be critical in delivering solutions to advance the capabilities of the Loyalty platform (J4U) and be part of a stellar team building a scalable cloud service platform.

This is a DevOps Database Engineerposition to perform day-to-day tasks aligned with continuous delivery best practices. The ideal candidate for this role will have a deep understanding of SQL Server Administration, Development, and Database Design using MS SQL Server environments. The candidate must be aware of cloud technologies, strong analytical and troubleshooting skills, excellent automation skills, and great communication skills.

Key Responsibilities include, but are not limited to:

* Monitor incident ticket queue and resolve database incidents within SLAs
* Restore service of all database related issues
* Maintain and support databases/instances required by application, vendor, and design teams
* Monitor backup results and resolve/troubleshoot failed database backups
* Provide daily development support to application teams including database connectivity, configuration (index creation, database layout, schema changes) and Data migration
* Monitor database and server performance and identify current and potential bottlenecks
* Provide performance monitoring during all phases of the Application's development lifecycle
* Responsible for trouble shooting database issues including collecting information through traces and other logging facilities
* Provide database performance tuning expertise through recommendation to application developers, vendors, and other core Application teams
* Provide database configuration for optimal performance including Database Partitioning
* Review and update runbook documentation
* Support installations of database maintenance and security patches and upgrade to supported release levels
* Implement policies, procedures, and technologies to ensure database system security through secure system access, monitoring, control, and routine security evaluations.
* Perform and test database backups and restores to ensure system recovery from error or outage.
* Review and deploy database upgrades and vendor-supplied patches according to best practices.
* Engineer and provide guidance in new database deployments
* Documents all changes, upgrades, maintenance, procedures, etc. using company document infrastructure
* Adherence to change control and release procedures

Qualifications:

* 5-7 Years of hands-on experience with SQL Server database administration experience handling 4- 70+ TB databases
* BS/BA in Computer Science, Business Administration, or related degree
* Experience with a second DBMS especially Cassandra is highly desirable
* Experience in database design, tuning, and performance analysis (Candidates must have in-depth understanding of Join methods, data access path and SQL traces)
* Experience in the use of partitioning and indexing and data models
* Solid and proven skills in managing database lifecycle -- builds, patching, backup, and recovery
* Experience with Linux (Redhat or SUSE), Solaris and Unix AIX are desired
* Experience with Windows Failover Clustering
* Demonstrated use of scripting, Stored Procedures, Triggers, Cursors, Logins and Views
* Results oriented, willing to take responsibility and accept accountability for action
* Experience in working a cloud and virtual environments
* Strong communication and leadership skills with the demonstrated ability to lead and influence technical professionals across the enterprise
* Comfortable with ambiguity as needs change on a regular basis with a high degree of initiative and sense of urgency
* Excellent oral and written skills with the ability to interact with senior management, technical subject matter experts, and business customers are essential in this role
* Ability to work on multiple initiatives and projects simultaneously
* Deep knowledge of Oracle DB architecture, tools, utilities, backup/cloning, security, monitoring, etc.
* Experience with other databases like MS SQL, MySQL, MongoDB is preferred.
* Experience with MS Azure, DevOps and managing Relational Databases.
* Strong understanding of ITIL service support and service delivery
* Ability to operate in a support role, assuming on call responsibilities
* Genuine desire to provide superior customer service

How to Apply: Interested candidates are encouraged to submit a resume by visiting https://www.albertsonscompanies.com/careers/en/home.html

Diversity is fundamental at Albertsons Companies. We foster an inclusive working environment where the different strengths and perspectives of each employee is both recognized and valued. We believe that building successful relationships with our customers and our communities is only possible through the diversity of our people. A diverse workforce leads to better teamwork and creative thinking, as well as mutual understanding and respect.

The Albertsons Companies policy is to provide employment, training, compensation, promotion and other conditions of employment without regard to race, color, religion, sexual orientation, gender identity, national origin, sex, age, disability, veteran status, medical condition, marital status or any other legally protected status.

We support a drug-free workplace -- all applicants offered a position are required to pass a pre-employment drug test before they are hired.

AN EQUAL OPPORTUNITY EMPLOYER