What are the responsibilities and job description for the SQL DBA/Database Infrastructure Engineer position at Solomons International?
We are seeking a skilled Database Infrastructure engineer to design, maintain, and optimize our core database environments. In this role, you will be the guardian of our data ecosystem, focusing heavily on automation, scheduling management, and infrastructure scaling. You will leverage scripting languages to automate routine maintenance, monitor system health, and orchestrate complex database jobs to ensure maximum uptime and peak performance.
Core Responsibilities:
- Infrastructure Management: Design, configure, provision, and manage hardware and software configurations (Azure Cloud services and Windows Servers). Ensure compliance with data governance and State data privacy regulations and manage user permissions.
- Automated Job Management: Design, implement, and monitor automated database jobs, maintenance tasks, and ETL workflows.
- Scripting & Automation: Write and maintain robust scripts (SSIS, PowerShell, etc.) to automate routine DBA tasks, deployments, backups, and health checks.
- Performance Tuning: Proactively monitor system performance, identify bottlenecks, optimize queries, and manage indexing strategies. Ability to resolve hardware, software and network issues.
- High Availability & DR: Maintain and test robust disaster recovery (DR) strategies, and failover testing. Provide 24/7 support for mission-critical systems as needed.
- Collaborate with cross-functional IT teams: Support application development and data integration through application environment configuration, IIS administration, and implementation of security and performance best practices.
- Supervises the coordination of design and security for computer databases to store, track, and maintain a large volume of critical business information.
Required Skills & Qualifications:
- Bachelor s degree in computer science, information technology, or a related field.
- 7 years of expertise in managing enterprise systems (e.g., MS SQL Server, Windows Server, and Azure Cloud environment).
- 7 years of advanced knowledge of scripting languages like PowerShell and SSIS for automation.
- 7 years of solid understanding of storage systems, network architecture, and cloud infrastructure (i.e. Azure).
- 7 years of excellent troubleshooting skills under pressure for critical production incidents.
- Certifications in relevant database technologies (e.g., Azure Database Administrator).
- Certifications such as Microsoft Certified: Azure Database Administrator Associate, Microsoft SQL Server.
- 7 years of experience with PowerApps, Power BI Services, Power Automate.
- 7 years of familiarity with CI/CD pipelines, DevOps processes and .NET applications.
Professional Skills :
| Skill Name | Required/Desired | Total Years |
|---|---|---|
| Bachelor s degree in computer science, information technology, or a related field | Required | |
| Expertise in managing enterprise systems (e.g., MS SQL Server, Windows Server, and Azure Cloud environment). | Required | 7 |
| Knowledge of scripting languages like PowerShell and SSIS for automation. | Required | 7 |
| Understanding of storage systems, network architecture, and cloud infrastructure (i.e. Azure). | Required | 7 |
| Excellent troubleshooting skills under pressure for critical production incidents. | Required | |
| Certifications in relevant database technologies (e.g., Azure Database Administrator). MUST UPLOAD CERTIFICATION | Required | |
| Certifications such as Microsoft Certified: Azure Database Administrator Associate, Microsoft SQL Server MUST UPLOAD CERTIFICATION | Required | |
| Experience with PowerApps, Power BI Services, Power Automate. | Required | 7 |
| Familiarity with CI/CD pipelines, DevOps processes and .NET applications | Required | 7 |