Information Technology Specialist 2 (Database Administrator), SG-18 - StateJobsNY : Job Details

The New York State Department of Financial Services seeks to build an equitable, transparent, and resilient financial system that benefits individuals and supports business. Through engagement, data-driven regulation and policy, and operational excellence, the Department and its employees are responsible for empowering consumers and protecting them from financial harm; ensuring the health of the entities we regulate; driving economic growth in New York through responsible innovation; and preserving the stability of the global financial system.

The Department of Financial Services is seeking candidates for the position of Information Technology Specialist 2 (Database Administrator) in The Technology Bureau. Duties include, but are not limited to, the following:

• Works in a gatekeeper capacity to protect our Oracle environment by careful reviewing of all incoming requests from app teams, etc.
• Reviews all alerts daily, including logging-into the server(s) and thoroughly pro-actively reviewing various logs, performance metrics, etc, and taking appropriate remedial action where necessary.
• Performs Oracle system administration activities and hardware support such as system racking and stacking, cabling, component replacement, etc.
• Installs, configures, patches, upgrades, and maintains Oracle Enterprise Manager (OEM), Oracle operating systems, firmware, clusterware, Oracle databases, APEX (database tier only), Oracle middleware such as BI Publisher (used with APEX)
• Utilizes Oracle Enterprise Manager (OEM) to pro-actively detect issues making use of advanced features such as metric extensions, monitoring templates, etc.
• Handles server and/or database crashes, performance issues, etc.
• Carefully documents all processes and keeps refining those processes on an ongoing basis.
• Works with application and helpdesk teams on keeping server and client-side Oracle drivers up-to-date.
• Effectively works with Oracle Support and their support portal, including understanding how their portal integrates with hardware assets, ASR fault monitoring, etc, and maintaining those functionalities.
• Understands Oracle licensing and work to keep us in compliance with licensing agreements, including conducting occasional informal audits to ensure we are in compliance.
• Works with higher-level specialists on Oracle-related purchasing to understand the process and Oracle-related hardware, server, and database architecture, design, planning, etc.

Preferred Qualifications:

• Bachelor's degree in computer science or a related field with at least 3 credit hours in a database and/or operating systems related course; or Bachelor's degree in computer science or a related field with at least 1 year of professional experience in database administration and/or systems administration and Strong knowledge of SQL and relational database concepts, Strong knowledge of, Linux or other Unix-like environments, and Strong knowledge of shell scripting.

Minimum Qualifications:

• One year of the service of permanent competitive, non-competitive NY Helps, or 55-b/55-c service as an Information Technology Specialist 1 or Information Technology Specialist 1 (Programming).
• A bachelor's or higher-level degree including or supplemented by 15 semester credit hours in computer science; or a bachelor's or higher-level degree in any field and one year of experience in information technology; or 60 semester credit hours including or supplemented by 15 semesster credit hours in computer science and one year of professional experience in information technology; or two years of professional experience in information technology.

Salary: $66,951 $85,138

Positions located within the New York City metropolitan area, as well as Suffolk, Nassau, Rockland, and Westchester Counties, are also eligible to receive an additional $4,000 annual downstate adjustment. Positions located in the New York City metropolitan area, as well as the Mid-Hudson region, are eligible to receive an additional $9196.00 Increased Hiring Salary.

Appointment Status: Permanent or Contingent-Permanent

Some positions may require additional credentials or a background check to verify your identity.

Department, location, job_id, requisition_id, and other hanging information have been removed.