Title: Database Administrator (DBA)

Location: Atlanta or Birmingham

Department Name: Information Technology, Application Services, Database Services

Purpose: This position interfaces closely with portfolio and business unit developers to design, implement, tune, and troubleshoot database solutions for new development projects, enhancements to existing solutions, and implementation of purchased vendor packages. A DBA ensures that proper creation, support, placement, performance and security are in place for Southern Company data. Significant coordination is required with developers and infrastructure support groups for operating system upgrades, software upgrades, migrations, and hardware replacements.

Education / Experience:

• Degree in Computer Science or a related field required
• In-depth knowledge of DBMS related technologies (specifically SQL Server)

Job Responsibilities:

• Develop and/or implement timely, cost effective, and high quality database solutions
• Perform database maintenance, consisting of:
  • DBMS and related software installs, upgrades and patches (including security patching)
  • Logical and physical database design
  • Structure modifications / schema management
  • Database Reorganizations
  • Space monitoring and management / Capacity planning
  • Performance analysis and tuning (both at SQL and DBMS level)
  • Data integrity checks and cleanup
  • Database backups and recovery
  • Disaster recovery
  • Data loads
  • Coding, maintaining and consulting on database procedures and triggers
  • Troubleshooting DBMS and related problems
  • Participate in on-call duty pager rotation
• Consultation on database issues and tools with internal customers and other IT groups
• Build and maintain relationships with customers, peers, staff and other IT groups
• Provide project activities in compliance with the approved methodologies and standards
• Provide root cause analysis, efficient production support and maintenance / enhancements for existing applications
• Participate in special projects/assignments
• Meet schedules and estimates for assigned tasks
• Demonstrate understanding and application of Southern Style attributes

Job Requirements:

1. Experience with the varied methodologies of upgrading and migrating SQL Server databases and associated security principles. Experience in addressing migration issues including security settings, permission errors, SQL Collations, version syntax, etc.
2. In-depth knowledge of SQL Server (2012, 2014, 2016,2017, 2019).
3. Knowledge of Clustering, Log shipping, Mirroring, and "Always on" a plus.
4. Understanding of database support for Biztalk , Sharepoint or BI (SSIS, SSAS, SSRS) a plus.
5. Experience with database support of System Center (SCCM, SCOM) is a plus.
6. Understanding of typical DBMS SOX controls is a plus.
7. Organization, workload prioritization, and multi-tasking skills are required.
8. Working knowledge of Windows platform including scripting, editors, etc.
9. Working knowledge and understanding of software development technologies, methodologies, and associated tools
10. Working knowledge of application architectures (Web, Client Server, Batch, etc.)
11. Working knowledge of typical IT organization and business units
12. Experience with IDERA SQL Diagnostic Manager is a plus.
13. Experience with the Remedy change management solution is a plus.
14. Working knowledge of typical IT organization and business units
15. Awareness of energy industry trends, opportunities and challenges is a plus.

Competencies:

1. Proven effective communication and interpersonal skills
2. Ability to negotiate and influence others
3. Ability to function independently and as a team member
4. Proven analytical and problem solving skills
5. Ability to lean new approved technologies and apply them
6. Excellent customer service skills
7. Ability to handle multiple assignments and conflicting priorities
8. Ability to quickly establish new, strong interpersonal relationships with customers, peers, and management.
9. Ability to lead small internal projects and initiatives.
10. Ability to document actionable recommendations.
11. Ability to provide planning, guidance and implementation of best practices.
12. Ability to work proactively, take initiative, leverage resources and drive change.
13. Good decision making skills

Reporting Relationship: (Manager, peer, subordinate jobs -- organization structure, organization chart may be attached)

• This position reports to a Supervisor within Database Services

Physical Demands / Work Environment: The physical demands and work environment characteristics described here are representative of those that must be met by an employee and those an employee may encounter while performing essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work is generally sedentary, with no specific need for physical coordination or effort. May require physical effort associated with using the computer to access everyday activities. Tasks do not expose employee to physically unpleasant or hazardous conditions

*** This job description does not, nor is it intended to represent an exhaustive listing of all duties, tasks or responsibilities for the position listed. Based upon individual experience and team work load, responsibilities are assigned in varying degrees.

** An equal opportunity employer. Drug free workplace. M/F/D/V