Database Administrator

RainTech

About This Role

• •Customer Support & Success :
• •Provide technical support to customers running MySQL, PostgreSQL, and MongoDB
• •on Leafcloud
• •Troubleshoot database performance issues, replication problems, and connectivity
• •challenges
• •Advise customers on database design, query optimization, and best practices
• •Assist with database migrations to and within the Leafcloud platform
• •Create and maintain customer-facing documentation, guides, and knowledge base
• •articles
• •Conduct database health checks and proactive performance reviews for customers
• •Serve as a trusted advisor to customers on database architecture and scaling
• •strategies
• •Platform Development (OpenStack Trove) :
• •Help design, deploy, and operate our managed database platform built on OpenStack Trove
• •Configure and optimize Trove datastores for MySQL, PostgreSQL, and MongoDB
• •Develop and improve Trove guest images, configurations, and automation
• •Build tooling and automation to streamline database provisioning, backups, and scaling
• •Define service tiers, configurations, and default settings for managed offerings
• •Contribute to the roadmap for managed database features based on customer needs
• •Collaborate with infrastructure and engineering teams to integrate Trove with our
• •OpenStack environment
• •Test new database versions, features, and configurations before customer rollout
• •Database Design & Architecture
• •Design database architectures that meet performance, scalability, and availability requirements
• •Evaluate and recommend database solutions based on workload characteristics
• •Define data modeling standards, naming conventions, and schema design best
• •practices
• •Plan and execute database migrations, upgrades, and version management
• •Installation, Configuration & Deployment :
• •Install, configure, and deploy MySQL, PostgreSQL, and MongoDB instances across development, staging, and production environments
• •Automate database provisioning using Infrastructure as Code (Terraform, Ansible)
• •Deploy and manage databases on Kubernetes using operators (e.g., Zalando Postgres Operator, Percona Operators, MongoDB Kubernetes Operator)
• •Configure database parameters and settings for optimal performance
• •Performance Tuning & Optimization :
• •Monitor and analyze database performance metrics to identify bottlenecks
• •Optimize slow queries through query analysis, execution plan review, and index optimization
• •Perform index management: creation, maintenance, and removal of redundant indexes
• •Tune database configuration parameters (buffer pools, cache sizes, connection
• •limits, etc.)
• •Conduct capacity planning and resource forecasting
• •Implement and manage connection pooling (PgBouncer, ProxySQL)
• •High Availability & Replication :
• •Design and implement high availability solutions (clustering, failover, load balancing)
• •Configure and manage replication topologies:
• •MySQL: Master-Slave, Master-Master, Group Replication, InnoDB Cluster
• •PostgreSQL: Streaming replication, logical replication, Patroni for HA
• •MongoDB: Replica sets, sharded clusters
• •Plan and execute failover and switchover procedures
• •Test and validate disaster recovery plans regularly
• •Backup, Recovery & Data Protection :
• •Design and implement backup strategies (full, incremental, differential, point-in-time recovery)
• •Configure and manage backup tools:
• •MySQL: mysqldump, mysqlpump, Percona XtraBackup, MySQL Enterprise Backup
• •PostgreSQL: pg_dump, pg_basebackup, pgBackRest, Barman
• •MongoDB: mongodump, MongoDB Cloud Backup, Percona Backup for MongoDB
• •Perform regular backup testing and recovery drills
• •Manage backup retention policies and storage
• •Document and maintain disaster recovery procedures
• •Security & Access Management :
• •Implement database security best practices and hardening procedures
• •Manage user accounts, roles, and privileges following the principle of least privilege
• •Configure and maintain authentication mechanisms (native, LDAP, Kerberos, certificate-based)
• •Implement encryption at rest and in transit (TLS/SSL configuration)
• •Conduct security audits and vulnerability assessments
• •Ensure compliance with data protection regulations (GDPR)
• •Manage and rotate credentials, API keys, and certificates
• •Monitoring, Alerting & Observability :
• •Implement comprehensive database monitoring using tools such as:
• •Prometheus with database exporters (mysqld_exporter, postgres_exporter, mongodb_exporter)
• •Grafana for visualization and dashboards
• •Percona Monitoring and Management (PMM)
• •pgAdmin, MySQL Workbench, MongoDB Compass
• •Configure alerting for critical metrics (replication lag, connection saturation, disk usage, query performance)
• •Maintain and improve monitoring dashboards
• •Perform log analysis and troubleshooting
• •Automation & Scripting :
• •Write scripts to automate routine DBA tasks (Bash, Python, SQL)
• •Develop and maintain automation for provisioning, backup, and maintenance operations
• •Implement GitOps workflows for database configuration management
• •Create and maintain runbooks and operational documentation
• •Maintenance & Operations :
• •Perform regular maintenance tasks (vacuuming, analyzing, optimizing tables, statistics updates)
• •Manage storage allocation, tablespaces, and disk space
• •Plan and execute schema changes with minimal downtime
• •Participate in on-call rotation for database-related incidents
• •Conduct root cause analysis for database incidents

What We're Looking For

• ✓Core Database Expertise
• ✓5+ years of experience as a Database Administrator or similar role
• ✓Deep hands-on experience with at least two of the following:
• ✓PostgreSQL (12+): Configuration, replication, partitioning, extensions, VACUUM, EXPLAIN ANALYZE
• ✓MySQL (8.0+): InnoDB internals, replication, performance schema, query optimization
• ✓MongoDB (5.0+): Document modeling, aggregation framework, replica sets, sharding
• ✓Strong SQL skills and query optimization expertise
• ✓Understanding of ACID properties, transaction isolation levels, and concurrency control
• ✓Experience with database connection pooling and proxy layers
• ✓Infrastructure & Platform Skills :
• ✓Experience running databases on Linux (Ubuntu, RHEL/CentOS)
• ✓Familiarity with containerized database deployments (Docker, Kubernetes)
• ✓Experience with cloud platforms (OpenStack preferred; AWS, GCP, or Azure acceptable)
• ✓Understanding of storage systems (block storage, SSDs, IOPS considerations)
• ✓Knowledge of networking fundamentals relevant to databases (firewalls, load balancers, DNS)
• ✓Automation & Tooling :
• ✓Proficiency in scripting (Bash, Python)
• ✓Experience with Infrastructure as Code (Terraform, Ansible)
• ✓Familiarity with CI/CD pipelines for database changes• Experience with version control (Git)
• ✓Monitoring & Observability :
• ✓Hands-on experience with Prometheus, Grafana, or similar monitoring stacks
• ✓Experience with database-specific monitoring tools (PMM, pgAdmin, etc.)
• ✓Soft Skills :
• ✓Strong analytical and troubleshooting skills
• ✓Excellent customer-facing communication and the ability to explain complex database concepts clearly
• ✓Patience and empathy when supporting customers through challenging issues
• ✓Clear written communication for documentation and knowledge sharing
• ✓Ability to work collaboratively with development, infrastructure, and support teams
• ✓Comfortable with on-call responsibilities
• ✓Proactive mindset- identifying customer needs and platform improvements
• ✓Fluent in English
• ✓Nice to Have :
• ✓Experience with OpenStack Trove or other Database-as-a-Service platforms
• ✓Experience with Kubernetes database operators (Zalando, Percona, CrunchyData, MongoDB Operator)
• ✓Background in building or operating managed database services
• ✓Experience in a customer-facing technical role (support engineer, solutions architect, consultant)
• ✓Knowledge of OpenStack components (Nova, Neutron, Cinder, Keystone, Heat)
• ✓Knowledge of time-series databases (TimescaleDB, InfluxDB)
• ✓Experience with Redis or other caching layers
• ✓Familiarity with database proxy layers (PgBouncer, ProxySQL, mongos)
• ✓Knowledge of data warehousing concepts and analytical databases
• ✓PostgreSQL or MySQL certifications
• ✓Contributions to open-source database projects
• ✓Interest in sustainability and green technology