Database Analyst

Lviv, Ukraine
Share on FacebookTweet about this on TwitterShare on LinkedIn

About position

The Technical Operations Team at is looking for a DBA who is interested in assisting in maintaining a highly scalable and fault-tolerant distributed database systems. Our team values creativity, innovation, hard work, open communication and rapid iteration and learning.

As a Database Administrator you will take an active role in determining what architectures and technologies perform, scale and deliver stability. You and the Operations team will transform logical database models into physical database designs scaling across multiple data centers. You will collaborate with business and engineering teams to design and implement enhancements.


  • Responsible for performance and up-time of our production MS SQL Server 2016 / Windows Server 2012 cluster environment
  • Implement and operate data warehouse solutions using MS SQL Server or other applications
  • Responsible for performance and up-time of our production MySQL instances running on Red Hat & Centos Linux server environments
  • Monitor and optimize physical storage for database systems
  • Work with our production team on PCI (payment card industry) compliance related to our DB deployments
  • Optimize indexes for performance
  • Provide day-to-day monitoring, troubleshooting, and performance tuning of all databases
  • Ensure that data is up to date and accurate
  • Develop and evolve the physical equipment layout of our application
  • Monitor, maintain and modify replication as needed
  • Identify and resolve locking, blocking, I/O and CPU-intensive operations and other resource contention
  • Design and capture performance benchmarks
  • Help chart future directions for other database systems


  • BSEE or BSCS or equivalent years of work experience
  • 2+ years of database administration with a primary focus on MS SQL Server and large terabyte database deployments
  • Experience setting up lightweight profiles and traces
  • Hands-on experience in tuning hardware for performance
  • Understanding of SQL server internals and issue resolution
  • Develop scaling strategies including data partitioning, sharding, replication, and recovery
  • Experience with consumer facing 24×7 high traffic websites
  • Production MySQL experience
  • Experience with MySQL partitioning, MySQL Events and advanced configurations
  • Understand how to use cron, compression, copying, and basic scripting in Linux

Desired Skills

  • Experience or desire to learn Analysis Services
  • Experience with NOSQL, Redis, MongoDB, Elastic Search
  • Experience with Data Warehousing concepts and technologies
  • Experience with SAN hardware
  • Experience designing and deploying large scale databases with multiple locations is a plus

Зацікавила вакансія?

або Погодитися на LinkedIn