Database Architects

Job Title: Database Architects
Location: Hackensack, NJ
Employer: 4Consulting, Inc
Position Type: Full Time
Worksite: Hybrid

Position Summary

4Consulting, Inc is seeking a qualified Database Architects to support technology consulting, application development, systems analysis, testing, data management, cybersecurity, infrastructure, or project delivery services for client projects. The selected candidate will perform duties consistent with the client’s project requirements and company delivery standards.

Essential Duties and Responsibilities

The candidate will be responsible for:

Lead onshore and offshore development and production support teams through sprint planning, code reviews, release readiness, incident management, and technical delivery, ensuring consistent development practices and operational reliability.

Design and optimize PostgreSQL data warehouse architecture, including dimensional models, data structures, partitioning strategies, analytical reporting layers, and database performance standards.

Develop and maintain complex PL/pgSQL procedures, functions, and high-volume ETL/ELT pipelines while implementing data transformations, reconciliation processes, logging, and performance optimization strategies.

Own data quality and production issue resolution by investigating upstream data failures, schema changes, and downstream reporting impacts; implement root-cause fixes, proactive monitoring, and preventive controls while communicating risks and status to stakeholders.

Minimum Qualifications

The position requires:

Education:

Bachelor’s degree in Computer Science, Information Technology, Engineering, Business, or related field, or equivalent combination of education and experience.

Experience:

10+ years of experience in PostgreSQL database development, data warehouse architecture, advanced SQL, performance tuning, ETL/ELT development, and production support, including hands-on technical leadership of distributed development and operations teams.

Technical Skills:

PostgreSQL, PL/pgSQL, Advanced SQL, Data Warehousing, ETL/ELT, Database Performance Tuning, Data Modeling, High Availability and Disaster Recovery, Database Security, Production Support

Business / Domain Skills:

Experience designing and supporting enterprise data warehouse and analytical reporting environments, including reporting datasets, aggregated data structures, business intelligence extracts, and downstream analytical workflows.

Experience managing end-to-end data processing and reporting operations, including data reconciliation, data quality controls, incremental data loads, source-data changes, and resolution of upstream and downstream data issues.

Experience translating business reporting requirements into data models, analytical datasets, reporting solutions, and operational controls that support reliable and consistent business decision-making.

Experience leading distributed technical teams, coordinating production support, managing release readiness, and collaborating with business stakeholders to prioritize issues, communicate risks, and maintain critical data services.

Communication:

Ability to communicate with technical and business stakeholders.

Documentation:

Ability to prepare project documentation, status updates, and deliverables.

Work Authorization:

Must be legally authorized to work in the United States. Sponsorship may be considered where permitted by company policy and project requirements.

Certification Required

None

Travel Required

None

Supervisory Role

No

Preferred Qualifications

Expert knowledge of PostgreSQL internals, query optimization, indexing, partitioning, database extensions, replication, backup and recovery, and database security controls.

Experience with cloud-managed PostgreSQL platforms, database migration initiatives, data orchestration frameworks, monitoring solutions, and high-availability architectures.

Strong technical leadership, stakeholder management, troubleshooting, and communication skills, with a calm, accountable approach to production incidents and cross-team problem resolution.

Equal Employment Opportunity Statement

4Consulting, Inc is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, citizenship status, immigration status where protected by law, or any other legally protected status. All candidates will be evaluated based on job-related qualifications, experience, skills, availability, and ability to perform the essential duties of the position.