Senior Oracle Database Administrator

The New York Independent System Operator (NYISO) manages the efficient flow of electricity on more than 11,000 circuit-miles of high-voltage transmission lines, dispatching power from hundreds of generating units across the state.

The New York Independent System Operator (NYISO) applies cutting-edge technology to operating a reliable electricity system, managing competitive markets for wholesale electricity, and planning for the Empire State's energy future.  The NYISO’s Information Technology department invites applications for a full-time Senior Database Administrator to join our Information Technology Team.

The Senior Database Administrator architects, manages and administers Oracle and Microsoft SQL Server databases. The Senior Database Administrator is responsible for database architecture, design and implementation, database installation, upgrades, patching, integrity, security, capacity planning, scripting, disaster recovery, and performance tuning, develops, maintains, adheres to and enforces database administration and user standards and procedures. The Senior Database Administrator leads or participates on project teams and collaborates with application developers and infrastructure to modify database structures as necessary, manages and maintains database storage requirements, and performs database backup and restoration procedures. This individual leads and/or supports audit efforts and ensures compliance with corporate and regulatory standards, mentors and trains associate and database administrators. The Senior Database Administrator provides database expertise in strategic IT planning, establishes and maintains working relationships with IT partners, business customers, and vendors and creates and maintains technical documentation

ESSENTIAL DUTIES and RESPONSIBILITIES

• Performs advanced and/or highly complex work with minimal or no supervision. Establishes work plan for department based on organizational goals; sets independent objectives to accomplish specific tasks supporting the larger plan. 
• Leads functional or virtual departmental or inter-departmental teams and demonstrates accountability for completion of team-wide objectives. Acts as key contributor and represents team for larger organizational teams; regularly interacts with peer departments, business partners, market participants, vendors, and other external constituents. 
• Demonstrates the highest proficiency with assigned technology platforms and disciplines; has broad knowledge of ancillary information technologies, methodologies and platforms.  Has broad knowledge of IT service management, governance, continuity, financial, project, and lifecycle management.  Has basic understanding of the energy vertical, energy markets, the electric industry, and the NYISO’s business & operations. 
• Installs and maintains new versions and patch upgrades of Oracle and Microsoft SQL Server database software.
• Monitors and maintains security and performance needs of all development, test, and production relational databases.
• Performs on-going performance tuning and resource optimization.
• Architects, tests, implements and supports database architectures and configurations, and database management technologies.
• Architects, tests, implements and supports automation of database management.
• In partnership with other subject matter experts and our Business Continuity department, design, test and implement complex solutions that support high availability and inter-site and intra-site fail over capabilities. This includes a monthly review of recovery plans and yearly testing for cyber infrastructure protection (CIP) assets.
• Develops, manages, maintains and tests database backup and recovery plans.
• Leads and participates in capacity planning and lifecycle management required to create and maintain relational databases.
• Provisions and controls database user permissions and privileges with strict adherence to access guidelines following SOC1 and CIP standards.
• Due to the significance of the industry and the organization’s role within it, a rigorous change management process must be adhered to in order to minimize risks to the computing environment.  Must demonstrate adherence to these processes. Subject matter experts are expected to champion their changes from initiation through deployment.
• Provides technical support to software development, infrastructure, IT operations and inter-departmental teams; assists with impact analysis of any changes made to database objects; ensures software development meets established database standards; leads project teams where appropriate.
• Participates in and/or leads in-depth troubleshooting and root cause analysis in inter-disciplinary teams.
• Designs and maintains database systems to adhere to all established NYISO and regulato