Unison Consulting Logo

Unison Consulting

Gaussdb DBA

Reposted 14 Days Ago
Be an Early Applicant
In-Office
5 Locations
Mid level
In-Office
5 Locations
Mid level
The GaussDB DBA manages and optimizes GaussDB databases, ensuring data integrity and security, and providing troubleshooting support while performing regular maintenance tasks.
The summary above was generated by AI
Description

A GaussDB Database Administrator (DBA) is responsible for the overall management, security, and performance of GaussDB databases. They ensure data integrity, optimize database operations, and maintain systems to meet business requirements. This includes tasks like database design, creation, maintenance, performance tuning, security implementation, backup and recovery, and user management.

Key Responsibilities of a GaussDB DBA:

Database Design and Implementation:

Working with developers to design, create, and implement GaussDB databases, including tables, schemas, and other database objects.

Performance Optimization:

Monitoring database performance, identifying bottlenecks, and implementing optimizations like indexing, query tuning, and data warehousing strategies.

Security Management:

Implementing and enforcing security policies, managing user accounts and permissions, and ensuring compliance with security standards.

Maintenance and Backup:

Performing regular database maintenance tasks, including backups, restores, and data archiving, to ensure data availability and integrity.

Troubleshooting and Support:

Resolving database-related issues, providing technical support to users and developers, and documenting database procedures.

Monitoring and Alerting:

Monitoring database activity, setting up alerts for performance or security issues, and responding to incidents.

Capacity Planning:

Analyzing data usage patterns, forecasting future capacity needs, and planning for database upgrades and expansions.

Data Migration and Integration:

Facilitating data migration between databases, integrating GaussDB with other systems, and ensuring data consistency.

Specific Skills for a GaussDB DBA:

Deep Understanding of GaussDB Architecture:

Knowledge of GaussDB's distributed architecture, including coordinator nodes, data nodes, and global transaction managers.

SQL Proficiency:

Expertise in SQL, including query writing, optimization, and data manipulation.

Operating System Knowledge:

Familiarity with Linux/Unix operating systems, as GaussDB is typically deployed on these platforms.

Database Performance Tuning:

Skills in identifying and resolving performance bottlenecks, including index optimization, query tuning, and resource management.

Security Best Practices:

Knowledge of database security principles, access control, and auditing techniques.

Problem-Solving and Communication:

Ability to diagnose database issues, troubleshoot problems, and communicate effectively with developers and other stakeholders.

Backup and Recovery:

Experience with database backup and recovery procedures, including point-in-time recovery and data restoration.


Top Skills

Gaussdb
Linux
SQL
Unix

Unison Consulting Singapore Office

1 Changi Business Park Crescent, , Plaza 8 #03-06 Tower A, Singapore, , Singapore, 486025

Unison Consulting Singapore Office

#12-00, 63 Market Street, Bank of Singapore Center, Singapore, , Singapore, 048942

Similar Jobs

4 Days Ago
Hybrid
Taipei, TWN
Entry level
Entry level
Artificial Intelligence • Hardware • Information Technology • Security • Software • Cybersecurity • Big Data Analytics
As a Graduate System Engineer, you'll support operational aspects of ICT and Radio systems and develop testing solutions while gaining hands-on experience.
Top Skills: Ict SystemsIp NetworksRadio SystemsRf SystemsTest Automation Systems
4 Days Ago
Easy Apply
In-Office
Taipei City, TWN
Easy Apply
Expert/Leader
Expert/Leader
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Develop and optimize embedded firmware for camera systems, collaborating across teams to enhance camera performance and reliability in diverse applications.
Top Skills: AndroidAospBashC/C++LinuxPython
5 Days Ago
Easy Apply
Hybrid
Taipei, TWN
Easy Apply
Senior level
Senior level
Big Data • Cloud • Software • Database
The Senior Solutions Architect will guide customers in designing scalable systems using MongoDB, collaborating closely with sales to drive success and customer satisfaction.
Top Skills: Apache KafkaC#C++JavaKubernetesMongoDBNode.jsPythonSQL

What you need to know about the Singapore Tech Scene

The digital revolution has driven a constant demand for tech professionals across industries like software development, data analytics and cybersecurity. In Singapore, one of the largest cities in Southeast Asia, the demand for tech talent is so high that the government continues to invest millions into programs designed to develop a talent pipeline directly from universities while also scaling efforts in pre-employment training and mid-career upskilling to expand and elevate its workforce.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account