Cohesive · 14 hours ago
Sr Windows Engineer – Azure Architect - MS SQL
Maximize your interview chances
Asset ManagementConsulting
Culture & ValuesH1B Sponsor Likely
Insider Connection @Cohesive
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Deep understanding of Azure cloud platform, including IaaS (Compute, Networking, Storage, Security, Management), PaaS, and SaaS offerings.
Proficiency in Windows Server operating systems, Active Directory, and related technologies including DNS, DHCP HA, DFS, Windows Failover Cluster and WSUS.
Install, configure, and maintain Windows servers (including updates, patches, and service packs)
Manage Active Directory, including creating and managing accounts, permissions, and group policies.
Designing and implementing Azure and Windows infrastructure solutions that align with business requirements and best practices.
Familiarity with cloud migration strategies and tools.
Monitor system performance using tools like Windows Event Viewer and Performance Monitor.
Continuously monitor and optimize the performance, reliability, and cost-efficiency of Azure cloud services with a focus on diversity and inclusion, ensuring that our solutions meet the needs of business.
Monitor server health, performance, and availability, and take proactive measures to prevent issues.
Troubleshooting and resolving technical issues related to Azure and Windows environments.
Implement and manage VM, data backup solutions and disaster recovery plan using native solution and Azure backup solutions.
BCP Solutions using Azure Site Recovery
Conduct routine system backups and test restore procedures.
Experience with Azure Update Manager, WSUS
Experience on Cisco Duo
Apply security patches and updates to Windows servers and applications.
Implementing and maintaining robust security measures to protect Azure and Windows infrastructure.
Ensuring compliance with relevant industry standards and regulations (e.g., GDPR, HIPAA).
Document system configurations, changes, and procedures.
Maintain inventory records of hardware and software assets.
Create and maintain comprehensive technical documentation, utilizing clear and inclusive language, architecture diagrams, deployment guides, and standard operating procedures.
Use PowerShell or other scripting tools to automate routine administrative tasks.
Experience with Infrastructure as Code (IaC) concepts and tools (e.g., BiCep, ARM templates)
Collaborate with other IT team members to support cross-functional projects.
Provide technical support and assistance to end users for Windows-related issues.
Install, configure, and maintain MS SQL Server databases.
Perform database backups and recovery operations.
Monitor database performance and troubleshoot issues.
Apply database patches and upgrades.
Design and implement database solutions to meet business requirements.
Develop and optimize SQL queries and stored procedures.
Create and maintain database objects, such as tables, indexes, and views.
Identify and resolve database performance bottlenecks.
Optimize database queries and indexes.
Monitor database resource utilization and adjust configuration settings as needed.
Implement and maintain database security best practices, including user access controls, encryption, and data masking.
Stay up-to-date on security threats and vulnerabilities.
Implement and maintain high availability and disaster recovery solutions, such as SQL Server Always On Availability Groups and Database Mirroring.
Conduct regular DR drills and failover tests.
Experience with cloud-based SQL Server deployments (e.g., Azure SQL Database, AWS RDS).
Manage and maintain cloud-based database instances.
Automate routine database tasks using scripting languages (e.g., PowerShell, SQL Server Agent).
Implement automation tools to improve efficiency.
Develop and maintain comprehensive business continuity and disaster recovery plans.
Create and update runbooks for various IT operations.
Develop, manage, and maintain operational policies and procedure documentation, including:
Patching schedules
Backup schedules
Scheduled maintenance procedures
Coordinate with application teams to review and align application SOPs with infrastructure standards.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Deep understanding of Azure cloud platform, including IaaS (Compute, Networking, Storage, Security, Management), PaaS, and SaaS offerings.
Proficiency in Windows Server operating systems, Active Directory, and related technologies including DNS, DHCP HA, DFS, Windows Failover Cluster and WSUS.
Install, configure, and maintain Windows servers (including updates, patches, and service packs)
Manage Active Directory, including creating and managing accounts, permissions, and group policies.
Designing and implementing Azure and Windows infrastructure solutions that align with business requirements and best practices.
Familiarity with cloud migration strategies and tools.
Monitor system performance using tools like Windows Event Viewer and Performance Monitor.
Continuously monitor and optimize the performance, reliability, and cost-efficiency of Azure cloud services with a focus on diversity and inclusion, ensuring that our solutions meet the needs of business.
Monitor server health, performance, and availability, and take proactive measures to prevent issues.
Troubleshooting and resolving technical issues related to Azure and Windows environments.
Implement and manage VM, data backup solutions and disaster recovery plan using native solution and Azure backup solutions.
BCP Solutions using Azure Site Recovery
Conduct routine system backups and test restore procedures.
Experience with Azure Update Manager, WSUS
Experience on Cisco Duo
Apply security patches and updates to Windows servers and applications.
Implementing and maintaining robust security measures to protect Azure and Windows infrastructure.
Ensuring compliance with relevant industry standards and regulations (e.g., GDPR, HIPAA).
Document system configurations, changes, and procedures.
Maintain inventory records of hardware and software assets.
Create and maintain comprehensive technical documentation, utilizing clear and inclusive language, architecture diagrams, deployment guides, and standard operating procedures.
Use PowerShell or other scripting tools to automate routine administrative tasks.
Experience with Infrastructure as Code (IaC) concepts and tools (e.g., BiCep, ARM templates)
Collaborate with other IT team members to support cross-functional projects.
Provide technical support and assistance to end users for Windows-related issues.
Strong knowledge of MS SQL Server technologies, including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
Experience with database performance tuning and optimization.
Proficiency in T-SQL and scripting languages (e.g., PowerShell).
Strong problem-solving and troubleshooting skills.
Excellent communication and interpersonal skills.
Ability to work independently and as part of a team.
Experience with cloud-based SQL Server deployments (e.g., Azure SQL Database, AWS RDS).
Manage and maintain cloud-based database instances.
Automate routine database tasks using scripting languages (e.g., PowerShell, SQL Server Agent).
Implement automation tools to improve efficiency.
Develop and maintain comprehensive business continuity and disaster recovery plans.
Create and update runbooks for various IT operations.
Develop, manage, and maintain operational policies and procedure documentation, including patching schedules, backup schedules, and scheduled maintenance procedures.
Coordinate with application teams to review and align application SOPs with infrastructure standards.
Preferred
Microsoft certifications (e.g., MCSA, MCSE: Data Platform)
Experience with cloud-based database solutions.
Knowledge of data warehousing and business intelligence concepts.
Company
Cohesive
Cohesive brings you the world's leading digital engineering, enterprise asset management, asset delivery and asset service performance optimization solutions.
H1B Sponsorship
Cohesive has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (3)
Funding
Current Stage
Growth StageLeadership Team
Company data provided by crunchbase