Database Administrator III - Covenant Eyes
Owosso, MI 48867
About the Job
Working at Covenant Eyes is about something bigger than creating and selling software; it’s about creating a movement and changing culture. At the end of the day you are contributing to saving a marriage, protecting a child’s innocence, strengthening a commitment to purity, and working to end sexual exploitation.
As a company focused on restoring relationships, we take our families seriously. We believe in hard work, but we believe in balance too. Our first jobs are to our families and we know that balance is crucial.
If you’re looking to make a positive impact, you have an eye toward innovation, and are looking for an employer that offers advancement opportunities, work life balance, and a competitive benefits package that starts on day one, we would love to hear from you!
About the position
A DBA at Covenant Eyes will plan, help coordinate and participate in all activities related to the design, development, implementation and ongoing support of the enterprise test, preproduction, and production databases.
A DBA can also provide architectural vision with regards to new database setups in addition to analysis and problem solving within our existing technology space. This role, guided by CE Systems Architects, applies and develops technologies and processes, from proof-of-concept and reference implementations through to production systems.
This position is also responsible for the hands-on management and support of existing technology solutions, and for technical definition and delivery of new solutions and tools, both internal and customer facing.
Responsibilities:- Configuring, maintaining, monitoring, optimizing, and supporting CE s high availability and geographically dispersed databases
- Installing and testing database software upgrades
- Developing, documenting, and communicating standards for use, operations, and security of databases and data
- Analyzing business requirements to identify and implement database and replication solutions
- Participating in a monthly on-call rotation
- Performing Business Analytics and Data Mining
- Troubleshooting and correcting database issues
- Participating in systems implementation projects
- Working alongside and being highly responsive and communicative with cross functional teams, including Developers, Systems Engineers, User Experience Practitioners, and Quality Assurance Practitioners
Qualifications:
- 4+ years of experience with MariaDB, Percona, or MySQL
- MySQL stored procedures & functions, triggers, views
- Demonstrated experience designing and developing complex ETL pipelines using tools such as Informatica, SSIS, Talend, Apache NiFi etc.
- Query design and performance tuning
- Data modeling and design
- Oracle Linux (RHEL 7 or newer [and variants])
- Shell scripting
- The majority of your time will be spent at a desk using a phone, computer and monitor, and general office equipment. You may be required to reach with hands and arms; sit; stand; talk and hear; use your hands to finger, handle, or feel.
It would be great if you had:
- Galera, MariaDB (MaxScale), Master-Master Configuration
- Redis
- InfluxDB (Time series)
- Python, JSON, Percona toolkit
- Ansible (DevOps automation)
- AWS, Oracle Cloud, Kubernetes, Containerization
- ETL (Extract, Transform, & Load)
- Partitioning & Sharding
- Data security
- Sizing and capacity planning
- Database backup and disaster recovery
Personal Characteristics that lead to a successful Career at Covenant Eyes:
- Independent: Able to grasp high level product requirements and translate these to developing or modifying running software effectively
- Strong sense of ownership: Sees projects throughout their lifecycle; from development to deployment. Personally ensures that code works correctly when deployed
- Encourages constructive criticism on his or her work
- Accountable: Should be a results-oriented team player who holds themselves accountable for performance, takes absolute ownership, and champions all aspects of quality software
- Flexible and adaptable. Should be able to switch gears in various situations and apply themselves to quickly learning new technologies and adopting new methodologies
*** We appreciate cover letters, let us know why you'd like to work for Covenant Eyes and how your skills align with the position! ***