ZipRecruiter

Log In

1

Database Mart Jobs (NOW HIRING)

AAR Corporation

Database Administrator

Wood Dale, IL · On-site

The Database Administrator will be responsible for managing all aspects of database administration ... Mart (Chicago) in early 2027. What you will be responsible for: * Fully support, configure ...

MagnaFlow

Database Developer

Oceanside, CA

$130K - $1M/yr

Develop and support enterprise data warehouse and data mart architectures to enable reporting ... Optimize database and warehouse performance through indexing, partitioning, query tuning, and ...

MagnaFlow

Database Developer

Oceanside, CA · On-site

$130K - $150K/yr

Develop and support enterprise data warehouse and data mart architectures to enable reporting ... Optimize database and warehouse performance through indexing, partitioning, query tuning, and ...

AAR Corporation

Database Administrator

Wood Dale, IL · On-site

The Database Administrator will be responsible for managing all aspects of database administration ... Mart (Chicago) in early 2027. What you will be responsible for: * Fully support, configure ...

next page

Showing results 1-20

All JobsDatabase Mart Jobs

Database Mart information

What are some common challenges faced by professionals working in a Database Mart role, and how can they be addressed?

Professionals managing a Database Mart often encounter challenges such as ensuring data consistency across multiple sources, optimizing query performance, and effectively managing data security. Addressing these challenges typically involves implementing robust ETL (Extract, Transform, Load) processes, using indexing and partitioning strategies for faster queries, and adhering to strict access controls and compliance standards. Collaboration with data engineers, business analysts, and IT security teams is essential to maintain the quality and reliability of the data mart and to support organizational reporting needs.

What is the difference between Database Mart vs Database Administrator?

AspectDatabase MartDatabase Administrator
CredentialsTypically no formal certifications requiredRequires certifications like Oracle DBA, Microsoft SQL Server, or MySQL
Work EnvironmentData storage and management in retail or warehouse settingsIT departments, data centers, or corporate offices
Industry UsageUsed mainly in retail, logistics, and warehousing sectorsCommon across all industries with data management needs
Job FocusManaging physical data storage units or systemsMaintaining, backing up, and securing databases

The main difference is that a Database Mart typically refers to a physical or logical data storage unit used in retail or logistics environments, while a Database Administrator is an IT professional responsible for managing and maintaining databases across various industries. The roles differ in focus, credentials, and work settings, but both are essential for effective data management.

What is a database mart?

A database mart is a subset of a data warehouse focused on specific business areas or functions, designed to provide quick access to relevant data for analysis and reporting. Database marts are often used by data analysts and require knowledge of database querying tools like SQL. They help improve data retrieval efficiency and support decision-making processes.

Where is Database Mart located?

Database Mart is a company that provides data management solutions, and its physical location may vary depending on the branch or office. For specific job locations, it is best to check the company's official website or job postings for the most accurate information.

What are the key skills and qualifications needed to thrive as a Database Administrator, and why are they important?

To thrive as a Database Administrator, you need expertise in database management, data modeling, and proficiency with SQL, often supported by a degree in computer science or a related field. Familiarity with database platforms like Microsoft SQL Server, Oracle, or MySQL, as well as certifications such as Microsoft Certified: Azure Database Administrator Associate, is typically required. Strong problem-solving skills, attention to detail, and effective communication are valuable soft skills in this role. These skills ensure database integrity, performance, and security, which are critical for supporting organizational data needs.

How secure is Databasemart?

Database Mart, as a data management role, typically involves handling sensitive information, so security depends on the organization's data protection measures, such as encryption, access controls, and regular security audits. Professionals in this role should be familiar with database security best practices and tools to ensure data integrity and confidentiality.

What is the Databasemart company history?

Database Mart is a company specializing in database solutions and data management services. Its history includes providing enterprise database support, consulting, and training, often utilizing tools like SQL and Oracle. The company has evolved over time to meet the changing needs of data-driven organizations.
SQL SERVER DATABASE DEVELOPER / DATA ENGINEER

SQL SERVER DATABASE DEVELOPER / DATA ENGINEER

VSolvit

Norco, CA • On-site

Other

Posted 9 days ago

Job description

Senior Technical Lead For SQL Server Database Development

Position is 100% onsite daily in Norco, CA.

The contractor shall serve as the senior technical lead for SQL Server database development, data migration, data warehouse/data mart architecture, and ETL/ELT initiatives supporting Navy mission systems and enterprise data platforms.

Responsibilities
  • Design, develop, and maintain SQL Server databases, tables, views, stored procedures, functions, triggers, and indexes.
  • Support OLTP database design including normalization, constraints, keys, and referential integrity.
  • Develop and maintain Data Warehouse and Data Mart solutions utilizing dimensional modeling and star schema design.
  • Create, optimize, and troubleshoot complex T-SQL queries and stored procedures.
  • Develop ETL/ELT processes and data integration solutions for loading data from files, APIs, staging environments, and external systems.
  • Perform data validation, reconciliation, and data quality assessments.
  • Support migration activities between PostgreSQL, SQL Server, and other relational database platforms.
  • Create and maintain database documentation including ERDs, data dictionaries, source-to-target mappings, and technical design documentation.
  • Develop reporting views and curated datasets to support analytics and business intelligence initiatives.
  • Analyze execution plans and perform query tuning, indexing optimization, and database performance improvements.
  • Support software releases, deployments, testing, and environment promotion activities across Development, Test, Staging, and Production environments.
  • Participate in Agile/Scrum ceremonies and collaborate with developers, analysts, and stakeholders.
Required Qualifications
  • Minimum 3 years of Microsoft SQL Server database development experience.
  • Minimum 2 years of advanced T-SQL development experience.
  • Experience designing and developing production database solutions.
  • Experience creating and maintaining tables, views, stored procedures, functions, triggers, and indexes.
  • Experience with database performance tuning and query optimization.
  • Experience with OLTP database design and normalization principles.
  • Experience with Data Warehouse and Data Mart development.
  • Experience with ETL/ELT processes and data integration.
  • Understanding of dimensional modeling, star schema design, fact tables, and dimension tables.
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Experience producing technical documentation and database designs.
  • Experience with SQL Server Integration Services (SSIS).
  • Experience migrating PostgreSQL databases to SQL Server.
  • Knowledge of data governance, role-based access controls, and database security best practices.
  • US Citizenship
  • If applicable: If you are or have been recently employed by the U.S. Government, a post-employment ethics letter will be required if employment with VSolvit is offered
Desired Qualifications
  • Experience with Git, CI/CD pipelines, and database deployment processes.
  • Experience supporting Department of Defense (DoD) systems and secure environments.
  • Experience with Agile/Scrum development methodologies.
  • Active Secret Clearance.
Expected Deliverables
  • SQL Server database schema designs.
  • Database tables, views, stored procedures, functions, triggers, and indexes.
  • ETL/ELT pipelines and data integration solutions.
  • Data warehouse and data mart models.
  • Source-to-target mapping documents.
  • Entity Relationship Diagrams (ERDs).
  • Data dictionaries and technical documentation.
  • Data quality assessment and validation reports.
  • Deployment and implementation documentation.

Apply