Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR.
United States Jobs Expertini

Urgent! ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR Job Opening In New York – Now Hiring City of New York

ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR



Job description

Job Description

The Department of Social Services (DSS) is comprised of the administrative units of the New York City Human Resources Administration (HRA) and the Department of Homeless Services (DHS).

HRA is dedicated to fighting poverty and income inequality by providing New Yorkers in need with essential benefits such as Food Assistance and Emergency Rental Assistance.

DHS is committed to preventing and addressing homelessness in New York City by employing a variety of innovative strategies to help families and individuals successfully exit shelter and return to self-sufficiency as quickly as possible.

Information Technology Services (ITS) is DSS’s technology services organization.

ITS mission is to support the daily, emergent, and long-term needs of both agencies.

ITS creates and enhances the technology infrastructure and computer applications that support HRA and DHS and develops applications, including a variety of client eligibility and recertification systems, case management systems, housing systems, employment/work engagement services, revenue producing computer matches, claiming systems, and personnel systems.

Under the general direction of the Sr. Director, HRA Enterprise Data Warehouse, the EDW Database Administrator / Architect will provide administration, development, design, support, and maintenance of database servers that enable the agency to interface between multiple hardware and software-based systems to deliver critical business solutions in a rapid and agile manner.



Information Technology Services (ITS) is recruiting for one (1) IT Project Specialist, to function as an Enterprise Data Warehouse (EDW) Architect and Database Administrator, who will:

- Implement Oracle 19c database solution for Oracle T5-8 Supercluster Engineered System on Solaris Servers, including installation, administration, configuration, integration, deployment, and design.

- Manage the database design of a very large, read-only RAC database to give business users and programmers across the agency the power to analyze historical, multi-source data quickly and easily.



- Monitor Oracle Enterprise Manager (OEM) for any performance or space-related issues.

Performance tuning of the DB and any SQL queries is essential.



- Be responsible for data warehouse design, complex transformations, integration, mapping, and transporting data to multiple targets.

Experience with various source systems, including mainframe, mapper, OLAP, and flat files.

Strong experience with E-R modeling, modeling with Snowflake schema, slowly changing dimension, data analytics, and system architecture, maintaining Enterprise User Security, synchronizing user credentials between Oracle Internet Directory and Microsoft Active Directory.



- Be familiar with compliance requirements like the Health Insurance Portability and Accountability Act for protecting secure restricted data.

Hours/Shift:

9am-5pm

IT PROJECT SPECIALIST - 95710

Qualifications

1.

A baccalaureate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and four years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

2.

An associate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and six years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

3.

A baccalaureate degree from an accredited college, and eight years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

4.

Education and/or experience which is equivalent to 1, 2, or 3 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 individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Salary Min: $ 75,000.00
Salary Max: $160,000.00


Required Skill Profession

Other General



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your ENTERPRISE DATA Potential: Insight & Career Growth Guide


  • Real-time ENTERPRISE DATA Jobs Trends in New York, United States (Graphical Representation)

    Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for ENTERPRISE DATA in New York, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 53194 jobs in United States and 2270 jobs in New York. This comprehensive analysis highlights market share and opportunities for professionals in ENTERPRISE DATA roles. These dynamic trends provide a better understanding of the job market landscape in these regions.

  • Are You Looking for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR Job?

    Great news! is currently hiring and seeking a ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR to join their team. Feel free to download the job details.

    Wait no longer! Are you also interested in exploring similar jobs? Search now: .

  • The Work Culture

    An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at City of New York adheres to the cultural norms as outlined by Expertini.

    The fundamental ethical values are:
    • 1. Independence
    • 2. Loyalty
    • 3. Impartiality
    • 4. Integrity
    • 5. Accountability
    • 6. Respect for human rights
    • 7. Obeying United States laws and regulations
  • What Is the Average Salary Range for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR Positions?

    The average salary range for a varies, but the pay scale is rated "Standard" in New York. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

  • What Are the Key Qualifications for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR?

    Key qualifications for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR typically include Other General and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.

  • How Can I Improve My Chances of Getting Hired for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR?

    To improve your chances of getting hired for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

  • Interview Tips for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR Job Success
    City of New York interview tips for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR

    Here are some tips to help you prepare for and ace your job interview:

    Before the Interview:
    • Research: Learn about the City of New York's mission, values, products, and the specific job requirements and get further information about
    • Other Openings
    • Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.
    • Dress Professionally: Choose attire appropriate for the company culture.
    • Prepare Questions: Show your interest by having thoughtful questions for the interviewer.
    • Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.
    During the Interview:
    • Be Punctual: Arrive on time to demonstrate professionalism and respect.
    • Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.
    • Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.
    • Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.
    • Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.
    • Follow Up: Send a thank-you email to the interviewer within 24 hours.
    Additional Tips:
    • Be Yourself: Let your personality shine through while maintaining professionalism.
    • Be Honest: Don't exaggerate your skills or experience.
    • Be Positive: Focus on your strengths and accomplishments.
    • Body Language: Maintain good posture, avoid fidgeting, and make eye contact.
    • Turn Off Phone: Avoid distractions during the interview.
    Final Thought:

    To prepare for your ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR interview at City of New York, research the company, understand the job requirements, and practice common interview questions.

    Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the City of New York's products or services and be prepared to discuss how you can contribute to their success.

    By following these tips, you can increase your chances of making a positive impression and landing the job!

  • How to Set Up Job Alerts for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR Positions

    Setting up job alerts for ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!