Database Administrator Developer Sr

American Electric Power•Roanoke, VA

1d•$98,993 - $128,688•Onsite

About The Position

We are looking for a talented and proactive SQL Server Database Administrator (DBA) with a strong background in SQL development and performance tuning, particularly within the utility sector. This position involves a blend of database administration and development responsibilities, focusing on optimizing database performance and supporting application teams in real-time applications, SCADA, and transmission/distribution systems. NOTE: This is an onsite position reporting 5 days in office either at the New Albany OH or Roanoke VA location.

Requirements

Associates Degree in Computer Science, Electrical Engineering, Telecommunications or related Technical field or higher from an accredited college/university or high school diploma and two years related military or electric utility technical experience.
Six (6) years EMS/SCADA experience with associate's degree or eight (8) years of experience with a high school diploma.
Individuals with a bachelor's degree and 4 years of EMS/SCADA experience may be considered for entry into the organization at this level.
In addition to the EMS/SCADA experience noted above, detailed knowledge is required in three other pertinent areas below: Application development Operating System support Computer system administration Database technologies and supportDistribution - can use this job family, need to update language in actual posting to reflect DMS and Distribution and remove EMS and transmission references
Proven experience in installation, configuration, and management of SQL Server (including multiple instances on a single server/VM).
Expertise in performance tuning, index management, and SQL query optimization.
Strong skills in TSQL and PowerShell.

Nice To Haves

Working experience with MongoDB and PostgreSQL.
Background in utility space, real-time applications, SCADA, and transmission/distribution systems is an added advantage.

Responsibilities

Monitor and maintain database health, performance, and security.
Implement and manage database backup and recovery strategies.
Ensure high availability and disaster recovery readiness.
Manage user access and roles, ensuring compliance with data governance and security policies.
Perform audits and vulnerability assessments to maintain security standards.
Analyze and optimize SQL queries and overall database performance.
Identify and resolve bottlenecks in database systems.
Implement indexing, tuning strategies, and partitioning for performance gains.
Resolve platform-related issues and participate in incident response.
Coordinate with vendors for product-related issues, patches, and bug fixes.
Work closely with application developers, system administrators, and business analysts to understand new requirements and recommend high-level direction and approach.
Provide support for development, testing, and production environments.
Develop scripts for monitoring, maintenance, and automation tasks.
Utilize tools like shell scripting, Python, or Perl to automate processes.

Benefits

In addition to a competitive compensation, AEP offers a unique comprehensive benefits package that aims to support and enhance the overall well-being of our employees.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume