Senior Oracle/ MySQL DBA

Senior Oracle/ MySQL DBA - Full time opportunity -Marshall, MI- Onsite opportunity

Job Scope

The ideal candidate will ensure the smooth installation, configuration, monitoring, and maintenance of crucial databases, including SAP Hana, PostgreSQL, OceanBase, Doris, and MySQL, which host applications such as MES, LES, TOM, SPC, and WMS in both on-premise and cloud environments. Additionally, you will work with the team to analyze performance and availability issues related to business systems, such as MES, LES, TOM, SPC, and ERP.

Essential Functions:

• Install and configure databases, including SAP Hana, PostgreSQL, OceanBase, MySQL, and

others, ensuring proper integration with other IT infrastructure.

• Assist with the installation and setup of MES, LES, TOM, SPC, and other essential

application systems and their related databases.

• Troubleshoot and resolve database issues related to SAP Hana, PostgreSQL, OceanBase,

MySQL, and other databases, optimizing performance as needed.

• Monitor the operational status of MES, LES, TOM, SPC, WMS, and other application

systems to ensure they are running efficiently.

• Manage the backup and recovery processes for the aforementioned databases and

systems to prevent data loss.

• Install, configure, and monitor databases and applications in fail-over or load-balancing

architectures to support high availability, load balancing, performance scale-up, or scale

out.

• Establish and execute disaster recovery or business continuity plans to prevent data or

business loss in case of adverse incidents.

• Patch systems, including databases and related infrastructure, based on vulnerabilities or

bug-fix needs, minimizing business impact.

• Monitor the performance and availability of databases and related systems/software,

addressing any issues that arise promptly.

• Conduct performance tuning and optimization for databases and systems to enhance

efficiency.

• Quickly identify and resolve database and system faults to minimize downtime. • Develop

and implement a database and application health governance mechanism. Set up tools to

monitor and measure database health and alert stakeholders; define and refine processes

or procedures for database administration.

• Evaluate and plan for system resource requirements to ensure adequate capacity and

scalability.

• Work in public cloud environments such as AWS, Azure, and GCP, or in private cloud

deployments. Set up or advise on applications in physical servers, virtual machines, and

container environments, including Docker and Kubernetes.

• Collaborate with other IT team members to support cross-functional projects and

initiatives.

Minimum Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, Automation, Electronic

Engineering, or a related field.

• Ability to quickly learn new technologies and gain key knowledge of different databases

and applications.

• Minimum of 5 years of experience in managing databases, with at least 3 years of

experience administering applications on Linux, Unix, and Windows servers.

• Proficiency in installing, configuring, and maintaining various database systems, including Oracle, MySQL, SQL Server, OceanBase, and Doris.

• Experience with SAP HANA is a plus.

• Strong troubleshooting skills with the ability to quickly resolve system and database issues.

• Experience in performance tuning and optimization of both databases and application

systems.

• Knowledge of backup and recovery processes to ensure data integrity and availability.

• Experience in developing and practicing disaster recovery and business continuity plans.