Job Summary
Job description
Overview of job
Looking for a strong, outstanding, persistent Database Administrator who has experience or is eager to learn HP Vertica, and ready to challenge himself/herself in the area of Data Warehousing / Data Marting.
As a specialist of this field, you are going to work for our partner - GoodData - gooddata.com - a US company which provides a massively scalable, secure & high-performance Insights Platform-as-a-Service for 70,000 businesses, over a million users.
According to Forrester, insights-driven businesses will steal $1.2 Trillion/year from traditional market players by 2020. This is the transformation GoodData is enabling globally.
By joining us, you won’t just grow your career, enjoy the life of a DB specialist in LHV professional work environment. You’ll be part of a movement that is changing how people live, work and make decisions.
What you will do
- Be responsible for both DB administration and DB-related design/development tasks on not only Vertica but also PostgreSQL and MariaDB.
- Participation on proof-of-concepts of other related technologies can be required as well (e.g. Hadoop).
DBA
- Operate many highly utilized Vertica database clusters.
- Proactively monitor server and database process health to ensure availability and performance.
- Provide database performance tuning.
- Validate and maintain data security.
- Cooperate on investigation of Vertica bugs together with Vertica support. Work closely with the Vertica community.
- Implement reproducer scripts.
Development
- Define best practices, help (internal) users/developers with good database design, provide tips, training, workshops
+ SQL performance tuning, Database monitoring, ...
- Implement DB-related automatic deployment processes
- Implement DBA tooling
e.g. backup / restore, monitoring, …
- Implement DB-related tooling
e.g. analyze/predict workload
Job Requirement
- Good English is a MUST so you can communicate with the Vertica Support team.
- Analytical, problem solving ability are your strengths.
- Experience working on multitasking and prioritizing.
- Able to work independently and collaboratively.
- Know how to make decisions, explain and presentation.
DBA:
- Hands-on experience as DBA with any enterprise database system
e.g. Oracle, DB2, MS SQL, MySQL, PostgreSQL, Teradata
- In-depth knowledge of database internals and data structures
- Hands-on experience with database optimization and tuning
- Good knowledge of Linux operating system administration
Development:
- Hands-on experience with development in scripting languages
shell, python, perl, ruby, ...
- Hands-on experience with development of DB-related tooling
deployment, monitoring, ...
Required Qualifications
- 5+ years experience in DBA.
- Hands-on experience in relational database design, transactional SQL and DBMS (Vertica, PostgreSQL, Oracle, MySQL or MSSQL).
Advantage Qualifications:
- Prior experience with Vertica.
- Database certifications.
- Hands-on experience with managing large data volumes (1+ TB)
- Hands-on experience with Graphite monitoring / Grafana
- Hands-on experience with automatic deployment tools such as Puppet, Foreman, Jenkins, Docker containers, Splunk and GIT
Why You'll Love Working Here
Good salary & bonus:
- Attractive salary, annual review and quarterly recognition bonus.
- 13th salary paid before Tet.
- Premium health checkup and insurance.
Learning & development support:
- English and IT courses support.
- Safari Books Online accounts support.
- Sport activities support.
Pleasure environment:
- Flexible working hours, 2 days/month working from home, 15 days annual leave.
- Regular team building activities and company trips.
- Kitchens full of free refreshments.
Languages
-
English
Speaking: Intermediate - Reading: Intermediate - Writing: Intermediate
Technical Skill
- DBA
- MS SQL
- Vertica
- IBM DB2
- Oracle
- System Administration
- Linux
- MySQL
- Python
- Git
- Perl
- Database Design
- Ruby
- DBMS
- RDBMS
- Jenkins
- Puppet
- Docker
- Splunk
- Grafana
- Teradata
- Graphite
COMPETENCES
- Analytic Skills
- Problem Solving Skills
- Working Independently
- Presentation Skills
BUSINESS PROFILE
LHV Software is a software development and software outsourcing company providing services worldwide.
Founded in 2004, LHV Software is a software development and software outsourcing company providing services worldwide. LHV has been offering professional services to companies operating in IT and IT enabled industries as Hewlett-Packard, GoodData & ExpenseCloud.
By providing high quality services, we aim to develop long-term partnerships with IT companies over the world especially in North America & Europe.
LHV Software has been appraised at CMMI maturity level 3 and ISO QMS (ISO 9001:2000).