Database Administrator

**Summary/Objective**

**Job Overview**

**Key Responsibilities**

**Database Management & Administration**
- Design, configure, and maintain **AWS RDS (PostgreSQL, MySQL, SQL Server), Microsoft SQL Server, and MongoDB databases.**
- Ensure high availability, performance, and scalability of all databases
- Implement **backup and disaster recovery** strategies, including point-in-time recovery (PITR) and failover mechanisms.
- Monitor and optimize database performance using tools like **AWS CloudWatch, SQL Profiler, and MongoDB Atlas Performance Advisor**:

- Manage database **provisioning, patching, and version upgrades** in production and non-production environments

**Security & Compliance**
- Enforce **data security best practices**, including **encryption, access controls (IAM, RBAC), and compliance with HIPAA** and other healthcare regulations
- Perform** regular security audits** and vulnerability assessments using tools like **AWS Security Hub and Tenable**:

- Implement and maintain **database auditing, logging, and monitoring** to detect and prevent unauthorized access

**Optimization & Automation**
- Analyze and optimize **query performance, indexing strategies, and database schema design.**:

- Automate database maintenance tasks using** Terraform, AWS Lambda, PowerShell, or Python scripts.**:

- Work with DevOps to integrate **CI/CD pipelines for database changes** (e.g., Flyway, Liquibase).
- Optimize storage and resource utilization in AWS to **reduce costs while maintaining performance**

**Collaboration & Support**
- Work closely with **DevOps, Engineering, and Security teams** to ensure database reliability and security.
- Provide guidance and best practices to developers on database design, indexing, and query performance tuning.
- Participate in on-call rotation for database-related incidents and outages.

**Required Qualifications & Experience**
- 5+ years of experience as a Database Administrator in a SaaS or cloud environment.
- Strong expertise in AWS RDS (PostgreSQL, MySQL, or SQL Server).
- Proficient in Microsoft SQL Server, including T-SQL, SSMS, and high-availability configurations.
- Experience with NoSQL databases like MongoDB (Atlas preferred).
- Deep understanding of performance tuning, query optimization, indexing strategies, and partitioning.
- Familiarity with Terraform, AWS CloudFormation, or other Infrastructure-as-Code (IaC) tools.
- Experience with backup and disaster recovery strategies in AWS and on-prem environments.
- Knowledge of database replication, clustering, and high-availability architectures.
- Proficiency in scripting (Python, PowerShell, Bash) for automation.
- Strong knowledge of security best practices (IAM, RBAC, data encryption, audit logging).
- Familiarity with healthcare compliance requirements (HIPAA, HITRUST) is a plus.

**Preferred Skills & Certifications**
- AWS Certified Database - Specialty
- Microsoft Certified: Azure Database Administrator Associate
- MongoDB Certified DBA Associate
- Experience with AI/ML-driven database performance optimization tools
- Exposure to data warehousing and analytics (Redshift, Snowflake, or BigQuery)

**Other Duties**
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without advance notice. Any changes may be for an indeterminate time frame.

**EEO Statement**
Reveleer provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristics protected by federal, state, or local laws.