Database Administrator

компания "файненшл технолоджи компани" the product team is looking for skilled db administrator to become the part of our team! here, at finteco, as the name suggests, we are developing future products for our partners in the financial industry. the open vacancy is for our most successful product – payment solutions platform that serves millions of clients and businesses worldwide and enables its clients from more than 150 countries can pay, send and receive money internationally in over60 currencies. we are looking for a db administrator that can help us not only maintain sql server 2019 cluster, but also migrate to cloud, review dmls that devs need to run on production db and clean and optimize our dbs from old and unused stuff. we also have a small postgres setup which needs some care and ownership. tasks for sql server perform regular maintenance setup adequate monitoring, logging, backups, obfuscation, replication automate sql server deployment and configuration with ansible ocasionally review developers’ sql and assist them optimize complex queries and stored procedures remodel sql tables into a different structure remove unused schema objects (tables, sps, indexes, соlumns) and simplify db in general tasks for postgres setup adequate monitoring, logging, backups, obfuscation, replication automate sql server deployment and configuration with ansible our environment 2 production sql server clusters in dag mode 15 development sql server instances 1.5 tib total production db size 30 databases, 850 tables, 1200 stored procedures reporting services + analysis services schema in git + sqlpackage for diff generation requirements 5+ years of experience deep knowledge how sql server works and how it should be maintained deep knowledge of t-sql knowledge of query optimization techniques knowledge of data modelling best practices we offer the following benefits: 28 calendar days annual vacation and sick-leave days access to medical insurance compensation of sport expenses corporate english classes annual bonuses on the base of performance results compensation of attending conferences and obtaining certification friendly team with well-established workflow