Remote Senior Database Administrator

Summary

Join Accela's Costa Rica team as a Senior Database Administrator and contribute to the company's global growth strategy. As an integral part of the Accela Database Engineering team, you will collaborate with world-class application engineers and a leadership team renowned for their expertise in Architecture, Operations, and Security. In this role, you will participate in on-call rotation, production support activities, maintenance, and application releases, drive incidents to resolution, and implement permanent solutions to prevent recurrence.

Requirements

• 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

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

Preferred 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

Benefits

• Competitive salary
• Remote work options
• Paid time off with paid holidays, paid annual leave, and paid ‘wellness days’
• Company ‘soft-close’ during the week between Christmas Day and New Year’s Day