What are the responsibilities and job description for the Database Infrastructure Engineer position at Expert Technology Services?
Job Summary (Bullet/List Format):
- Design, maintain, and optimize core database infrastructure, focusing on high availability and scalability.
- Automate routine database tasks using scripting languages (e.g., PowerShell, SSIS).
- Manage and monitor hardware/software configurations, including Azure Cloud services and Windows Servers.
- Ensure data compliance with governance and privacy regulations; manage user access and permissions.
- Design and oversee automated database jobs, maintenance tasks, and ETL workflows.
- Proactively monitor database performance; identify and resolve bottlenecks, optimize queries, and implement indexing strategies.
- Troubleshoot and resolve hardware, software, and network issues quickly, especially in production environments.
- Develop and test disaster recovery (DR) strategies and perform regular failover testing; provide 24/7 support for mission-critical systems as necessary.
- Collaborate with cross-functional IT teams, supporting application development, data integration, IIS administration, and implementing security/performance best practices.
- Leverage CI/CD pipelines and DevOps processes to support database and application deployment.
- Utilize tools and services such as PowerApps, Power BI Services, and Power Automate as needed.
Required Skills & Qualifications:
- Bachelor’s degree in Computer Science, IT, or related field.
- Strong experience with MS SQL Server, Windows Server, and Azure Cloud environment.
- Advanced proficiency in scripting (PowerShell, SSIS).
- Solid understanding of storage systems, network architecture, and cloud infrastructure (especially Azure).
- Excellent troubleshooting and problem-solving skills.
- Certifications in relevant database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft SQL Server).
- Familiarity with CI/CD, DevOps, and .NET applications.
- Experience with PowerApps, Power BI Services, and Power Automate.
- Design, maintain, and optimize core database infrastructure, focusing on high availability and scalability.
- Automate routine database tasks using scripting languages (e.g., PowerShell, SSIS).
- Manage and monitor hardware/software configurations, including Azure Cloud services and Windows Servers.
- Ensure data compliance with governance and privacy regulations; manage user access and permissions.
- Design and oversee automated database jobs, maintenance tasks, and ETL workflows.
- Proactively monitor database performance; identify and resolve bottlenecks, optimize queries, and implement indexing strategies.
- Troubleshoot and resolve hardware, software, and network issues quickly, especially in production environments.
- Develop and test disaster recovery (DR) strategies and perform regular failover testing; provide 24/7 support for mission-critical systems as necessary.
- Collaborate with cross-functional IT teams, supporting application development, data integration, IIS administration, and implementing security/performance best practices.
- Leverage CI/CD pipelines and DevOps processes to support database and application deployment.
- Utilize tools and services such as PowerApps, Power BI Services, and Power Automate as needed.
Required Skills & Qualifications:
- Bachelor’s degree in Computer Science, IT, or related field.
- Strong experience with MS SQL Server, Windows Server, and Azure Cloud environment.
- Advanced proficiency in scripting (PowerShell, SSIS).
- Solid understanding of storage systems, network architecture, and cloud infrastructure (especially Azure).
- Excellent troubleshooting and problem-solving skills.
- Certifications in relevant database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft SQL Server).
- Familiarity with CI/CD, DevOps, and .NET applications.
- Experience with PowerApps, Power BI Services, and Power Automate.