Unison Consulting Logo

Unison Consulting

Gaussdb DBA

Reposted 19 Days Ago
Be an Early Applicant
5 Locations
Mid level
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

20 Hours Ago
Easy Apply
Taipei City, TWN
Easy Apply
Senior level
Senior level
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
As a Firmware Engineer, you will design and test embedded features, collaborate cross-functionally, and ensure high-quality firmware for products.
Top Skills: AndroidAospC/C++LinuxRtos
5 Days Ago
Easy Apply
Hybrid
Taipei City, TWN
Easy Apply
Senior level
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Lead the hardware design team in Taiwan, overseeing EE and PD engineers, managing product development from prototyping to validation, and ensuring successful product launches. Mentor the team and collaborate with ODM and JDM partners in hardware design.
Top Skills: AccelerometersAIBleComputer VisionDspsElectrical EngineeringGpsImaging SensorsLow Power McusLteMachine LearningSocsSystems DesignWifi
8 Days Ago
Easy Apply
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

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