Oracle Database Administrator
New York, New York County, New York, 10261, USA
Listed on 2026-06-03
-
IT/Tech
Database Administrator, Data Engineer
Overview
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 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
- Administer Oracle 19c databases across production and non-production environments on AIX/Linux platforms.
- Support Microsoft SQL Server databases as part of the enterprise database environment.
- Perform database installation, configuration, maintenance, patching, upgrades, and troubleshooting.
- Support Oracle RAC environments, including routine administration, monitoring, troubleshooting, and patching activities.
- Perform database refreshes, schema migrations, exports, imports, and data movement activities using Oracle Data Pump and related tools.
- Support application releases, production implementations, database changes, and data fixes in coordination with application development teams and vendors.
- Troubleshoot complex production and non-production database issues, including performance problems, connectivity failures, batch processing issues, backup failures, locking/blocking, space issues, and application/database errors.
- Participate in incident response, root cause analysis, and follow-up activities for database-related issues.
- Maintain technical documentation, operational procedures, scripts, implementation steps, and troubleshooting notes.
- SQL Performance Tuning and Performance Monitoring
- Analyze and tune SQL performance for online, reporting, and batch workloads.
- Review execution plans, indexes, optimizer behavior, wait events, database statistics, resource utilization, and long-running SQL statements.
- Use Oracle performance tools and views such as AWR, ASH, ADDM, SQL Monitor, Oracle Enterprise Manager, and dynamic performance views.
- Identify inefficient SQL, database bottlenecks, resource contention, and application/database performance issues.
- Work with application development teams and vendors to support SQL tuning efforts and permanent performance improvements.
- Monitor database activity to help ensure system response times remain within acceptable levels.
- Review performance trends for peak processing periods, nightly batch cycles, reporting activity, and other high-volume workloads.
- Backup, Recovery, and Disaster Recovery
- Implement, monitor, and troubleshoot RMAN backup and recovery procedures.
- Support enterprise backup and recovery processes using Veritas Net Backup or similar tools.
- Investigate backup failures, recovery issues, archive log problems, and database availability concerns.
- Perform database recovery activities…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).