Lead DBA R01542952

$135,200 - $137,280/Yr

Brillio - Dallas, TX

Full-time - Entry Level

Remote - Dallas, TX

Professional, Scientific, and Technical Services

About the position

The Lead Database Engineer at Brillio is responsible for managing and maintaining database systems to ensure optimal performance and reliability. This remote position requires a detail-oriented individual who can troubleshoot connectivity issues, manage user accounts, monitor database performance, and support compliance audits. The role involves executing routine maintenance tasks, handling incident tickets, and assisting with database migrations, all while contributing to continuous improvement efforts within the team.

Responsibilities

• Investigate and resolve user connection problems.
• Create, delete, or modify user accounts and roles.
• Respond to automated monitoring alerts for performance issues.
• Ensure scheduled backups are completed successfully.
• Identify slow-running queries and provide basic troubleshooting.
• Restart database services when non-responsive or encountering failures.
• Monitor database storage and disk space.
• Check the health and availability of databases and server resources.
• Assist with SOX and HIPAA audit requests by gathering necessary data.
• Triage and escalate complex issues to L2/L3 teams.
• Investigate basic performance complaints and escalate if needed.
• Execute pre-approved SQL scripts or queries for basic maintenance tasks.
• Notify higher-level teams in case of database failovers in HA environments.
• Handle special requests like generating reports or performing data extracts under supervision.
• Assist with applying security patches and addressing basic vulnerabilities under L2/L3 guidance.
• Support pre-migration tasks and monitor migration processes, escalating issues to L2/L3 as needed.
• Continuously enhance processes and tools while updating knowledge base articles.
• Assist with new deployments for IaaS/On-Prem DBs and handle deployment features.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Basic understanding of database management systems (DBMS).
• Knowledge of Azure IaaS and DB.
• Familiarity with SQL and basic query optimization techniques.
• Strong problem-solving skills and attention to detail.
• Good communication skills and ability to work in a team environment.
• Willingness to learn and adapt to new technologies and processes.

Nice-to-haves

• Experience with database monitoring tools.
• Basic knowledge of SOX and HIPAA compliance requirements.
• Previous experience in a similar role is a plus.

Benefits

• Competitive hourly wage of $65 - $66.
• Remote work flexibility.
• Opportunities for professional development and growth.