SQL DBA

SQL Server AdministratorDTech DBA Team is looking for a SQL Server Administrator to help transfer knowledge from a group member that is retiring and also backfill the responsibilities of another team member that is on leave.This is a contract for hire opportunity for a SQL Server Administrator with experience. The work location for this position is at 799 G ST, 95814 with limited remote work options.We are seeking a skilled and experienced Microsoft SQL Server Database Administrator (DBA) with expertise in SQL Server Reporting Services (SSRS) and Transact-SQL (TSQL). The successful candidate will be responsible for the design, implementation, maintenance, and optimization of our SQL Server databases, ensuring high performance, availability, and security. Additionally, proficiency in SSRS and TSQL is crucial for developing and maintaining reports and queries.Database ManagementDesign, implement, and maintain SQL Server databases.Monitor database performance and optimize for efficiency.Ensure data integrity, security, and availability.SSRS DevelopmentDevelop and maintain SSRS reports for various business requirements.Collaborate with stakeholders to gather reporting requirements.Optimize and enhance existing SSRS reports for performance and usability.TSQL DevelopmentWrite and optimize complex TSQL queries for data retrieval and manipulation.Troubleshoot and resolve database-related issues.Collaborate with application developers to optimize SQL queries within applications.Backup and RecoveryImplement and maintain database backup and recovery strategies.Perform regular backups and ensure data restoration capabilities.Security and ComplianceImplement and enforce database security measures.Ensure compliance with data protection and privacy regulations.CollaborationCollaborate with DBA team as well as cross-functional teams to understand and address database related requirements.Provide technical support and expertise to team members.QualificationsBachelor's degree in Computer Science, Information Technology, or related field.Proven experience as a Microsoft SQL Server Database Administrator.Strong expertise in SQL Server Reporting Services (SSRS) and Transact-SQL (TSQL).Experience in database design, optimization, and troubleshooting.Familiarity with database security and compliance standards.Strong analytical and problem-solving skills.Excellent communication and collaboration skills.Preferred SkillsPerformance tuning and optimization of SQL Server databases.Experience with SQL Server Integration Services (SSIS).Familiarity with cloud-based database solutions.Experience in Ansible is a plus.