What are the responsibilities and job description for the SQL Server DBA - GA position at Brandon Consulting?
Job Details
Responsibilities:
- Database Administration:Design, implement, maintain, and optimize SQL Server databases for performance, scalability, and high availability. This includes capacity planning, performance tuning, security management (user access, encryption), backup and recovery, and disaster recovery planning.
- Cloud Integration:Manage and administer SQL Server instances and related database services within cloud environments, specifically Microsoft Azure and Amazon Web Services (AWS). This involves deploying, configuring, migrating, and optimizing databases in cloud-native services (e.g., Azure SQL Database, Azure SQL Managed Instance, AWS RDS for SQL Server) and/or IaaS virtual machines.
- High Availability & Disaster Recovery:Implement and maintain high-availability solutions (e.g., Always On Availability Groups, failover clustering) and disaster recovery strategies in both on-premises and cloud environments.
- Performance Monitoring & Tuning:Proactively monitor database performance, identify bottlenecks, and implement solutions using tools like SQL Server Profiler, Performance Monitor, Dynamic Management Views, CloudWatch, and Azure Monitor.
- Security & Compliance:Enforce robust security protocols, including access controls, data encryption, and compliance with relevant regulations and policies (e.g., GDPR, HIPAA).
- AI/ML Integration:Explore and integrate AI/Machine Learning capabilities for database optimization, automation of routine tasks, predictive analytics on database performance, or supporting AI-driven applications that interact with SQL Server data. This may involve working with Azure Machine Learning, AWS SageMaker, or other AI platforms.
- Collaboration & Support:Work closely with development teams, data engineers, and other IT stakeholders to ensure seamless integration of applications with database systems, provide technical support, and offer guidance on best practices.
- Automation:Automate routine database tasks and operational workflows using scripting languages (e.g., PowerShell, Python) and cloud-native automation tools.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a SQL Server Database Administrator.
- Strong expertise in SQL Server administration, including installation, configuration, troubleshooting, performance tuning, and high availability solutions.
- Demonstrable experience with Microsoft Azure and/or AWS cloud platforms, specifically with database services and infrastructure management.
- Familiarity with AI/Machine Learning concepts and potential applications in database administration or data-driven solutions.
- Proficiency in T-SQL and scripting languages (e.g., PowerShell).
- Excellent problem-solving, analytical, and communication skills.
- Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, AWS Certified Database - Specialty) are a plus.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
