Sql database developer • chicago il
Role: VDOT Senior MS SQL Database Administrator</b></p> <p><b>Location: 9120 Lockwood Blvd, Mechanicsville, VA 23116 Hybrid</b></p> <p><font color=&... Mostrar más
SQL Server DBA – Work From Home.We are seeking a talented and self-motivated Senior Database Administrator to join a growing IT team.This position requires experience administrating MS SQL Server (... Mostrar más
Job Title: JAVA Developer<br /> Location: Chicago, IL</b></div> <div> </div> <div><b>Must Have Requirements:</b></div> <ul> <li>St... Mostrar más
Assisting customer requests with information, entering data and upload documents into customer portals .Will create reports to communicate work completed.Will create letters by following formats a... Mostrar más
Job Description</b></p> <p><b>Sr.Data Engineer with strong SQL and Databricks experience</b></p> <p><b>Experience: - Min</b> 8+ Years</p>... Mostrar más
Senior Staff Infrastructure Engineer - IEB07BE.We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies.Working here means having ... Mostrar más
Database Architecture & Engineering.Design and implement scalable MongoDB database architectures for enterprise applications.Establish data models, schema design standards, indexing strategies, and... Mostrar más
Calibri, sans-serif; color:red"><span style="color:#000000;"><b><u><span style="font-family:Helvetica, sans-serif">Magento Developer</span>... Mostrar más
Concept Reply, part of the Reply Network, is a leader in IoT solutions.We support and advise our customers in Automotive, Manufacturing, Smart Infrastructure and beyond in all aspects of Internet o... Mostrar más
A leading organization is seeking a Data Quality Assurance Engineer to join its growing Data & Analytics team in a hybrid work environment.This full-time opportunity offers the chance to work with ... Mostrar más
Month Contract-to-Hire -W2 Only.Our client is looking for a Sr.NET, MS SQL Server, cloud development, and modern engineering practices.Develop and modernize enterprise.Analyze existing code and dat... Mostrar más
One of our top banking clients is looking for a *SQL Developer*.Locations: *Charlotte NC or Irving TX *Must be able to work on W2*.Top Skills * SQL * SSIS * Stored Procedures About TEKsystems: We'r... Mostrar más
Database Administrator’s primary role is to oversee the database performance, perform database maintenance, and support of database technologies.They be responsible for providing operational databa... Mostrar más
We are seeking a Senior Database Architect who combines deep expertise in legacy database systems with forward-looking vision for AI-native data architecture.You'll lead the decomposition of comple... Mostrar más
This position demands a critical understanding of data warehousing concepts, advanced ETL and BI report development skills, and an in-depth knowledge of SQL Server database.Primary responsibilities... Mostrar más
Headquartered in San Francisco, our investors include.Database Systems Evaluation Expert.Design challenging, self-contained.Evaluate performance measures such as.Write clear grading criteria for.St... Mostrar más
We are seeking a Senior Java Developer to support enterprise identity and access management (IAM) integration across complex legacy and modern applications.The engineer will investigate how applica... Mostrar más
Publicis Re:Sources is seeking a highly skilled and experienced Microsoft Power BI developer.This role requires expertise in data visualization, data modeling, DAX, Power Query, and ETL processes, ... Mostrar más
Platform Expertise: Expert-level proficiency in Adobe Marketo Engage (building programs, smart campaigns, and engagement streams).Platform Expertise: Expert-level proficiency in Adobe Marketo Engag... Mostrar más
About Us Ardmore Roderick is a full-service infrastructure solutions firm that specializes in Utilities, Transportation, Aviation, Rail and Transit, Building and Facilities Projects.We are headquar... Mostrar más
Role: VDOT Senior MS SQL Database Administrator
Location: 9120 Lockwood Blvd, Mechanicsville, VA 23116 Hybrid
Contract
Job description:
VDOT ITD Tolling group is seeking a SQL Server / Cloud DBA to join the Tolling Eng and Ops Team to administer and support SQL Server and cloud databases in the Tolling group; the role also includes help desk and application support responsibilities.
The Virginia Department of Transportation (VDOT) 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 6 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)
Master'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
Minimum 3 4 years hands-on experience upgrading E Z Pass Virginia Tolling SQL Server environments from SQL 2012 to SQL 2019, including compatibility evaluations, Query Tuning Assistant, and Database Migration Assistant.
Experience diagnosing and resolving deadlocks and blocking in Tolling production workloads, including extended events, Query Store, and wait statistic analysis.
Experience tuning Very Large Databases (2 TB+)including index optimization, long running workload analysis, and minimizing resource contention.
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 VDOT technologies.
