About The Role
Were looking for a skilled and motivated Database Administrator (DBA) to join our team and support both on-premises SQL Server databases and cloud-based environments in AWS (RDS, Redshift). Youll be responsible for ensuring database performance, stability, and scalability.This role is ideal for someone who thrives in both traditional database environments and cloud-native architectures, enjoys problem-solving, and takes ownership of incident response and continuous improvement.
Responsibilities
- Administer, configure, and maintain Microsoft SQL Server (on-premises) and AWS RDS/Redshift environments.
- Perform regular maintenance tasks such as backups, restores, patching, and capacity planning.
- Manage database security, user access, and roles across environments.
- Provision, configure, and manage AWS RDS (SQL Server, PostgreSQL) and Redshift instances.
- Implement backup strategies, monitoring, and disaster recovery solutions in the cloud.
- Automate routine database tasks and processes using AWS tools and scripting.
- Deploy and monitor AWS Glue and AWS Lambda.
- Troubleshoot ETL job failures, ensure data quality, and support the timely delivery of data.
- Use tools like AWS CloudWatch, SolarWinds, and Redgate SQL Monitor for real-time performance tracking and alerting.
- Identify and resolve performance bottlenecks in SQL queries, indexes, and server configurations.
- Act as a point of contact for database-related incidents and outages.
- Perform root cause analysis, document findings, and work with engineering teams to implement long-term fixes.
- Maintain comprehensive and up-to-date documentation on database systems, configurations, and procedures.
- Collaborate with development and DevOps teams to support database and data platform needs.
- Contribute to automation and infrastructure improvements in cloud and hybrid environments.
- Maintain detailed documentation and knowledge base articles for internal teams.
Qualifications
- Experience as a database administrator, with a strong foundation in SQL Server administration, backup/restore strategies, and high availability solutions (e.g., Always On, clustering).
- Hands-on experience managing AWS RDS (SQL Server/PostgreSQL) and Amazon Redshift, including provisioning, scaling, backups, snapshots, and security configurations.
- Proficiency with monitoring tools like AWS CloudWatch, SolarWinds, and Redgate SQL Monitor, with the
ability to configure alerts, identify trends, and proactively address performance bottlenecks.
- Expertise in performance tuning for :
- SQL Server : Execution plan analysis, indexing strategies, TempDB optimization, query tuning.
- RDS : Parameter group tuning, performance insights, instance sizing.
- Redshift : WLM configuration, vacuum/analyze, distribution/sort keys, and query optimization.
- Strong understanding of database security best practices, user access controls, encryption, and auditing.
- Experience managing incident response, including root cause analysis, mitigation planning, and follow-up documentation.
- Ability to create and maintain detailed runbooks, SOPs, and knowledge base articles for repeatable processes and troubleshooting procedures.
- Comfortable working in hybrid environments, with coordination across on-premises and cloud-based systems.
- Familiarity with automation and scripting using PowerShell, Python, or Bash to streamline database tasks and monitoring.
- Hands-on experience with CI/CD pipelines to support database changes and deployments using tools like AWS CodePipeline or GitLab CI.
- Experience integrating database deployments into DevOps pipelines, including version-controlled DDL/DML scripts, pre-deployment checks, and rollback strategies.
- Ability to perform manual deployments when required (e.g., via SSMS, pgAdmin, or SQL scripts) while adhering to change management processes.
- Ability to work independently, manage priorities, and take ownership of tasks in a distributed team environment.
- Strong communication and interpersonal skills, with the ability to explain technical concepts clearly to both
technical and non-technical stakeholders.
- A proactive and detail-oriented mindset, with a focus on continuous improvement and system reliability.
(ref:hirist.tech)
