Assurity Trusted Solutions Pte Ltd

Application Database Administrator

Assurity Trusted Solutions Pte Ltd

contract

Posted on:

Origin:  • 🇸🇬 Singapore

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

CloudMS SQL ServerMySQLNoSQLOraclePostgresSQL

About the role

  • Collaborating with application developers and system architects to design and develop database structures that align with the requirements of the organisation's applications.
  • Writing and optimising database queries to ensure efficient data retrieval and manipulation, thereby enhancing the performance of the applications.
  • Monitoring and fine-tuning database performance to improve the overall responsiveness and efficiency of the applications.
  • Creating and maintaining data models that accurately represent the organisation's data and its relationships, ensuring that the databases are well-structured and scalable.
  • Implementing automation processes for database deployment, configuration, and maintenance to streamline operations and reduce manual effort.
  • Implementing and maintaining security measures within the databases to protect sensitive data, including access controls, encryption, and security best practices.
  • Working closely with application developers to understand their database requirements, provide guidance on database best practices, and support them in optimising database interactions within their applications.
  • Resolving database-related issues, providing support to application developers, and participating in incident response and problem resolution efforts.

Requirements

  • Proficiency in database management systems such as Sybase, Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or NoSQL databases.
  • Strong understanding of database design principles, data modeling, and database development, including experience with SQL and database programming languages.
  • Experience in performance tuning, query optimisation, and database indexing to ensure efficient data retrieval and manipulation.
  • Knowledge of database security best practices, including access control, encryption, and compliance with relevant data protection regulations and standards.
  • Familiarity with database backup and recovery strategies, including disaster recovery planning and implementation.
  • Ability to troubleshoot database-related issues, provide support to application developers, and participate in incident response and problem resolution efforts.
  • Understanding of data integrity, data validation, normalisation, and data quality management within databases.
  • Proficiency in database automation, scripting, and scheduling tasks for database maintenance and management.
  • Strong communication and collaboration skills to work effectively with application developers, system administrators, and other stakeholders to support database requirements.
  • Previous experience in a database engineering or administration role, with a focus on application databases and their integration with software applications.
  • Ability to stay updated with the latest trends, tools, and best practices in database management and application development.