LanceSoft, Inc. ยท 20 hours ago
GDOT - Sr SQL Server Database Administrator
LanceSoft, Inc. is seeking a Senior SQL Server Database Administrator for the Georgia Department of Transportation. The role involves coordinating, designing, and securing databases, serving as a subject matter expert, and managing various aspects of database administration.
Information Technology
Responsibilities
Manage all aspects of physical database administration including schema management; security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning and capacity planning for SQL Server
Support application teams and their projects to enhance, troubleshoot and performance tune
Support SQL Server databases in Production, Test and Development environments and within Microsoft SharePoint farm
Install, upgrade, configure ALWAYS ON, test and deploy complex database software
Develop and implement database recovery plans and procedures
Analyze the performance of databases and recommends tuning and application changes
Implement user authentication and validate databases security protocols across systems
Reviews system design and develop new database systems as needed
Modifying database structure or deploying schema changes as a result of new requirements
Scripting batch data loads and operational job automation
Working Knowledge of Cohesity Backup Appliance
Working Knowledge of Cloud Technology and governance
Qualification
Required
Bachelor's degree in computer science or a related field from an accredited college or university AND Seven years of experience in support of an operating system, database management system or a related field
Hands on administrative experience with SQL Server RDBMS - 6 Years
Hands on experience in managing backup, recovery and high availability scenarios - 6 Years
Hands on development and tuning of databases in SQL Server with Performance Tuning - 6 Years
Hands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming - 6 Years
Hands on query experience with SQL and scripting skills - 6 Years
Strong knowledge and experience on Always ON High Availability groups - 4 Years
Required 4 Years Strong Knowledge and Experience on Migrations - 4 Years
Required 4 Years SQL Server database space management/storage design and capacity planning according to best practices - 3 Years
Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management - 4 Years
Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture - 3 Years
Company
LanceSoft, Inc.
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele.
H1B Sponsorship
LanceSoft, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (55)
2024 (32)
2023 (23)
2022 (25)
2021 (60)
2020 (80)
Funding
Current Stage
Late StageCompany data provided by crunchbase