| Senior SQL Server DBA, New York City, NY (Onsite) at York, New York, USA |
| Email: [email protected] |
| From: abhishek, StellentIT [email protected] Reply to: [email protected] Senior SQL Server DBA, New York City, NY 12+ Months Phone + Skype Effectively coordinate and communicate with all stakeholders. Learn relevant business processes and understand data flow, criticality and dependencies. Engage in continuous sizing exercises to forecast growth and work with storage team to ensure adequate storage on all servers. Maintain data integrity and security (manage roles and permissions of database users). Use available toolset (Idera Diagnostic Manager, SQL Sentry, Embarcadero DB/Artisan, etc.) for database tuning. Generate traces, execution plans, identify and resolve performance issues, address deadlocks/contention. Develop HA/DR strategies to meet or exceed application RTO/RPO targets and implement solutions for managing backup and recovery. Support and mentor software developers to drive proper coding practices and assist in the development of complex SQL, tuning of DML and the creation of stored procedures/functions/triggers/etc. Participate in 24x7 on-call rotation to support database environment. Support ancillary systems in the database environment (Delphix, etc.) Innovative approach to work, constantly looking for opportunities to uplift the system to more efficient and effective new technologies. Experience with Azure technologies as they related to the Microsoft Data Platform is preferred. Experience with SQL Server encryption technologies (TDE, column-level encryption, AlwaysEncrypted).Required DATABASE DATABASE ADMINISTRATOR MAINTAIN DATA SQL MS SQL SERVER DATABASE SYSTEMS DATA INTEGRITY CODING DOCUMENTATION MENTOR ENCRYPTION SWITCH CAPACITY EMBARCADERO Keywords: database microsoft New York |
| [email protected] View all |
| Mon Jul 24 21:50:00 UTC 2023 |