Development DBA

SQL Server database administration and development (SQL Server 2012, 2014, 2016, 2017), T-SQL, Kimball Data Warehouse Concepts
Full Time
Depends on Experience
Work from home not available Travel not required

Job Description

Responsibilities:

  • 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 installation and configuration, upgrades, and patching
  • Manage SQL server privileges and permissions of all database users
  • Perform database rollouts and upgrades across different environments
  • Apply data modelling techniques and generate custom ETL scripts using cdc and SSIS. Translate business requirements into ETL designs and mapping specifications.
  • ETL of data 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. Design, tune and maintain existing ETL processes.
  • Leverage T-SQL and other data querying tools to assist end-users with data analytics
  • SQL job setup and scheduling using SQL Agent, Activebatch, or proprietary DW based job system
  • Setup and manage database high-availability technologies, such as transactional replication, Always-On availability group, log shipping, with focus on transactional replication and Always-On
  • 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

Basic Qualifications:

  • 5+ years of experience in SQL Server database administration and development (SQL Server 2012, 2014, 2016, 2017)
  • Strong experience in logical/physical database designs
  • Excellent troubleshooting skills and ability to apply them under pressure
  • Strong experience in T-SQL development and
  • Experience in working with database and application developers
  • Hands on experience with SQL Server replication
  • Knowledge of Kimball Data Warehousing concepts
  • Experience with SSAS, SSIS and CDC (change data capture)
  • Experience in working with external data feeds via SFTP/Web Services
  • 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

Preferred Qualifications:

  • Experience with windows scripting using Powershell
  • Experience with RedGate SQL tools (SQL source control, SQL compare, SQL data compare, etc)
  • Knowledge of Microsoft Azure cloud-based data technologies
  • Prior work experience in financial sector
Dice Id : 10379290
Position Id : 6148056
Originally Posted : 3 months ago
Have a Job? Post it

Similar Positions

Senior SQL Server DBA
  • Fintech
  • New York, NY
SQL DBA
  • Confidential Company
  • Secaucus, NJ
SQL Server Database Administrator
  • Net2Source Inc.
  • Secaucus, NJ
SQL Server Database Administrator
  • Staffing Solutions USA
  • New York, NY
SQL Server DBA
  • Chenoa Information Services
  • Holmdel, NJ
Sr SQL Server Database Administrator/ Developer
  • The Randy Neuringer Company
  • New York, NY
Senior Financial SQL DBA - Fix Income
  • Recruit Professional Services
  • New York, NY
SQL SERVER DBA
  • OperationIT
  • Hicksville, NY
SQL Server DBA
  • Samiti Technology Inc.
  • Jersey City, NJ
SQL DBA - Database Administrator
  • Norgate Technology Inc
  • Jericho, NY
Database Administrator
  • Pierce Technology Corporation
  • Edison, NJ
IBM DB2 / UDB DBA
  • Alpha Technologies Inc
  • Holmdel, NJ
Senior SQL Server DBA with Cloud exposure
  • V.L.S. Systems, Inc
  • Holmdel, NJ