Oracle Database Administrator

Oracle Database Administrator

FISA-OPA is seeking a highly motivated and experienced Oracle Database Administrator to support the Database Management Team within the Financial Systems division. The selected candidate will be responsible for hands-on database administration, operational support, performance tuning, scripting, backup and recovery, monitoring, and troubleshooting for critical financial applications used by the City of New York. The database environment supports production and non-production systems, including FMS3 Accounting, Vendex, PIP, Debt Management System, IFA, and related applications running on Oracle AIX/Linux platforms and Microsoft SQL Server. The selected candidate will work as a member of the DBA team and will be expected to support mission-critical systems that require a high level of availability, reliability, security, and performance. This is a is not a supervisory or team lead role. The candidate must be able to independently perform assigned technical tasks, work collaboratively with other DBAs and technical teams, communicate clearly, and remain effective in a complex enterprise environment with multiple priorities and stakeholders. The ideal candidate will have strong hands-on experience with Oracle 19c database administration, SQL performance tuning, Unix/Linux shell scripting, RMAN backup and recovery, Data Pump, Oracle patching, monitoring tools, disaster recovery support, and Microsoft SQL Server administration. The candidate should be dependable, technically resourceful, organized, and able to work professionally with individuals across different teams and communication styles. This is a hybrid position requiring both on-site and remote work, based on agency policy, operational needs, and management direction.

Responsibilities

Database Administration and Operational Support

SQL Performance Tuning and Performance Monitoring

Backup, Recovery, and Disaster Recovery

Shell Scripting, Automation, and Job Scheduling

Capacity Planning and Space Management

Security, Monitoring, and Compliance

Team Collaboration and Professional Communication

Required Technical Experience

The preferred candidate should possess hands-on experience in the following areas:

Oracle Database 19c administration in production and non-production environments.

Oracle database administration on open systems platforms, preferably AIX 7.3 and Red Hat Linux 9 or above.

Oracle RAC 19c administration, monitoring, patching, and troubleshooting.

Oracle patch management, including Release Updates, OPatch, datapatch, interim patches, and database upgrade activities.

SQL performance tuning, including execution plan analysis, wait event analysis, AWR, ASH, ADDM, SQL Monitor, indexing strategies, optimizer behavior, and database statistics.

Unix/Linux shell scripting, preferably Korn shell, for database automation and operational support.

RMAN backup and recovery.

Veritas NetBackup or similar enterprise backup and recovery tools.

Oracle Data Pump export/import.

Oracle Enterprise Manager for database monitoring, performance analysis, alerting, and administration.

Microsoft SQL Server administration.

Database monitoring, capacity planning, tablespace management, storage growth analysis, and resource utilization analysis.

Disaster recovery testing and database recovery procedures.

Enterprise workload automation tools, preferably Broadcom d-Series or a similar job scheduling platform.

Troubleshooting complex production issues involving database performance, connectivity, batch processing, backups, storage, security, and application/database interactions.

Preferred Skills

Strong troubleshooting, analytical, and problem-solving skills. Strong SQL tuning and database performance analysis skills. Strong scripting and automation skills. Strong written and verbal communication skills. Ability to work independently while also functioning effectively as part of a technical team. Ability to support multiple database platforms and technologies. Ability to manage assigned work with minimal supervision. Ability to work professionally with technical staff, business users, vendors, auditors, and management. Ability to remain calm and focused during production incidents and high-pressure situations. Ability to document procedures, findings, changes, implementation steps, and troubleshooting results clearly. Strong understanding of production support, change management, incident management, release management, and operational support processes. Ability to participate in 24x7 on-call support, off-hours maintenance, emergency response, and disaster recovery events. Strong attention to detail and commitment to database reliability, availability, performance, and security.

Additional Information P-173 The City of New York offers a comprehensive set of benefits and programs to employees, including health insurance, pension plan, Deferred Compensation Plan (with 457, 401K and Roth IRA options), pre-tax Commuter Benefit program, pre-tax Flexible Spending Accounts programs and more. Additional benefits such as prescription drug coverage, dental benefits, vision care benefits and more are also available through District Council 37 – Local 2627, the union that represents employees in this title