Cynet Systems · 17 hours ago
Application DBA
Cynet Systems is a company seeking an Application DBA to work closely with application developers. The role involves optimizing database structures, monitoring performance, and migrating data 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
Ability to monitor and optimize indexes and queries as database and loads change over time
Ability to help developers troubleshoot application issues with data components
Ability to analyze legacy application data stores
Ability to plan out and execute migrations of data from existing SQL Server on premise storage to cloud based databases
Ability to assist migrating data to data storage on Google cloud for use in analytical reporting
Ability to help with various needs on the existing SQL Server based infrastructure
Preferred
Familiarity with Redis cache