SQL Performance Tuning DBA (Database Administrator)

Posted 20 Days Ago
Be an Early Applicant
Philippines
Senior level
Artificial Intelligence • Software
The Role
The SQL Performance Tuning DBA will optimize SQL queries, maintain SQL Server databases, and manage AWS RDS environments. Responsibilities include performance tuning, database design, backup and recovery strategies, and ensuring database security and availability. Collaboration with development teams is essential, utilizing monitoring tools to identify and resolve performance issues.
Summary Generated by Built In

Description

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.

Requirements

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.

Benefits

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.

Top Skills

SQL
The Company
31 Employees
Remote Workplace

What We Do

Nacre Capital is a global venture builder specialized in creating, building and growing disruptive start-ups with deep technologies that significantly impact lives.
We are an international team of entrepreneurs, business leaders and experts including – pioneering scientists, renowned technologists, researchers, growth experts and thought leaders – that together develop and transform ventures into world-class disruptive market-leading companies.
We bring onboard the best entrepreneurs and talent to imagine and create new ventures from scratch and work together to successfully transform novel ideas into fast-growing, market-leading companies.
Our inhouse portfolio of companies solve complex fundamental problems that impact society through real breakthrough innovation employing deep technology.

Similar Jobs

Mondelēz International Logo Mondelēz International

Performance Management Analyst

Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Hybrid
Manila, First District NCR, National Capital Region, PHL
90000 Employees
Hybrid
Manila, First District NCR, National Capital Region, PHL
289097 Employees
Hybrid
Manila, First District NCR, National Capital Region, PHL
289097 Employees
Hybrid
Manila, First District NCR, National Capital Region, PHL
289097 Employees

Similar Companies Hiring

TrainingPeaks (A Peaksware Company) Thumbnail
Software • Fitness
Louisville, CO
69 Employees
bet365 Thumbnail
Software • Gaming • eSports • Digital Media • Automation
Denver, Colorado
6100 Employees
Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account