Database Administrator Developer Sr

Overview

SQL Server DBA/developer optimizing utility SCADA databases and supporting real‑time apps.

Key Responsibilities

• database optimization
• automation scripting
• performance monitoring
• backup recovery
• security audits
• vendor coordination

Tasks

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

Requirements

• sql server
• tsql
• powershell
• mongodb
• postgresql
• scada

What You Bring

-Background in utility space, real-time applications, SCADA, and transmission/distribution systems is an added advantage. -Expertise in performance tuning, index management, and SQL query optimization. -Proven experience in installation, configuration, and management of SQL Server (including multiple instances on a single server/VM). -Strong skills in TSQL and PowerShell. -Working experience with MongoDB and PostgreSQL.

People Also Searched For

About American Electric Power

-Powers millions across the United States with a vast electric transmission and distribution network. -Has been a leader in the transformation of the energy sector for over a century. -Focuses on reliable power generation, cutting-edge energy solutions, and a growing commitment to renewables. -Operates one of the largest electricity transmission networks in the U.S., delivering energy to homes, businesses, and industries. -Has a legacy of pioneering innovative technologies and projects to improve grid reliability and energy efficiency. -Is expanding its footprint in the renewable energy sector, including solar and wind power projects that are helping shape the future of energy. -Undertakes large-scale projects such as major power plant construction, infrastructure upgrades, and renewable energy installations, supporting both industrial and residential clients. -Is dedicated to sustainable energy and modernizing grid infrastructure, making it an influential player in the energy transition.

Sector Specialisms