---

---

Location

Noida | India

---

Job description

Job Summary/Objective:

Install, maintain, upgrade MS SQL Server Database on Azure Cloud in a Secure, HA & DR Environment

Skills:

MS SQL Server Administration

Azure Cloud Administration

Window Server Administration, PowerShell Scripting

(Nice To Have Experience) on Active Directory (AD), ADFS , Hyper-V, Backup Tools

Certifications:

MCDBA/Microsoft Certified IT Professional (MCITP) Database certification

Microsoft Certified: Azure Database Administrator Associate (DP-300)

Experience: 4-6 Years

 

Personal attributes:

• Good communication skills specially written
• Effectively articulates ideas, convey information
• Addresses customer inquiries or issues promptly and professionally
• Clear and concise communication is essential for understanding requirements & expectations

Reporting Structure: Report to AGM IT-Infra

Work Environment : Posting at Greater Noida, May have to travel Faridabad, Chennai, Overseas

Skills Required : SQL Ser Administrator, Azure Cloud Administrator, Windows Server Administrator
Education/Qualification : BE/MCA
Role :

Main Tasks:

• Designing and creating databases based on business requirements
• Installing Database Server instances in Azure Cloud Environment
• Migrating a database from on-premises to the Azure cloud
• Configuring Database for optimal performance and security
• Indexing Strategies for optimization & indexed views creation
• Implementing backup and recovery strategies
• Writing scripts to schedule regular maintenance tasks, automate backups, or generate reports
• Ensuring data protection and minimize downtime
• Developing and implementing strategies and procedures for disaster recovery
• Ensuring minimum data loss and downtime in case of catastrophic events
• 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
• Performing restoration in case of data loss or system failures
• 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)
• Monitoring & verifying backups’ integrity
• 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)
• Implementing database maintenance tasks (reindexing, updating statistics)
• 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
• Security patches, and feature enhancements.
• Planning and executing SQL Server version upgrades
• Estimating storage requirements and planning for future capacity needs
• 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

Experience : 4 to 8 Years

---

Job tags

---

---

Salary