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 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 Oracle Database 19c administration in production and non-production environments. Oracle database administration on open systems platforms, preferably AIX 7.3 and RedHatLinux9 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 Broadcomd‑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. Minimum Qualifications A baccalaureate degree from an accredited college in computer science, engineering or a related field and four years of satisfactory full‑time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering. A baccalaureate degree from an accredited college and eight years of satisfactory full‑time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering. Education and/or experience which is equivalent to "1" or "2" above. Benefits 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 Council37 – Local2627, the union that represents employees in this title. Work Information Hours/Shift: 35 hours Weekly/Day. Work Location: 5 Manhattan West, NY, NY. Equal Employment Opportunity 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. #J-18808-Ljbffr