Vacancy expired!
The Office of Technology and Innovation (OTI/DoITT) oversees all Citywide technology, privacy, cybersecurity, infrastructure, and telecommunications to ensure the security of, and enhance, City operations and service delivery to New York City's residents, businesses, employees, and visitors. As the City's technology and innovation leader, OTI is responsible for operating, maintaining and securing IT infrastructure and systems that touch every aspect of City life from public safety to human services, from education to economic development crossing the full spectrum of governmental operations.
Job Description:- Install, configure, customize, create, implement, and support Oracle databases in Non-RAC and RAC environments, and software and related tools/products for the database systems at DOITT;
- Implement Grid Infrastructure release 12c & 19c on a Unix/Linux platform;
- Implement ASM cluster Filesystem and maintain it; Add new disks to an ASM disk group;
- Patching grid infrastructure software;
- Implement instance caging;
- Setup/administer Oracle database security environment;
- Carry out DB Performance Tuning;
- Troubleshoot DB problems, working with ORACLE support on problems and questions;
- Schedule RMAN (backup/recovery);
- Configure/Support Active Dataguard and Golden Gate for Oracle Replication;
- Install and configure, customize ORACLE server and clients;
- Schedule, install and configure ORACLE upgrades; install, configure, customize ORACLE related system level software; design, development, and create all database file systems layouts and Oracle databases;
- Monitor software notifications and updates;
- Managing distributed databases and configuring client/server and Web-based environments;
- Provide technical assistance and troubleshooting support to developers;
- Review database design specifications and application coding routines to ensure adherence to best practice methods for database usage;
- Ensure database performance is maintained at optimal levels and is able to support defined business requirements;
- Create/maintain referential integrity relationships/constraints;
- Provide problem diagnosis and resolution; schedule database backups; diagnose and resolve backup failures; configure, analyze application SQL code to do SQL Tuning for performance improvement opportunities;
- Develop/maintain Oracle database operational procedures;
- Utilize Solaris/Linux Administration skills as needed; develop UNIX shell scripts; Automation using ansible; work with the Database team and teams of Unix engineers and administrators to design, build, upgrade and support the necessary Oracle infrastructure to meet the needs of DoITT and supported agencies.
- Work hands on with day to day tasks as well as more extensive projects such as migration and testing and implementing of new features and architectures. Helping team members in case of issues/technical problems;
- Perform special projects and initiatives as assigned.
Vacancy expired!