SQL Database Administrator
2 months ago
Position: SQL Database Administrator
Location: Charlotte, NC (Remote/Hybrid- 3 days on-site)
Length: 6 months +
Top Requirements:
-7+ years of SQL Server DBA experience -experience creating and standing up databases for applications.
-OLTP Database Modeling experience including: Primary Key Concepts, Foreign Keys Concepts, Code table, Extended Table, Relational Table Concepts, Constraints, Referential Integrity, normalization concepts
-Experience with database optimization, database performance, capacity management, improving system health by optimizing data resources.
Job Description/Overview:
Cloud Database Modeler Experience
As part of this role, the resource needs to be familiar with building Transactional data models (Conceptual, Logical, Physical), writing DDL, and creating Load sql scripts to populate new models. Resource must have a clear understanding of differences between OLTP databases (relational, document, graph (nice to have) and Datawarehouse solutions(star schema, fact tables, and dimensions).
OLTP Database Modeling Skills
Primary Key Concepts, Foreign Keys Concepts, Code table, Extended Table, Relational Table Concepts, Constraints, Referential Integrity, normalization concepts
Data Warehouse Modeling Skills (nice to have)
Fact Table Modeling, Dimension Table Modeling, Type2 Data concepts, Aggregation, Managing History
Application Database Administrator Experience
As part of this role, the resource needs to understand how to translate Business Requirements, and Application Development Requirements into logical database solutions. Resource should be able to make simple database changes such as add constraints, add new tables, add indexes, create data load scripts, basic sql performance management. Advanced skills in writing complex SQL. Resource should be familiar with Snowflake Integration. Resource will oversee and manage database related releases.
System Database Administrator Experience
As part of this role, this resource needs to understand the systems level concepts related to managing databases and Azure data related Services.
System Database Administrator skills
Database optimization, database performance, capacity management, improving system health by optimizing data resources. Review and remediate security issues identified through NIST assessments, managing database permissions, key vault secret rotation management, Backup/recovery solutions and Archive solutions.
CQRS architectural patterns and how to implement them. Maintain AzDo Repository of SQL and Azure Data Factory assets for release through CI/CD pipelines
Azure Data Resource Solutions
Azure Active Directory, Azure Resource Configurations, Azure Key Vault, Azure Data Factory, Azure SQL Databases solutions, Azure Cosmos Database solutions, and Azure Storage. Team with DevOps Engineers to maintain AzDo Repository of Infrastructure as Code (Bicep) code for maintaining Azure Data Resources for release through CI/CD pipelines.
Azure Data Engineer Experience
As part of this role, this resource needs to understand basic ETL concepts and how to apply them within an Azure platform. Must be familiar with basic Data Flow concepts of Data Landing, Data Cleansing, Data Standardization, Data Quality. Hands on experience with Azure Data Factory, and how to transform data using Azure Databricks or Azure SQL stored procedures, integrating Azure Key Vault into Azure Data Factory Solutions, and leveraging Scala or Python programming for ETL/ELT.
SQL Developer
The Data Engineer role spends much of their time analyzing data across our platform. Since our databases are generally created as Azure SQL databases, experience using sql is required.
SQL Developer Skills
Experience with SSMS and data modeling tools
Ability to write complex sql queries, DDL, and DML, and stored procedures
Required Skills : Top Requirements: -7+ years of SQL Server DBA experience -experience creating and standing up databases for applications. -OLTP Database Modeling experience including: Primary Key Concepts, Foreign Keys Concepts, Code table, Extended Table, Relational Table Concepts, Constraints, Referential Integrity, normalization concepts -Experience with database optimization, database performance, capacity management, improving system health by optimizing data resources.
Basic Qualification : Top Requirements: -7+ years of SQL Server DBA experience -experience creating and standing up databases for applications. -OLTP Database Modeling experience including: Primary Key Concepts, Foreign Keys Concepts, Code table, Extended Table, Relational Table Concepts, Constraints, Referential Integrity, normalization concepts -Experience with database optimization, database performance, capacity management, improving system health by optimizing data resources.
Additional Skills : Top Requirements: -7+ years of SQL Server DBA experience -experience creating and standing up databases for applications. -OLTP Database Modeling experience including: Primary Key Concepts, Foreign Keys Concepts, Code table, Extended Table, Relational Table Concepts, Constraints, Referential Integrity, normalization concepts -Experience with database optimization, database performance, capacity management, improving system health by optimizing data resources.
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :No
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :Administration/Support
Master Job Title :DBA: SQL Server
Branch Code :Charlotte
-
SQL Database Administrator
4 weeks ago
Charlotte, North Carolina, United States Saxon Global Full timeJob Title: SQL Database AdministratorJob Summary: We are seeking an experienced SQL Database Administrator to join our team at Saxon Global. The successful candidate will be responsible for designing, implementing, and maintaining databases to support our business applications.Key Responsibilities:Design and implement databases to meet business...
-
SQL Database Administrator
2 weeks ago
Charlotte, North Carolina, United States Vaco Full timeJob SummaryVaco is seeking a skilled SQL Database Administrator to manage and monitor enterprise-level database systems. This role involves maintaining current databases, deploying new ones, troubleshooting issues in production and non-production environments, and supporting both internal and external projects while aligning with team objectives.Key...
-
SQL Database Administrator
3 weeks ago
Charlotte, North Carolina, United States Saxon Global Full timeJob DescriptionWe are seeking a highly skilled SQL Database Administrator to join our team at Saxon Global. As a key member of our database administration team, you will be responsible for designing, implementing, and maintaining our database infrastructure.Key Responsibilities:Design and implement database solutions to meet business requirementsDevelop and...
-
Senior SQL Database Administrator
2 weeks ago
Charlotte, North Carolina, United States Insight Global Full timeJob Title: Senior SQL Database AdministratorWe are seeking a highly skilled Senior SQL Database Administrator to join our team at Insight Global. As a key member of our database administration team, you will be responsible for designing, implementing, and maintaining large-scale SQL databases on Azure. Your expertise in Azure (AZ 900 and AZ 104) and...
-
SQL Server Database Administrator
2 weeks ago
Charlotte, North Carolina, United States Vaco Full timeJob SummaryWe are seeking a highly skilled SQL Server Database Administrator to join our team at Vaco. As a key member of our IT department, you will be responsible for managing and monitoring enterprise-level database systems, ensuring optimal availability and functionality.Key Responsibilities: Oversee database performance, error detection, and backup...
-
Jr SQL Database Administrator
2 weeks ago
charlotte, United States Vaco Full timeWe are currently seeking a Jr. SQL Server Database Administrator. This position is responsible for managing and monitoring enterprise-level database systems. The ideal candidate will be tasked with maintaining current databases, deploying new ones, troubleshooting issues in production and non-production environments, and supporting both internal and external...
-
Jr SQL Database Administrator
3 weeks ago
Charlotte, United States Vaco Full timeWe are currently seeking a Jr. SQL Server Database Administrator. This position is responsible for managing and monitoring enterprise-level database systems. The ideal candidate will be tasked with maintaining current databases, deploying new ones, troubleshooting issues in production and non-production environments, and supporting both internal and external...
-
Jr SQL Database Administrator
3 weeks ago
Charlotte, United States Vaco Full timeWe are currently seeking a Jr. SQL Server Database Administrator. This position is responsible for managing and monitoring enterprise-level database systems. The ideal candidate will be tasked with maintaining current databases, deploying new ones, troubleshooting issues in production and non-production environments, and supporting both internal and external...
-
Jr SQL Database Administrator
2 weeks ago
charlotte, United States Vaco Full timeWe are currently seeking a Jr. SQL Server Database Administrator. This position is responsible for managing and monitoring enterprise-level database systems. The ideal candidate will be tasked with maintaining current databases, deploying new ones, troubleshooting issues in production and non-production environments, and supporting both internal and external...
-
Senior SQL Database Administrator
2 weeks ago
Charlotte, North Carolina, United States Insight Global Full timeJob Title: Senior SQL Database AdministratorJob Summary:We are seeking a highly skilled Senior SQL Database Administrator to join our team at Insight Global. As a key member of our database team, you will be responsible for designing, implementing, and maintaining large-scale SQL databases on Azure.Key Responsibilities:Design and implement high-performance...
-
SQL Server Database Administrator
2 weeks ago
Charlotte, North Carolina, United States LTI Mindtree Full timeAbout LTIMindtree:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies.As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help...
-
Senior SQL Database Administrator
4 weeks ago
Charlotte, North Carolina, United States Insight Global Full timeJob Title: Senior SQL DBAWe are seeking a highly skilled Senior SQL DBA to join our team at Insight Global. As a key member of our database team, you will be responsible for designing, implementing, and maintaining large-scale SQL Server databases in Azure.Key Responsibilities:Design and implement high-performance SQL Server databases in AzureDevelop and...
-
Database Administrator
2 weeks ago
Charlotte, North Carolina, United States Vaco Full timeDatabase AdministratorWe are seeking a skilled Database Administrator to manage and monitor our enterprise-level database systems. This role involves maintaining current databases, deploying new ones, troubleshooting issues in production and non-production environments, and supporting both internal and external projects while aligning with team...
-
Senior SQL Database Developer
4 weeks ago
Charlotte, North Carolina, United States Apex Systems Full timeJob Title: SQL DeveloperWe are seeking an experienced SQL Developer to join our Research Management Systems team.As a SQL Developer, you will play a vital role in directing and supporting our database design & development process to build a next-generation software solution that investment teams across all areas of our business will use to make...
-
Database Developer
3 weeks ago
Charlotte, North Carolina, United States Manpower Group Inc. Full timeJob Title: SQL DeveloperWe are seeking a skilled SQL Developer to join our team in Charlotte, NC. The ideal candidate will have expertise in SQL and T-SQL for managing and querying databases, as well as strong experience in data mapping and data analysis to ensure the accuracy and integrity of data across systems.Main Responsibilities:Analyze complex...
-
SQL Server Administrator
2 days ago
charlotte, United States LTIMindtree Full timeAbout Us:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise...
-
SQL Server Administrator
5 days ago
Charlotte, United States LTIMindtree Full timeAbout Us:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise...
-
SQL Server Administrator
24 hours ago
charlotte, United States LTIMindtree Full timeAbout Us:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise...
-
Charlotte, North Carolina, United States Triunity Software Full timeJob Title: SQL Server Administrator/UAM Application SupportWe are seeking a highly skilled SQL Server Administrator to join our team at Triunity Software. As a key member of our IT team, you will be responsible for ensuring the smooth operation of our SQL Server infrastructure and providing top-notch support for our UAM application.About UsTriunity Software...
-
Oracle Database Administrator
2 days ago
charlotte, United States LTIMindtree Full timeAbout Us:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise...