Position: DBA (Database Administrator)
Company: Koyfin
Category: SQL
Experience required: 3y
English level: intermediate

Requirements
*At least 3 years of experience in administering cloud-based multiuser environments with expertise in planning, designing, building, and implementing complex database systems
*In-depth understanding of SQL and NoSQL databases theory and concepts
*Significant practical hands-on experience with database administration, backup and recovery, performance tuning, and high-availability solutions
*Detailed understanding of PostgreSQL, MongoDB, and Elasticsearch architecture, concepts, features, and high-availability technologies
*Expert knowledge of PL/PgSQL, triggers, stored procedures development and optimization 
*Expert knowledge of MongoDB aggregation pipelines and index usage
*Ability to apply the principles of continuous performance management to Elasticsearch 
*Experience with database replication, hot standby, clustering, sharding and partitioning
*Linux platform familiarity, system resource monitoring and tuning
*English - Upper-Intermediate

Responsibilities
*Responsible for implementing, managing, and tuning high-availability 24x7 databases
*Establish policies and procedures about data management, security, maintenance, and utilization
*Audit for data integrity and consistency across systems
*Develop, manage, and test database backup & recovery strategies
*Perform database installations, configurations, upgrades and migrations
*Proactively monitor and tune for performance
*Consult with software and infrastructure engineering teams to help meet continuous application growth
*Create and maintain procedures, schemas, and guides for troubleshooting database systems
*Research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements
*Work with data-warehousing and Business Intelligence tools