Database Engineer

Job Description:

-Create, Design and Implement Database Architecture (Tables, Data Type, Schema, Etc)

-Understand SQL Programming

-Familiar with Structurized Database, and able to build a Database Design Document from existing Structure

-Minimize database downtime and manage parameters to provide fast query responses

-Famiiliar with Liquibase or Flyway

-Hands-on experience on database management, performance tuning in high traffic environments

-Familiarity with structured database and NoSQL Databases tools

-Develop automation scripts and tools for provisioning, deployment, monitoring, and backup/recovery of databases using infrastructure as code (laC) principles.

-Implement robust monitoring and alerting systems for database performance metrics.

-Develop and maintain disaster recovery plans and backup strategies for databases to minimize downtime and data loss in the event of failures.

-Maintain version-controlled configurations for database servers, ensuring consistency and repeatability across environments via IaC.

-Automate routine tasks such as database backups, schema migrations, and data archiving to improve operational efficiency.

-Develop database high availability and replication solutions to meet the requirements of critical applications.

-Develop standardized operational procedures within the DBaaS framework to ensure the consistent provision of highly available solutions.

-Participate in an on-call rotation schedule to ensure 24/7 availability and timely response to critical incidents.

-Conduct Data Warehousing routine and ensure Database Performance to serve

-Conduct Data Optimization such as Vacuum, Index and Query Optimization.

-Understand of Database Clustering Technique and ETL Concept

Requirements:

-5+ years of Experience as a Database Engineer / DB DevOps Engineer with a focus on database management.

-Hands-on experience with CloudSQL and Google Cloud Platforms (GCP) environment

-Experience with Database monitoring (Datadog, SolarWind DB Analyzer, Prometheus, etc)

-Experience with Database Replication tools for PostgreSQL such as PgPool, HAProxy, Etc

-Proficiency in scripting languages such as Go, Shell, and Ruby for automation tasks.

-Experience with infrastructure as code tools (e.g., Terraform, CloudFormation) for provisioning and managing database resources.

-In-depth knowledge of database systems such as PostgreSQL (Mandatory), MySQL (Mandatory), Redis (Mandatory), Oracle (Plus point), including configuration, optimization, and troubleshooting.

-Strong understanding of CI/CD practices and tools.

-Experience with disaster recovery strategies (including hands-on backup and recovery experience).

-Experience in configuration management tools (eg, Ansible) for database patching and maintenance automation.

-Experience in Banking Switch Vendor Company is a plus

-Familiarity with database design, documentation and coding