Job Details

ID #46211943
State New York
City Brooklyn
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Svam International, Inc.
Showed 2022-10-04
Date 2022-09-27
Deadline 2022-11-25
Category Et cetera
Create resume

Sr. SQL Server Developer/DBA required for a long term project at Brooklyn, NY

New York, Brooklyn, 11203 Brooklyn USA

Vacancy expired!

We are trying to

source Sr. Sql Server Developer/DBA for our direct client at Brooklyn, NY. We need a Sr. Developer with strong background in SQL Server 2012 and 2014, Access, backups, restores and recovery models.

It will be a Long-Term Project based at Brooklyn, NY

Tasks:
  • Implement conceptual design to physical database implementation, enhance and refine the logical design of the database.
  • Monitors and manages SQL Servers and databases on a day-to-day basis; develops database designs, stored procedures, triggers, and constraints for new applications in MS SQL Server based on client standards.
  • Provides day to day advice to users on data structures and terminology and develops policies and procedures related to the support and maintenance of database applications.
  • Monitor databases for optimal performance and acts to mitigate blocking and performance tuning issues.
  • Provide guidance to Application Development staff for query, stored procedures, functions, and database design.
  • Baseline system performance and monitor for deviation, recommending and implementing improvements to slow running queries.
  • Document database architecture, configuration settings, baseline performance metrics and planned and unplanned outages.
  • Establishes and implements best practices regarding data definition, data quality, data security, and data integration.
  • Performs database administration duties, including installation, patching, backup and recovery management, space management, schema management, startup, and shutdown.
  • SQL Server Database Administrators with Clustering, High Availability, SQL Installation, SQL Configuration, Replication, SQL Server Monitoring, Database Backup/Restore, Disaster Recovery, Index Tuning experience

Skills:
  • Technical expertise in writing optimal T-SQL queries, stored procedures, User defined functions and views.
  • In depth knowledge and hands-on experience developing, deploying, and maintaining complex SSIS packages.
  • Through understanding of database maintenance practices, including index management, backup strategies and disk space requirements.
  • Knowledge of Microsoft systems, i.e., Windows 2012, 2019, IIS, SQL Server 2012 and 2014, Access, MS.
  • Experience with backups, restores and recovery models.

Vacancy expired!

Subscribe Report job