Hybrid SQL Server DBA

Crossfire is a temporary hiring firm - this role is a contract position with our client:
This position requires an in person interview and in person onboarding in NY, NY.

Job Title: Database Architect / Database Administrator / Data Engineer
Contract Length: Duration until 2/2027 with possible extension
Location: New York, NY
Work Setup: Hybrid

The Database Architect / Database Administrator / Data Engineer is a senior technical role responsible for the design, administration, optimization, integration, and governance of Construction organizations data. This hybrid position combines database architecture, database administration, and data engineering functions to support critical business applications, analytics, initiatives, and digital transformation programs.

The successful candidate will lead the scalable, secure, and highly available database solutions while developing and supporting enterprise data pipelines, integrations, and reporting platforms. The role requires a balance of planning, hands-on technical expertise, operational support, and cross-functional collaboration across many stakeholders.

Database Architect / Database Administrator / Data Engineer Key Responsibilities

Database Architecture

• Design and maintain enterprise database architectures supporting transactional, analytical, and operational systems.
• Develop conceptual, logical, and physical data models to support 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.

Database Administration

• Administer SQL Server and other enterprise database platforms.
• Monitor database health, performance, capacity, and availability.
• Perform database tuning, indexing, query optimization, and performance analysis.
• Implement backup, recovery, replication, and access controls.
• Troubleshoot production issues and perform root cause analysis.

Data Engineering

• Design, develop, and maintain organization level transform and load processes and data pipelines.
• Support data warehousing, data lake, and lakehouse architectures.
• Develop data cleansing, transformation, validation, and reconciliation processes.
• Support the team performing analytics, business intelligence, and reporting initiatives.
• Automate data movement and operational support processes using modern engineering practices.

Data Governance & Security

• Adhere to data governance standards, metadata management, and master data management practices as dictated by enterprise 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 auditing standards.
• Support regulatory, audit, SOX, and data retention teams.

Leadership & Collaboration

• Partner with business stakeholders, application development teams, infrastructure teams, and contractors.
• Documenting database administration, development environments, and current projects and tasks.
• Facilitate database architecture reviews and technical design sessions.
• Develop and maintain technical documentation, standards, and operational procedures for current and future environments.

Database Architect / Database Administrator / Data Engineer Qualifications

Education

• High School, associates Degree, bachelors degree or Equivalent combination of education and experience will be considered.

Experience

• 10+ years of experience in database administration or database design.
• 5+ years supporting enterprise organizations/ large scale companies.
• Demonstrated experience in enterprise data integration and analytics.

Database Architect / Database Administrator / Data Engineer Technical Skills

Database Platforms- Required

• Microsoft SQL Server

Development & Scripting Preferred experience

• VBA
• SQL
• T-SQL
• Python
• PowerShell
• Shell Scripting

Data Engineering & Analytics Preferred experience

• SSIS
• Data Lakes
• Data Warehousing
• ETL (Transform and Load) Development
• Power BI

Infrastructure & Operations Preferred experience

• Performance Tuning
• Disaster Recovery
• Backup and Recovery
• Database Security
• Capacity Planning
• Automation and Monitoring Tools

Database Architect / Database Administrator / Data Engineer Knowledge, Skills, and Abilities preferred experience

• Strong database architecture and data modeling expertise.
• Deep understanding of relational databases and data integration patterns.
• Excellent 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.
• Ability to communicate technical concepts to technical audiences.

Database Architect / Database Administrator / Data Engineer Working Conditions

• Hybrid work arrangement with a combination of onsite and remote work.
• Participation in planned maintenance windows and occasional after-hours support.
• Availability for on-call support during critical production incidents.
• This is a Contract position.: duration until 2/2027 with possible extension: Hybrid - ny, ny

We look forward to reviewing your application!
#tech