Database ArchitectApply now »Date: Oct 15, 2024Location: Atlanta, GA, US, 30308Company: Norfolk Southern Corp.NOTICE OF FILING OFAPPLICATION FOR PERMANENT EMPLOYMENT CERTIFICATIONAn 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 ArchitectNorfolk 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:
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.
Job Requirements:
Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Computer Engineering, or a related, relevant field.
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; and
Administering NoSQL databases.
Demonstrated knowledge of:
Unix and PowerShell scripts.
Demonstrated ability to:
Develop database resiliency architecture for highly available databases;
Adapt to evolving technologies;
Lead database re-design and migration efforts with minimal downtime; and
Work collaboratively with cross functional teams.
Must be able to work weekends and on-call as necessary.
Location of Employment:650 West Peachtree Street NW, Atlanta, GA 30308Apply via email: HR.CareersInbox@nscorp.com or call (404) 360-5906.Salary: $171,267 to $183,418 per yearThis notice is provided as a result of the intended filing of an Application for Permanent Employment Certification for the above job opportunity. Any person may provide documentary evidence bearing on this application to:Certifying OfficerU.S. Department of LaborEmployment and Training AdministrationOffice of Foreign Labor Certification200 Constitution Avenue NW, Room N-5311Washington, DC 20210This notice was posted in a conspicuous place in the office of Norfolk Southern Corporation in Atlanta, Georgia and on the company’s intranet for a period of 10 consecutive business days from until . The notice remained clearly visible and unobstructed during the entire period of posting. Signature DatePrinted NameTitleCompany OverviewSince 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. Its dedicated team members deliver more than 7 million carloads annually, from agriculture to consumer goods, and is the largest rail shipper of auto products and metals in North America. Norfolk Southern also has the most extensive intermodal network in the eastern U.S., serving a majority of the country’s population and manufacturing base, with connections to every major container port on the Atlantic coast as well as the Gulf of Mexico and Great Lakes. Learn more by visiting www.NorfolkSouthern.com .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.