Lead Database Engineer

Summary

Join Accela as a Database Engineer and contribute to the delivery of exceptional customer experiences by implementing critical features for both web and mobile platforms. As part of the Cloud Operations DBA team, you will support production environments, assist in developing new features using the Ionic framework, and tackle technical challenges that will enhance your technical and leadership skills. You will be responsible for on-call support, maintenance, application releases, project completion, incident resolution, and developing automation scripts using PowerShell and Terraform. You will also collaborate with a cross-functional team to deliver high-quality database services, optimize databases for speed and scale, and conduct system-wide analysis to ensure best-in-class solutions. This role requires a Bachelor's degree in computer science or a related field, 7+ years of SQL Server experience, and 3+ years of Azure/Cloud experience.

Requirements

• Bachelor’s degree in computer science or a related field
• 7+ years of SQL Server work experience in production
• 3+ years of Azure/Cloud experience, including
• Azure cloud-native services
• Azure SQL Database as a Service
• Azure Infrastructure as a Service
• Azure Networking
• DNS
• Experienced in all aspects of database management, including
• SQL Server Availability Groups
• SQL Server Log shipping, Replication, and Database Mirroring
• SQL Server HA/DR
• Performance tuning and troubleshooting
• Backup and Recovery
• Mastery in Windows System Administration and Windows clustering
• Expertise in creating, modifying, troubleshooting, and maintaining PowerShell automation scripts
• Experience managing 24x7 production database systems
• Ability to remediate operational performance of database processes, including
• Transactional
• Reporting
• Batch
• System Health/Monitor: DB Monitoring – Idera and Datadog

Responsibilities

• Key member of the high-performance Cloud Engineering DBA team
• Participate in on-call, production support activities, maintenance, and application releases
• Complete customer requests within agreed-upon SLOs
• Complete projects/Go-Lives as agreed upon schedules
• Drive incidents to resolution and implement permanent solutions to prevent recurrence
• Develop PowerShell automation to replace manual tasks; support existing PowerShell automation and contribute to future changes
• Develop and support Terraform automation for provisioning new infrastructure in Azure Cloud
• Transform legacy operations into cloud-native processes
• Develop Accela’s next-generation Civic application platform
• Collaborate with a cross-functional team of developers, designers, and QA engineers to deliver high-quality database services
• Perform database design reviews and database code reviews for high performance
• Optimize databases to maximize speed and scale
• Conduct system-wide analysis to ensure proposed solutions are best-in-class without causing negative impacts

Preferred Qualifications

• Strong experience with Active Directory and Azure Active Directory
• Experience with Terraform for infrastructure provisioning in Azure Cloud
• Ability to create automated remediation
• Independent thinker with creative, resourceful, and proactive problem-solving skills
• Experience with data migration between database platforms like Oracle and SQL Server is a plus
• Experience with SSRS, Power BI, and Crystal Reports is a plus
• Experience with Azure cloud-native services, Azure SQL, and Networking
• Experience with data warehouse and ETL processing is a plus
• Bachelor’s degree in computer science or equivalent experience in a related field

Benefits

• The annual base salary range for this full-time position is [$150,000-$170,000.00] (less applicable taxes)
• The actual annual base salary offered may be adjusted based on a variety of factors, including but not limited to, location, education, skills, training, and experience
• In addition to an annual base salary, this position is eligible for an annual bonus target
• This is a discretionary bonus awarded based on company and individual goal achievement
• Accela’s U.S. team members will receive a generous benefits package consisting of options including flexible time off, comprehensive medical, dental, and vision plans, family planning benefits, 401(k) retirement savings plan with company match, health savings account with company contributions, flexible spending account, life, accident, and disability coverage, business travel insurance, employee assistance programs, and other well-being benefits