Tower Lead - AzureMSSQL DBA, Microsoft Azure (IN)

HCLTech

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

Job description

Seeking a seasoned Tower Lead with expertise in Azure MSSQL DBA and Oracle to spearhead database architecture and management. This role is pivotal in ensuring the scalability, performance, and security of our critical database systems.

Ideal candidates will possess a deep understanding of relational database engines, advanced scripting, and cloud-native database solutions. Your contribution will be instrumental in maintaining high availability and driving seamless database migrations and upgrades.

Responsibilities

Architect and design robust, scalable database solutions, establishing data modeling standards and overseeing schema design for both OLTP and OLAP applications.

Serve as the ultimate escalation point for complex performance issues, diagnosing and resolving critical bottlenecks such as locking, deadlocking, and latching.

Design, implement, and manage enterprise-grade high availability and disaster recovery solutions, including cluster configurations and backup/recovery strategies.

Establish and enforce stringent database security protocols, covering encryption, access control, and comprehensive audit logging.

Plan and execute zero- or low-downtime database migrations and upgrades, ensuring minimal disruption to operations.

Qualifications

A minimum of 7 years of extensive experience in enterprise database administration, engineering, or performance tuning is required.

Possess in-depth knowledge of relational database engines, storage, memory management, query optimizers, and concurrency controls.

Demonstrate mastery in advanced SQL, procedural languages (T-SQL, PL/SQL, PL/pgSQL), and automation scripting (PowerShell, Bash, Python).

Exhibit strong familiarity with underlying infrastructure, including SAN/NAS, OS-level configurations (Windows Server/Linux), and virtualized environments (VMware).

Showcase proven experience managing cloud-based relational databases (AWS RDS, Azure SQL Database, Google Cloud SQL) and hybrid-cloud architectures.

Essential Skills

Azure SQL DatabaseMSSQL DBAOracleSQLT-SQLPL/SQLPL/pgSQLPowerShellBashPythonSANNASWindows ServerLinuxVMwareAWS RDSGoogle Cloud SQLHA/DRDatabase ArchitecturePerformance TuningSecurityComplianceData ModelingSchema DesignOLTPOLAPLockingDeadlockingLatch issuesQuery OptimizationExecution PlansFailover MechanismsCluster ConfigurationsSQL Server Always On Availability GroupsPostgreSQL ReplicationBackup/RecoveryData EncryptionData MaskingRBACAudit LoggingZero-Downtime MigrationLow-Downtime MigrationDatabase Upgrades

Highlights

  • Actively hiring

More Details

RoleTower Lead - AzureMSSQL DBA, Microsoft Azure (IN)
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting