SQL Server Database Engineer Remote

SQL Server Database Engineer Remote
Full Time
$75 - 83 per hour

Job Description

job summary:

This is a 100% Remote position!


The DBA/Data Engineer role is responsible for the design, development, implementation, and operational support of CCM's data tier within the Information Technology division


Required Skills - 3-5? 5+ years of experience in SQL Server database administration and development (SQL Server 2012, 2014, 2016, 2017)


? strong experience in logical/physical database designs and T-SQL language


? Demonstrated experience configuring and administering SQL Server platform components including: SSAS, SSIS and CDC (change data capture),


? Hands on experience configuring and administering SQL Server replication.


? Excellent troubleshooting skills and ability to apply them under pressure


? Knowledge of Kimball Data Warehousing concepts


? Knowledge of cloud platform services for ETL/ETL such as Azure Data Factory and Logic Apps


? Experience with administering and using SQL monitoring tools, such as Spotlight 

location: Manhattan, New York

job type: Contract

salary: $75 - 83 per hour

work hours: 8am to 5pm

education: Bachelors

 

responsibilities:

? 5+ years of experience in SQL Server database administration and development (SQL Server 2012, 2014, 2016, 2017)


? strong experience in logical/physical database designs and T-SQL language


? Demonstrated experience configuring and administering SQL Server platform components including: SSAS, SSIS and CDC (change data capture),


? Hands on experience configuring and administering SQL Server replication.


? Excellent troubleshooting skills and ability to apply them under pressure


? Knowledge of Kimball Data Warehousing concepts


? Knowledge of cloud platform services for ETL/ETL such as Azure Data Factory and Logic Apps


? Experience with administering and using SQL monitoring tools, such as Spotlight



Desired skills, responsibilities, experience neededJob Description:


The DBA/Data Engineer role is responsible for the design, development, implementation, and operational support of CCM's data tier within the Information Technology division.


Duties:


? Design, develop, monitor, and performance tune database tables, views, indexes, stored procedures, functions, etc.


? Provide up to 24/7 database support for all SQL Servers, including backup and recovery, database


maintenance, health and performance monitoring, and troubleshoot database related issues


? Perform SQL server DBA tasks such as installation and configuration, upgrades, and patching, database security and user management.


? Apply data modelling techniques and generate custom ETL flows using SQL Server Change Data Capture (CDC) and SSIS.


? Setup and manage database high-availability technologies, such as transactional replication, Always-On availability group, and log shipping


? SQL job setup and scheduling using SQL Agent, ActiveBatch, and proprietary DW based job system


? Translate business requirements into Hybrid and Cloud Native ETL/ELT designs using Azure services such as Azure Data Factory, LogicApps, and Azure Functions.


? Design, develop, tune and maintain existing ETL processes from various sources, including structured (replicated SQL tables, txt/csv/xls, etc), semi-structured (xml, json), and unstructured (doc, pdf) data into fact/Dimension tables.


? Leverage T-SQL and other data querying tools to assist end-users with data analytics


? Performance tuning and optimization for T-SQL queries, stored procedures, SSIS packages, SQL Server and database configurations


? Understand, learn, and become proficient at Cerberus' proprietary data warehouse structure and dataflow, including its data warehouse management (DWM) and reporting (DWR) tools


? Communicate with business users on various data administrative projects and tasks, such as data and


system integration into DW, day-to-day master data management, DW reporting enquiries, etc.


? Provide support and guidance to other software developers and team members on SQL tools, techniques, and best practices


Skills/Qualifications


Required:


? 5+ years of experience in SQL Server database administration and development (SQL Server 2012, 2014,


2016, 2017)


? strong experience in logical/physical database designs and T-SQL language


? Demonstrated experience configuring and administering SQL Server platform components including:


SSAS, SSIS and CDC (change data capture),


? Hands on experience configuring and administering SQL Server replication.


? Excellent troubleshooting skills and ability to apply them under pressure


? Knowledge of Kimball Data Warehousing concepts


? Knowledge of cloud platform services for ETL/ETL such as Azure Data Factory and Logic Apps


? Experience with administering and using SQL monitoring tools, such as Spotlight


? Excellent written and oral communication skills


? Ability to learn and apply new technologies to existing environment


? Ability to perform work with minimal guidance from the other team members


? Willingness to communicate and work with business users and understand their requirements


Desired:


? Experience with windows scripting using PowerShell


? Experience with RedGate SQL tools (SQL source control, SQL compare, SQL data compare, etc.)


? Knowledge of Microsoft Azure services including Azure SQL Databases, Managed SQL, Azure Synapse Analytics, Cosmos DB and Power BI.


? Experience with Hybrid and Native Cloud Data Warehouse environments and cloud migration a big plus


? Prior work experience in financial sector, especially Capital Markets or Asset Management





 

qualifications:


  • Experience level: Experienced
  • Minimum 5 years of experience
  • Education: Bachelors
 

skills:
  • SQL



  • For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.



    Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

    Dice Id : cxsapwma1
    Position Id : 872846
    Originally Posted : 4 months ago
    Have a Job? Post it

    Similar Positions

    Data Engineer - G
    • Next Step Systems
    • New York, NY, USA
    Data Analyst
    • IT-SCIENT
    • Berkeley Heights, NJ, USA
    SQL Database Developer
    • Engage Partners, Inc.
    • New York, NY, USA
    Principal Database Engineer
    • Infinity Consulting Solutions
    • New York, NY, USA
    DATABASE ENGINEER - 1244
    • Montefiore Information Technology
    • Yonkers, NY, USA
    Database Developer
    • Data Processing Resources
    • New York, NY, USA
    Database Administrator
    • Above and Beyond Talent Acquisition, Inc.
    • New York, NY, USA
    ETL Developer
    • MTA New York City Transit
    • New York, NY, USA
    SQL Server Data Engineer
    • Judge Group, Inc.
    • Bridgewater Township, NJ, USA