SQL DBA -Local to Ohio

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Able to Provide Sponsorship

Skills

Backup Administration
Data Integrity
Data Integration
Data Lake
Data Modeling
Data Warehouse
Database Administration
Database Architecture
High Availability
Extract
Transform
Load
Disaster Recovery
Database Security
Microsoft Azure
Mentorship
Microsoft SQL Server
Microsoft SSIS
Microsoft Windows Server
Multitasking
Optimization
Performance Tuning
Policies and Procedures
Problem Solving
Query Optimization
Microsoft SQL Server DBA
SQL
SQL Azure
Switches
Systems Management
Regulatory Compliance

Job Details

One of our clients is looking for the position of SQL Database Administrator based on following skills:

Face to Face Interviews Only

Will be required to be onsite 5 days a week.

The candidate will be supporting the team working on tasks for the Transportation Systems Management and Operations (TSMO) team.

This role will be instrumental in ensuring the performance, availability, security, and integrity of our critical SQL Server database environments, both on-premises and within Azure Synapse. The ideal candidate will possess significant experience in working in complex SQL Server infrastructures, including Always On availability groups, as well as designing, implementing, and maintaining ETL processes using SQL Server Integration Services (SSIS). This individual will also be a key contributor in troubleshooting database issues, optimizing query performance, and ensuring the smooth operation of our data platforms.

Responsibilities:

  • Administer and monitor our Azure Synapse Analytics environment, including data warehousing and data integration components.
  • Design, develop, implement, and maintain ETL packages using SQL Server Integration Services (SSIS) to support data integration needs.
  • Provide recommendations to business unit on database architecture for new use cases
  • Take the lead on implementation of a new Data Lake in an Azure Synapse environment
  • Perform regular database maintenance tasks.
  • Monitor database performance, identify bottlenecks, and implement effective performance tuning strategies.
  • Troubleshoot database-related issues, including connectivity problems, query performance degradation, and data corruption.
  • Maintain database security policies and procedures, ensuring data integrity and compliance.
  • Collaborate with application development teams to optimize database design and query performance for new and existing applications.
  • Document database configurations, processes, and procedures.
  • Stay current with the latest SQL Server and Azure data platform technologies and best practices.

Experience:

  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Experience with SQL Server High Availability important.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. Build SSIS packages to integrate data throughout systems.
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes. Assist developers with complex query tuning and schema refinement.
  • Perform scheduled maintenance and support release deployment activities after hours.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Have experience with decommissioning and migration of older to new systems.

Required Skill:

4-year college degree or equivalent technical study with advanced study preferred.

  • 5-10+ years MS SQL Server Administration experience required
  • 5+ years MS Azure SQL Server Administration experience required
  • 2+ years administering an Azure Synapse Analytics environment
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Experience working with Azure Data Lake architecture
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience working with Windows server, including Active Directory
  • Excellent written and verbal communication
  • Flexible, team player, get-it-done personality
  • Ability to organize and plan work independently
  • Ability to work in a rapidly changing environment
  • Ability to multi-task and context-switch effectively between different activities and teams

The successful candidate may have to undergo a drug test and background check.


Sincerely,

Tamana Nair

Digitek Software, Inc.

650 Radio Drive, Lewis

Center, OH 43035 Tel No ext. 3105/ Fax

Email

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.