Company Description
The Picas Group is a technology company focused within the Horticulture industry. Our flagship software, Picas, is the leading Greenhouse Management and Production Software system for the floriculture and horticulture industries. As a technology partner, we offer top-quality software and services to keep our customers ahead of their competition. From Crop Management to EDI and E-Commerce, we provide the most seamlessly integrated system on the market. We are passionate about growth and strive for everyone involved with The Picas Group to be growing together.
Job Summary
This is a full-time role for a Database Administrator at The Picas Group. As a Database Administrator, you will manage and maintain company and customer databases daily. Responsibilities include database design, troubleshooting, replication, and ensuring overall database performance and security. While the role is primarily based in the Grand Rapids Metropolitan Area, there is flexibility for some remote work.
Job Duties
- Provide comprehensive database administration, system support, and maintenance to company and customer databases.
· Perform monitoring, tuning, optimizing, installation, updates, and upgrades to databases and related software.
· Build new relational databases using industry-standard design and architecture.
· Handle incident and problem management activities, escalating issues to external technical support when necessary. Track issues over time and manage changes.
· Resolve issues such as database crashes, connection problems, ODBC permissions, and performance concerns as they arise.
· Communicate to company and customers when database outages occur. Develop and implement plans to prevent similar outages in the future.
· Extract database statistics, metadata, and performance information for analysis and action.
· Support team members with data analysis and other application support activities.
· Manage operational tasks such as providing technical support for ETL processes, SQL Jobs, and Picas software releases.
· Coordinate with the development team to ensure seamless integration of software code with database structure, function, and performance.
· Maintain database access through various entry points such as shared memory, SQL, ODBC, JDBC, 4GL, and other TCP/IP communication methods.
· Oversee automated database changes, ensuring uniformity across customer tables and indices.
· Produce and maintain technical and user documentation.
· Perform regular maintenance on databases such as defragmentation, purging, dump & load, fixing bad data, conversions, and merging data.
· Collaborate with the IT team to design and implement database backup and recovery procedures, documenting and testing all processes.
· Provide development and production support to troubleshoot day-to-day database or related application issues.
· Maintain and administer database security access.
· Manage DBA-related projects within the organization.
· Participate in the strategic development of Data Governance, DevOps, Customer Success, and other high-level, cross-departmental teams.
· Participate in the on-call rotation to ensure 24/7 support of database operations.
· Explore new products and tools to improve and modernize IT and business processes, such as containerization, Linux, AI, cloud, etc.
· Other various IT projects and tasks that may not be directly database related.
Job Qualifications
- A bachelor's degree in IT or a related field.
2. Experience managing and maintaining large relational databases, with a focus on uptime, performance, and security.
3. Deep understanding of database ERD, ETL, structure, indices, keys, privileges, and roles.
4. Security-first mindset that translates to authentication, authorization, and access controls.
5. Proficiency in SQL, including optimizing queries and automating manual processes.
6. Experience with Progress databases and Advanced Business Language (ABL) is a plus.
7. Ability to think critically and execute thoroughly.
8. Strong multitasking skills and the ability to manage many details and moving parts.
9. Exceptional attention to detail and commitment to quality.
10. Strong team collaboration and problem-solving skills, with a focus on creating an enjoyable work environment.
Tech Stack
At The Picas Group, we are constantly pushing to modernize and improve our technology at pace with the industry. Tools we use include:
- Progress OpenEdge RDBMS
- Progress Advanced Business Language (ABL) for legacy Picas.Current desktop application
- JavaScript for modern Picas.Next web application
- PostgreSQL
- SQL, ODBC, and JDBC
- Jenkins
- PowerBI
- Microsoft Fabric
- Microsoft Azure
- Microsoft Windows Server