Job Details

ID #46086724
State New York
City Kingscounty
Job type Permanent
Salary USD $75,000 - $150,000 75000 - 150000
Source NYC Dept of Info Technology (DoITT)
Showed 2022-09-29
Date 2022-09-19
Deadline 2022-11-17
Category Et cetera
Create resume

Database Design Engineer

New York, Kingscounty 00000 Kingscounty USA

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.

Qualification Requirements:
  • A BA/BS in computer science, engineering or a related field and 4 years’ experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering;
  • -or-
  • A BA/BS in areas other than computer science and 8 years’ experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering;
  • -or-3.Education and Experience equivalent.

    To Apply

    Please go to www.nyc.gov/jobs/search and search for Job ID #459274 SUBMISSION OF A RESUME IS NOT A GUARANTEE THAT YOU WILL RECEIVE AN INTERVIEWAPPOINTMENTS ARE SUBJECT TO OVERSIGHT APPROVALSVisit us at www.nyc.gov/DoITT

    NOTE: This position is also open to qualified persons with a disability who are eligible for the 55-a Program

    Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

    COVID-19: As of August 2, 2021, all new hires must be vaccinated against the COVID-19 virus, unless they have been granted a reasonable accommodation for religion or disability. If you are offered city employment, this requirement must be met by your date of hire, unless a reasonable accommodation for exemption is received and approved by the hiring agency. The Department of Information Technology & Telecommunications and the City of New York are inclusive equal opportunity employers 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.OTI (DoITT) Participates in E-Verify

    Vacancy expired!

    Subscribe Report job