SQL Database Administrator - 3688666

New York, NY, US • Posted 15 hours ago • Updated 4 hours ago
Full Time
On-site
USD $65.00 - 70.00 per hour
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • SQL
  • Database Administration
  • Risk Management
  • Analytics
  • Optimization
  • Quality Assurance
  • Microsoft SQL Server
  • Reporting
  • Microsoft Azure
  • Snow Flake Schema
  • Cloud Computing
  • Migration
  • Slowly Changing Dimensions
  • Data Structure
  • Conflict Resolution
  • Problem Solving
  • Database
  • Alteryx
  • Workflow

Summary

Lighthouse Technology Services is partnering with our client to fill their SQL DBA position! This is an 18+ month contract with potential to convert and will be hybrid in Buffalo, NY.

This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.

What You'll Be Doing:

  • Lead data cleanup and remediation efforts for an enterprise-wide risk management database transformation initiative
  • Build and implement robust database structures to support a new cloud-based risk management data product
  • Support the migration of on-premises SQL Server environments to Azure or Snowflake cloud platforms
  • Design and develop large-scale application data schemas optimized for reporting and analytics purposes
  • Execute database engineering tasks including data transformation, structure optimization, and quality assurance
  • Implement slowly changing dimension methodologies to track trends and historical data changes
  • Partner with architects and stakeholders to translate requirements into technical database solutions

What You'll Need to Have:

  • Proven experience with large-scale database transformation and migration projects
  • Strong proficiency in SQL Server for data cleanup, transformation, and database development
  • Solid understanding of data schema design and development for large applications and reporting systems
  • Knowledge of both Azure and Snowflake cloud database platforms and migration strategies
  • Demonstrated ability to work with slowly changing dimensions and temporal data structures
  • Experience building and optimizing databases in complex, enterprise-scale environments
  • Strong problem-solving skills for database remediation and structure improvement initiatives
  • Alteryx experience is a significant plus for data transformation workflows

Pay Range: $65-70/hr

Questions about any of our jobs? Email us at

View all of our open jobs here: jobs.lhtservices.com
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10114206
  • Position Id: d2a2ad5e346ecc03a833351c9355406
  • Posted 15 hours ago
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

New York, New York

•

Today

Full-time

New York, New York

•

Today

Full-time

USD 178,200.00 - 297,000.00 per year

New York, New York

•

Today

Full-time

USD 65.00 - 75.00 per hour

Hybrid in New York, New York

•

25d ago

Easy Apply

Contract, Third Party

Depends on Experience

Search all similar jobs