Application DBA

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 analyze 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.