As a SQL DBA, you will engineer and support database systems including analysis, planning, design, development, implementation, and upgrades. Applying established architectural and engineering best practices, you will take charge of complex systems to achieve strategic objectives in the areas of solving for client, infrastructure availability and automation, as well as a strong focus on database environment security.
Top Skills:
SQL Server Administration & Engineering - upgrade and migrate and troubleshoot databases
MSBI component - SSI
PowerShell OR Ansible expertise
Must Have:
Minimum of 5 years - 8 years of experience in SQL Server Administration and Engineering
Need someone to fully manage our on-prem SQL Server and Azure environment.
Someone w/ expertise in all key components of SQL server administration
Basic automation in PowerShell, Jenkins, Ansible, Gitlab and CI/CD pipelines
MSBI - SSIS integration experience 25% of the role
Upscaling
Infrastructure of SQL Server
Nice to Have:
Python
Eager to learn and able to work in a team environment
Hashicorp.
Power BI
Key Responsibilities & Duties:
Database Administration: Oversee the installation, configuration, and maintenance of SQL Server databases, ensuring optimal performance, security, and availability. Including MSBI Components (SSAS, SSIS, SSRS)
High Availability and Disaster Recovery: Implement and manage SQL Server Always on Availability Groups (AOAG) and other high availability and disaster recovery (HADR) solutions.
Automation and Scripting: Develop and maintain automation scripts using PowerShell, Ansible and other tools to streamline database management tasks.
Database Migrations: Plan and execute database upgrades and migrations with minimal downtime.
Performance Tuning: Monitor and optimize database performance through indexing, query optimization, and resource management.
Backup and Recovery: Develop and implement robust backup and recovery procedures.
Security Management: Ensure database security through the application of best practices and adherence to compliance requirements.
Monitoring and Maintenance:
Proactively monitor production databases to ensure high availability and performance.
Observe key database metrics such as performance, storage, and memory utilization.
Set up and manage automated alerts to identify and address issues Proactively.
Perform regular health checks and maintenance to prevent potential problems.
Collaboration: Work collaboratively within and outside the team and other departments to support application development, deployment, and maintenance.
Mentorship: Share knowledge and mentor junior team members, fostering a culture of continuous learning and improvement.
Incident Response: Act as a point of escalation for complex database issues, providing expert-level troubleshooting and resolution.
Qualifications:
Experience: Minimum of 10 years of experience administrating SQL Server databases and MSBI components.
Technical Skills:
Hands-on expertise with SQL Server Always On Availability Groups (AOAG).
Advanced scripting skills with PowerShell, Ansible or any other similar tool.
Proficient in database migrations and upgrades.
Hands-on expertise with MSBI components (SSAS/SSIS/SSRS)
Strong understanding of Windows Server administration.
Additional Knowledge and Experience Desired:
Bachelor's degree in computer science, Information Systems or related field, or an equivalent combination of education and work experience.
Experience with using Hashicorp Vault and/or CyberArk vaulting for access to SQL Server or other administrative IDs as needed
Experience working within Atlassian's Jira software for agile based feature and story creation and execution.
Experience with AWS, Azure or other cloud environments including technologies such as RDS, Azure SQL Database
Experience with using Delphix for database virtualization
Experience using database related products and technologies such as: ELK stack, Dynatrace and SolarWinds DPA
Experience with PowerBI Gateway management
Qualifications and Education Requirements:
Strong technical aptitude and ability to logically analyze and creatively solve complex issues independently.
Ability to effectively communicate both verbally and in writing to multiple levels of the organization.
Ability to work well with teams not centrally located.
Ability to be self-directed and collaborative in ambiguous situations.
Strong interpersonal skills and ability to work effectively with all levels throughout the enterprise.
Strong sense of ownership and the ability to work with limited set of requirements.
Ability and desire to train/mentor other team members.