Cynet Systems · 2 days ago
Application DBA
Cynet Systems is looking for an Application DBA to work closely with application developers in managing databases. The role involves optimizing database structures, monitoring performance, and assisting with data migrations to cloud-based solutions.
EmploymentRecruitingStaffing Agency
Responsibilities
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
Qualification
Required
Expert in creating table structures that map nicely to business classes
Ability to create stored procedures using languages such as TSQL
Experience with monitoring and optimizing indexes and queries
Ability to help developers troubleshoot application issues with data components
Experience analyzing legacy application data stores
Ability to plan out and execute migrations of data from SQL Server on premise storage to cloud based databases
Ability to assist migrating data to data storage on Google cloud for analytical reporting
Experience with SQL Server based infrastructure
Preferred
Familiarity with Redis cache