Database Administrator (DBA)

Company Overview

Not specified.

Job Summary

The Database Administrator (DBA) role focuses on ensuring the effective and secure operation of databases within the organization. This position demands a strong emphasis on analyzing and resolving issues within assigned Service Level Agreements (SLA). The DBA will take ownership of problems, maintain communication with relevant teams, and collaborate to achieve timely resolutions while adhering to guidelines during changes to production environments.

Responsibilities

• Administer databases in both on-premise and cloud-based environments.
• Work with MySQL, PostgreSQL, AWS RDS MySQL, Aurora, PostgreSQL, and Amazon Redshift.
• Manage Oracle Cloud Infrastructure (OCI) databases, including DBCS and Autonomous Data Warehouse (ADW).
• Proactively monitor database performance and manage capacity.
• Conduct backups, restores, and implements recovery models while executing proactive housekeeping and archiving tasks.
• Perform performance tuning and optimization using native monitoring and troubleshooting tools.
• Execute operational automation using Shell, Perl, and Python scripts.
• Troubleshoot database integrity, performance, blocking/deadlocking, and connectivity issues.
• Raise support tickets with vendors such as AWS, Oracle, and Solarwinds and coordinate for the resolution.

Qualifications

• Education: Bachelor's degree in Computer Science or a related field.
• Experience: 8 to 12 years of database administration experience.
• Solid experience with MySQL, PostgreSQL, and AWS environments.
• Familiarity with Oracle databases and associated tools such as SQL Developer and OMC.
• Extensive knowledge of Oracle CDBs and PDBs, and experience in migrating databases across environments.
• Strong proficiency in scripting languages such as Python.
• Knowledge of storage and alerting tools like SolarWinds DPA and CloudWatch.
• Proficiency in performance tuning and proactive monitoring of databases.

Preferred Skills

• Familiarity with Hadoop environments.
• Experience with database monitoring tools and CLI command line tools like OCI CLI.
• Understanding of database integrity and resource contention issues.

Experience

• Minimum of 8 to 12 years in a Database Administration role with comprehensive experience in managing production systems.

Environment

This is a remote position, allowing flexible working arrangements.

Salary

Not specified.

Growth Opportunities

Not specified.

Benefits

Not specified.