Talent.com
This job offer is not available in your country.
(Only 24h Left) Azure AD & MS SQL Server Administrator

(Only 24h Left) Azure AD & MS SQL Server Administrator

Yamaha Motor Solutions IndiaFaridabad, Haryana, India
22 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

    Only 24H Left • Faridabad, Haryana, India

    Related jobs
    • Promoted
    Azure AD & MS SQL Server Administrator

    Azure AD & MS SQL Server Administrator

    Yamaha Motor Solutions IndiaFaridabad, Haryana, India
    Set up & Maintain Azure Hybrid Cloud Core Infrastructure.Install, maintain & upgrade MS SQL Server Database on Azure Cloud in a Secure, HA & DR Environment. Active Directory (AD), ADFS Administratio...Show moreLast updated: 30+ days ago
    • Promoted
    Database Administrator

    Database Administrator

    SMC GroupDelhi, India, India
    JD PostgreSQL / MongoDB / SQL Server DBAWork experience : 3+ years.Hands-on experience in PostgreSQL / MongoDB / SQL Server Database Administration and Maintenance in Windows / Linux Environment with proficie...Show moreLast updated: 30+ days ago
    • Promoted
    Linux System Administrator (AWS Specialist)

    Linux System Administrator (AWS Specialist)

    MGT-COMMERCE GmbHDelhi, IN
    Do you live and breathe Linux? Do you enjoy building and managing servers in the cloud?.Linux-focused System Administrator. AWS infrastructure and keep systems running at peak performance.Setting up...Show moreLast updated: 30+ days ago
    • Promoted
    Azure Intune & Windows Hybrid Cloud Administrator-1

    Azure Intune & Windows Hybrid Cloud Administrator-1

    Yamaha Motor Solutions IndiaFaridabad, Haryana, India
    Set up & Maintain On-premises Active Directory, Azure Hybrid Cloud Infrastructure.Windows Administration on VMWARE / Hyper-V in Datacenter & Backup Administrator. On-premise Active Directory Administr...Show moreLast updated: 9 days ago
    • Promoted
    Aurora PostgreSQL Database Administrator

    Aurora PostgreSQL Database Administrator

    Tata Consultancy ServicesDelhi, India
    Years of Experience : : 7 to 12.Strong experience in Cloud DB Administration - Must have worked on Postgres - Oracle experience is good to have - Good communication and negotiation skills.Lead and b...Show moreLast updated: 4 days ago
    • Promoted
    Senior Oracle Database Administrator

    Senior Oracle Database Administrator

    DigiKey Global Capability CenterDelhi, India
    Position Overview : This position is responsible for execution of standard tasks that fall under the database administration domain. Responsibilities : Acquire workable knowledge of Snowflake, DataOps...Show moreLast updated: 4 days ago
    • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    Tata Consultancy ServicesDelhi, India
    Senior Application DBA / Oracle developer / designer Location : .Skills Required : Primarily focused on optimizing PL SQL and SQL. analyzing existing packaged procedures and designing / developing new objec...Show moreLast updated: 4 days ago
    • Promoted
    Senior Sql Database Administrator

    Senior Sql Database Administrator

    LTIMindtreeDelhi, India
    Role : Senior Sql Database Administrator Experience : - 5-9.Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022 Installing Service Pack...Show moreLast updated: 4 days ago
    • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    LTIMindtreeNoida, Uttar Pradesh, India
    Experience Range : 3 to 5 years.Notice Period : Immediate joiners.Install, configure, and maintain Oracle databases (12c,19c). In charge of developing and implementing database backups and disaster re...Show moreLast updated: 17 days ago
    • Promoted
    SQL Database Administrator

    SQL Database Administrator

    Tata Consultancy ServicesDelhi, India
    Experience on SQL Server 2014 / 16 / 19 installation and upgrade activities.Database backup and restore skills, Point in Recovery. Experience in Database version upgrade.Database maintenance (Index re-b...Show moreLast updated: 4 days ago
    • Promoted
    MSSQL (Azure DBA)

    MSSQL (Azure DBA)

    LTIMindtreeDelhi, India
    Job Title - MSSQL DBA with Azure DBA.Location - Bangalore / Hyderabad / Coimbatore.Interested candidates please share your updated CV to v. V Philip Talent Acquisition LTIMindtree v.Show moreLast updated: 4 days ago
    • Promoted
    ORMB Developer

    ORMB Developer

    RIA Advisoryfaridabad, haryana, in
    Role : Senior Consultant - ORMB.Will be primarily responsible for the Implementation of one of the Oracle products ORMB within the framework guidelines and interacting with onsite teams / business use...Show moreLast updated: 7 days ago
    • Promoted
    IAM Analyst

    IAM Analyst

    Dexian IndiaDelhi, IN
    Contractual Role / Freelancer-3 Months.Skills-IAM, Data analysis or validation (Excel, VLookup, Macro), Query Language (SQL or PowerShell) , Python (Good-to-Have). Need basic IAM conceptual Knowledge....Show moreLast updated: 14 days ago
    • Promoted
    SQL Server Oracle DBA

    SQL Server Oracle DBA

    Litmus7Delhi, India
    We are looking for a dynamic and detail-oriented SQL Server-focused DBA with experience in Oracle as a secondary skill.The ideal candidate will handle the administration, performance tuning, monito...Show moreLast updated: 4 days ago
    • Promoted
    Senior Oracle Database Administrator

    Senior Oracle Database Administrator

    SoftengerDelhi, India
    Role : Oracle Database Administrator Location : Pune Title : System Analyst (Oracle DBA) The Advanced Customer Services (ACS) is a unit within the Oracle’s Customer Service Organization that establish...Show moreLast updated: 4 days ago
    • Promoted
    IFS Administrator

    IFS Administrator

    HighShine IT Solutions Private LimitedDelhi, India
    At Highshine IT Solutions, you’ll work directly under visionary leadership, where your contributions aren’t lost in bureaucracy. This is your chance to lead, to shape solutions, and see the impact o...Show moreLast updated: 4 days ago
    • Promoted
    snowflake Cloud Database Administrator

    snowflake Cloud Database Administrator

    Leading automobile GCCDelhi, India
    Cloud Platform Expertise : Familiarity with leading cloud platforms such as Amazon Web Services (AWS), Microsoft Azure, and Snowflake is essential. Understanding their database offerings, such as AWS...Show moreLast updated: 4 days ago
    • Promoted
    Cloud Database Administrator

    Cloud Database Administrator

    ZarthiGhaziabad, IN
    Job Description : Cloud Database Administrator (DBA).Zarthi is a technology service provider that acts as a catalyst for businesses. We have established relationships with companies and organizations...Show moreLast updated: 28 days ago
    • Promoted
    Linux Server Admin

    Linux Server Admin

    ZettaMine Labs Pvt. Ltd.Delhi, India
    Job Title : Linux Server Administrator Experience : .Hyderabad & Bangalore & Pune Shifts : .Job Summary : We are seeking a skilled and proactive. The ideal candidate will have strong hands-on expertise in...Show moreLast updated: 4 days ago
    • Promoted
    AWS Administrator

    AWS Administrator

    Tata Consultancy ServicesDelhi, India
    Greetings from TCS!!! TCS is hiring for AWS Admin Experience : 5+ years Location : Mumbai.Job Description - AWS Cloud architect certification OR AWS Sysops certifications Hands-on experience on follo...Show moreLast updated: 4 days ago