SQL Database Engineer

Job highlights
Identified by Google from the original job post
Qualifications
SQL Server Administration & Engineering – upgrade and migrate and troubleshoot databases
MSBI component – SSI
PowerShell OR Ansible expertise
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
Python
Eager to learn and able to work in a team environment
Hashicorp
Power BI
Including MSBI Components (SSAS, SSIS, SSRS)
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
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
Responsibilities
As a SQL Server Database Systems Engineer, 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
Database Administration: Oversee the installation, configuration, and maintenance of SQL Server databases, ensuring optimal performance, security, and availability
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
Job description
As a SQL Server Database Systems Engineer, 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.