SQL Database Administrator

SQL DBA

Responsibilities

• Deploy TDE across all non-Cardinal databases to ensure encryption at rest.

• Configure and maintain TDE settings, keys, and certificates in line with security policies.

• Ensure minimal disruption during the encryption process while maintaining system availability.

• Implement and enforce best practices for database administration, focusing on performance, security, and availability.

• Optimize database performance through efficient configuration, monitoring, and tuning.

• Maintain database security by managing access controls, auditing, and monitoring for suspicious activity.

• Address and resolve audit findings related to database security and operations, specifically those raised in audits.

• Assist in creating and updating documentation to ensure continuous compliance with audit standards.

Requirements

• Experience as a SQL DBA.

• In-depth knowledge of TDE (Transparent Database Encryption) setup and management.

• Familiarity with database security concepts (e.g., user authentication, encryption, auditing).

• Experience with backup and recovery technologies for databases.

• Understanding of database performance tuning and capacity planning.

• Proficient in PowerShell, or equivalent scripting languages for automation.

• Hands-on experience with database monitoring tools.