Position: Senior Database Administrator
Company: NCube
Category: SQL
Experience required: 5y
English level: upper

We are looking for a Senior Database Administrator who will be responsible for the performance, integrity and security of the database, someone who can guarantee the security of data storage.As a DBA, you will be involved in the planning and design of the database, as well as troubleshooting any issues on behalf of the user, including user access data, have experience in evaluating database software purchases, overseeing modifications to any existing database software data, updating and maintaining the performance of database software, reviewing and optimizing of queries, indices, and table structure. 
 
**Project** – (Client from USA Chicago) tool that helps traders find wrong prices and high probability trades in the promising crypto options market. The emerging market for crypto options is leading to pricing inefficiencies and positive expected value trades. 


**Must have skills:** 
-  5+ years or equivalent knowledge and experience.  
-  Deep experience with Postgres DB, sharding and building high availability systems. 
-  Intimate knowledge with Postgres’ query planner. 
-  BS degree in a computer science or relevant certification. 
-  Proven working experience as a Database Administrator for databases thatare larger than 10 TB. 
-  Hands-on experience with database standards and end user applications. 
-  Excellent knowledge of data backup, recovery, security, integrity and SQL. 
-  Familiarity with database design, documentation and coding. 
-  Previous experience with DBA case tools (frontend/backend) and third party tools. 
-  Problem solving skills and good analytical skills. 
-  Strong communication and teamwork skills. 
-  The ability to work under tight deadlines. 
-  Good organizational skills. 
-  Flexible and adaptable. 
-  Willingness to keep up to date with developments in new technology. 
-  Upper-Intermediate English and better. 

** Good to have: **
- Experience with ZFS file systems, connection pooling, Timescale or WAL-G. 

** Responsibilities:** 
- Keeps the database up and running smoothly 24/7. 
- Provides a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. 
- Builds database systems of high availability and quality depending on each end user’s specialized role. 
- Designs and implements the database in accordance to end users information needs and views. 
- Defines users and enables data distribution to the right user, in appropriate format and in a timely manner. 
- Uses high-speed transaction recovery techniques and backup data. 
- Minimizes database downtime and manages parameters to provide fast query responses. 
- Provides proactive and reactive data management support. 
- Determines, enforces and documents database policies, procedures and standards. 
- Performs tests and evaluations regularly to ensure data security, privacy and integrity. 
- Securing database access for both applications and users. 
- Monitors database performance, implements changes and applies new patches and upgrades when required. 
- Reviewing and optimizing queries, indices, and table structures. 
- Implementing a Postgres load balancing and HA for both read / write queries. 

** We offer: ** 
- Competitive salary with the regular review. 
- Flexible working schedule, fully remote work opportunities, office in the - very center of Kyiv.  
- PE 5% Taxes compensations, accountant assistance.  
- Vacation (up to 20 working days). 
- Paid sick leaves (10 working days). 
- Medical Insurance after probation period (3 months).  
- Online English courses. 
- Direct cooperation with the customer. 
- Teambuildings, corporate parties and company trips abroad . 
- Great working environment and team spirit.