Database Administrator
Company Background
Direct Commerce Group, LLC (DCG) is a growing and entrepreneurial business with multiple areas of focus. Privately held and well capitalized by private investors and internet industry veterans, DCG currently operates Tall Ridge and Office Designs.
Tall Ridge (www.tallridge.com) is a full-service digital marketing agency focused on helping brands like Hydro Flask, Boll & Branch and Gerber Gear succeed on Amazon and other online marketplaces. We offer products for the quality conscious consumer.
Office Designs (www.officedesigns.com) is an e-commerce business focused on offering high-end ergonomic seating, modern office furniture, and office décor products to small and mid-size businesses and home offices. Full-service offerings include design and layout services, curated product offering and installation. Because of our capabilities, we are selectively authorized to offer high-quality brands such as Herman Miller, Steelcase, Humanscale, and Haworth, in addition to various other brands.
Position Summary
Using your deep expertise in databases and application development, you will work with the team to develop and maintain DCG’s data platform. You will help develop, enhance and maintain applications using AWS cloud technologies, along with using relational, MySQL and other specialized databases. You will help write data services in Java and demonstrate concurrent programming skills as needed. We will depend on your futuristic thinking to mitigate issues before they occur and will look to you to test, debug and troubleshoot challenges and to document resolution steps when necessary.
Key Responsibilities
Formulates detailed network, storage, and computes design specifications for stable and secure computing operations in a dynamic cloud based environment to support Tableau reporting infrastructure.
Monitors MySQL databases to assist in optimization of database performance, resource use, and physical implementation.
Creates custom Java and/or Python based scripts to automate data retrieval and integration into database.
Collaborates with internal and external parties to transform high-level technical objectives into comprehensive technical requirements.
Makes recommendations for improvements to security, scalability, manageability, and performance across a wide variety of network, storage, and compute technologies.
Participates in, implements, and coordinates with others, in maintaining, modifying, and creating database structures.
Develops strategies for data acquisitions, archive recovery, and implementation of MySQL databases.
Assists and begins to develop designs for databases.
Monitors and manages MySQL database backups and restorations.
Installs, maintains, and upgrades MySQL database software as required.
Administers, maintains, and develops policies and procedures for ensuring the security and integrity of databases.
Continues our charge towards test automation and continuous integration
Drives innovation by coming up with new and surprising ideas for our applications and our processes
Designs, implements, and maintains our application and infrastructure components
Refactors and improves maintainability of the codebase
Solves complex scalability, platform, and integration problems
Learns new paradigms, languages, and libraries as you work
Assists with identifying and planning potential new cloud services, features, and capabilities.
Demonstrates problem solving skills and the ability to work on multiple projects simultaneously.
Meets predetermined deadlines set for assigned tasks.
Studies the technical structure and requirements of the DBM system to be supported.
Demonstrates the ability to utilize training in assigned tasks.
Performs project tasks to ensure that associated deliverables are completed in a timely manner.
Creates documentation in accordance with the tasks performed.
Ensures written communication is accurate, timely and thorough.
Adheres to accepted department standards and procedures.
Database Administration and Monitoring
Owns and solves performance issues of database applications by implementing changes to database objects and/or working with developers/vendors on application tuning effort
Requirements:
Bachelor’s degree in computer science, MIS or a related field or the equivalent in education and experience is required
Experience in data modeling, along with 2-3 years of programming experience writing performant stored procedures/functions/SQL statements is required
Experience installing/administering clustered MySQL v5.x+ instances
Solid understanding of different Database Models
Experience in either Oracle or MySQL is required
Minimum 2 years of working experience in core java is required.
Understanding of how HTTP works as it applies to RESTful architectures required
Data warehousing experience is preferred
Compensation and Benefits
- Competitive salary
- Flexible work location
- Stocked kitchen
- Health, dental and vision insurance
- Smart and fun co-workers who will quickly feel like family
- 3 weeks PTO
- 401k plan with company match
- Short Term Disability