Position: Database Administrator
Company: Limestone Digital
Experience required: 5y
Category: Data Engineer
English level: upper
Published: 2022-11-01T00:00:00+02:00

Limestone Digital is looking for Database Administrator to expand our team

**Required Skills:**
- 5+ years working on database administration;
- 3+ years on SQL Server / Oracle administration;
- 3+ experience with cloud-based databases;
- Experience with code maintenance;
- Bachelor's degree from an accredited university in computer science or related;
- Excellent listening, verbal and written and presentation communication skills;
- Demonstrated ability to work in a fast-paced environment by learning quickly, applying new knowledge effectively, and still maintain a disciplined approach to software development;
- Ability to work both independently and with a team, and with remote development teams (international);
- Passion for quality and continuous improvement;
- Upper-intermediate English level.

**As a plus:**
- Experience with data warehousing;
- Experience with scripting languages like Ruby;
- Good multitasking and communication skills;
- Not complacent with the status quo;
- Passionate about innovation and discovery.

**Responsibilities:**
- Analyze data access patterns and ensure efficient SQL and optimal database design;
- Detect slow queries and optimize SQL queries;
- Setup and tune Autovacuum constraints;
- Analyze, setup, maintain and improve indexes;
- Write and maintain automated db maintenance scripts;
- Monitor Postgres performance, setup metrics, thresholds, and alarms to detect issues in DBS;
- Maintain proper backup and recovery strategies;
- Follow and recommend Postgres 3rd party tools and plugins;
- Monitor and plan for increasing load/capacity, prepare and plan additional resources;
- Assist development team to take full advantage of Postgres features;
- Maintain performance for DBs in both OLTP and OLAP use-cases;
- Help support move of OLTP data to a 'data warehouse' or 'data lake' type of environment;
- Triage, debug and diagnose production and development database issues;
- Support product deployment, configuration, and testing;
- Communicate pro-actively and listen carefully;
- Work independently;
- Commit to negotiated schedule.

**We Offer:**
We invite you to join our friendly international team and remote works;
- Comfortable work schedule;
- Zero bureaucracy;
- Pleasant working atmosphere;
- Interesting projects and challenging tasks;
- Opportunities for self-realization, professional and stable career growth;
- English courses.

**About the Project**
Our client is an international transport company with the key project of an enterprise platform for real-time visibilityof transportation, yard operations and inventory orchestration throughout the supply chain using advanced cloud-software capabilities, IoT solutions, artificial intelligence and machine learning. Limestone Digital assists in the development and further support of the yard management automation project.