SQL Server DBA (Troy)

CareerBuilder-US in Troy, NY

  • Industry: Information Technology - Data Architect/Analyst/Administrator
  • Type: Full Time
  • $62,820.00 - 148,460.00
position filled

Work Location: Brooklyn NY 11201
Interview: In-person

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:

- Experience in Database Management doing Relational Data modeling.?
- Experience in SQL Server in the setting up and Configuring Microsoft SQL Server on Windows platform.?
- Experience in SQL Server in managing and administering SQL Server database.?
- Experience in SQL Server Backup and Restore Strategy.?
- Experience in data modeling for data warehouse and data mart.?
- Experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)?
- Experience in SQL Server Performance Tuning and Query Optimization.?
- Experience in writing complex Stored Procedure and Functions in T- SQL.?
- Bachelor?s Degree

Associated topics: data analyst, data analytic, data engineer, data scientist, database administrator, erp, hbase, mongo database, mongo database administrator, sql

You may be interested in these similar jobs!
Microsoft SQL Server DBA
eiWorkflow Solutions, LLC in Albany, NY

eiWorkflow Solutions, LLC is a cloud software consulting firm based in Albany, NY. eiWorkflow Solutions, LLC is currently looking for a consultant fo…

Read More
Oracle SQL Server DBA
PRISM IT in Albany, NY

Job title: SQL server DBA Location: Albany, NY JD Experience of Oracle 11g RAC systems; Experience of shell and SQL scripts; Good understanding of RD…

Read More
Database Architect
teksalt in Albany, NY

One of our client is looking for Database Architect in Albany, NY Job Description This position is under COOPlatforms but will be functionally sha…

Read More
.NET Developer (Schenectady)
LATITUDE in Schenectady, NY

Growing Government Contractor looking to add a .NET Developer to there team.Responsibilities: Assist in strategic planning and customer transitions t…

Read More
Senior DevOps Engineer
MATRIX Resources in Troy, NY

Our client in the Troy, NY area is seeking aSenior DevOps Engineer at theirTroy, Ny Location. You will be responsible for managing the Deploy Automat…

Read More
BizTalk Developer or Lead or Architect (Albany)
CBL Solutions in Albany, NY

Job Title: BizTalk Developer or Lead or Architect Location: NYC location Duration: Long Term RESPONSIBILITIES: Microsoft BizTalk Server, including …

Read More
SQL Database Architect-10513
Teczones LLC in Albany, NY

Company Overview:Creating value by bringing together the right people to achieve results is our motto. Our clients and employees say they choose to w…

Read More
Business Analyst (Schenectady)
sigma group in Schenectady, NY

In-Person mandatory 9 years of experience: Proficiency in creating impressive screen designs with interactivity. Proficiency in using tools like i…

Read More
SQL Lead (Clifton Park)
Capital Markets Placement in Clifton Park, NY

The level of expertise are as follows:1 Beginner2 Intermediate3 ExpertResponsibilities1.Deployment (Level 2)a.Deploy SQL scripts, schema changesb.Dep…

Read More
SQL lead (Clifton Park)
Capital Markets Placement in Clifton Park, NY

The level of expertise are as follows:? 1 Beginner? 2 Intermediate? 3 ExpertResponsibilities1. Deployment (Level 2) Associated topics: .net, applicat…

Read More