Dba - Noida, Uttar Pradesh, India - HCL Technologies

HCL Technologies

Verified Company

Noida, Uttar Pradesh, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

DBA:

Noida

Years

INDIA

Job Family

Development (Development)

Job Description (Posting).
- killQL Database/Database server Install/Configure/Decommission.
SQL Database Upgrade/Patch Recommend/Test/Install(2008,2012, 2014, 2016,2017 & 2019 )SQL Database Monitoring of MS SQL Servers, space usage etc.
SQL Database Storage (Capacity) recommendation and Capacity management for Databases.
SQL Database Backup/Recovery/Refresh and Backup tools.
SQL Database Security/Compliance.
SQL Database Maintenance/Purge.
SQL Database Disaster Recovery Plan/Procedure/Test.
SQL Database backups, Restore, Recovery, and Disaster Recovery Plans.

SQL server Migration and upgrading on-premisesConfiguring MS SQL server Security and managing permissionsBuild and Configure HA (SQL Failover Clustering) active/active & active/passive.

Configuring and troubleshooting Replication, log shipping,& Always-On (2008 ,2012, 2014, 2016,2017 & 2019 )managing Database object permissions, user accounts and passwords.

Creation of MS SQL server databases and Database objects.
Developing and implementing DBA Maintenance Plan ola hallengren scripts.
Scheduling and managing jobs & alerts on MS SQL Server.
Database Performance Tuning/Optimisation/troubleshootingmanaging reports and calls with clients on Critical Incidents and Changes for MS SQL servers.
Hands-on experience in managing and Configuring Elastic Pool and Azure SQL Database.

Responsible for the Migration from on-prem to Azure SQL VM and Azure SQL.Cloud migrations from On-Premises to Azure using tools like using DMA& DMS (Offline & Online).Strong knowledge in T-SQL & Power Shell Scripting.

Provide 24x7 support for critical production systems.
Role is to Install, Migrate, implement, Upgrade, and optimize the Performance of Databases.
Expertise on Microsoft SQL server having knowledge of oracle databases would be an added advantage.
Design and implement various Backup and Recovery strategies on multiple Database environments. Recovery of Database with no or m nimal data loss.

Configure and maintain Database Servers and processes, including Monitoring of system health and Performance, to ensure high levels of Performance, availability, and security.

Command on all versions of Windows servers. Extensive understanding of various Patch level compatibilities with Database releases.

(1.) To prepare and submit status reports (2.) To create work plans, monitor and track the work schedule for on time delivery as per the defined quality standards.

(3.) To develop and guide the team members in enhancing their technical capabilities and increasing productivity. (4.) To ensure process improvement and compliance in the assigned module, and participate in technical discussionsorreview. (5.) To understand the business requirements and map it to functional specifications

Qualification