Database Administrator - Atlanta, GA

Atlanta, GA, United States

Job ID: 498331

Exempt

Oldcastle Infrastructure™, a CRH company, is the leading provider of utility infrastructure solutions for the water, energy, and communications markets throughout North America. We're more than just a manufacturer of precast concrete, polymer concrete, or plastic products. We're a trusted and strategic partner to engineers, contractors, distributors, specifiers, and more. With our network of more than 80 manufacturing facilities and more than 4,000 employees, we're leading the industry with innovation and a safety-first mindset.

Are you ready to be part of a growing organization that is going through an IT transformation to bring value to CRH? The role of Database Administrator is to identify and implement improvements of operational support systems and processes across a diverse portfolio to optimize the value chain. This is an exciting role where you will be empowered to identify and prioritize opportunities to simplify and optimize. Coordinate with developers, system analysts, engineers, and functional managers to maintain operational stability, security, and availability. This individual will ensure that all solutions, with related procedures, adhere to organizational standards, controls and best practices, according to industry standards.

Key Responsibilities

Design, implement, and maintain database solutions adhering to company standards and industry best practices

Drive to identify root cause, leading to action avoiding reoccurrence, enabling focus on higher value opportunities

Take responsibility for the overall planning, execution and success of complex database projects

Support projects thru full SDLC life cycle (inception, design, implementation, migration/cutover planning, production support/maintenance, etc.)

Implement, maintain, and enhance backup/recovery strategy, High Availability (HA) and Disaster Recovery (DR) solutions, best standards configurations, and database maintenance solutions

Lead efforts for performance tuning, simplified administration, and continuous availability

Lead security, compliance, and audit efforts

Proactively monitor all database systems to maximize availability and minimize downtime/performance degradation

Create and maintain documentation on standards, procedures, and processes

Facilitate continuous improvement through innovation, continuous learning, and industry best practices

Liaise with vendors, customers, and other IT personnel on triaging problem resolution and new initiatives

Help coordinate dependencies across multiple projects and products through active partnerships with other engineering teams, vendors, and customers

Required Skills /Qualifications

While it is not required to have expert knowledge of every database services tool, process and technology in the spectrum, it is required to have a strong working knowledge with many of the following technologies, or their commercial or open-source equivalents. Broad awareness of different areas of database services is essential, coupled with willingness to expand the knowledge. 7+ years of experience with operational database administration on MS SQL Server

7+ years of SQL Server 2008/2012/2014/2016/2017/2019/2022

7+ years writing complex SQL (stored procedures, triggers, agent jobs, maintenance scripts, etc.)

Comprehensive understanding of SQL Server features. Knowledge to determine which features are most suited in various scenarios to address technical and business needs

Experience in troubleshooting and resolving database problems involving a diverse portfolio of technologies, applications, sites, vendors, and customers in mid and large cap companies

Experience conducting in depth evaluations, diagnosing, troubleshooting and resolving complex technical issues

Experience with backups, restores, various recovery models, and backup and restore strategies

Experience in Performance Tuning and Optimization (PTO), using native monitoring, custom scripts, and 3rd party tools

Proven ability to manage databases > 10TB in size containing tables with > 1B rows

Experience migrating multi-terabyte SQL Server databases between different sites and/or cloud with minimal downtime

Demonstrated understanding of SQL Server wait types, query options and hints, execution plans, locking and blocking

Good knowledge of indexes, index management, and statistics

Experience managing multiple database instances leveraging PowerShell and community toolkits such as DBA Tools

Experience setting up and maintaining transactional replication and change data capture

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server

Experience setting up and maintaining AlwaysOn Availability Groups running on WFC

Experience with database and data modeling, physical and logical design, for both OLTP and OLAP system

Excellent understanding of ITIL best practices, including change management, incidents, and requests

Experience working with windows servers, including proper OS, disk, and network configurations

Strong data and business analysis skills

Strong oral and written communication skills, including presentation skills

Ability to speak the language of other teams (networking, cloud, devops, etc.) to facilitate productive communications

Strong analytical and problem-solving skills

Preferred Skills /Qualifications Experience with SQL Server 2019 and beyond

Experience with other databases such as Oracle or Postgres

Experience with Snowflake data warehouses

Experience with ETL Tools such as Informatica and SSIS

Experience with cloud based ETL tools such as Fivetran and Data Factory

Experience AWS: VMs in AWS, RDS, Redshift, Aurora, Storage, Network, Security

Azure: VMs in Azure (PAAS), Managed Instance, SQL Database (SAAS), Data Lakes, Storage, Network, Security

Cloud based Backups/Recovery, Retention/Storage, HA, and DR

migrating on prem databases and applications to the cloud, administrating DB instances in the cloud, and hybrid solutions:

Experience with the Following Applications/Tools: Microsoft Dynamics AX

Mulesoft

Tableau

Okta

ServiceNow

SolarWinds

SQL Sentry

CommVault

Foglight

Redgate

Certifications: SQL Database Administration, SQL Database Development, Oracle Database Administration, Oracle Database Development, Data Management & Analytics, AWS, Azure

2+ years working for 10+ Location Enterprise

Work Requirements Ability to travel up to 10% as required by business needs

Office location for this position is Oldcastle Infrastructure's headquarters in Atlanta, GA

This position is fully remote but occasional office visits may be required with advanced notice

What CRH Offers You Highly competitive base pay

Comprehensive medical, dental and disability benefits programs

Group retirement savings program

Health and wellness programs

A diverse and inclusive culture that values opportunity for growth, development, and internal promotion

About CRH

CRH has a long and proud heritage. We are a collection of hundreds of family businesses, regional companies and large enterprises that together form the CRH family. CRH operates in a decentralized, diversified structure that allows you to work in a small company environment while having the career opportunities of a large international organization.

If you're up for a rewarding challenge, we invite you to take the first step and apply today! Once you click apply now, you will be brought to our official employment application. Please complete your online profile and it will be sent to the hiring manager. Our system allows you to view and track your status 24 hours a day. Thank you for your interest!

Oldcastle Infrastructure, a CRH Company, is an Affirmative Action and Equal Opportunity Employer.

EOE/Vet/Disability--If you want to know more, please click on this link.

Date: Jun 10, 2024