Lead Database Engineer

ABOUT THE ROLE

As a Database Engineer, you will be an individual contributor, delivering exceptional customer experience and leading the implementation of critical features to accelerate the delivery of Accela’s products on both web and mobile platforms. You will be part of the Cloud Operations DBA team, supporting production and assisting engineering in developing new features and capabilities built on the Ionic framework.
You will encounter a range of technical challenges and customer experiences daily, which will stretch and develop your technical and leadership skills. You are a problem solver with a passion for delivering high-quality software and meticulous attention to detail. If you are a motivated Database Administrator/Engineer with extensive experience in all aspects of database administration and management, looking to join a collaborative and hardworking team, this might be the perfect fit for you!

SPECIFIC 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

REQUIRED QUALIFICATIONS

• 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

DESIRED 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

ABOUT ACCELA

For nearly 20 years, Accela has been an industry leader in designing and delivering government software to improve efficiency, increase citizen engagement and enable the development of thriving communities. Today, citizens are savvy about how services should be delivered, and expect a consistently convenient, openly transparent view of their local government. While government agencies struggle to do more with less, our mission has never been more critical. Accela provides a robust, cloud-based platform of government software solutions that accelerate growth, efficiency, and transparency in communities of all sizes. From planning, to building, to service request management and more, Accela’s SaaS offerings level the playing field for small and medium governments and enable smaller agencies to leverage larger city technologies. Our open and flexible technology helps agencies address specific needs today; while ensuring they are well prepared for the emerging challenges of the future.

OUR COMMITMENT TO DIVERSITY, EQUITY, AND INCLUSION
Accela believes in developing and nurturing a workplace community where our differences are celebrated, and everyone feels a sense of psychological safety and belonging. Accela is committed to putting resources and attention towards evolving our practices, policies, and philosophies to enable diversity to thrive and to support equity in opportunity for everyone.

COMPENSATION AND WELL-BEING

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.