Manage the day-to-day operations of enterprise database platforms, including configuration, maintenance, patching, backups, restores, performance, security, and capacity.

Administer, maintain, and optimize Microsoft SQL Server environments across on-premises, virtualized, and cloud-hosted platforms.

Monitor database health, performance, job execution, storage utilization, blocking, deadlocks, replication, availability groups, and backup success.

Perform database performance tuning, including query analysis, indexing strategy, execution plan review, statistics maintenance, wait analysis, and resource optimization.

Implement and support high availability and disaster recovery solutions, including SQL Server Always On Availability Groups, clustering, log shipping, replication, backups, and restore testing.

Plan and execute database maintenance activities, including index maintenance, integrity checks, patching, upgrades, and lifecycle management.

Support database capacity planning, storage forecasting, performance baselining, and scalability planning for business-critical systems.

Provide after hours on-call support on a rotation schedule with other staff members.

Maintain database security controls, including authentication, authorization, least-privilege access, role-based permissions, encryption, auditing, and privileged access review.

Partner with Security and Infrastructure teams to support secure database connectivity, certificate use, service accounts, firewall rules, vulnerability remediation, and patch compliance.

Protect the integrity of enterprise data through routine DBCC checks, backup validation, restore testing, change review, and controlled release practices.

Review and support database changes, schema updates, stored procedures, SQL Agent jobs, integrations, and application releases to reduce operational risk.

Sr SQL Administrator

Responsibilities

Qualification

Required

Benefits

Company

Penumbrainc

More roles at Penumbrainc