SQL Server Administrator

Job Title: Senior SQL Server Administrator

Location: Richmond, VA 23219 (Need to come to office 3 days a week)
Duration: Full Time Permanent
Salary: $DOE/Annum + Benefits

NOTE: H1B Transfer acceptable and Client will file visa in premium once confirmed.

NOTE: SQL DBA Architect with hands on development experience and H1B Transfer acceptable and Client will file visa in premium once confirmed.

NOTE:

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

Candidate Details Required:

1. Full Name:
2. Current Location Address with Zip Code:
3. Phone:
4. Email:
5. Visa Status:
6. LinkedIn Must:

Experience Skill Matrix:

1. Senior SQL Server Administrator: Years

1. 15+ years of experience with native SQL Server tools: Years
2. Designing and developing documentation on database designs (i.e., stored procedures, configuration files, tables, views, and functions): Years
3. SQL Architecture and data modelling: Years
4. Containerization (Cloud) and Migration experience: Years
5. SQL Database: 2016 to 2019
6. Migration Experience: SQL Profiler
7. Azure Cloud: Years
8. Performance Tools experience: Years
9. Third Party Tools experience like Idera: Years
10. ER Diagrams Creation Tools experience: Years
11. 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

•

Last updated on Jul 17, 2023