Database Administrator - SQL Server (7-10 yrs)

Job Responsibilities :

As a Senior SQL Server Database Administrator, you will be responsible for the design, implementation, and maintenance of critical SQL Server databases.

Your role will involve :

Database Administration :

- Installation, configuration, and upgrade of SQL Server instances.

- Performance tuning and optimization of SQL Server databases.

- Monitoring database health and proactively addressing issues.

- Implementing and maintaining backup and recovery strategies.

- Ensuring data integrity and security.

- Troubleshooting database-related problems.

High Availability and Disaster Recovery :

- Designing and implementing HA and DR solutions (i.e., AlwaysOn Availability Groups, Log Shipping).

- Performing failover and failback procedures.

- Ensuring business continuity and minimal downtime.

Security :

- Implementing robust security measures, including user access controls, encryption, and auditing.

- Staying up-to-date with security best practices and addressing vulnerabilities.

Cloud Migration and Management :

- Migrating SQL Server databases to cloud platforms (Azure SQL Database).

- Managing cloud-based databases, including performance tuning, security, and backup.

Technical Skills :

Core SQL Server Skills :

- Deep understanding of SQL Server architecture, components, and features.

- Proficiency in T-SQL scripting and query optimization.

- Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

- Knowledge of PowerShell scripting for automation.

Performance Tuning :

- Ability to identify performance bottlenecks and implement effective solutions.

- Experience with performance monitoring tools (i.e., SQL Server Profiler, Extended Events).

- Knowledge of indexing strategies, query optimization techniques, and execution plans.

High Availability and Disaster Recovery :

- Hands-on experience with AlwaysOn Availability Groups, Log Shipping, and mirroring.

- Understanding of failover clusters and clustering technologies.

Security :

- Knowledge of SQL Server security features, including role-based security, encryption, and auditing.

- Ability to implement secure database configurations and policies.

Cloud Technologies :

- Experience with Azure SQL Database and other cloud-based database services.

- Understanding of cloud migration strategies and best practices