$ads={1}
SQL Server Database Administrator
Location: Remote/Eastern Time Zone
Permanent, Direct Hire
Constellation R.O. Writer Inc. (ROW) (https://www.rowriter.com), is a leading automotive software business and an innovative market leader with a long history of success in serving independent and franchised automotive repair shops. Their software helps these shops increase efficiency, predictability, and profits which has allowed ROW to become the trusted partner for thousands of businesses across North America.
Position Summary:
We are seeking a mid-level SQL Server Database Administrator who will be responsible for all aspects of operational support for SQL databases to deliver high levels of performance, availability, and security. You will also be responsible for designing, developing, and maintaining efficient database solutions and ETL processes using Microsoft SQL Server Integration Services (SSIS) and other related technologies.
Responsibilities:
- Installation/configuration, maintenance, and administration of SQL Server instances for business-critical applications in an Azure Cloud environment, including: Securing data, Provisioning user access, Back-ups and data recovery, Logging and monitoring, Managing upgrades, refreshes and new implementations
- Troubleshoot database issues individually or with other team members (analyze, solve, correct)
- Create a performance and tuning strategy to resolve performance issues
- Supporting daily operational needs of business-critical applications by ensuring that all Standard Operating Environment requirements are maintained, all compliance, version control/patching, Disaster recovery standards kept up to date.
- Work directly with Tier 3 support on database or Cloud related issues, as required
- Assist with Azure Cloud infrastructure maintenance and build
- Perform scheduled maintenance and support release deployment activities after hours
- Design, develop, and maintain SQL Server Integration Services (SSIS) packages to facilitate efficient data extraction, transformation, and loading (ETL) processes.
- Create and optimize complex SQL queries, stored procedures, and functions to extract, transform, and load data from various data sources.
- Develop and maintain documentation, including data flow diagrams, data dictionaries, and technical specifications.
Qualifications:
- Must have at least 5 years of SQL Server experience, including Azure SQL, SSIS, ADF.
- BS in Computer Science, Information Systems, or equivalent work experience
- Good knowledge of SQL Server technologies (SSIS, SSRS, etc.) Specifically, building/maintaining servers and troubleshooting performance and other technical issues.
- Good knowledge of back-up technologies, high availability, and disaster recovery solutions
- Good knowledge of monitoring tools ( SQL Performance Monitor, Quest tools)
- Working knowledge of PowerShell, T-SQL, Dynamic SQL, C#, Java/Beanshell
- Good knowledge of Windows OS
- Good knowledge of Azure technologies (IaaS, PaaS, VM sizing, disk management, Runbooks, virtual desktop, PowerBI, etc.)
- Azure Cloud infrastructure experience with implementations, migrations, and upgrades or Azure Certification would be a plus
Job Type: Full-time
Salary: $85,000.00-$95,000.00 per year
Benefits:
- Dental care
- Paid time off
- Vision care
Schedule:
- Monday to Friday
Education:
- Bachelor's Degree (preferred)
Experience:
- Microsoft SQL Server: 5 years (required)
- Azure: 5 years (required)
- SSIS: 5 years (required)
- SSRS: 5 years (required)
- Monitoring Tools: 2 years (required)
- Disaster recovery: 4 years (required)
- PowerShell: 2 years (required)
Work Location: Remote
