Amplifire is seeking a DBA that is looking to build on their expertise as a member of a dynamic team supporting our global web-based application. Our goal is to hire energetic, bright, and cooperative people who are a joy to work with and love working with others. Candidates for this position should be able to work alongside their technical counterparts as well as work hand in hand with our business leaders and product owners. This position provides a flexible work location either at home or at our headquarters based in Boulder, CO with direct access to Colorado’s Flatirons.
Responsibilities
· Responsible for the development, performance, integrity, and security of database systems
· Identify and resolve database performance issues, such as slow queries, inefficient indexing, or resource contention
· Maintain and support data models across the OLTP and Reporting platforms
· Good data analysis experience with an eye for data integrity
· Create database patches supporting new functionality (DDL and DML)
· Assist in the creation and population of all non-production systems
· Perform and help support our Operations team with production infrastructure and application deployments
· Perform security reviews, database upgrades and maintenance as needed
· Recommend and implement emerging database technologies.
· Support on-call activities as needed
Technical Stack
· Database Platform: PostgreSQL
· Languages: SQL, Perl, Python, Shell, PHP
· Tools: Postman, DBAdmin (or similar), AWS Monitoring
· Server: Linux (RHEL)
Skills & Requirements
· Experience working with PostgreSQL
· Knowledge of AWS RDS / Aurora
· Work with teams to ensure database integrity and security
· Performs development of DML, DDL, and other database functions or procedures
· Ensure storage, backup, and archiving procedures are functioning correctly
· Knowledge or experience with agile development methodologies
· Experience with git
· Excellent communication skills with a "can do" customer facing attitude
· Independent, self-starter who is resourceful and an excellent team player
· Strong desire to learn with an ability to pick up new concepts and technologies quickly
· Ability to be flexible, proactive, accountable, decisive and successful working in an environment of change
· Good understanding of SQL and ability to write complex statements
· Generate documentation and SOP for all processes implemented