Senior Database Administrator

OpenGov

Remote
  • Job Type: Full-Time
  • Function: IT
  • Post Date: 01/05/2021
  • Website: opengov.com
  • Company Address: 955 Charter Street, Redwood City, CA, 94063

About OpenGov

We were founded in 2012, when California was in the middle of a budget crisis and municipal revenues were drying up. We discovered that dedicated public servants were struggling against outdated technology that prevented them from accessing timely spending information and communicating their priorities to citizens and elected officials. So we developed an easy-to-use, integrated Smart Government Cloud™ that features robust solutions for Budgeting, Operational Performance, and Citizen Engagement.

Job Description

OpenGov is a mission driven fast-growth, Series D, venture backed startup (includes Andreessen Horowitz, Formation 8, Thrive Capital, and Emerson Collective). Our Board of Directors includes iconic Silicon Valley executives John Chambers (former Cisco Chairman and CEO) and Marc Andreessen (Time Magazine’s list of the 100 most influential people in the world).  
 
We have surpassed 1,000+ governments (and growing fast!) using our products in our mission to power more effective and accountable government.
 
About the Senior Database Administrator Role:
 
OpenGov Financials is the premier GovTech SaaS ERP (Enterprise Resource Planning) solution.  We are looking for a motivated, self-driven engineer who enjoys the administration of a cloud native application using PHP, Javascript Frameworks, and SQL based databases.  You will be bringing customers into the cloud through data migrations.  Stream lining will be the key here.  This position is fast paced and requires supporting an ever changing development environment. You will be helping to build “THE” SaaS ERP that will change the way governments manage their personnel, assets, resources, finances, permits, licenses…..and the list goes on.
 
At OpenGov, we value each of our employees and make every attempt to ensure that you are properly supported as a developer and a person.
 
Responsibilities:
 
•Provide feedback on potential improvements and execute those improvement plans for the Financials database, both for on-prem and in the cloud
•Perform data restores, migrations to the cloud, backups in a hands on and advisory role to other engineers
•Advise on proper structuring of view, federated tables, stored procedures, etc
•Help to optimize data access (read and write capability)
•Create and execute complex queries against the Financials database for internal and external projects
•Provide security advice on proper database access
•Work across multiple database platforms, including cloud-native databases, such as AWS RDS
•Create, optimize, and evolve database schemas
•Apply and advise on connection strings to multiple languages (PHP, JAVA, C#, VB)
 
Requirements:
 
•Expert level experience SQL databases and some familiarity with No-SQL database functionality
•Able to properly design and produce structured and scalable SQL queries
•Understanding of relational views, federated tables, and complex joins
•Experience in identifying database scaling bottlenecks and implementing monitoring and alerting strategies for database instances
•5+ years of experience SQL databases (Postgres, DB2, SQL Server, MySQL)
 
Nice To Haves:
 
•In-depth knowledge of IBM DB2, Postgres, and Cloud-native (SaaS) development in AWS
•Knowledge of advanced database access methods in PHP with DB2
•ERP development background in one or more of the following domains: Core Financials (e.g. General Ledger, Accounts Payable, Accounts Receivable), Payroll, HR, Utility Billing) 
•Knowledge of platform constructs such as Authentication, Authorization (Access Controls), and Audit Logging
•Microsoft Windows Server knowledge
•Experience in Java
•Hands-on knowledge of DevOps, SRE, and CI/CD practices in a public cloud environment, preferably AWS and Kubernetes
•BS/MS Degree in Computer Science or Data Engineering or equivalent
What makes OpenGov unique
 
» Leadership: CEO Zac Bookman (MPA from Harvard and JD from Yale) is truly a mission driven CEO. He was named one of the 100 most Intriguing Entrepreneurs by Goldman Sachs and SF Business Times' 40 under 40 class of 2018!
 
» Funding: $140 million, Series D company, from top tier investors including Andreessen Horowitz, 8VC, Thrive Capital, and Emerson Collective. Click here to read more about our latest round of funding!
 
» Board of Directors: Includes iconic Silicon Valley executives John Chambers (former Cisco Chairman and CEO) and Marc Andreessen (Time Magazine’s list of the 100 most influential people in the world).
 
» Growth: Double growth with 1,000+ governments (and counting) using our products!
 
» Perks: Fully stocked kitchens, daily breakfast and catered lunches, gym reimbursement, music room, zen room, foosball and pool table, Unlimited PTO and 11 paid holidays, 90% medical premium coverage for employees, fun events, and more! Just look at www.opengov.com/careers 
 
» Product: Named a Tech Pioneer by the World Economic Forum, our cloud solution leverages cutting-edge technology to innovate on the core processes of Government.
 
» Mission Driven: We are a technology company helping out our communities, cities, and states. We're powering more effective and accountable government.
 
Come join us and make a positive social impact!

Related Jobs

Account Executive (SaaS/ERP)

OpenGov - United States

Account Executive (SaaS/ERP) - Texas

OpenGov - Dallas, TX, USSan Antonio, TX, USHouston, TX, USAustin, TX, US

Senior Product Designer II

OpenGov - United States of America

Associate Integrations Analyst (Pacific Coast Evening Coverage)

OpenGov - United States of America

Associate Integrations Analyst (East Coast Evening Coverage)

OpenGov - United States of America
Disclaimer: Local Candidates Only
This company does NOT accept candidates from outside recruiting firms. Agency contacts are not welcome.