Database Architect

$171,267 - $183,418/Yr

Norfolk Southern - Atlanta, GA

Full-time - Mid Level

Remote - Atlanta, GA

Rail Transportation

About the position

The Database Architect at Norfolk Southern Corporation will be responsible for designing and implementing scalable, high-performance databases that support both Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP). This role involves advanced performance tuning, backup and recovery strategies, and ensuring database security. The position allows for telecommuting within 50 miles of Atlanta, GA, in accordance with the company's hybrid work policy.

Responsibilities

• Create and maintain optimal on-prem and cloud database architectural artifacts.
• Develop on-prem to cloud database migration solutions and strategies.
• Serve as representative in Architectural Review Board (ARB) to align database structure and function with organizational needs.
• Lead and partner with application teams to develop database design and model for optimal database, application performance and throughput.
• Design active-active, high availability and disaster recovery strategies and solutions for OLTP databases.
• Design and configure on-prem/cloud analytics platform operational infrastructure related to OLAP databases.
• Responsible for analytics platform governance and cluster provisioning for OLAP databases.
• Design and support of multi-region on-prem to cloud data streaming and engineering platform for OLAP databases.
• Monitor data quality and database resource utilization for OLAP databases.
• Serve as Subject Matter Expert (SME) on performance tuning and optimization of SQL queries, stored procedures, and indexes to improve database performance.
• Collaborate with database administrators to develop database backup and recovery strategies to ensure business continuity and disaster recovery.
• Manage database security by implementing appropriate authentication, authorization, and auditing mechanisms.
• Collaborate with developers and database administrators to design and implement database schema changes.
• Serve as Level 3 on-call support for critical database analytics, database, and warehouse issues.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, Computer Engineering, or a related field.
• Minimum of five (5) years of progressively responsible experience working with complex databases providing database architecting expertise.
• At least three (3) years of experience troubleshooting and resolving complex database issues.
• Experience working with Red Hat Linux platform, ansible, or terraform automation framework.
• Experience utilizing Github interactions for database DDL change tracking.
• Experience administering NoSQL databases.
• Demonstrated knowledge of Unix and PowerShell scripts.
• Ability to develop database resiliency architecture for highly available databases.
• Ability to adapt to evolving technologies.
• Ability to lead database re-design and migration efforts with minimal downtime.
• Ability to work collaboratively with cross functional teams.