Role: SME-SQL Database Administrator Worksite flexibility: Hybrid
Location: Hybrid in New York, NY (Locals ONLY)
Duration: 12 month with possible extension Job Description We are looking for a
Senior SQL Database Administrator for a
12-month+ contract opportunity that is
hybrid in
New York, NY . The ideal candidate will provide services to build and maintain MS SQL-Servers, SSIS, SSAS with the latest version and would have atleast 10 Years experience with recent experience in payments Domain.
What You'll Do - SME (L3 or above only) DBA consultant with ten plus years of experience will provide enterprise services to build, maintain MS SQL-Servers, SSIS, SSAS with latest version. Implement CIS security best practices and automate the build standard. Implement policy management features to leverage the product features to roll out changes seamlessly. Example: SQL 2019 or above.
- Install, upgrade and patch both existing and new database environments and other supporting tools such as SCCM or Ansible based automation.
- Implement alerts through SCOM and OEM monitoring on new build servers environment to automate DBA proactive jobs and actively monitoring.
- Hygiene best practice implementation, SDLC, change control best practices. Consultant will participate 24X7 production database support (Rota based) as required.
- Consultant must provide technical documentation of the work including all scripts and commands applicable in a standard word format. Perform general troubleshooting on all database-related issues and documenting solution steps.
- Partnership with application development, production support teams and Implement changes to the production environment CAB based change management guidelines and approval. Non-Production will be approved SNOW- SR based. He/She will be working with various CAPEX or OPEX type of projects tasks and update the project managers on a daily basis.
- Candidate should have experience independently on complex projects and at the same time possessing excellent team skills to be able to collaborate with various infrastructure groups
- Understanding of current support processes, definition of the to-be processes and gap analysis
- Partnering with IT-Risk, CISO organization for planning and implementing security initiatives, performing vulnerability assessments, patch management, anti-virus management. Having knowledge of Qualys Scan is preferred.
- Establishing process for maintaining sound backups for all database environments. Such as SQL Server Full, Differential, Log backups automation
- Proactively monitor the SQL production databases and ensure alerts are provided when they occur, take corrective action to resolve these issues, and alert the IT management team of the issue.
- Consultant will follow the SDLC policies and implement such policies and procedures to mitigate future risks.
- Review, hardening and securing the current databases as per CIS standards. Provide guidance for securing databases which store sensitive and/or restricted data
- Implementing database security controls via CyberArk to prevent data loss/leakage or unauthorized access to databases. Manage/Enhance Database Engine Security Configuration.
- Identify root cause analysis ("RCA") of performance issues and recommend the best possible solutions. Conduct RCAs for recurring production Database Administration related problems and automation is the Key.