Senior IT Database Analyst

Duke Energy•Huntersville, NC

5d•Hybrid

About The Position

The Database Analyst (also know as Database Administrator or DBA, for short) generally works in the infrastructure side of the IT organization. The Database Analyst is focused on installation and support of database management systems and adhering to best practices within the department while delivering high level of customer service. The database analyst should be a self-motivated individual with good communication skills and able to who work well in a collaborative environment. The DBA role tends toward supporting production, staging and/or quality assurance databases and the availability, access, and security of the associated data assets stored within. In addition, the DBA will consult with IT management and clients to identify and recommend opportunities for better utilization of technologies that could improve business application systems, business area operations, or infrastructure operations as a result of improved database maintenance, database monitoring, database security, database backup, database recovery, database performance, and/or database integrity techniques for production, staging, or quality assurance databases. This individual may also provide the overall technical database expertise and leadership to the development team in delivering before mentioned solutions.

Requirements

Associate's degree in Information Technology
Minimum of 6 years required of related work experience
In lieu of Associate's degree and 6 years of related work experience listed above, High School/GED degree AND 8 years of related work experience

Nice To Haves

Experience with the following: Nuclear Oracle X9M Exadata, GoldenGate, Qlik, CyberArk Password Management
Nuclear applications support and project experience
Experience providing nuclear Oracle X9M Exadata on-call support.
Experience with sequential query language or the equivalent in one or more of the database platforms' native programming language(s). E.g., T-SQL, PL/SQL, Access SQL, Python, etc.
Experience in file structures, design, retrieval, access methods, etc.
Excellent communication skills and inter-personal skills
Strong analytical and problem resolution skills, strong organizational skills, and ability to analyze business problems and opportunities

Responsibilities

Responsible for the creation of physical databases per design documentation as provided by database designers, architects and/or vendors to meet business requirements.
Creation and execution of database backup and recovery processes.
On-going database performance monitoring and tuning.
Performs data optimization and access analysis.
Performs data replication, movement, and/or manipulation to meet business requirements while adhering to enterprise guidelines and standards (or seeking exceptions when appropriate).
Responsible for executing database security and auditing processes.
Responsible for database product installation, configuration, and administration.
Responsible for reporting tools installation, configuration, and administration.
Foundation in database access methods; including RDBMS and OLAP data sources.
Development and execution of SQL report optimization.
Development of data abstraction and metadata layer for end-user interfaces.
Data Analysis report design, creation, execution, and analysis.
Messaging software installation, configuration, and administration.
Knowledge of XML, Java, and database access methods.
Helps develop and support Oracle GoldenGate environments for Duke Energy Nuclear.