Senior Database Administrator (AWS / Redshift / MySQL)

The Senior Database Administrator (DBA) is responsible for the design, administration, optimization, and operational support of enterprise database environments hosted primarily in AWS cloud platforms. This role will focus on Amazon Redshift data warehouse environments and MySQL databases, ensuring high availability, performance, security, and reliability across production and non-production environments.

The Senior DBA will work closely with engineering, DevOps, data, and application teams to support data platforms, troubleshoot performance issues, implement database best practices, and contribute to the continuous improvement of the organization’s cloud data architecture.

Database Administration & Operations

• Administer, monitor, and maintain Amazon Redshift clusters and MySQL databases in AWS environments.
• Ensure database availability, performance, scalability, and reliability across production and non-production environments.
• Perform database installation, configuration, upgrades, patching, and migrations.
• Implement and manage backup, restore, and disaster recovery strategies.
• Monitor database health and performance and proactively address potential issues.

Performance Optimization

• Analyze and optimize database performance, queries, and indexing strategies.
• Identify and resolve database bottlenecks and resource contention issues.
• Implement performance tuning strategies for large-scale data warehouse workloads in Redshift.

Cloud Database Management

• Manage and optimize databases deployed in AWS environments, including:
• Amazon Redshift
• Amazon RDS
• EC2-hosted databases
• Work with AWS services such as CloudWatch, IAM, S3, and AWS Backup to support database operations.
• Support data lifecycle management and storage optimization strategies.

Security & Compliance

• Implement database security best practices, including encryption, access controls, and auditing.
• Manage database user access, roles, and privileges.
• Support compliance requirements, such as SOC 2, PCI, HIPAA, and internal security policies, where applicable.

Automation & DevOps Collaboration

• Work with DevOps teams to implement automation for database deployments, patching, and monitoring.
• Support Infrastructure as Code (IaC) initiatives using tools such as Terraform or CloudFormation where applicable.
• Assist in CI/CD pipelines for database changes and schema deployments.

Troubleshooting & Incident Management

• Provide L2/L3 database support for production incidents.
• Perform root cause analysis and implement preventive measures.
• Participate in on-call rotation for critical database systems if required.

Documentation & Reporting

• Maintain documentation of database configurations, procedures, and architecture.
• Produce operational and performance reports as required.
• Contribute to operational runbooks and knowledge base documentation.

• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
• 7+ years of experience in database administration.
• Strong experience with:
• Amazon Redshift
• MySQL
• Hands-on experience managing databases in AWS cloud environments.
• Experience with database performance tuning and query optimization.
• Strong understanding of:
• Data warehousing concepts
• High availability and disaster recovery
• Backup and recovery strategies
• Experience with monitoring and troubleshooting database environments.

Nice to Have

• Experience with Snowflake Data Cloud platform.
• Experience with database automation and scripting (Python, Bash, etc.).
• Knowledge of data governance and security frameworks.

Technical Skills

Databases

• Amazon Redshift
• MySQL
• Snowflake (preferred)

Cloud Platforms

• AWS (RDS, EC2, S3, IAM, CloudWatch)

#LI-AL1