SQL Database Administrator

TechDigital Group; Lenexa (KS); On-site; USD 80,000 - 110,000; Full time

Job summary

A software solutions company is seeking an experienced Application DBA to work closely with developers in Lenexa, Kansas. This role involves optimizing data storage and retrieval in PostgreSQL and MongoDB, creating effective data models, and migrating data to cloud services. Ideal candidates will have strong skills in TSQL and query optimization, along with experience in cloud-based database environments.

Qualifications

• Experience with PostgreSQL and MongoDB; ability to design data models that map to business objects.
• Familiarity with TSQL and stored procedures; experience with query tuning and index optimization.
• Experience with data migrations and cloud-based database services.

Responsibilities

• Collaborate with application developers to store and retrieve data efficiently in PostgreSQL and MongoDB.
• Create stored procedures and optimize indexes and queries.
• Analyze legacy application data and plan migrations to cloud databases.

Skills

PostgreSQL

MongoDB

TSQL

Data migration

Query tuning

Index optimization

Redis cache

Job description

Overview

Application DBA role. This position will be working with application developers to store and retrieve their business objects and other data efficiently in databases (PostGreSQL and MongoDB). The candidate should be an expert in creating table structures that map nicely to business classes and do so in a way that queries to store and retrieve that data are quick and reliable.

Responsibilities

• Collaborate with application developers to store and retrieve data efficiently in PostgreSQL and MongoDB; design table structures that map to business classes and support fast, reliable queries.
• Create stored procedures using languages such as TSQL; monitor and optimize indexes and queries as databases and workloads change; help developers troubleshoot data component issues.
• Analyze legacy application data stores, plan and execute migrations from on-premises SQL Server to cloud-based databases.
• Assist migrating data to Google Cloud for analytical reporting.
• Support the existing SQL Server-based infrastructure until migration is complete.

Qualifications

• Experience with PostgreSQL and MongoDB; ability to design data models that map to business objects.
• Familiarity with TSQL and stored procedures; experience with query tuning and index optimization.
• Experience with data migrations and cloud-based database services.
• Nice to have: familiarity with Redis cache.