Database Administrator

McGee CorporationMatthews, NC, US

30+ days ago

Job type

Full-time

Job description

Job Description

Description :

Database Administrator

Location : Matthews, NC (Onsite) — Applicants must be local to Matthews, NC

Reports To : Continuous Improvement Manager

Contract Duration : 3-6 months

Position Overview

We are seeking a skilled Database Administrator (DBA) with expertise in Oracle (particularly older versions) and Microsoft SQL Server for a short-term project.

The primary responsibility of this role is to support and lead the migration of a legacy database from Oracle 8 to SQL Server. The ideal candidate will have a strong background in database management, query optimization, data migration, and scripting with a focus on ensuring data integrity and system reliability. Experience with MongoDB is a plus.

Key Responsibilities

Plan, script, and test the migration of a legacy database from Oracle to SQL Server, ensuring data accuracy.
Work with development to draft the schema design, index optimization, and query tuning for the new database.
Document migration processes, configurations, changes, and best practices for future reference.

Required Qualifications

Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).

5+ years of experience as a Database Administrator with hands-on expertise in Oracle and SQL Server.

Proven experience in migrating databases from Oracle to SQL Server, including schema refactoring and data type mapping.

Strong knowledge of SQL, PL / SQL, and T-SQL for writing and optimizing complex queries and stored procedures.

Experience with query optimization and indexing in Oracle and SQL Server environments.

Strong communication skills to document processes effectively and collaborate with a cross-functional team.

Preferred Qualifications

Experience with Quest TOAD for working with Oracle.

Experience with PowerShell for automation tasks.

Experience with MongoDB is a plus.

Requirements :

Create a job alert for this search

Database Administrator • Matthews, NC, US

Related jobs

Promoted

Senior Data Engineer

CPI SecurityCharlotte, NC, US

Full-time

CPI Security, a national leader in residential and commercial security solutions, is seeking a Senior Data Engineer to join us on our data transformational journey. This is an exciting, hands-on opp...Show moreLast updated: 13 days ago

Promoted

IDD Administrator

RHA Health ServicesAlbemarle, NC, US

Full-time

Manages and directs the operations of a single business location ensuring sustained the high quality of care and services to persons with disabilities. The Administrator leads and directs the admini...Show moreLast updated: 30+ days ago

Promoted

Senior.Net Developer

CapgeminiFort Mill, SC, US

Full-time

Excellent knowledge of C with Multithreading AsyncGood command over OOP concepts SOLID principles Design patterns.Experience in REST API Microservices using ASPNet WebAPI Only ASPNet MVC is not acc...Show moreLast updated: 3 days ago

Discovery Database Administrator (DBA) (Top Secret Clearance Required)

CGSCharlotte, North Carolina, United States, 28202

Full-time

Discovery Database Administrator (DBA).Employment Type : Full-Time, Executive-Level.CGS is seeking a dedicated Discovery Database Administrator to join a fast-paced and hard-working team to assist w...Show moreLast updated: 30+ days ago

Senior SQL Database Administrator

RETIREMENT CLEARINGHOUSE LLCCharlotte, North Carolina, United States, 28273

Full-time

Senior SQL Database Administrator – Hybrid Work Opportunity.Applicants must reside in the Charlotte, NC area •.Charlotte Magazine in 2024 and 2025! When you join the team, you'll make a real differe...Show moreLast updated: 26 days ago

Data Engineer

CGSCharlotte, North Carolina, United States, 28202

Full-time

Employment Type : Full-Time, Mid-level.Department : Business Intelligence.CGS is seeking a passionate and driven Data Engineer to support a rapidly growing Data Analytics and Business Intelligence pl...Show moreLast updated: 30+ days ago

Promoted

Solutions Architect(SRE)

Business Needs Inc.Fort Mill, SC, US

Full-time

Title : Solution Architect(SRE).Location : Fort Mill, SC (Onsite- 5 days / week).Note : Stakeholder experience is Must.Net, SQL, React, Dynatrace, Solarwinds DPA, AWS Cloud Splunk, Elastic Stack, Python...Show moreLast updated: 3 days ago

Senior Database Administrator II

CGSCharlotte, North Carolina, United States, 28202

Full-time

Senior Database Administrator II.Employment Type : Full-Time, Mid Level.Department : Information Technology.Contact Government Services is seeking a Senior Database Administrator to assist with admin...Show moreLast updated: 30+ days ago

Promoted

Supply Chain Data Scientist

Ross Stores, Inc.Rock Hill, SC, US

Full-time

Our values start with our people, join a team that values you!.Bring your talents to Ross, our leading off-price retail chain with over 2,200 stores, and a strong track record of success and growth...Show moreLast updated: 30+ days ago

Promoted

Associate Scientist

Element Staffing ServicesLancaster County, SC, United States

Full-time

As a function of Product Development / Technical Operations team, the job candidate is required to work in the lab performing bench trials, physical raw materials / products evaluations, and assist wit...Show moreLast updated: 1 day ago

Promoted

Data Engineer

Zone IT SolutionsCharlotte, NC, US

Permanent

We are actively looking for Data Engineer for a permanent position.This exciting opportunity is with a well-established global IT service provider known for its excellence in the industry.Designing...Show moreLast updated: 13 days ago

Analytics Consultant

Everstead FinancialRock Hill, SC, US

Full-time

Quick Apply

Everstead Financial is a forward-thinking consultancy specializing in data-driven transformation.We partner with organizations across industries to unlock the power of analytics and turn complex da...Show moreLast updated: 30+ days ago

Promoted

IT Professional

NavyMonroe, NC, United States

Full-time

ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...Show moreLast updated: 14 days ago

Promoted

Information Systems Technician

NavyWingate, NC, United States

Full-time

Senior Database Administrator

CGSCharlotte, North Carolina, United States, 28202

Full-time

Employment Type : Full-Time, Mid Level.Department : Information Technology.Contact Government Services is seeking a Senior Database Administrator to assist with administering all aspects of Microsoft...Show moreLast updated: 30+ days ago

Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

CGSCharlotte, North Carolina, United States, 28202

Full-time

Senior Discovery Database Administrator (DBA).Employment Type : Full-Time, Executive-Level.CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced and hard-working te...Show moreLast updated: 30+ days ago

Data Engineer IV

Signature ConsultantsUSA, North Carolina, Charlotte

Full-time +1

Quick Apply

Location : Charlotte, NC (Hybrid) / Open for Remote.Duration : 12+ Months - Permanent Hire Possibility.The Client's Enterprise Data Platforms Team is seeking a Subject Matter Expert to help develop D...Show moreLast updated: 30+ days ago

Senior IT Analyst

Auria SolutionsAlbemarle, NC, US

Full-time

Auria is a leading global supplier of highly-engineered systems for automotive flooring, acoustical, thermal, aerodynamic and other fiber-based solutions for gas and electric vehicles.Southfield, M...Show moreLast updated: 6 days ago