CI
Senior MS SQL DBA
Crescens Inc.
- ๐บ๐ธ United States
- Hybrid
- Senior
- 12 hours ago
- SQL
- T-SQL
- Windows
- SSIS
- SSRS
- Azure Cloud
- Data Modeling
- Microsoft SQL Server
- Azure
- Snowflake
- Databricks
12 hours ago
Location:Mechanicsville, VA (Remote)
Duration: 8+months
Type: Contract
Job Description:
- The client Information Technology Division (ITD) Tolling group is seeking a SQL Server database / Cloud database administrator to join the Tolling Engineering and Operations Team.
- The selected candidate will administer and support SQL Server and cloud databases in the Tolling group.
- Additional help desk and application support responsibilities will be part of rotation with the Tolling team.
The selected candidate has:
- Expertise working as a SQL Server DBA
- Expertise working with SQL clustering, mirroring and high availability
- Experience working with large SQL databases Expertise in writing Transact SQL
- Experience tuning SQL Server databases
- Expertise in installing, upgrading, patching and migrating SQL Server databases
- Experience working on a Windows platform
- Exposure to SSIS, SSAS, & SSRS
- Experience working with Azure Cloud
The selected candidate will:
- Monitor databases to maintain/ensure database uptime and availability.
- Troubleshoot application/database issues related to connectivity, access, security, etc.
- Tune long running SQL Review & refine existing database tasks and processes to better align with agency/group priorities.
- Leverage & utilize O/S scripting utilities in support of database maintenance/diagnosis/support.
- Review the existing database implementation and propose, execute, and/or direct necessary changes. Perform SQL Server installations (2022,2025+ w/ failover clustering).
- Support SQL Server databases (administration, support, tuning).
- Knowledgeable of data modeling principles Be expected to...
- Rely on experience and judgment to plan and accomplish goals. Independently perform a variety of complicated tasks.
- Work with a team of Engineering and Operations professionals.
- Communicate clearly and effectively, both speaking and in writing.
Qualifications:
- At least 2 years of experience w/ Microsoft SQL Server database
- At least 1 year of Azure, Snowflake, or Databricks experience (a certification is acceptable in lieu of experience)
- Bachelor's degree in computer science, information systems or other applicable and/or equivalent skills, knowledge and/or work history
- Demonstrated experience in communicating effectively using standard requirements and design artifacts
- Desired knowledge of and experience with the following technologies:
- SQL Server 2019+
- Cloud databases (Azure, Snowflake, and/or Databricks)
- Special Instructions to Applicants:
- This position requires a fingerprint-based background check.
- The successful contractor will be required to continue education at own expense to stay current with client technologies.
Required:
- MS SQL Server Database Management
- SQL Server Tuning
- Experience working with SSIS, SSRS & SSAS
- Coding & debugging Transact SQL
- Expertise in installing, upgrading, patching and migrating SQL Server databases
- DB Administration on Azure Cloud, Snowflake, and/or Databricks
Senior MS SQL DBA ยท Crescens Inc.