Senior Oracle Database Administrator

Job Description

FISA-OPA is seeking a highly motivated and experienced Senior 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 senior-level technical position and 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 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


To Apply

Applicants may visit the Jobs NYC website: and apply to Job ID: 780021. While all complete applications will be given consideration only candidates selected for an interview will be contacted.

Hours/Shift

35 hours Weekly/Day.

Work Location

5 Manhattan West NY NY

SENIOR IT ARCHITECT - 95711

Qualifications :

1. A baccalaureate degree from an accredited college in computer science information systems engineering mathematics or related field and six years of satisfactory full-time experience related to enterprise architecture solutions architecture network architecture and/or IT infrastructure systems; or

2. A baccalaureate degree from an accredited college and ten years of satisfactory full-time experience related to enterprise architecture solutions architecture network architecture and/or IT infrastructure systems; or

3. Education and/or experience which is equivalent to 1 or 2 above.

Additional Information :

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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work :

No

Employment Type :

Full-time