Sr. Database Administrator

This job is with
Gicoh.
Their expertise covers all major platforms and technology stacks, enabling to provide customized and comprehensive solutions that address our clients specific requirements.

About The Role
We are seeking a highly skilled and experienced
Database Administrator
(
DBA)
to join our dynamic team. This role involves managing, maintaining, and enhancing multiple database environments including
MySQL, MariaDB, SQL Server, and PostgreSQL
The ideal candidate will ensure that all databases remain available, secure, high-performing, scalable, and recoverable, while also conducting R&D initiatives to improve our database tools, architecture, and performance.

Key Responsibilities
1. Database Administration:

• Install, configure, upgrade, and maintain multiple database systems.
• Perform schema design, object creation, user management, and permission control.
• Manage and optimize database objects such as tables, views, indexes, stored procedures, triggers, and functions.
• Ensure adherence to best practices for all relational database environments.

2. Backup, Restore & Disaster Recovery

• Develop, implement, and monitor incremental and full backup strategies.
• Configure and maintain replication, clustering, mirroring, and other HA/DR solutions.
• Conduct routine restore tests to ensure business continuity and minimal downtime.

3. Performance Monitoring & Optimization

• Monitor database health using monitoring tools; identify and resolve performance bottlenecks.
• Optimize slow queries, indexes, caching, and server configurations.
• Provide recommendations to improve database and application performance.

4. Maintenance & Automation

• Schedule and automate regular maintenance tasks including reindexing, vacuuming, consistency checks, and log cleanup.
• Develop automation scripts using Bash, PowerShell, or Python to reduce manual workloads.

5. Data Management & ETL

• Execute data extraction, transformation, and loading (ETL) processes.
• Handle database version upgrades and data migrations with integrity and minimal downtime.
• Ensure secure, auditable handling of sensitive data.

6. Security & Compliance

• Implement and maintain database security policies including authentication, authorization, encryption, and auditing.
• Identify vulnerabilities and apply patches/fixes.
• Ensure compliance with internal data governance and regulatory requirements.

7. Research & Development (R&D)

• Research new database technologies, tools, and performance strategies.
• Conduct POCs on monitoring tools, database features, or scaling architectures.
• Document findings and implement improvements to the database environment.

8. Cross-Functional Support

• Collaborate closely with DevOps, Cloud, Development, and Security teams.
• Support application deployments, migrations, and performance incident troubleshooting.
• Participate in an on-call rotation to support critical database-related incidents.

Requirements & Qualifications
Must-Have Skills

• 5+ years of DBA experience in MySQL, MariaDB, SQL Server, and PostgreSQL.

• Strong expertise in:

• Backup & recovery strategies

• Replication, clustering, and HA/DR
• Performance tuning and query optimization

• Authentication, security, and access control

• Hands-on experience with database tools:

• SSMS, SQLYog, MySQL Workbench, pgAdmin, Toad, etc.
• Strong understanding of Linux and Windows Server environments.
• Experience with monitoring tools like Prometheus, Grafana, CloudWatch, Zabbix, SolarWinds, etc.
• Scripting experience in Bash, PowerShell, or Python.

Education

• Bachelors Degree in Computer Science, Computer Engineering, Information Technology, or a related field.

Preferred Qualifications

• Experience with cloud-managed databases (AWS RDS, Azure SQL, Cloud SQL).
• Knowledge of NoSQL databases (MongoDB, Redis, Cassandra).
• Experience with Kubernetes, containerized DB deployments, and operators.
• Familiarity with CI/CD pipelines and DevOps practices.
• Professional certifications in MySQL, SQL Server, PostgreSQL, or cloud platforms.