SQL Performance Tuning DBA (Database Administrator)

We are seeking an experienced SQL Server DBA with expertise in query optimization, database

efficiency, and AWS RDS for SQL Server. The ideal candidate will have a strong background in

Microsoft SQL Server, performance tuning, and cloud-based database management. You will be

responsible for optimizing queries, designing efficient database structures, and ensuring the

performance, security, and availability of SQL Server databases hosted both on-premise and in

AWS RDS.

Key Responsibilities:

● Optimize SQL Queries: Analyze, review, and refactor existing SQL queries for improved

performance on both on-premise and AWS RDS-hosted SQL Servers.

● Database Maintenance: Monitor, maintain, and tune SQL Server databases, ensuring

high performance and availability in both on-premise and AWS RDS environments.

● AWS RDS Management: Configure, manage, and optimize SQL Server databases

hosted on AWS RDS, including backups, security, scaling, and monitoring.

● Index Management: Design, implement, and maintain indexing strategies to ensure

efficient query execution.

● Performance Tuning: Identify and resolve performance bottlenecks using SQL Profiler,

Performance Monitor, AWS CloudWatch, and other monitoring tools.

● Database Design: Collaborate with development teams to design efficient, scalable

database structures that meet business needs.

● Backup and Recovery: Implement backup and disaster recovery strategies for both

on-premise SQL Server databases and AWS RDS instances.

● Security Management: Ensure the security of databases, with a focus on AWS IAM

roles, encryption, and security best practices for cloud environments.

● Documentation: Maintain thorough documentation of database configurations,

optimizations, and AWS RDS configurations.

Qualifications:

● Experience: 5+ years of hands-on experience as a SQL Server DBA, with a focus on

performance tuning and query optimization, including 2+ years of experience managing

SQL Server databases on AWS RDS.

● Technical Skills:

○ Expertise in Microsoft SQL Server (versions 2016 and above).

○ Strong proficiency in T-SQL programming, query tuning, and stored procedures.

○ Experience with database indexing, partitioning, and normalization.

○ Familiarity with SQL Profiler, Extended Events, and Query Store.

○ Knowledge of AWS RDS for SQL Server, including setup, configuration, and

optimization.

○ Experience with AWS services like CloudWatch, IAM, S3, and EC2 in relation to

database management.

○ Expertise in replication, high availability (HA), disaster recovery (DR), and

clustering strategies.

○ Experience with database design, data modeling, and cloud-based scaling

strategies.

● Tools: Familiarity with AWS management tools, SSMS, Visual Studio, and third-party

monitoring tools.

● Performance Tuning: Proven ability to troubleshoot performance issues on both

on-premise and AWS RDS databases.

● Collaboration: Strong communication skills, with the ability to work closely with

development and IT teams.

● Certifications: AWS certifications (e.g., AWS Certified Database - Specialty, AWS

Solutions Architect) and Microsoft SQL Server certifications (e.g., MCSE: Data

Management and Analytics) are a plus.

Preferred Qualifications:

● Knowledge of DevOps principles, CI/CD pipelines, and automated database

deployments in AWS environments.

● Experience with hybrid database architectures (on-premise and cloud-based).

● Familiarity with PowerShell scripting and AWS CLI for automation tasks.

● Experience working with other AWS databases, such as Aurora or DynamoDB.