Database Administrator

Hyphen Solutions

1d

About The Position

Build Your Future with Hyphen While Our Clients Build Homes with Your Support. We Build a Trusted Homebuilder Network, Unifying the Construction Supply Chain. GENERAL DESCRIPTION: This position manages AWS RDS (MySQL 8.0 and PostgreSQL 15) databases that support large scale application workloads. The DBA ensures the performance, reliability, and security of the data layer while collaborating closely with application engineering teams. The role is responsible for managing, securing, optimizing, and supporting the organization’s database environments, with emphasis on SQL query development and performance tuning. The DBA serves as the primary escalation point for database and data related issues and works with internal teams to maintain dependable data access across applications. The DBA also partners with customer care to troubleshoot reported problems and creating and executing operational scripts as required.

Requirements

• Bachelor’s degree in computer science, Information Systems, or equivalent practical experience
• 3 to 5 years of hands‑on experience with relational database systems, specifically MySQL and PostgreSQL
• Strong knowledge of database design, normalization, indexing strategies, and query optimization
• Proficient in writing, maintaining, and tuning SQL and PL/pgSQL (or MySQL stored procedures where applicable)
• Proficient with MySQL Workbench, pgAdmin, and command‑line administrative utilities
• Proficient with Git for source control and database change management
• Experience with database backup, restore, point‑in‑time recovery, and replication
• Knowledge of schema versioning and migration tools commonly used with Spring Boot
• Comfortable supporting 24×7 production environments and participating in on‑call rotations
• Ability to learn modern technologies quickly and adapt to evolving architectures
• Willingness to work after hours or weekends during production issues or planned maintenance
• Strong verbal and written communication skills
• Ability to manage multiple tasks independently and work effectively in a dynamic, team‑oriented environment
• Experience with Java Spring Boot application architectures, including connection pooling and ORM layers such as Hibernate, is a plus
• Experience with AWS RDS, Aurora, or other cloud database services is a plus
• Experience with AWS Data Migration Services is a plus
• Experience with scripting languages (Python, Bash, or similar) is a plus

Nice To Haves

• Experience with managed cloud database services (AWS RDS, Azure Database for MySQL/PostgreSQL, GCP Cloud SQL)
• Exposure to Kubernetes, operators, or containerized database patterns
• Familiarity with caching tiers such as Redis
• Basic understanding of Java to trace how queries are generated and invoked
• Experience with partitioning, logical replication, or performance extensions (e.g., pg_stat_statements)
• Honesty.
• Respect.
• Passion

Responsibilities

• Administer MySQL and PostgreSQL databases in production and non-production environments
• Perform installation, configuration, upgrades, and patching for both database platforms
• Monitor performance, identify bottlenecks, and apply tuning strategies
• Review and optimize SQL queries, schema designs, and migrations for application(s) layer
• Manage backups, restores, disaster recovery, and high availability setups
• Implement user access controls, auditing, encryption, and compliance measures
• Support migration pipelines
• Troubleshoot slow queries, locking, deadlocks, replication lag, and connection pool issues
• Maintain monitoring dashboards and alerting across both database technologies
• Collaborate with developers on indexing strategy and query patterns
• Document database standards, operational procedures, and best practices
• Create and maintain MySQL objects, including stored procedures, functions, and views.
• Automate maintenance and operational workflows using Bash, Python, or MySQL Shell.
• Monitor and tune performance using slow query logs, execution plans, indexing, and server configuration.
• Diagnose database issues affecting microservices and integrations.
• Review and execute approved data modifications from business teams.
• Provide documentation, deploy database changes, and participate in production support.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level