Frontend Arts
MS SQL DBA
Frontend Arts, Charlotte, North Carolina, United States, 28245
1) Core skill sets Hiring Manager is looking for:
•Microsoft certified SQL Server consultant with experience in MS SQL Server 2019/2017/2014/2012
2) Detail level of technologies:
•Extensive experience in managing both standalone and Replication, clustered and Always on Environment.
•Experience in upgrading SQL Server databases SQL 2012, 2014, 2016 to 2019 and setting up failover cluster.
•Expertise in core DBA (Database Administrator) tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing.
•Installing and Configuring SSRS (SQL Server Reporting Services) in SQL Server 2016 and 2019.
•Expert level experience on Data Center Migrations and Server Consolidation.
•Proven experience in maintenance of SQL Server in a VLDB environment (Database's size1.5 to 2TB) &experience in troubleshooting and resolving problems.
•Extensive experience in managing MS SQL Server on Windows and 2008, 2016 Servers.
•Must have experience in using DMVs, DMFs monitoring, and troubleshooting performance issues.
•Working experience with tools like SQL Profiler, Windows Permanence and Redagate for Monitoring and Tuning MS SQL Server Performance
•Experience in performing Database Integrity Checks, Database Maintenance plans, update Database Statistics and perform Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
•Extensive Experience in RED Gate Installation and configuration on Prod servers
Key Skills:
# MS SQL server , # DBA , # DB Admin , # core DBA , # SSRS installing , # Data center migration , # VLDB , # DMV , # DMF , # RED Gate
Minimum Experience :
10 YrsRoles & Responsibilities:
Scope of work that they will be supporting.
•Maintaining SQL server 2016 and 2019 Always on Cluster and standalone servers.
•Monitoring Replication performance and maintaining replication on Production servers and lower environments.
•Creating task scheduler jobs and monitoring logs of production jobs.
•Working on performing Database Integrity Checks, Database Maintenance plans, update Database Statistics and perform Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
•Monitoring Redgate alerts and resolve if there are any blockings, server waits or long running queries.
•Monitor windows cluster logs and identify if there are any issues.
•Working on ServiceNow tickets to resolve user access issues or data copy requests from one environment to another through Red Gate Schema compare and Data compare tools.
•Maintaining Security on database servers through SECURE.
•Production deployments support after business hours.
•Resolve any performance slowness issues in production and stage environments.
•Create and maintain reports on performance and growth of databases in production
•Set up alerts and notifications if there are any login failures and if there are any replication job failures.
•Maintain indexes and resolve slowness issues.
Education:
A Bachelor's degree in engineering or computer science, or a Bachelor's degree with significant work experience in technology Industry
•Microsoft certified SQL Server consultant with experience in MS SQL Server 2019/2017/2014/2012
2) Detail level of technologies:
•Extensive experience in managing both standalone and Replication, clustered and Always on Environment.
•Experience in upgrading SQL Server databases SQL 2012, 2014, 2016 to 2019 and setting up failover cluster.
•Expertise in core DBA (Database Administrator) tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing.
•Installing and Configuring SSRS (SQL Server Reporting Services) in SQL Server 2016 and 2019.
•Expert level experience on Data Center Migrations and Server Consolidation.
•Proven experience in maintenance of SQL Server in a VLDB environment (Database's size1.5 to 2TB) &experience in troubleshooting and resolving problems.
•Extensive experience in managing MS SQL Server on Windows and 2008, 2016 Servers.
•Must have experience in using DMVs, DMFs monitoring, and troubleshooting performance issues.
•Working experience with tools like SQL Profiler, Windows Permanence and Redagate for Monitoring and Tuning MS SQL Server Performance
•Experience in performing Database Integrity Checks, Database Maintenance plans, update Database Statistics and perform Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
•Extensive Experience in RED Gate Installation and configuration on Prod servers
Key Skills:
# MS SQL server , # DBA , # DB Admin , # core DBA , # SSRS installing , # Data center migration , # VLDB , # DMV , # DMF , # RED Gate
Minimum Experience :
10 YrsRoles & Responsibilities:
Scope of work that they will be supporting.
•Maintaining SQL server 2016 and 2019 Always on Cluster and standalone servers.
•Monitoring Replication performance and maintaining replication on Production servers and lower environments.
•Creating task scheduler jobs and monitoring logs of production jobs.
•Working on performing Database Integrity Checks, Database Maintenance plans, update Database Statistics and perform Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
•Monitoring Redgate alerts and resolve if there are any blockings, server waits or long running queries.
•Monitor windows cluster logs and identify if there are any issues.
•Working on ServiceNow tickets to resolve user access issues or data copy requests from one environment to another through Red Gate Schema compare and Data compare tools.
•Maintaining Security on database servers through SECURE.
•Production deployments support after business hours.
•Resolve any performance slowness issues in production and stage environments.
•Create and maintain reports on performance and growth of databases in production
•Set up alerts and notifications if there are any login failures and if there are any replication job failures.
•Maintain indexes and resolve slowness issues.
Education:
A Bachelor's degree in engineering or computer science, or a Bachelor's degree with significant work experience in technology Industry