Overview
On Site
Depends on Experience
Contract - W2
Contract - Independent
Skills
Application DBA
PostGreSQL
MongoDB
Redis
Migration
Data Storage
Cloud Computing
Caching
Microsoft SQL Server
Transact-SQL
Google Cloud
Google Cloud Platform
Reporting
Legacy Systems
Storage
Database
Business Objects
Analytical Skill
TSQL
Redis cache
Job Details
Title: Application DBA (PostGreSQL and MongoDB)
Location: Kansas City, KS
Job description:
- This role will be working with application developers to store/retrieve their business objects and other data efficiently in databases (PostGreSQL and MongoDB). Should be an expert in creating table structures that map nicely to business classes and doing so in such a way that queries to store and retrieve that data are quick and reliable.
- The person should be familiar with creating stored procs using languages such as TSQL. Should be able to monitor and optimize indexes and queries as database and loads change over time. Should be able to help developers troubleshoot application issues with data components.
- The person will also need the ability to analyse legacy application data stores, plan out and execute migrations of that data from the existing SQL Server on premise storage to cloud based databases.
- The person should also be able to assist migrating data to data storage on Google cloud for use in analytical reporting.
- The person will also be expected to help with various needs on the existing SQL Server based infrastructure until we have fully migrated away from that.
- A nice to have would be familiarity with Redis cache.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.