Database Administrator (DBA)

Responsibilities

• Design, implement and Build database systems of high availability and Quality
• Install, upgrade, manage and maintain performance of database servers and applications.
• Develop processes for optimizing database security, performance and efficiency.
• Set and maintain database standards ensuring quality, efficiency, security and high availability of Databases.

• Performance tuning & Optimization of database systems to improve performance including Caching, Compression, Partitioning, Indexing, Concurrency control, connection pooling, etc.
• Determine, enforce and document database policies, procedures and standards
• Perform tests and evaluations regularly to ensure data security, privacy and integrity
• Monitor database performance, implement changes and apply new patches and versions when required
• Execute regular database maintenance tasks, including database defragmentation, backups, and database replication.
• Identify and implement database requirements for new or existing applications by working collaboratively with other teams.
• Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.
• Use high-speed transaction recovery techniques and backup data
• Minimize database downtime and manage parameters to provide fast query responses

Requirements

Requirements and skills

• Bachelor's degree in computer science or computer/communications engineering or any other related field.

• 5 Years of proven working experience as a Database Administrator with hands-on experience with database standards and end user applications.
• Excellent knowledge of data backup, recovery, security, integrity and SQL.
• Familiarity with database design, documentation and coding.
• Previous experience with DBA case tools (frontend/backend) and third-party tools.
• Hands on Experience with different Database structures and Techniques (e.g. SQL, MYSQL, MONGO).
• Knowledge of database automation tools such as Ansible, Puppet, Chef, etc... and Ability to use a scripting language (like Python or Peri) to automate database administration tasks.
• Relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA).
• Experience in cloud database technologies.

Last updated on Aug 12, 2024