Database Administrator, II

Description

Database Administrator II

JOB SUMMARY:

This position will be embedded in several teams who are building and supporting applications for the GAS database systems.

The DBA will work with stakeholders - both in the business and the technology organization, to confirm performance and supportability of the database. They will fulfill tasks described here across multiple database environments. They will enforce standards and best practices at the database level while working with developers. They will not own development of database code and stored procs but will advise on approaches and recommendations for database configurations and custom code changes that might affect the database. Part of this will require assisting developers with their query requests, by gathering, building, and providing examples. This will include checking for proper indexing of the databases. They will trace and capture database metrics, offering recommendations for performance tuning of our queries, probably by running the app and watching the existing queries hitting the database. They will manage and configure the change data capture (CDC) processes, used to audit data within SQL Server. They will also setup and advise the team on database availability groups and mirroring that is required to support high tier applications, and the corresponding reporting processes that will hit the mirrored databases for disaster recovery. They will help define and communicate support plans related to these items. This DBA should be familiar with project management methodologies.

They will physically assist with setting up and coordinating our parallel system cutover plans, disaster recovery plans, and enterprise tiering requirements. The DBA will review all the SQL hitting the database, especially complex SQL generated by Entity Framework. The candidate will work closely with the lead DBA to highlight risk areas where database code may need to be adjusted due to complexity and could cause difficult future support situations. This DBA should be well experienced and familiar with enterprise systems supporting both OLTP and OLAP applications and tools.

SKILLS:

Required:

• 5 years Microsoft SQL Server experience in a production DBA support role, ideally supporting production enterprise systems with COTS applications and heavy custom coded components.
• 5 database deployment planning, including both infrastructure and database management approaches for deploying critical applications on SQL Server. Experience documenting such efforts is also required.
• 5 years tuning and rewriting SQL queries (T-Sql)
• 5 years migrating databases across various environments to support the SDLC
• 3 years upgrading Microsoft SQL Server (2014, 2016, 2017, 2019)
• 2 years SQL Server change data capture experience
• 2 years supporting SQL Server always on, Availability groups, and database mirroring
• Experience with Agile methodology and tools such as JIRA
• Experience with Waterfall methodology

Additional Competency Qualifications:

• Being self-motivated, curious, and passionate about helping to make a project successful
• Excellent communication and interpersonal skills.
• Team oriented and collaborative.
• Quick learning and self-managing.

Nice to have skills:

• Familiarity with Oracle
• Experience with Microsoft Entity Framework and Code First approach.
• Experience working across many teams to deliver complex technical software in a large organization
• Being self-motivated, curious, and passionate about architecting solutions that are flexible and scalable.
• Ability to effectively present information and respond to questions from Business and IT Groups
• Ability to define problems, collect data, establish facts, and draw valid conclusions
• Ability to prepare status reports and provide status of project in daily stand-up meetings

#LI

Southern Company (NYSE: SO) is America's premier energy company, with 46,000 megawatts of generating capacity and 1,500 billion cubic feet of combined natural gas consumption and throughput volume serving 9 million customers through its subsidiaries . The company provides clean, safe, reliable and affordable energy through electric operating companies in four states, natural gas distribution companies in seven states, a competitive generation company serving wholesale customers across America and a nationally recognized provider of customized energy solutions, as well as fiber optics and wireless communications . Southern Company brands are known for excellent customer service, high reliability and affordable prices that are below the national average. Through an industry-leading commitment to innovation, Southern Company and its subsidiaries are inventing America's energy future by developing the full portfolio of energy resources, including carbon-free nuclear, 21st century coal, natural gas, renewables and energy efficiency, and creating new products and services for the benefit of customers. Southern Company has been named by the U.S. Department of Defense and G.I. Jobs magazine as a top military employer, recognized among the Top 50 Companies for Diversity by DiversityInc, listed by Black Enterprise magazine as one of the 40 Best Companies for Diversity and designated a Top Employer for Hispanics by Hispanic Network. The company has earned a National Award of Nuclear Science and History from the National Atomic Museum Foundation for its leadership and commitment to nuclear development and is continually ranked among the top energy companies in Fortune's annual World's Most Admired Electric and Gas Utility rankings. Visit our website at www.southerncompany.com.

Southern Company is an equal opportunity employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law.

Job Field: Information Technology

Job Type: Standard

Primary Location: Georgia-Metro Atlanta-Atlanta

Operating Company: Southern Company Services

Job Type: Standard

Travel (Up to): Yes, 25 % of the Time

Work Location(s):

Southern Company Gas Headquarters (10Atlanta)

10 Peachtree Place

Atlanta, 30309

Req ID: SCS2011018