Job Summary / Objective :
- Set up & Maintain Azure Hybrid Cloud Core Infrastructure
- Install, maintain & upgrade MS SQL Server Database on Azure Cloud in a Secure, HA & DR Environment
Qualifications : BE / MCA
Skills :
Azure Cloud AdministrationActive Directory (AD), ADFS AdministrationAzure Devops CI / CD Pipelines Security setup SkillMS SQL Server AdministrationWindow Server Administration,Proficient PowerShell Scripting / .NET ProgrammingKnowledge of Project Management Documentation Artifacts for SDLC & Change ManagementGood Document writing Skill on Microsoft Excel & PowerPoint PreparationProgramming Experience in .NET Environment (Nice to Have)Work Experinece on Azure Security Centre, Azure Defender, and Azure Sentinel (nice to Have)Experience on Hyper-V Admin, Backup Tools (Nice to Have)Work Experience in ISO27001 / SOC2 / GDPR Compliant Organization (Nice to Have)Certifications :
Exam AZ-800 : Administering Windows Server Hybrid Core InfrastructureExam AZ-801 : Configuring Windows Server Hybrid Advanced ServicesSC-300 : Microsoft Identity and Access AdministratorMicrosoft Certified : Azure Database Administrator Associate (DP-300)MCDBA / Microsoft Certified IT Professional (MCITP) Database certificationExperience : Relevant 8-10 Years
Personal attributes :
Good Communication skills specially written, Excel and PowerPoint PreparationTeam Leader, effectively articulation of ideas, convey information.Addresses customer inquiries or issues promptly & professionally.Clear and concise communication is essential for understanding requirements & expectations.Work Environment : 5 Days in-office working, posting at Faridabad / Greater Noida, may have to travel Chennai & Overseas
Roles & Responsibilities
Azure Administrator Activities Overview :
Create detailed design documents, architectural diagrams, and solution blueprints.Organize resources by creating a structured subscription model that aligns with business units, environments (e.g., dev, test, prod), and cost centres.Use management groups to efficiently manage access, policies, and compliance across multiple subscriptions.Conduct assessments of current infrastructure and recommend cloud migration strategies.Implement continuous integration and continuous deployment (CI / CD) pipelines using Azure DevOps to automate the application lifecycle.Ensure high availability, disaster recovery, and business continuity for Azure solutions.Design and implement security best practices for Azure environments.Work closely with development, operations, and security teams to integrate Azure solutions.Implement cost management strategies to optimize cloud spending.Monitor and report on cloud usage and costs, providing recommendations for cost savings.Azure AD Admin Activities :
Implement identity and access management solutions using Azure Active Directory (Azure AD).Manage and maintain the Azure Active Directory (Azure AD) environment.Create, modify, and delete user accounts, groups, and roles.Manage synchronization between on-premises Active Directory and Azure AD using Azure AD Connect.Implement and manage identity and access management (IAM)policies, including role-based access control (RBAC) and conditional access policies to enforce the principle of least privilege.Integrate Azure AD with other cloud services and on-premises systems.Automate routine administrative tasks using PowerShell and other scripting tools.Manage single sign-on (SSO) configurations and integrate with external identity providers.Generate and analyse reports on user activities, access patterns, and security incidents.Assist with onboarding and offboarding processes to ensure proper access management.Work closely with IT, security, and development teams to implement and manage Azure AD solutions.Azure Network Admin Activities :
Design and implement Azure network solutions, including virtual networks, subnets, network security groups (NSGs), and routing configurations.Manage and maintain azure network services such as Azure VPN Gateway, Azure ExpressRoute, Azure Firewall, Azure Load Balancer, and Azure Traffic Manager.Monitor network performance and troubleshoot network-related issues to ensure optimal performance and availability.Implement and manage network security measures, including firewalls, intrusion detection / prevention systems (IDS / IPS), and security policies.Conduct regular network assessments and audits to ensure compliance with industry standards and best practices.Azure Security Related Activities :
Establish security policies, standards, and procedures for Azure environments.Conduct risk assessments and vulnerability analyses to identify potential threats.Design secure architectures for Azure cloud solutions, including network, application, and data security.Design and implement secure hybrid cloud solutions, integrating on-premises and Azure resources.Configure Azure security services, such as Azure Security Centre, Azure Defender, and Azure Sentinel, Azure Policy, Azure BlueprintsImplement network security measures, including Azure Firewall, Network Security Groups (NSGs), and Virtual Private Networks (VPNs).Deploy secure development practices, integrating security into CI / CD pipelines with tools like Azure DevOps.Implement continuous monitoring and logging using Azure Monitor, Azure Log Analytics, and Azure Sentinel.Maintain comprehensive documentation of security policies, procedures, and configurations.Ensure compliance with regulatory requirements and industry standards (SOC2, GDPR, ISO 27001).MS SQL Server DBA Tasks :
Migrating a database from on-premises to the Azure cloudConfiguring Database for optimal performance and securityIndexing Strategies for optimization & indexed views creationWriting scripts to schedule regular maintenance tasks, automate backups, or generate reportsDeveloping and implementing strategies and procedures for disaster recoveryDesign, build, testing of DR sites configuring Standby Database by Log shipping to DR site / cloudConfiguring HA using Failover Cluster Instances (FCI) / Database MirroringPerforming Periodic Disaster recovery DR-Drills at agreed frequencyScheduling regular online / offline full backups, periodic differential backups, transaction log backupsEnsuring compliance with YMC IT governance for Application SecurityManaging user access, roles, permissions, enforcing password policies, configuring database auditingImplementing Row-Level Security (RLS), Transparent Data Encryption (TDE) to protect data at rest.Security audits covering Windows and SQL Server authenticated accounts.IT Risks Management (Risk Identification & Mitigation)Investigating and resolving database-related issues, such as performance problems, data corruption, connectivity errors, and other system failuresMonitoring SQL Server performance metrics (CPU and memory usage), analyzing database wait statistics.Identifying and resolving performance bottlenecks Using dynamic management views (DMVs) and performance monitoring tools (such as SQL Server Profiler or Extended Events)Optimizing query execution plans, re-writing queries, utilizing query hints or plan guidesServer Parameter configurations to improve response times and resource utilization.Handling Developers Requests for script runs for packages, functions, procedures, new tables etc.Clone, refresh or replace an existing database with a copy from another instanceApplying SQL Server patches, service packs, and updates to ensure the database system remains up-to-date with the latest bug fixesPlanning and executing SQL Server version upgradesImplementing strategies such as partitioning or horizontal scaling to manage large databasesOther Tasks :
Identify potential risks or issues before they escalateDealing with Customers for issuesEmbrace change, adapt quickly to shifting Database needs or conditions.Maintaining documentation of database configurations, processes, and proceduresGenerating reports on database performance, availability, and security metrics for management and compliance purposesPay attention to details to ensure project requirements and deliverables are met accuratelyReview project documentation, monitor progressWork closely with diverse teams, stakeholders, and clientsProvide Consultancy to the Customers
Mandatory Skills
Azure AD, On-premises AD, Window Server Administrator, PowerShell Programming.