Database administrator (full time)
Responsibilities:
-Database deployments on Linux, Windows, and Cloud platforms.
-DBA support for SQL database monitoring and performance tuning to ensure new and upgraded
systems/databases run at optimal levels. Includes performing resource contention analysis and
system tuning as part of remediation or proactive monitoring.
-Perform migrations from SQL platforms such as Oracle and MS SQL Server to PostgreSQL.
-Develop and document database policies, procedures, and standards for SQL databases.
-Automate existing SQL database installation, configuration, and management standards and
procedures based on industry best practices.
-Establish and maintain access controls and security for non-production and production SQL
database environments (including CIS benchmarks).
-Proactively maintain database systems at the latest security patch levels.
-Develop automation procedures and provide proactive intervention to minimize downtime.
-Assist our operations team in SQL database installations, including troubleshooting, problem
resolution, and on-call after hours and weekend support if needed.
-Monitor and automate capacity planning for all SQL database installations.
-Provide support to our DBA operations team and our application teams.
Requirements:
-3+ years of experience working with PostgreSQL/ MSSQL/MySQL (Oracle;
-3+ years of experience performing database performance analysis, system and statement SQL
tuning;
-3+ years of experience architecting and implementing PostgreSQL replication solutions using
streaming replication including pg Pool;
-3+ years of experience migrating non- PostgreSQL databases to PostgreSQL, such as MS SQL
Server, or Oracle;
-Knowledge of DevOps/Infra as Code practices and tools like Git, Bitbucket, Bamboo;
-Knowledge of working with Agile methodology and tools like Confluence/JIRA;
-Communication skills necessary to work on a geographically distributed team;
-Skills / Other Personal Attributes Required Motivated self-starter with an entrepreneurial spirit;
-Strong communicator (written and verbal) and listener;
-Possesses diplomacy and the cooperative style necessary to interface effectively with all
personalities and across functional disciplines;
-Proven ability to effectively sell ideas and build consensus at all levels within the organization;
-Strong analytical skills with ability to define, collect, analyze data, establish facts, draw valid
conclusions, and make fact-based decisions;
-Handling multiple tasks and balancing multiple objectives, while consistently ensuring that highest
priority commitments are delivered on schedule.
We Offer:
-Professional and career growth;
-Best team;
-Compatible and stable salaries;
-Flexible working time.
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 ∙ 12 hours 33 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 ∙ 14 hours 24 minutes back ∙ 31 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 ∙ 15 hours 31 minutes back ∙ 16 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 6 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 3 days 11 hours back ∙ 35 proposals |