Senior Database Engineer

Engineering · Costa Rica · Remote possible

Job description

ABOUT THE ROLE

The Senior Database Engineer will be an integral part of the overall Accela Database Engineering team based in Costa Rica. Accela Database Engineering consists of experienced Production DBAs with SaaS expertise—this is not your typical back-office Database Administration.

In this role, you will collaborate with world-class application engineers and a leadership team renowned for their expertise in Architecture, Operations, and Security, actively fostering your growth. Our tight-knit, diverse team thrives on the #oneteam philosophy, embracing Agile methodologies for software development, and fostering a culture of collaboration and active communication. At Accela, your ideas matter, your contributions make an impact, and together we thrive.

 SPECIFIC RESPONSIBILITIES 

 

  • Participate in on-call rotation, production support activities, maintenance, and application releases.
  • Complete customer requests within agreed-upon OLA.
  • Complete projects/Go-Lives as per the agreed-upon schedule.
  • Drive incidents to resolution and implement permanent solutions to prevent recurrence. Develop PowerShell automation to replace manual tasks; support existing PowerShell automation and contribute towards future enhancements.
  • Possess deep knowledge and experience in working with PowerShell to automate various database and application tasks.
  • Have extensive knowledge in troubleshooting PowerShell errors/failures and enhancing the existing codebase as it evolves.
  • Develop and support Terraform automation for provisioning new infrastructure in Azure and AWS Cloud.
  • Develop processes to transform legacy operations into cloud-native processes.
  • Contribute to the development of Accela’s next-generation Civic platform application.
  • Work closely with a cross-functional team of developers, architects, and QA engineers to deliver high-quality database services.
  • Collaborate with developers to perform database design reviews and database code reviews for high performance.
  • Optimize databases to maximize speed and scale.
  • Perform system-wide analysis to ensure the proposed solution is best-in-class without causing any negative impact.

REQUIRED QUALIFICATIONS

  • Bachelor’s degree in computer science or equivalent experience in a related field.
  • 5+ years of SQL Server experience in production.
  • 3+ years of PostgreSQL experience in production.
  • 2+ years of Azure/Cloud experience.
  • Proficiency in Azure Cloud Native Services, including Azure SQL Database as a Service, Azure Infrastructure as a Service, and Azure Networking and DNS.
  • Comprehensive experience in Database Management, covering SQL Server Availability Groups, SQL Server Log Shipping, Replication, and Database Mirroring, SQL Server High Availability/Disaster Recovery (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.
  • Capability to remediate operational performance of database processes for transactional, batch, and reporting workloads.
  • Proficiency in system health monitoring tools like DB Monitoring – Idera SQL DM and Datadog.
  • Strong experience working with Active Directory and Azure Active Directory.
  • Proficiency in Terraform for infrastructure provisioning in Azure Cloud.
  • Ability to create automated remediation procedures.
  • Independent thinker with creative, resourceful, and proactive problem-solving skills.

DESIRED QUALIFICATIONS

  • AWS Cloud experience.
  • Experience in data migration between database platforms like Oracle and SQL Server is a plus.
  • Proficiency in reporting tools such as SSRS, Power BI, and Crystal Reports is a plus.
  • Familiarity with Data Warehouse and ETL (Extract, Transform, Load) processing is a plus.
  • Knowledge or experience working with Oracle and PostgreSQL is a plus.
  • Proficiency or exposure to Azure tools, including Azure Data Factory, Azure Power BI, Azure Synapse, Azure Databricks, and Azure Fabric.

Accela is establishing a new entity in Costa Rica as part of our global growth strategy. Our organization specializes in advanced SaaS Software Applications covering a wide range of technologies and complex solutions such as: Hybrid Mobile Applications, Data Analytics & Reporting, Enterprise Payment Integrations, Advanced GIS mapping & routing, Responsive Angular UIs, and new AI POCs. These applications are hosted on our multi-cloud platform spanning both Azure and AWS. Being a part of the Accela team provides an opportunity to collaborate with world-class application engineers and a leadership team renowned for expertise in Agriculture, Operations, Security.

Compensation and Benefits: Accela offers a competitive salary and benefits in line with local standards.

Work-Life Balance: Accela is a “remote-first” organization and offers remote work options where feasible so employees can work in an environment that sparks motivation and creativity. Additionally, Accela offers generous paid time off with paid holidays, paid annual leave, paid “wellness days” offered sporadically throughout the year to focus on rest and relaxation, and a company “soft-close” during the week between Christmas Day and New Year’s Day.

 Career Growth and Development: Accela encourages and practices promoting from within to enable employees to hone or expand their skill set, contribute more value to the company, and grow. In addition, Accela offers non-promotional learning and development opportunities for skills enhancement through on-the-job training and internal and external education, including a paid LinkedIn Learning subscription to all employees. As a global company, Accela employees have the opportunity to work closely with international teams, providing a broader perspective and a chance to develop a global network.

Impactful Contributions: As a new member of Accela’s Costa Rica team, you will make significant contributions in setting the tone and influencing the company’s success in a new location. This opportunity provides a chance to make a visible impact.

Accela Culture: Our closely integrated, diverse team thrives on a #oneteam philosophy, embracing agile methodologies for software development, fostering a culture of collaboration, and active communication. At Accela, your ideas matter, your contribution makes an impact, and together we thrive. We think of employees as partners because we are all partners in shared success. We make sure everything we do is through the lens of humanity—from our commitment to the highest-quality SaaS solutions to the way we engage with our customers and communities to do business responsibly. We offer our employees strong values and purpose, empathetic leadership, and a place where all people feel they belong. Accela believes in building a diverse and inclusive culture where team members can make a real impact.

Your best work starts here. #Oneteam #BeWellWorkWell

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 to how services should be delivered, and expect a consistently convenient, openly transparent view into 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.

All qualified applicants will receive consideration for employment without regard to race, sex, color, religion, national origin, protected veteran status, or based on disability, gender identity, and sexual orientation.