AWS Aurora Database Analyst (Washington, DC)

Cedent; Washington (District of Columbia); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading technology company in Washington, D.C. seeks an experienced AWS Aurora Database Analyst. The ideal candidate will be responsible for optimizing analytics performance, troubleshooting, and serving as a subject matter expert. A Bachelor's degree in Computer Science and substantial experience with AWS Aurora are required. This role offers the opportunity to work collaboratively with stakeholders to address business needs.

Qualifications

• 10 years of comprehensive database experience.
• 9 years specifically with AWS Aurora database.
• Strong experience in performance tuning and SQL querying.

Responsibilities

• Optimize analytics performance through SQL queries.
• Serve as an SME to resolve issues.
• Collaborate with stakeholders for business requirements.

Skills

Performance tuning

SQL queries

Issue resolution

Database monitoring

Troubleshooting

Education

Bachelor's degree in Computer Science or related field

Tools

DBeaver

SQL Workbench

Job description

Overview

Summary: We are seeking an experienced AWS Aurora Database Analyst to join our team in Washington, D.C. The ideal candidate will have a Bachelor’s degree in Computer Science or related field, with 10 years of comprehensive database experience, including 9 years specifically with AWS Aurora database. The role involves optimizing analytics performance, serving as a Subject Matter Expert (SME) for issue resolution, collaborating with stakeholders to understand business requirements, and ensuring data quality through SQL queries. Additionally, the candidate should excel in performance tuning, database monitoring, and troubleshooting.

Responsibilities

• Optimize analytics performance through SQL queries on various relational databases.
• Serve as an SME to resolve issues and optimize queries on PostgreSQL.
• Collaborate with stakeholders to understand business requirements and design technical solutions.
• Create and maintain documentation related to system architecture and design.
• Develop SQL queries for data quality validations and reporting purposes.
• Extract, manipulate, and calculate information as per project requirements.
• Capture detailed defect information for timely resolution during defect management.
• Utilize SQL querying tools such as DBeaver, SQL Workbench, etc.
• Identify and rectify database performance issues, including query optimization and index tuning.
• Monitor database activity and performance using appropriate monitoring tools and collaborate with cross-functional teams for issue resolution.

Qualifications

Required: Bachelor's degree in Computer Science or related field, with 10 years of comprehensive database experience, including 9 years specifically with AWS Aurora database.