Search jobs > Chicago, IL > Temporary > Sql dba

Azure SQL DBA / Architect

V-Soft Consulting
Chicago, Illinois
Full-time

Azure SQL DBA / Architect (Remote)

Primary Location : Remote

V-Soft Consulting is currently hiring for an Azure SQL DBA / Architect (Remote) for our premier client.

WHAT YOU’LL NEED :

Technical Requirements and Certifications

  • MCTS, MCITP, and / or MVP certifications a plus.
  • MCSE / MCSA certifications preferred.

Education and Experience

  • Bachelor’s degree in computer science or a related field or equivalent experience.
  • Minimum 5 years experience as a Microsoft SQL DBA, including design, builds, upgrades, migrations, support, and performance tuning database administrative experience.
  • Cloud migration project implementation and support experience.
  • Must have a complete understanding of underlying data and applications.
  • Must possess the following, including but not limited to system knowledge of Windows server, WSFC, Always On, Disaster Recovery, thorough knowledge of SQL Server databases, architecture and software development methodologies and practices;

strong database performance tuning skills; and strong database troubleshooting and problem resolution skills.

  • Experience with SSIS and SSRS to meet various Business Intelligence requirements. Experience with Database Administration for MSSQL Server.
  • Extensive experience in setting up and supporting SQL Server Mirroring, Log Shipping, Mirroring / Log Forwarding, Clustering, and other disaster recovery methods.
  • Demonstrates comprehensive knowledge and hands-on experience with SQL High Availability features, SQL Structured Query Language, and SQL Clustered environments.
  • Experience configuring multiple nodes (Active / Passive) in SQL Servers to establish Clustering Environments. Experience in troubleshooting and resolving database problems, and in using native monitoring and troubleshooting tools.
  • Proficient in Performance Tuning, Query Optimization, Client / Server Connectivity, conducting Database Consistency Checks using DBCC Utilities.
  • Experience with backups, restore and recovery models, and configuring failover clusters.
  • Experience with Microsoft Azure and Cloud Solutions IaaS, PaaS desirable.
  • Experience in implementing operational automation using scripts.
  • Experience working with Windows server, including Active Directory and proper disk configurations.

Knowledge, Skills and Abilities

  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server - Always On, Clustering, Failover etc.
  • Knowledge of indexes, index management, and statistics.
  • Good communication and documentation skills.
  • Strong interpersonal, verbal, and written communication skills.

WHAT YOU’LL DO :

Job Responsibilities :

  • Design and implement data migration strategies to seamlessly transition to Azure cloud.
  • Plan for and safely migrate HA SQL databases from on-premise to Azure Cloud environments.
  • Lead the architecture and design of complex database systems, focusing on performance optimization and scalability.
  • Collaborate with cross-functional teams to understand business requirements and translate them into efficient database solutions.
  • Drive the adoption of cloud-based database solutions, particularly Microsoft Azure SQL Managed Instance (SQL MI), leveraging its capabilities for scalability and manageability.

V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.

S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.

As a valued V-Soft Consultant, you’re eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more.

V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.

V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

LI-LG1

30+ days ago
Related jobs
V-Soft Consulting
Chicago, Illinois

Azure SQL DBA/Architect (Remote). Azure SQL DBA/Architect (Remote). Demonstrates comprehensive knowledge and hands-on experience with SQL High Availability features, SQL Structured Query Language, and SQL Clustered environments. Drive the adoption of cloud-based database solutions, particularly Micr...

Promoted
Loyola University Chicago
Chicago, Illinois

Cleans and maintains the University's data models by developing a strategy for removing and deleting old data; and introducing new data. DATA, SECURITY, & ARCHITECTURE. This position develops strategies for business intelligence, reporting and data warehouse/data marts. Act as principal data archite...

Promoted
Kaufman Hall & Associates LLC
Chicago, Illinois

Function as a database engineer, supporting multiple database solutions and developing database code for these solutions. This individual would have significant prior Microsoft SQL Server database experience working with large, complex datasets, database design, data modeling, developing SQL queries...

Promoted
ShipBob, Inc.
Chicago, Illinois

As a Database Engineer III at ShipBob, you will be working within a team handling all facets of the database environment, from assisting engineering teams in table design, to building databases, to working with our data warehouse. Work closely with our development and devops teams to provide databas...

Promoted
Infotech Sourcing
Chicago, Illinois

Job Title: Distributed Systems / Database Performance Engineer. We are seeking a highly skilled Distributed Systems / Database Performance Engineer to join our team. Database Performance Optimization: Expertise in database tuning, query optimization, and performance benchmarking. Database Migration:...

Promoted
NEWITY
Chicago, Illinois

We are seeking a detail-oriented and self-motivated HubSpot Database Administrator. Understanding of databases and database management. This role requires a strong understanding of CRM systems and database administration. In this role you will report directly to our Head of Technology and will be re...

Promoted
Alert IT Solutions
Chicago, Illinois

A Senior SQL Report Developer is responsible to participate in the analysis, build, and test of software components for data migration solutions. Responsible for developing SQL databases and writing applications to interface with SQL databases. It would be particularly beneficial for a Senior SQL Re...

Promoted
IBI Group
Chicago, Illinois

Arcadis' is seeking an experienced Senior Project Architect to join our dynamic Industrial architecture team contributing to a range of high-profile data center and mission critical projects. Professional degree in Architecture and an active architectural license. In this role, you’ll over...

Promoted
Shure Incorporated
Niles, Illinois

This position offers an excellent opportunity for you to gain hands-on experience working with research scientists in data engineering while working in a collaborative environment on innovative technologies supporting data science. Working closely with our data science and software engineering team ...

Promoted
Publicis Groupe
Chicago, Illinois

The Director, Solutions Architect will draw on their experience and expertise in media and data strategy as it relates to the technology and platforms solutions marketplace to intersect and drive synergy between data, advanced analytics, and marketing strategy. The ideal candidate has a minimum of 7...