What are the responsibilities and job description for the SQL Database Administrator position at firstPRO, Inc?
We’re seeking a SQL Database Administrator to join our client’s IT team in Marlborough, MA. This is a full-time, permanent opportunity role offering a hybrid schedule, blending on-site collaboration with remote flexibility.
Role Overview
The Database Engineer will be responsible for managing, optimizing, and supporting a variety of database platforms in both on-premises and cloud environments. This position requires a balance of hands-on administration, performance tuning, and automation to ensure reliable, high-performing systems that support business applications.
Key Responsibilities
- Partner with application teams to tune queries, indexes, and configurations for optimal performance.
- Manage creation, modification, and retirement of databases, tables, indexes, triggers, and constraints.
- Perform installations, upgrades, and configurations of PostgreSQL, MySQL, and MariaDB in cloud and hybrid environments.
- Support migrations of existing databases to AWS/Azure and maintain hybrid deployments.
- Monitor system health and capacity, implement backups, and manage recovery processes.
- Identify and resolve database performance issues at both application and infrastructure levels.
- Build automation to reduce manual database tasks using scripting and modern tooling.
- Collaborate with support teams to troubleshoot and resolve database-related issues.
- Stay current with evolving database technologies and industry best practices.
- Provide on-call coverage and occasional after-hours support as needed.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.
- 3–5 years of professional experience as a Database Administrator/Engineer.
- Strong knowledge of PostgreSQL and MySQL administration, with exposure to MariaDB.
- Hands-on experience with cloud database deployments (AWS or Azure).
- Familiarity with NoSQL technologies and modern data storage strategies.
- Background in automation, CI/CD pipelines, or infrastructure-as-code practices.
- Experience maintaining high-availability database systems, including backup and recovery processes.
- Excellent troubleshooting and communication skills.