Sci-Cal is a fast-growing startup building cutting-edge cloud-based applications. We are looking for a Database Administrator (DBA) to design and implement a backup solution for our database hosted on an AWS Lightsail Windows VM, followed by ongoing support and optimization of our database environment.
Responsibilities
· Design and implement a reliable backup and recovery solution for a database running on a Windows VM (AWS Lightsail).
· Ensure database availability, security, and performance.
· Manage, optimize, and maintain SQL Server databases on Windows.
· Develop and optimize queries using T-SQL.
· Monitor database health and troubleshoot performance and connectivity issues.
· Automate backup processes using Windows Task Scheduler, PowerShell, or other scripting tools.
· Configure and maintain SQL Server Management Studio (SSMS) for database administration.
· Ensure proper disaster recovery planning and test restore procedures.
· Provide ongoing database maintenance, tuning, and optimization.
· Work closely with the development team to support database needs.
Required Skills & Experience
· Experience as a Database Administrator (DBA) managing SQL Server databases.
· Strong knowledge of SQL, T-SQL, and query optimization.
· Experience with SQL Server backups, recovery, and disaster recovery planning.
· Familiarity with AWS Lightsail and managing Windows-based cloud VMs.
· Experience with Windows Server administration (security, user access, services, and updates).
· Ability to automate backups and tasks using PowerShell or batch scripting.
· Strong troubleshooting skills for SQL Server performance and Windows VM issues.
· Knowledge of networking and firewall configurations relevant to AWS-hosted Windows VMs.
Preferred Skills
· Experience with SQL Server Agent for automating maintenance tasks.
· Familiarity with cloud storage solutions (e.g., AWS S3) for offsite backups.
· Understanding of Windows Event Logs and performance monitoring tools.
· Exposure to AWS security best practices (IAM roles, security groups, encryption).
Why Join Sci-Cal?
· Opportunity to lead critical database projects in a fast-growing startup.
· Work with cutting-edge cloud technologies.
· Flexible work environment.
· Competitive compensation package.
If you're a DBA with strong SQL Server experience and AWS Windows VM expertise, we'd love to hear from you! Apply today to join Sci-Cal.
