Vacancy expired!
- 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.
- 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!