Database Administrator
Our technology department is building systems that serve the best customers in the world - our customers. Our platform uses some of the most cutting-edge technologies available. We have built most of our systems on open-source technologies. We use Linux, PHP, Ruby on Rails, MySQL, Apache, Nginx and more (you can even help us figure out what else!).
Job Description
Job description:
- Provide support for mission-critical database systems.
- Perform installations, upgrades, and apply patches to databases running on Linux/Unix platforms.
- Implementation and management of database objects including data files, tables, indexes, triggers, integrity constraints, materialized views, jobs, and database roles/permissions.
- Extensive performance tuning against mission-critical databases using native monitoring and troubleshooting tools.
- Design and implement operational automation using scripts.
- Design database performance specifications, database backup, and recovery plans, and database performance/capacity models including server capacity plans.
Qualifications
Qualifications:
- Min 5 years work experience with production support and maintenance as a MySQL or MariaDB DBA version 5.1 - 8.0 (5.1 - 10.5)
- MySQL backup and recover
- MySQL replication and clustering technologies
- MySQL performance troubleshooting and optimization
- MySQL monitoring requirements
- MySQL migrations
- MySQL upgrades
- MySQL disaster recovery
- Advanced Unix-like systems troubleshooting skills
- Excellent technical documentation skills
- Docker knowledge desirable
Additional information
- Compensation in direct correlation to your knowledge and talent
- Comfortable and cozy atmosphere
- Unlimited opportunities for self realization
- Friendly, professional, highly motivated and productive team
- Creative Environment where You will never be bored!
- Full/Part-time
- Office located in Brooklyn, in a modern building, near Sheepshead Bay Rd. (B,Q) train station
- And....slowly, but surely we are getting ready to conquer the world. Join us!
-
60 1 Linux, PHP, MySQL, Apache, Nginx Linux I know well. I can both administer these software products systematically and develop software for them.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORPAbout the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 8 hours 37 minutes back ∙ 3 proposals |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 10 hours 28 minutes back ∙ 28 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 11 hours 35 minutes back ∙ 16 proposals |
1C database for the enterpriseA database is needed for managing the auto dismantling inventory, controlling finances, and generating orders. It is necessary to add a car as an object and attach parts to it. I will explain the full structure of how it should look and work during the conversation. Databases & SQL ∙ 21 hours 9 minutes back ∙ 6 proposals |
1C data integrationOrganize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 2 days 2 hours back ∙ 9 proposals |