SQL Server DBA (Performance Tuning, Query Optimization, Data Modeling, Configuration, Backup, Recovery, Data Warehouse, Data Mart, SSAS, SSRS, T-SQL) in Brooklyn NY

DBA Web Technologies in New York, NY

  • Industry: Information Technology - Data Architect/Analyst/Administrator
  • Type: Part Time
  • $105,230.00 - 148,460.00
position filled
SQL Server DBA (Performance Tuning, Query Optimization, Data Modeling, Configuration, Backup, Recovery, Data Warehouse, Data Mart, SSAS, SSRS, T-SQL) in Brooklyn NY
Position: SQL Server DBA (Performance Tuning, Query Optimization, Data Modeling, Configuration, Backup, Recovery, Data Warehouse, Data Mart, SSAS, SSRS, T-SQL)
Location: Brooklyn, NY (Onsite)
Anticipated Start Date: March 2020
Rate: $60 per hour (As 1099 Contract)
Expected Project Duration: 24 Months - Part-Time (As 1099 Contract)
Interview Format: In person or Skype (if not local candidate)
SKILLS: SQL Server Database Management, Database Administration, Performance Tuning, Query Optimization, Data Modeling, SQL Server Configuration, Backup, Recovery, data warehouse and data mart, SSAS, SSRS, T-SQL
POSITION DESCRIPTION:
Manage requirements gathering and analysis for new and existing projects
Support Microsoft SQL Server 2012/2014/2016 databases across all environments
Support Microsoft SQL Server 2012/2014/2016 replication feature widely used by different applications
Support Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance
Implement and support Microsoft Clustering Services both on the SQL Server and System levels
Install and configure Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers
Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
Create, design, manage and troubleshoot SSIS packages
Monitor and troubleshoot ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools
Maintain error and system maintenance logs
OLAP and OLTP Data modeling with the ERWIN data modeling tool
Support Operational data model and data mapping
Support the development and maintenance of DIIT/STARS data dictionary
Manage and Support DB2 relational system and troubleshoot issues on the DB2 System
Administer DB2 Connect, DB2 Gateway in different ETL set up.

Mandatory Qualifications:
Expert Level: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Desired Qualifications:
84 Months of Experience in Database Management doing Relational Data modeling.
84 Months of Experience in SQL Server in the setting up and Configuring Microsoft SQL Server on Windows platform.
84 Months of Experience in SQL Server in managing and administering SQL Server database.
84 Months of Experience in SQL Server Backup and Restore Strategy.
84 Months of Experience in data modeling for data warehouse and data mart.
84 Months of Experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
84 Months of Experience in SQL Server Performance Tuning and Query Optimization.
84 Months of Experience in writing complex Stored Procedure and Functions in T- SQL.
Bachelor s Degree

====Background Check and Fingerprinting for selected candidate will be performed.
===========================================================
Please click the Apply Now button below to send your resume.
- provided by Dice
Associated topics: data analyst, data analytic, data architect, data integrity, data scientist, database, erp, hbase, mongo database administrator, sybase

You may be interested in these similar jobs!
Datamodeller 7+ years needed@Brooklyn, NY
3A Soft in New York, NY

Responsibilities: 7+ data modeling (conceptual, logical & Physical) Database Management performing installation, configuration, customizati…

Read More
Database Administrator
Softek International in Brooklyn, NY

Technical Requirements: 9 years of experience in the following: Query optimization experience with modification in TSQL queries, removing unnecessary…

Read More
Certified Lead SQL Server DBA Locals to NY/NJ only-Direct Client
InfoPeople in New York, NY

InfoPeople Corporation is currently seeking an Certified Lead SQL Server DBA expertise with our direct client in their NYC location. This is a 12 mon…

Read More
Database Developer - Trading Systems
Randstad in New York, NY

job summary: If you are the best database developer on your team then our industry leading clients need YOU! You can be working closely with traders…

Read More
Database Engineer - Trading Systems
Randstad in New York, NY

Database Engineer - Trading Systems **job details:** + location:New York, NY + salary:$100 per hour + date posted:Tuesday, February 18, 2020 + job …

Read More
database engineer - trading systems
Randstad in New York, NY

job description job summary: If you are the best database developer on your team then our industry leading clients need YOU! You can be workin…

Read More
Datamodeller 7 years neededBrooklyn, NY
3A Soft in New York, NY

Responsibilities: 7 data modeling (conceptual, logical & Physical) Database Management performing installation, configuration, customization, impleme…

Read More
Certified Lead SQL Server DBALocals to NY/NJ only-Direct Client
InfoPeople in New York, NY

InfoPeople Corporation is currently seeking an Certified Lead SQL Server DBA expertise with our direct client in their NYC location. This is a 12 mon…

Read More
SQL server ETL 7+
3ASoftInc in Brooklyn, NY

84+ Months of Experience in Database Management doing Data Modeling 84+ Months of Experience with MS SQL Server in the setting up and configuring Mic…

Read More
SQL DBA / Developer (LOCAL)
iit in New York, NY

Estimated Length: 12 months 9:00 AM to 5:00 PM / Monday through FridayLOCAL onlyRequirementsLead data modeling and database design for application de…

Read More