SIGNUP

Job Opportunities

Find jobs near you, whether onsite, hybrid, or remote.
  • Similar Jobs to: Oracle Database Administrator (Infrastructure)
XX
Oracle Database AdministratorNew York City | Jobs • United States
Apply Now
XX

Oracle Database Administrator

New York City | Jobs
  • US
    United States
  • US
    United States
Apply Now

About

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. 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
  • United States

Languages

  • English
Notice for Users

This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.