Location: Cleveland,OH, USA
Role :SQL Server DBA
Job type :Fulltime
Location : Brooklyn,OH
Roles and responsibilities:
he SQL Database Administrator (DBA) will manage the HNBs various Microsoft SQL Server environments. The successful candidate will be an integral team member in supporting IT Corporate Finance Reporting applications, as well as third party vendor applications. Team collaboration will be key in this role, as the DBA will actively work with other IT and application development teams. The effective administration of SQL Server environment(s) will be performed according to the Companys IT Change Management policies, with key responsibilities further summarized below.
Job Details:
Administer Microsoft SQL Server environment(s) and dependent infrastructure, including deployment, security, clustering, backup, recovery, and disaster recovery planning.
Perform proactive SQL Server performance tuning and optimization.
Project ownership, planning, and implementation as assigned.
Proactively trend SQL Server performance marks, bringing trending concerns & optimization recommendations before management.
Maintain a pulse of emerging SQL Server features and security risks, administering upgrades and patches as deemed appropriate.
Maintain documented SQL Server recovery procedures, exercising such within a controlled test environment to prove viability.
Actively collaborate with application development to; a) Aid in physical & logical database modeling, including database schema, stored procedures, triggers and other related objects, b) Provide functional insight into the likes of SSRS, SSAS, SSIS and emerging features, c) Plan for scalability of SQL Server environment(s)
Provide timely support of SQL Server environment(s), including after hours for those critical SQL Server instances.
Participate in the support of dependent Microsoft servers, enterprise storage and network fabric.
Develop PowerShell scripts to automate routine tasks.
Candidate Requirements:
7+ years administering Microsoft SQL Server environment(s) up to and including v2019 Standard.
5+ years administering performance tuning and optimization of SQL Server environments.
Working knowledge of Microsoft SQL Server SSRS, SSAS, SSIS and SQL Server Failover Clusters.
Knowledge of Microsoft OS, clustering, enterprise storage and network fabric.
Strong analytical and troubleshooting skills.
Strong written and verbal communication.
Experience with Kerberos authentication, delegation, and associated certificate management.
Experience with automated backup & recovery solutions; Veeam, Avamar, etc.
Experience in physical & logical database modeling, including database schema, stored procedures, triggers.
Knowledge of SQL Server and NOSQL databases and security in the Azure environment.
Transparent Data Encryption within SQL Server.
Over 3+ years of experience creating, updating and maintaining systems documentation.
Thanks & Regards,
Sweety Singh
Tata Consultancy Services
Mail: ...@tcs.com
Website: