StateJobsNY
Information Technology Specialist 2 (Database Administrator), SG-18
StateJobsNY, Albany, New York, us, 12237
Information Technology Specialist 2 (Database Administrator)
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.
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.