Engineer, IT Systems - DBA Specialist

Join to apply for the Engineer, IT Systems - DBA Specialist role at ScrollTab Overview We are seeking an experienced SQL Server DBA to install, configure, monitor, optimize, and maintain SQL Server instances across development, testing, and production environments. The role includes cloud-based database services, hybrid architectures, performance tuning, security, and disaster recovery planning. Responsibilities Install, configure, and maintain SQL Server instances across development, testing, and production environments. Manage database performance, security, backups, and recovery plans. Support database design, development, and deployment for application projects. Collaborate with developers to optimize database schemas, queries, and stored procedures. Provide support for database-centric application troubleshooting and issue resolution. Manage cloud-based database services, including Azure SQL Database, Azure Managed Instances, AWS RDS for SQL Server, and other cloud-native solutions. Implement and support hybrid database architectures and cloud migration strategies. Monitor and optimize cloud database performance and cost efficiency. Design and implement High Availability and Disaster Recovery (HA/DR) solutions in cloud and hybrid environments, including Azure Availability Zones, AWS Multi-AZ, and Always On. Test and maintain backup, recovery, and failover processes; ensure RTO and RPO. Implement database security best practices, including encryption, RBAC, and threat protection; ensure regulatory compliance. Develop automation scripts to streamline routine tasks using PowerShell, T-SQL, or other tools; implement monitoring and alerting; integrate with DevOps pipelines (e.g., Azure DevOps, AWS CodePipeline, Jenkins). Lead or participate in projects to migrate on-premises databases to Azure or AWS; modernize databases with cloud-native features. Use monitoring tools to track database health and performance; generate reports on usage and capacity planning. Maintain up-to-date documentation for database configurations, processes, and procedures. Collaborate with application development teams to design and optimize database architectures; mentor junior DBAs and engineers. Plan and execute SQL Server upgrades, migrations, and patching; evaluate new features and tools. Document processes, standards, and best practices for database and cloud environments. Qualifications Bachelor’s Degree; Major: Computer Science, Information Technology. Experience in lieu of required education is acceptable. Master’s preferred. 8+ years of experience as an SQL Server DBA, focusing on application support. 3+ years of experience managing cloud-based SQL Server environments on Azure and AWS. Hands-on experience with multiple database technologies, including relational and NoSQL databases. Expertise in database performance tuning, backup and recovery, disaster recovery, and high availability architectures. Strong understanding of database security practices and regulatory compliance. Expertise with SQL Server (2016 and later) and cloud database services (Azure SQL, AWS RDS, etc.). Strong understanding of T-SQL, query performance tuning, and indexing strategies. Proficiency with cloud-native tools like Azure Data Factory, AWS Glue, and Data Migration Services. Hands-on experience with containerized database environments using Docker or Kubernetes is a plus. Familiarity with ETL processes, data warehousing, and BI tools is desirable. Experience with large heterogeneous enterprise environments. Developing and enforcing data retention policies to comply with regulatory standards (e.g., HIPAA). Leading or participating in database migration projects; on-premises to cloud transitions or upgrades to newer technologies. Planning and executing regular disaster recovery drills to validate backup and restoration strategies. Incident management experience in diagnosing and resolving database-related incidents in high-pressure environments. Creating and maintaining detailed documentation for database systems, configurations, policies, and disaster recovery procedures. Job-Related Skills/Competencies Works with leaders and team members to drive change and influence decision making with objective metrics and strong partnerships. Ability to analyze problems using logic and reasoning to evaluate alternatives. Identifies and achieves challenging objectives; collaborates effectively with others. Maintains high levels of interest and enthusiasm; healthcare experience is a plus. Seniority level Mid-Senior level Employment type Full-time Job function Information Technology Industries IT Services and IT Consulting Disclaimer: Referrals increase your chances of interviewing at ScrollTab. #J-18808-Ljbffr ScrollTab