Senior Database Engineer

Total Quality Inc
Cincinnati, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Cincinnati, United States of America

Tech stack

Azure
Databases
Data Retrieval
Data Security
Relational Databases
Database Design
DevOps
Elasticsearch
Entity Framework
Python
Microsoft SQL Server
MongoDB
NoSQL
Online Transaction Processing
Performance Tuning
Powershell
Systems Development Life Cycle
Query Optimization
Software Engineering
Workflow Management Systems
JavaScript Pagination Plugin
Scripting (Bash/Python/Go/Ruby)
Data Storage Technologies
Caching
Database Performance
Indexer
GIT
Containerization
Kubernetes
Docker

Job description

The Database Engineer will be working closely with development teams during the design, development, testing and implementation of in-house application code primarily supporting their data storage and data access needs. While the focus will be on SQL Server, expertise in MongoDB, Elasticsearch and other DBMS platforms is crucial in supporting our ability to modernize and grow. The goal of this role is to be more proactive by addressing database performance and stability earlier on in the SDLC. What You Will Be Doing

  • Partner with application development teams to ensure the delivery of robust, data-intensive OLTP applications.
  • Provide technical expertise (eg schema design, query optimization, indexing, stress testing, etc) in SQL Server, MongoDB, Elasticsearch, and other DBMS platforms.
  • Assist in understanding and implementing the proper database platform based on data storage, data retrieval, and availability requirements.
  • Create and enforce database standards pertaining to nomenclature, security, and access methods (paging, caching, etc).
  • Conduct performance/stress testing in partnership with App Dev and Performance Engineers.
  • Identify and translate the data needs of development teams into structured requests ensuring timely delivery.
  • Ad hoc troubleshooting of database related issues in non-prod.
  • Liaise with the Database Administration team to guarantee the infrastructure can support current and future application development.

Requirements

  • Bachelor's degree or higher is preferred or relevant work experience.
  • Exceptional aptitude for learning new tools/technologies.
  • Excellent verbal and written communication skills.
  • Experience with ORMs such as Entity Framework.
  • 3 to 5 years of professional experience using SQL Server or other relational database platforms.
  • 1 to 3 years of professional experience using MongoDB, Elasticsearch or other NoSQL database platforms.
  • Knowledge of database design principles, data modeling, and normalization.
  • Familiarity with containerization/orchestration tools (eg, Docker, Kubernetes, Tilt).
  • Familiarity with DevOps practices and tools (eg Git, Azure DevOps, Pipelines).
  • Experience with Scripting languages (eg Python, PowerShell) for automation tasks.
  • Exposure to and understanding of AI models to accelerate growth (eg Custom skills, tool sets, etc).
  • In-depth knowledge of performance-tuning queries and optimizing indexes.

Apply for this position