Oracle Database Administrator

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 NetBackup or similar tools.
• Investigate backup failures, recovery issues, archive log problems, and database availability concerns.
• Perform database recovery activities in production and non-production environments when required.
• Participate in disaster recovery planning, testing, validation, and documentation.
• Support scheduled disaster recovery exercises, including database recovery, verification, troubleshooting, and status updates.
• Assist with improving recovery procedures to help ensure reliability and readiness for mission-critical systems.
• Shell Scripting, Automation, and Job Scheduling
• Develop, maintain, and troubleshoot Unix/Linux shell scripts, preferably Korn shell, used for database administration and operational support.
• Create and enhance scripts for backups, monitoring, refreshes, maintenance, reporting, space management, and database health checks.
• Troubleshoot script failures, job scheduling issues, environment problems, permissions, and datab

Benefits

Additional Information

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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Cityofnewyork? Share your experience