(Sr.) Database Administrator

Valley Forge
2 weeks ago
Job ID
2017-2946
# Positions
1
Category
Information Technology

General Position Summary

The PJM production database administrator (DBA) is responsible for ensuring the security, availability, integrity, and functionality of PJM's production databases. The production DBA works with the development and application teams to identify optimal physical implementation of the logical model. The production DBA is also responsible for monitoring the production databases and providing support, including problem identification and remediation, as well as performance monitoring. The production DBA will ensure that all changes to production databases are fully tested and are secure against unauthorized access and accidental damage.

The scope of responsibility for the position includes project support, maintenance and support activities, system enhancements and taking steps to keep abreast of the latest technologies.

Essential Duties and Responsibilities

  • Owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.
  • Development and maintenance of master business terms, master definitions and master sources. Support business and IT integration to understand and develop optimized data models for database implementations for business requirements.
  • Actively participate in group discussions to gain consensus on data security classifications
  • Develop queries and scripts against databases and servers to extract data for analysis
  • Analyze current integration architecture including: materialized views/views through db links/flat files, query timings, determining file size and assist in redesigning existing data transfers.
  • Maintain UML models using industry tools
  • Design and build XSDs and WSDLs based on UML model
  • Work effectively as part of a team to accomplish tasks and meet deadlines
  • Establish a sense of urgency to complete tasks in a timely, cost-effective manner with quality
  • Maintain an exceptional level of customer focus and maintain an inspired culture that is time based and centered on integrity and customer focus
  • Build relationships with key PJM personnel to educate them on the IT vision and strategy.
  • Work with infrastructure groups to find and optimize the existing processes and implementations.
  • Provide support to complete all data requests for security and audit requests.
  • Use technical knowledge to suggest improvements in system operations, performance and usage.
  • Work with IT infrastructure and operations to support in implementation of optimized solutions for data management, including backup/recovery, data governance and automation.
  • Build working knowledge of key products that facilitate data management including operating system, storage and new data management solutions.

Characteristics and Qualifications

Required

  • BS, Computer Science or Electrical Engineering
  • At least 5 years of experience leadership/consulting experience
  • Ability to produce high-quality work products with attention to detail
  • Ability to visualize and solve complex problems
  • Experience developing Oracle Stored Procedures/functions/packages
  • Experience in developing applications using Oracle PL/SQL
  • Experience with DBMS concepts (including SQL queries, tables, views, DB links, etc.)
  • Experience with Java-based web development frameworks and technologies including JSF (PrimeFaces or Rich Faces), Struts 2, Spring MVC/WebFlow and component technologies including HTML, JSON/Ajax, CSS and XML


Preferred

  • MBA, Business Administration
  • Experience with PJM operations, markets, and planning functions

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.