Database Administrator - Atlanta, United States - CRH

Description

Job ID: 498331

Exempt

Oldcastle InfrastructureTM, 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 migrating on prem databases and applications to the cloud, administrating DB instances in the cloud, and hybrid solutions:
  • 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
• 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.