Database Admin (PostgreSQL, DevOps)

The Access Group
Expired
+2
21-23 Nguyễn Thị Minh Khai, Bến Nghé, District 1, Ho Chi Minh
At office

Top 3 reasons to join us

  • A very attractive salary package
  • 20 annual leave days per year+public holidays
  • Hybrid flexible working mode

Job description

About Vincere

Vincere is a SaaS Cloud recruitment platform transforming the recruitment market with a CRM-based marketing system focused on recruitment, candidate relationship management, on-boarding, and back-office Pay & bill management. We have set our sights on executing the next generation of recruitment systems to the market, employing artificial intelligence and machine-augmented decision making to streamline recruitment processes, bring quantum improvements to recruiting, and weaponize our customers through technology. 

Vincere has a nimble, hard-driving team that is rapidly growing a worldwide scale. If you are passionate about innovation, and want to be involved in revolutionizing the recruiting world then we want to hear from you.

About you

You are a talented and passion driven individual who values working in a fast-growing environment, delivering high quality client-oriented services and collaborating with your peers.

You are a motivated, detail oriented, technical skills and energetic person who works well in a fast-paced, dynamic small-team environment. You learn quickly and are passionate about helping others.

You desire to be part of a fast-growing company and contribute to the mission of building the tool of choice of ambitious companies that everyday strive to enhance their daily recruitment operations.

 

About the job

Your responsibility:

1. Monitoring:

  • Monitoring is a core task that DBA needs to perform daily.
  • Set alerts and configure Database servers properly.
  • Need to be comfortable using various monitoring systems & tools such as: DataDog, Zabbix, CloudWatch, pg_activity, Glowroot
  • Need to be able to develop scripts for customized alerts to signal issues.
  • Need to be skilled in monitoring the performance of the infrastructure and constantly finding ways to make it faster.

2. High availability and disaster recovery:

  • Replication. There should always be a Standby/Slave database which replicates Data from the Master one in real time. When the Master Database fails, DBA needs to promote the Standby/Slave to Master. The DBA must ensure the MTTR (Mean Time To Recovery) is as low as possible. The data between servers need to be consistent so DBA must monitor the Replication carefully.
  • DR Plans: Backup, Restore and automate the process.

3. Performance tuning:

Performance tuning is a constant, iterative process. From the monitored data, DBA must:

  • Identify slow queries which impact the system
  • Help to optimize slow queries
  • Suggest business changes to improve queries performance
  • Work with Devs to improve response time
  • Review queries with Devs before putting code to production to prevent unexpected performance outage
  • Manage tenants' databases to distribute load in Multi-DB Architecture:

4. Automation:

  • Automation is another core task that must be adopted by DBA in our multi-tenancy multi-regional SaaS business.
  • DBA needs to perform queries over thousands of databases and ensure the queries run properly.
  • DBA may need to perform migration processes behind the scene so we can offload slow queries from Flyway and speed up our deployment progress.
  • Some repeatable processes should be automated to ensure reliability.

5. Security:

Security is a major concern in the Cloud. At Vincere we take security as the highest priority. Because security is a DBA responsibility, DBA needs to be familiar with which parts of our databases hold sensitive data.

DBA needs to know the change control and procedure measures that must be followed to provide access to sensitive database resources.

When setup database servers, DBA must ensure:

  • Put database servers in a private network
  • Setup Firewall to limit access to the database servers
  • Seperate Test/Staging/Migration/Production data to ensure security
  • Grant only authorized users access to our business data in production.

DBA also needs to apply new security updates and upgrade databases to new versions to ensure organization's security and growth.

6. Flexibility:

The DBA job is mostly involved in Postgres Database System. DBA may need to involve in our stateful services:

  • Postgres (self-managed + AWS RDS)
  • MongoDB
  • Redis (self-managed + AWS ElastiCache)
  • Memcached
  • Kafka
  • Cassandra
  • AWS Athena
  • AWS DynamoDB

Your skills and experience

Requirement:

  • 3+ years of administering large PostgreSQL databases.
  • Must have the ability to do performance tuning / index maintenance to meet and assist the needs of the Development teams using PostgreSQL as its backend database.
  • Must have experience backing up and restoring PostgreSQL databases on a regular basis.
  • Designing and Managing PostgreSQL database schemas.
  • Experience with highly-available web applications.
  • Knowledge of fault detection and resolution processes.
  • Experience setting up and using PostgreSQL database replication.
  • Proficiency in PL/pgSQL or other scripting languages such as Python/Perl/Bash/etc
  • Knowledge of designing a Data Warehouse.
  • English proficiency is a must.

Desirable Skills:

  • Basic Unix/Linux administration experience.
  • Experience with MongoDB or other NoSQL databases.
  • Expert in various SQL programming and fine tuning.

Why you'll love working here

Collaboration: At Vincere everyone shares the same vision and is dedicated to the mission. No egos. We support each other in order to make Vincere successful.

We are global: We've got an international team from Indonesia, Japan, Singapore, Sydney, all the way to London, Manchester and the US.

We grow, you grow: Annual bonuses, pay increments and performance reviews. Release incentives included. OT policies apply for every product release.

Company trips & events:

- Once in a lifetime experiences. Annual team building trips. Cruise around Saigon River - done. Next? Dinner Cruise on the Nile River.

- Quarterly Events such as dinner on cruise, golf course, bowling nights with challenging games and great rewards.

Welfare Support: Premium healthcare packages and yearly health check-ups.

The Access Group

View company

Join the Access Family and see how we make software ideas become a reality!

Company type
IT Product
Company size
1000+ employees
Country
United Kingdom
Working days
Monday - Friday
Overtime policy
Extra salary for OT