Role: SQL Server Database Administrator.
Location: NYC, NY. (Onsite).
Contract.
Job Description:
5+ years of hands-on experience as a SQL Server Database Administrator.
Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically SQL Managed Instance, Azure Storage account and Azure security fundamental.
Experience implementing High availability (Always-on).
Strong Knowledge of SQL.
Database technical design, storage configuration, space management, backup and recovery, disaster recovery, troubleshooting.
Development and maintenance of integrated databases and technical assistance in the design of new systems and/or modifications to existing systems including data modeling.
Database programming and the use of stored procedures, triggers, or similar development approaches.
Monitor performance and provide ongoing tuning of databases.
Install new database versions and upgrades.
Support for development, test and production environments.
Develop and maintain database administration procedures and operations to optimize database availability.
Evaluate and solicit feedback on processes to identify areas of improvement for optimizing transactions.
Assist with impact analysis of changes to database objects.