Database Administrator - Hybrid, OH

Oceanbluecorp; Ohio; On-site; USD 70,000 - 110,000; Full time

Job summary

An established industry player is on the lookout for a talented Database Administrator to oversee and enhance their Oracle and PostgreSQL environments. This role encompasses a variety of responsibilities, including performance tuning, data analysis, and the implementation of cloud solutions. The ideal candidate will thrive in a collaborative environment, utilizing their problem-solving skills to ensure database integrity and availability. Join a dynamic team where your contributions will directly impact the efficiency and reliability of critical database systems, and help shape the future of database management in a cloud-driven landscape.

Qualifications

• Strong understanding of database principles and performance tuning.
• Excellent problem-solving abilities and teamwork skills.

Responsibilities

• Manage and maintain Oracle and PostgreSQL databases, ensuring high availability.
• Implement cloud concepts and monitor database performance using AWS tools.
• Develop backup and recovery strategies while writing scripts for database tasks.

Skills

Database Administration

Oracle Database

PostgreSQL

AWS RDS

Shell Scripting

SQL

PL/SQL

Python

Problem-solving

Performance Tuning

Tools

AWS CloudWatch

AWS CloudTrail

CloudFormation

Job description

We are seeking a skilled Database Administrator to manage and optimize our critical Oracle and PostgreSQL database environments, including AWS RDS PostgreSQL and Oracle RAC. The ideal candidate will be responsible for data analysis, database administration, maintenance, and performance tuning.

This role requires a strong understanding of database principles, excellent problem-solving abilities, and the capacity to work both independently and collaboratively. If you are passionate about database management and eager to contribute to a dynamic team, we encourage you to apply.

Responsibilities:

• Managing and maintaining Oracle databases, including Oracle Real Application Clusters (RAC).
• Utilizing AWS CloudWatch to monitor database health and performance, and AWS CloudTrail for auditing and security purposes.
• Implementing and managing cloud concepts such as scalability, elasticity, on-demand provisioning, and cost optimization.
• Supporting the application system development life cycle methodologies.
• Creating and configuring RDS resources using CloudFormation templates for infrastructure-as-code.
• Developing and implementing database backup and recovery strategies.
• Defining and implementing database standards.
• Writing and maintaining scripts in Shell, SQL, PL/SQL, and Python for various database tasks.
• Configuring RDS for high availability (HA) and disaster recovery using multi-AZ deployments and backups.
• Performing database performance tuning and monitoring.
• Scheduling and monitoring data warehousing processes.
• Participating in software release management processes.
• Communicating effectively with team members and stakeholders, demonstrating excellent interpersonal and collaboration skills.
• Managing time effectively and prioritizing tasks to meet deadlines.
• Diagnosing and resolving database errors and performance issues using logs, metrics, and AWS documentation.
• Applying logical data modeling techniques.
• Authoring shell scripts to perform backup, restore, and monitoring tasks.
• Designing, installing, and converting databases.
• Ensuring database backup and recovery procedures, access security, database integrity, physical data storage design, and data storage management.