Senior IT Database Analyst

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.

• 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.

• 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

• 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.