Big Oh Tech - Database Administrator - MySQL/PostgreSQL (3-4 yrs)

Responsibilities :

- Provides troubleshooting and 24/7 database support.

- Documentation and Standards : Maintains database procedures and best practices.

Requirements :

- Skilled and capable Junior DBA with 4 years of experience in MySQL and PostgreSQL database administration.

- Proficient in database optimization, performance tuning, backup and recovery, and query analysis.

- Seeking an opportunity to leverage my expertise in database management and contribute to organizational success by ensuring efficient, secure, and high-performing database operations.

- Databases : MySQL, PostgreSQL (Performance tuning, backup and recovery, replication, query optimization) Database

- Management Tools : pgAdmin, MySQL Workbench, DBeaver

- Programming and Scripting : SQL

- Operating Systems : Linux, Windows

- Software/Tools : PuTTY, pgAdmin, MySQL

- Database Management : 4 years of experience in MySQL, PostgreSQL, and MongoDB for design, scaling, replication, and high availability.

- SQL and Scripting : Proficient in PL/SQL queries, procedures, triggers, and performance tuning.

- Backup and Recovery : Implements MySQLDump, hot/cold backups, and recovery procedures.

- Replication and Upgrades : Manages replication issues and version migrations.

- Database Administration : Experienced in installation, configuration, and maintenance on Linux and Windows.

- Performance Optimization : Supports developers with SQL query tuning and indexing strategies.

- Security and User Management : Manages roles, privileges, and database security.