Job description

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

Requirements