Information Technology Specialist 2 (Database Administrator), SG-18

State of New York-posted 3 months ago
$66,951 - $85,138/Yr
Full-time
Albany or NYC, NY
51-100 employees
Executive, Legislative, and Other General Government Support
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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.
  • 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.
  • Strong knowledge of SQL and relational database concepts.
  • Strong knowledge of Linux or other Unix-like environments.
  • Strong knowledge of shell scripting.
  • 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 semester credit hours in computer science and one year of professional experience in information technology; or two years of professional experience in information technology.
  • Public Service Loan Forgiveness (PSLF) eligibility.
  • 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 $9,196.00 Increased Hiring Salary.
Track Jobs with Teal

Job Search Resources

•
Resume Builder
•
Resume Examples
•
Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service