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 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 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 database connectivity errors.
• Work with the Job Scheduling team to implement and support database backup and maintenance scripts in the enterprise batch schedule.
• Improve automation where appropriate to increase reliability, consistency, and efficiency.

Capacity Planning and Space Management

• Monitor and report on database storage, tablespace utilization, filesystem usage, table growth, index growth, and capacity trends.
• Analyze database growth and provide technical recommendations for additional storage, memory, CPU, and related resources.
• Review database filesystem layouts and provide recommendations to improve performance, stability, and maintainability.
• Monitor memory usage, CPU utilization, I/O activity, and other database resource trends.
• Support capacity planning efforts for production and non-production databases.

Security, Monitoring, and Compliance

• Support database security administration, including users, roles, privileges, auditing, and access-related requests.
• Assist with audit inquiries, compliance reviews, and security remediation activities related to database platforms.
• Configure and support Oracle Enterprise Manager and other monitoring tools for database availability, alerts, performance, backups, and system health.
• Follow established change management, incident management, security, and operational support procedures.
• Maintain awareness of database software versions, vendor support timelines, patching needs, and operational risks.

Team Collaboration and Professional Communication

• Work as a contributing member of the DBA team while independently completing assigned technical work.
• Collaborate professionally with DBAs, application developers, infrastructure teams, security teams, audit staff, job scheduling teams, vendors, and management.
• Communicate technical findings, risks, status updates, and troubleshooting steps clearly and professionally.
• Remain effective in a fast-paced enterprise environment with multiple priorities, deadlines, and personalities.
• Demonstrate reliability, accountability, sound judgment, and a cooperative approach to problem-solving.
• Participate in the DBA 24x7 on-call rotation, including primary and secondary support coverage as assigned.
• Support off-hours maintenance, emergency response, production implementations, and planned system changes as needed.

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.
• Tuning of online, reporting, and batch database workloads.
• 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.

Hours/Shift

35 hours Weekly/Day.

Work Location

5 Manhattan West, NY, NY

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.