Job ID: JOB_ID_10850
Project Overview:
NYC DSS is undertaking a large-scale Data Center Co-location and Migration Project to modernize its IT infrastructure. Approximately 90% of current data center infrastructure is reaching End-of-Life (EOL) / End-of-Support (EOS). This project involves migration from 15 MetroTech Center to 11 MetroTech (Brooklyn, NY) and consolidation of multiple data centers into a single co-location facility. The focus is on infrastructure modernization, risk mitigation, and improving system reliability and performance. This project is critical to DSS operations, supporting applications used for public assistance, housing and shelter services, and benefits distribution systems.
Role: Enterprise Data Warehouse (EDW) Architect
We are seeking an experienced EDW Architect to play a key role in this critical modernization project. The ideal candidate will have extensive experience in data modeling, data administration, data security, performance monitoring, and database design, with a strong emphasis on Data Warehouse Architecture, DB Administration, and ETL processes.
Key Responsibilities:
- Lead the design and architecture of the Enterprise Data Warehouse, ensuring scalability, reliability, and performance.
- Oversee data modeling, data administration, data security, and integrity for the EDW.
- Manage performance monitoring and optimize database operations.
- Design logical and physical databases for the EDW.
- Implement and manage system upgrades, patching, Disaster Recovery, and Migration on Engineered Systems.
- Design LDOM, ZONES in an Engineered System.
- Perform migration, patching, upgrading, and recovery of Oracle Database.
- Administer WebLogic/OBIEE and Fusion Middleware.
- Design high-redundancy grid disks on Exadata using ZFS file system.
- Implement SSO using OAM and integrate OID with Active Directory, Security groups, and roles.
- Develop and manage OBIEE 12c, Oracle Portal, Reports server, and related development.
- Ensure strong working and technical knowledge of data migration, data integration, performance tuning, ETL tools (ODI, OWB), and File transfer.
- Manage UNIX/Linux operating systems, including Scheduler, scripting, and Cron jobs.
- Collaborate with cross-functional teams to ensure the EDW meets business requirements.
- Ensure compliance with data governance and security policies.
Required Skills and Experience:
- 8+ years of experience in data modeling, data administration, data security and integrity, performance monitoring, and logical and physical database design.
- Strong knowledge of Data Warehouse Architecture, DB Administration, and ETL.
- Strong knowledge of system upgrades, patching, Disaster Recovery, and Migration on Engineered Systems.
- Strong knowledge of designing LDOM, ZONES in an Engineered System.
- Experience in Migration, patching, upgrading, and recovery of Oracle Database.
- Familiar with WebLogic/OBIEE and Fusion Middleware Administration.
- Strong exposure of ZFS file system, designing high-redundancy grid disks on Exadata.
- Well-versed with SSO using OAM, integration of OID with Active Directory, Security groups, and roles.
- Exposure to OBIEE 12c, Oracle Portal, Reports server, and development.
- Strong Working & technical knowledge of data migration, data integration, performance tuning, ETL tools(ODI, OWB), and File transfer.
- Knowledge of UNIX/Linux operating systems and Scheduler, scripting, and Cron jobs.
Technical Tools and Technologies:
- Oracle Toolset: AWS Oracle RDS custom, Oracle RDBMS, Oracle ASM, Oracle Cloud Control, Oracle Data Guard, Oracle RMAN, Oracle Grid Infrastructure, Oracle Clusterware, Oracle RAC, Oracle ASM, Oracle RAT, OCFS, OCFS2.
- Data Replication: Oracle Golden Gate
- Development Languages/Tools/Frameworks: SQL, PL/SQL, Python, Java, Perl, Shell Scripting, Java Script, Oracle LogMiner, Toad, SQL Developer, PL/SQL Developer.
- Access Control: SSO using OAM, integration of OID with Windows AD
- Operating Systems: Linux, Unix (SUN Solaris), Microsoft Windows.
- Tools: OWB, ODI, OBIEE, Oracle Portal, Oracle Report Server, WebLogic, FMW
- Experience with: ZFS file system, LDOM, ZONES
Special Requirements
MUST have State & Federal Exp, Onsite, Both Web Cam and In Person Interview
Compensation & Location
Salary: $120,000 – $150,000 per year (Estimated)
Location: Brooklyn, NY
Recruiter / Company – Contact Information
Email: 28suman@gmail.com
Recruiter Notice:
To remove this job posting, please send an email from
28suman@gmail.com with the subject:
DELETE_JOB_ID_10850