Sr Administrator (Support & Operations) (IN)

HCLTech

8+ yrs India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking a Senior Administrator to oversee critical support and operations for MS SQL Server databases. This role requires extensive experience in administration, implementation, and maintenance of SQL Server environments, ensuring high availability and performance.

The position involves managing all aspects of database operations, from installations and upgrades to advanced configurations like Always On and replication models. A strong understanding of database design, capacity planning, and performance optimization is essential for success.

Responsibilities

Manage and maintain MS SQL Server databases across Development, QA, Staging, and Production environments.

Execute installations, upgrades, and patch management for SQL Server instances and service packs.

Implement and manage Always On availability groups, database mirroring, and various replication models (Snapshot, Merge, Transactional).

Optimize database performance through tuning and utilizing tools like DMV and Query Store.

Perform database migrations using in-place and side-by-side upgrade strategies.

Design and implement database structures, including data files and filegroup organization.

Ensure effective capacity planning for database growth and resource utilization.

Maintain comprehensive system documentation and contribute to release management processes.

Qualifications

A minimum of 8 years of hands-on experience in MS SQL Server Database Administration and Implementation is mandatory.

Demonstrated expertise in OLTP, web-based, production, and development environments, including installations and upgrades.

Proficiency in configuring and managing SQL Server Always On availability groups.

Strong skills in performance optimization and tuning, with experience using DMV and Query Store.

Proven ability to upgrade and migrate SQL Server databases from lower to higher versions.

Extensive experience with database mirroring, replication models, and log shipping.

Expertise in database design, capacity planning, and server migration techniques.

Solid understanding of Windows OS, virtualization, storage, and networking principles.

Excellent communication skills and the ability to work independently are required.

Essential Skills

MS SQL Server AdministrationDatabase ImplementationSQL Server InstallationsSQL Server UpgradesAlways On ConfigurationPerformance TuningDMVQuery StoreService Pack InstallationDatabase MigrationDatabase MirroringReplication (SnapshotMergeTransactional)SQL ReplicationLog ShippingDatabase DesignCapacity PlanningWindows OSVirtualizationStorageNetworkingPatch ManagementRelease ManagementSystem Documentation

Highlights

  • Actively hiring

More Details

RoleSr Administrator (Support & Operations) (IN)
DepartmentDatabase Administration
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting