Talent.com
This job offer is not available in your country.
Azure AD & MS SQL Server Administrator

Azure AD & MS SQL Server Administrator

Yamaha Motor Solutions Indiagurgaon, haryana, in
16 days ago
Job description

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 Administration
  • Active Directory (AD), ADFS Administration
  • Azure Devops CI / CD Pipelines Security setup Skill
  • MS SQL Server Administration
  • Window Server Administration,
  • Proficient PowerShell Scripting / .NET Programming
  • Knowledge of Project Management Documentation Artifacts for SDLC & Change Management
  • Good Document writing Skill on Microsoft Excel & PowerPoint Preparation
  • Programming 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 Infrastructure
  • Exam AZ-801 : Configuring Windows Server Hybrid Advanced Services
  • SC-300 : Microsoft Identity and Access Administrator
  • Microsoft Certified : Azure Database Administrator Associate (DP-300)
  • MCDBA / Microsoft Certified IT Professional (MCITP) Database certification

    • Experience : Relevant 8-10 Years

    Personal attributes :

  • Good Communication skills specially written, Excel and PowerPoint Preparation
  • Team 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 Blueprints
  • Implement 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 cloud
  • Configuring Database for optimal performance and security
  • Indexing Strategies for optimization & indexed views creation
  • Writing scripts to schedule regular maintenance tasks, automate backups, or generate reports
  • Developing and implementing strategies and procedures for disaster recovery
  • Design, build, testing of DR sites configuring Standby Database by Log shipping to DR site / cloud
  • Configuring HA using Failover Cluster Instances (FCI) / Database Mirroring
  • Performing Periodic Disaster recovery DR-Drills at agreed frequency
  • Scheduling regular online / offline full backups, periodic differential backups, transaction log backups
  • Ensuring compliance with YMC IT governance for Application Security
  • Managing user access, roles, permissions, enforcing password policies, configuring database auditing
  • Implementing 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 failures
  • Monitoring 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 guides
  • Server 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 instance
  • Applying SQL Server patches, service packs, and updates to ensure the database system remains up-to-date with the latest bug fixes
  • Planning and executing SQL Server version upgrades
  • Implementing strategies such as partitioning or horizontal scaling to manage large databases

    • Other Tasks :

  • Identify potential risks or issues before they escalate
  • Dealing with Customers for issues
  • Embrace change, adapt quickly to shifting Database needs or conditions.
  • Maintaining documentation of database configurations, processes, and procedures
  • Generating reports on database performance, availability, and security metrics for management and compliance purposes
  • Pay attention to details to ensure project requirements and deliverables are met accurately
  • Review project documentation, monitor progress
  • Work closely with diverse teams, stakeholders, and clients

    • Provide Consultancy to the Customers

    Mandatory Skills

    Azure AD, On-premises AD, Window Server Administrator, PowerShell Programming.

    Create a job alert for this search

    Administrator Server • gurgaon, haryana, in