SQL Server Administrator

Note

 

• SQL Database: 2016 to 2019
• Migration Experience: SQL Profiler 
  
   

Candidate Details Required

 

• Full Name:
• Current Location Address with Zip Code:
• Phone:
• Email:
• Visa Status:
• LinkedIn Must:
  
   

Experience Skill Matrix

 

• Senior SQL Server Administrator: Years
• 15+ years of experience with native SQL Server tools: Years
• Designing and developing documentation on database designs (i.e., stored procedures, configuration files, tables, views, and functions): Years
• SQL Architecture and data modelling: Years
• Containerization (Cloud) and Migration experience: Years
• SQL Database: 2016 to 2019
• Migration Experience: SQL Profiler
• Azure Cloud: Years
• Performance Tools experience: Years
• Third Party Tools experience like Idera: Years
• ER Diagrams Creation Tools experience: Years
• Experience with Performance Tuning and Query Optimization: Years
  
   

Roles And Responsibilities

 

• Lead MS SQL database management activities including analysis and design.
• Manage SQL Server Database performance, integrity, and security.
• Able to provide solutions and sell ideology to higher management.
• Support the project team with ad-hoc query generation and analysis.
• Support the PM with project/task scoping by analyzing the client requirements, coming up with approach, tasks, and level of effort.
• Complete physical/logical database schema and object design; Develop new tables, views, triggers and indexes to support a complex data model and ensure optimal database performance
  
   

Required Skills

 

• Bachelor's degree in computer science, Engineering, Management Information Systems, or equivalent work experience
• 15+ years of experience with native SQL Server tools
• 10+ years of experience designing and developing documentation on database designs (i.e., stored procedures, configuration files, tables, views, and functions)
• SQL Architecture and data modelling
• Containerization (Cloud) and Migration experience
• Experience with Azure Cloud and relevant tools
• Performance Tools experience
• Third Party Tools experience like Idera
• ER Diagrams Creation Tools experience.
• Experience troubleshooting performance and database issues.
• Experience with Performance Tuning and Query Optimization
• Hands on experience developing small presentations/training and be involved in all aspects of data administration.
• Ability to execute user/security management and document system configuration.
• Ability to create and document standard operating procedures as pertains to DB maintenance.
• Ability to create functions and stored procedures to provide custom functionality as per the requirements.
• Must be able to live, or relocate to a commutable distance from Richmond, VA