Vacancy caducado!
SQL Server DBA6+ months project onsite in Brooklyn NY Ideal candidate will have more than 10 years relevant experience
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.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, MSExperience with backups, restores and recovery models.Vacancy caducado!