About This Role
This role is for a senior database administrator who provides primary support for complex and escalated issues, offering guidance to team members. The individual will collaborate with IT stakeholders, vendors, and other teams to deliver high-quality database services.
Responsibilities
- Offer DBA PostgreSQL / MySQL support for the application development team
- Ensure integrity, availability, security, and performance of PostgreSQL / MySQL database systems by providing technical support and maintenance
- Monitor database uptime, performance, and recommend improvements for operational efficiency
- Assist in capacity planning, space management, and data maintenance activities for database systems
- Perform database enhancement and modification as per requirements
- Perform database recovery and backup tasks on a daily and weekly basis
- Develop and maintain patches for database environments
- Identify and recommend database techniques to support business needs
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any needed downtime
- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another
- Responsible for proactive remediation of database operational problems
- Manage logins and user accounts, including assigning database object permissions and privileges
- Rotate for morning and weekend support/on-call
Requirements
- Bachelor’s degree or above in Computer Science, MIS, or related field
- Around 10 years of relevant experience including database administration and database programming
- Strong knowledge of database installation, upgrades, and migration
- Strong knowledge of applying PostgreSQL / MySQL patches and fixes
- Experience in database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
- Strong understanding of command line and database server administration
- Capacity planning for all aspects of a database system (storage, compute, memory, etc.)
- Ability to work non-standard shifts including nights and/or weekend on-call responsibilities
- Understanding of networking and connectivity and how it relates to a database environment
- Good team player, capable of working under pressure and in a dynamic environment with minimal supervision
- Strong analytical, verbal, and written communication skills in English; Chinese will be an advantage
