Havas Chicago Logo

Havas Chicago

Senior Database Administrator

Posted 9 Days Ago
Be an Early Applicant
In-Office
Chennai, Tamil Nadu, IND
Senior level
In-Office
Chennai, Tamil Nadu, IND
Senior level
Owns the reliability, security, performance, availability, backup, recovery, and lifecycle management of enterprise Microsoft SQL Server environments. Responsibilities include troubleshooting, tuning, patching, upgrades, high availability, disaster recovery, security administration, automation, incident leadership, migrations, BI workload support, documentation, and mentoring. The role partners with developers and data engineers on schema design, query optimization, releases, and modernization initiatives including Azure SQL adoption.
The summary above was generated by AI

Agency :

Havas Creative

Job Description :

The Senior Database Administrator is a hands-on senior technical role responsible for the reliability, availability, security, performance, recoverability, and lifecycle management of enterprise Microsoft SQL Server environments. The position owns operational and strategic administration of SQL Server 2019 and later across development, QA, staging, reporting, and production workloads. The successful candidate brings a minimum of seven years of database administration experience, deep SQL Server troubleshooting expertise, strong automation practices, and the ability to lead complex production support, upgrade, security, and recovery initiatives.
  • Administer, monitor, tune, patch, upgrade, and troubleshoot SQL Server 2019 and newer environments.

  • Own database integrity, availability, backup, restore, and disaster recovery procedures, including recurring recovery testing.

  • Implement and support high-availability solutions such as Always On Availability Groups and appropriate failover architectures.

  • Analyze execution plans, indexes, statistics, waits, memory, tempdb, storage, blocking, deadlocks, and concurrency issues.

  • Create database maintenance standards for consistency checks, backups, index/statistics care, jobs, retention, and capacity.

  • Administer security using least privilege, role-based access, encryption, auditing, service-account governance, and access reviews.

  • Partner with developers and data engineers on schema design, stored procedures, query performance, releases, and rollback planning.

  • Automate operational tasks using T-SQL, PowerShell, SQLCMD, SQL Agent, source control, and approved monitoring platforms.

  • Lead database incident response, root-cause analysis, corrective actions, and stakeholder communication.

  • Provide technical leadership for SQL Server migrations, consolidations, upgrades, Azure SQL adoption, and hybrid modernization.

  • Support Microsoft BI and integration workloads where SQL Server is a source or platform, including SSIS, SSRS, SSAS, and Power BI connectivity.

  • Maintain architecture diagrams, configuration baselines, runbooks, escalation procedures, and support documentation.

Qualification:

• Minimum 7 years of professional database administration experience, including senior ownership of enterprise Microsoft SQL Server environments.

• Advanced production experience with SQL Server 2019 or later, including installation, configuration, patching, security, performance, backup/recovery, and troubleshooting.

• Advanced T-SQL and deep understanding of SQL Server internals, indexing, query optimization, transactions, locking, and concurrency.

• Hands-on experience with HA/DR technologies and validated recovery procedures.

• Strong Windows Server, authentication, storage, networking, service account, certificate, and permission fundamentals.

• Experience automating DBA work with PowerShell, T-SQL, and source-controlled scripts.

• Experience leading complex incidents and communicating clearly under production pressure.

Measures of Success

· Improved database availability, recovery confidence, and adherence to maintenance and patching standards.

· Reduced recurring incidents and improved response time through monitoring, automation, and documented runbooks.

· Measurable improvements in critical query and workload performance.

· Secure, auditable, least-privilege database access with clear ownership and review practices.

· Successful upgrades and migrations with validated rollback and recovery plans.

General Competencies

· Hands-on ownership, sound judgment, attention to detail, and disciplined follow-through.

· Clear written and verbal communication with technical and non-technical stakeholders.

· Ability to mentor team members, lead design or incident reviews, and document repeatable standards.

· Commitment to security, data privacy, responsible technology use, and continuous learning.

Contract Type :

Permanent

Here at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.

Similar Jobs

9 Days Ago
In-Office
Chennai, Tamil Nadu, IND
Senior level
Senior level
eCommerce • Retail • Software
Owns enterprise database and data-platform operations across production and non-production environments. Responsibilities include health monitoring, backup and recovery, database refreshes, patching, upgrades, performance tuning, release support, incident response, troubleshooting, documentation, and automation. The role supports SQL Server, SSAS, Azure SQL Database, MongoDB, and Cosmos DB while collaborating with application, infrastructure, security, networking, cloud, storage, authentication, and vendor teams. Scheduled after-hours maintenance and priority incident support are required.
Top Skills: Azure Cosmos DbAzure Sql DatabaseMicrosoft Sql ServerMongoDBPowershellRedgate Sql BackupSql Server Analysis ServicesT-SqlWindows Server
18 Days Ago
In-Office
Chennai, Tamil Nadu, IND
Senior level
Senior level
Fintech • Payments • Financial Services
Administer PostgreSQL, Cassandra, and ClickHouse databases for high-volume fintech workloads. Design schemas, indexing, partitioning, replication, disaster recovery, and point-in-time recovery strategies. Tune queries and capacity, automate operations with Shell and Python, manage database security and compliance, and resolve production incidents with root-cause documentation. Collaborate with engineering teams, maintain technical documentation, and participate in 24/7 on-call support.
Top Skills: CassandraClickhouseCqlLinuxPl/PgsqlPostgresPythonShellSQLUnix
One Month Ago
In-Office
Senior level
Senior level
Legal Tech
Lead design, administration, tuning, and governance of enterprise databases (DB2, MS SQL Server, Oracle). Develop data models, manage migrations, backups, recovery, and security, coordinate upgrades, support integrations for reporting and analytics, and train staff while ensuring compliance and high availability.
Top Skills: CloudIbm Db2Ms Sql ServerOracleSQL

What you need to know about the Chennai Tech Scene

To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account