CRH Americas - Atlanta, GA

posted 2 months ago

Full-time - Mid Level
Remote - Atlanta, GA
1,001-5,000 employees
Nonmetallic Mineral Product Manufacturing

About the position

The role of Database Administrator at Oldcastle Infrastructure is pivotal in identifying and implementing improvements in operational support systems and processes across a diverse portfolio. This position is designed to optimize the value chain and is part of an exciting IT transformation initiative aimed at enhancing the overall efficiency and effectiveness of the organization. As a Database Administrator, you will be empowered to identify and prioritize opportunities for simplification and optimization, working closely with developers, system analysts, engineers, and functional managers to maintain operational stability, security, and availability of database systems. In this role, you will be responsible for designing, implementing, and maintaining database solutions that adhere to company standards and industry best practices. You will drive efforts to identify root causes of issues, leading to actionable solutions that prevent recurrence and enable a focus on higher-value opportunities. The position requires taking responsibility for the overall planning, execution, and success of complex database projects, supporting them through the full Software Development Life Cycle (SDLC), which includes inception, design, implementation, migration/cutover planning, and production support/maintenance. Additionally, you will implement, maintain, and enhance backup and recovery strategies, High Availability (HA), and Disaster Recovery (DR) solutions, ensuring best practices in configurations and database maintenance. You will lead efforts in performance tuning, simplified administration, and continuous availability, while also overseeing security, compliance, and audit efforts. Proactive monitoring of all database systems to maximize availability and minimize downtime or performance degradation will be a key part of your responsibilities. You will also create and maintain documentation on standards, procedures, and processes, facilitating continuous improvement through innovation and adherence to industry best practices. Collaboration with vendors, customers, and other IT personnel will be essential in triaging problem resolution and initiating new projects.

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 through the 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.

Requirements

  • 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 and the ability 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 systems.
  • 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.

Nice-to-haves

  • 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 with AWS: VMs in AWS, RDS, Redshift, Aurora, Storage, Network, Security.
  • Experience with Azure: VMs in Azure (PAAS), Managed Instance, SQL Database (SAAS), Data Lakes, Storage, Network, Security.
  • Experience with 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 Microsoft Dynamics AX, Mulesoft, Tableau, Okta, ServiceNow, SolarWinds, SQL Sentry, CommVault, Foglight, Redgate.

Benefits

  • 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service