Database Architect / Database Administrator / Data Engineer

Compunnel, Inc.

Northern, New York (KY, NY)

Hybrid

USD 140,000 - 190,000

Full time

35 hours ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Compunnel, Inc. is seeking an senior Database Architect / DBA / Data Engineer in New York, NY. The role focuses on designing scalable databases, managing diverse data pipelines, and supporting data warehouses and lakes for enterprise analytics.

You will lead data modeling, governance, and performance tuning across transactional and analytical systems while collaborating with cross-functional teams and cybersecurity stakeholders.

Qualifications

10+ years of experience in database administration or database design.
Strong experience with enterprise data integration and analytics.
Advanced proficiency in Microsoft SQL Server.
Experience with data lakes, data warehouses, and ETL.
Experience with Power BI, PowerShell, and Python scripting.
Ability to lead technical initiatives and manage multiple priorities.
Strong verbal and written communication skills.

Responsibilities

Design and maintain enterprise database architectures supporting transactional, analytical, and operational systems.
Develop conceptual, logical, and physical data models based on business and technical requirements.
Establish database standards, governance, and data management best practices.
Design high-availability, disaster recovery, replication, and data resiliency solutions.
Administer Microsoft SQL Server and other enterprise database platforms.
Monitor database health, performance, capacity, and availability.
Perform database tuning, indexing, query optimization, and performance analysis.
Implement database backup, recovery, replication, and access controls.
Troubleshoot production database issues and perform root cause analysis.
Design, develop, and maintain data transformation and load processes and pipelines.
Support data warehousing, data lake, and lakehouse architectures.
Develop data cleansing, transformation, validation, and reconciliation processes.
Support analytics, business intelligence, and reporting initiatives.
Automate data movement and operational tasks using modern engineering practices.
Adhere to data governance, metadata management, and master data management standards.
Ensure data quality, integrity, consistency, and lineage.
Collaborate with cybersecurity and compliance teams to safeguard data assets.
Establish role-based access controls and database auditing standards.
Support regulatory, audit, SOX, and data retention requirements.
Partner with stakeholders, development teams, infrastructure teams, and contractors.
Document database administration activities and current projects.

Job description

New York, New York

09/18/2026

Contract

Active

Job Description

Job Summary

The Database Architect / Database Administrator / Data Engineer is a senior technical role responsible for database architecture, administration, optimization, integration, and data engineering. The role will design and maintain scalable, secure, and highly available database solutions while developing and supporting enterprise data pipelines, integrations, data warehouses, data lakes, and reporting platforms. The position requires a balance of hands‑on technical expertise, operational support, planning, data governance, and cross‑functional collaboration.

Key Responsibilities

Design and maintain enterprise database architectures supporting transactional, analytical, and operational systems
Develop conceptual, logical, and physical data models based on business and technical requirements
Establish database standards, architecture principles, governance frameworks, and data management best practices
Design high-availability, disaster recovery, replication, and data resiliency solutions
Administer Microsoft SQL Server and other enterprise database platforms
Monitor database health, performance, capacity, and availability
Perform database tuning, indexing, query optimization, and performance analysis
Implement database backup, recovery, replication, and access controls
Troubleshoot production database issues and perform root cause analysis
Design, develop, and maintain organization-level data transformation and load processes and data pipelines
Support data warehousing, data lake, and lakehouse architectures
Develop data cleansing, transformation, validation, and reconciliation processes
Support analytics, business intelligence, and reporting initiatives
Automate data movement and operational support processes using modern engineering practices
Adhere to enterprise data governance, metadata management, and master data management standards
Ensure data quality, integrity, consistency, and lineage across systems
Collaborate with cybersecurity and compliance teams to safeguard enterprise data assets
Establish role-based access controls and database auditing standards
Support regulatory, audit, SOX, and data retention requirements
Partner with business stakeholders, application development teams, infrastructure teams, and contractors
Document database administration activities, development environments, current projects, and operational tasks
Facilitate database architecture reviews and technical design sessions
Develop and maintain technical documentation, database standards, and operational procedures for current and future environments

Required Qualifications

10+ years of experience in database administration or database design
5+ years of experience supporting enterprise organizations or large-scale environments
Demonstrated experience with enterprise data integration and analytics
Advanced proficiency in Microsoft SQL Server
Advanced SQL skills, including the ability to develop stored procedures
Strong database architecture and data modeling expertise
Deep understanding of relational databases and data integration patterns
Experience writing SQL scripts for database development and administration
Experience with data lakes, data warehouses, and data warehouse ETL
Experience with SSIS and ETL development
Experience with Power BI
Experience with PowerShell and Python scripting
Strong troubleshooting and analytical skills
Strong understanding of data governance and cybersecurity principles
Ability to lead technical initiatives and manage multiple priorities
Strong verbal and written communication skills, with the ability to communicate technical concepts to technical audiences