SQL Database Administrator

OverviewThe SQL Database Administrator will be responsible for ensuring the optimal performance, availability, and security of our database systems. This role involves a keen understanding of SQL Server architecture, with a focus on performance profiling, permissions management, and data integrity practices. The ideal candidate will possess strong technical skills in SQL and related database technologies, along with an analytical mindset. The candidate will also have Azure experience.

ResponsibilitiesPerformance Profiling:

Monitor, analyze, and optimize the performance of databases to ensure they meet the needs of the business.

Use tools such as SQL Server Management Studio (SSMS) to identify and resolve performance bottlenecks.

Regularly conduct performance reviews and make necessary adjustments to database configurations for optimal operation.

Permissions Management:

Ensure that database users and applications have the appropriate permissions to access and modify tables, stored procedures, and other database objects.

Maintain column level encryption for data across clustered server environments.

Develop and implement policies for access controls, and audit logging.

Database Optimization:

Update databases to leverage foreign keys, indexes, and other features that enhance performance and integrity.

Perform database normalization to eliminate redundancy and improve data consistency.

Optimize stored procedures and application queries for efficiency and speed.

Load balancing , clustering, database tuning, and denormalization experience to maintain best performanceLeverage Data-tier application tools to maintain schema versioning and consistency in multiple databases.

Collaboration and Support:

Work closely with developers and other stakeholders to support database needs and address technical challenges.

Provide training and guidance on SQL Server technologies and best practices to team members as needed.

Support team when creating new columns/tables to optimize storage and data retrieval efficiency based on various factors such as data types.

Stay updated with the latest trends in database technology to continually improve our systems.

Backup and Recovery and Replication:

Develop, implement, and maintain a comprehensive backup and disaster recovery strategy.

Monitor backup logs and storage systems to ensure that all backups are successful, complete, and performed on schedule.

Conduct regular tests of the restore processes to validate effectiveness and to refresh lower environments with production like data.

Manage replication of databases across multiple servers in the cluster and review updates to before release to mitigate their impact on replication.

Data Sanitization:

Ensure that sensitive data is properly sanitized in lower environments and reduce unnecessary exposure of personal or sensitive information.