Urgent Requirement || Senior SQL Server DBA || NYC (Hybrid) || 6+ months at NYC, New York, USA |
Email: [email protected] |
From: Suraj Prashar, Pivotal [email protected] Reply to: [email protected] Hi, Hope you are doing great!! Please find the requirement below, If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number (703) 570-8775 * (Ext. 232). Job Title: Senior SQL Server DBA Location: NYC (Hybrid) Duration: 6+ months Visa Type- USC/GC/GCEAD/H4EAD Job Description:- Duties: Job Mission: The Senior SQL Server DBA position will be responsible for maintaining the company's SQL Server database systems ensuring resiliency, uptime, HA/DR, performance, capacity planning, overall monitoring, and documentation. This Senior SQL Server DBA role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, a focus on managing and resolving issues in alignment with SLAs, establishing and maintaining communication with stakeholders to keep them updated with status of their requests, initiating, and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. Skills: 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. Experience with SQL Server encryption technologies (TDE, column-level encryption, Always Encrypted). Keywords: database green card |
[email protected] View all |
Wed Jul 26 23:29:00 UTC 2023 |