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.
Similar Jobs
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.
