Database Architect

NOTICE OF FILING OF
APPLICATION FOR PERMANENT EMPLOYMENT CERTIFICATION
An application for permanent labor certification for the position described below will be filed by Norfolk Southern Corporation with the U.S. Department of Labor.
Job Title: Database Architect

Norfolk Southern Corporation is seeking a Database Architect based in Atlanta, Georgia. This position will provide expertise in Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) databases. This position will be responsible for database design for scalability, performance and resilience, advanced performance tuning, backup and recovery, active-active database design and implementation, and security. The individual in this position may telecommute from within 50 miles of the Atlanta metropolitan area in alignment with Norfolk Southern’s office/remote - hybrid work policy when not required to be in the office.

Job Duties:

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

Job Requirements:

1. Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Computer Engineering, or a related, relevant field.
2. Minimum of five (5) years of progressively responsible experience working with complex databases providing database architecting expertise. This experience must include at least three (3) years of experience:

• Troubleshooting and resolving complex database issues;
• Working with Red Hat Linux platform, ansible, or terraform automation framework;
• Utilizing Github interactions for database DDL change tracking;
• Administering NoSQL databases.

• Develop database resiliency architecture for highly available databases;
• Adapt to evolving technologies;
• Lead database re-design and migration efforts with minimal downtime;
• Work collaboratively with cross functional teams.

Location of Employment:
650 West Peachtree Street NW, Atlanta, GA 30308
Apply via email: or call (404) 360-5906.
Salary: $171,267 to $183,418 per year

This notice is provided as a result of the intended filing of an Application for Permanent Employment Certification for the above job opportunity.

Company Overview

Since 1827, Norfolk Southern Corporation (NYSE: NSC) and its predecessor companies have safely moved the goods and materials that drive the U.S. economy. Today, it operates a customer-centric and operations-driven freight transportation network. Committed to furthering sustainability, Norfolk Southern helps its customers avoid 15 million tons of yearly carbon emissions by shipping via rail.

At Norfolk Southern, we believe in celebrating our individuality. By leveraging the unique backgrounds and viewpoints of our employees, we can create a culture of innovation, respect, and inclusion. We know that employees thrive in a workplace where differing viewpoints, ideas, and experiences are freely shared and valued. As such, we encourage all employees to contribute their distinctive skills and capabilities to our organization.

Equal employment opportunities are available to all applicants regardless of race, color, religion, age, sex, national origin, disability status, genetic information, veteran status, sexual orientation, and gender identity. Together, we power progress.