Database Administrator

Kent Moore Cabinets is a 700-person manufacturing company with critical business systems built on robust database infrastructure. We're looking for a Database Administrator to own the reliability, performance, and security of our database platforms - SQL Server, PostgreSQL, and databases running in Docker containers. A major part of this role is managing data from Microvellum (MV), our cabinets design software. MV outputs a tremendous amount of complex data that drives our manufacturing operations and reporting. You'll partner with the Development team to organize, structure, and distribute that data across systems - from the ERP to analytics to production workflows. This data integration work is as important as traditional database administration. You'll work directly with our IT Director, Development team, System Administrator, and Network Administrator. The System Administrator owns the servers and systems your databases run on; the Network Administrator ensures data transmission is reliable and performant. Close collaboration with all three is essential to success. This role is essential to KMC's operation. Our manufacturing processes, ERP system, business reporting, and data-driven decision-making all depend on databases and data pipelines that work reliably, perform well, and recover quickly. You'll ensure database infrastructure and data flow are never the bottleneck. This is not a support role. You own database platform strategy, health, and performance for the company.

What You'll Own Database Platform Operations

• Administer SQL Server, MySQL, and PostgreSQL database platforms
• Manage databases running in Docker containers - health, performance, backup, recovery
• Own database infrastructure: storage, memory allocation, backup systems
• Establish and maintain database backup standards and restore procedures
• Execute regular restore testing to ensure disaster recovery capability
• Monitor database health, performance, storage, and growth across all platforms

Data Integration & Partnership (Microvellum)

• Partner with the Development team to manage the data pipeline from Microvellum (MV) - a high-volume, complex data source
• Work with Dev to ensure data structures, organization, and validation can be technically met and performed optimally
• Provide database expertise on data models to support manufacturing operations and reporting
• Ensure MV data distribution to systems that depend on it (ERP, reporting, analytics) is reliable and performant
• Troubleshoot data quality issues in collaboration with Dev and advise on structural improvements
• Optimize MV data extraction and transformation for performance and database reliability
• Maintain documentation of MV data structures, dependencies, and database-level considerations

Performance & Optimization

• Establish database performance baselines and monitor against them
• Identify and tune slow queries; guide developers on query optimization
• Manage indexing strategies and database maintenance jobs
• Advise on schema design impact and database standards
• Troubleshoot blocking, deadlocks, and performance issues

Security & Access

• Own database permissions and access controls
• Conduct quarterly access reviews and audit trails
• Support compliance requirements and security standards
• Implement database-level security (encryption, auditing where applicable)

Reliability & Recovery

• Define and maintain database backup/restore standards
• Set recovery objectives (RPO/RTO) in coordination with IT leadership
• Own database incident response and root-cause analysis
• Maintain documentation of database systems, dependencies, and recovery procedures
• Automate database maintenance, monitoring, and health reporting

Partnership with Development

• Guide development team on query performance, indexing, and database best practices

• Review high-impact queries and advise on optimization

• Coordinate with Development on production database changes

• Support database-related incident response and troubleshooting, Please upload your resume and a brief cover letter at our Paycom Careers website with the subject line "Database Administrator Application." Tell us about:

• A complex database performance issue you solved and what you learned

• Your experience with disaster recovery and backup testing

• Why you care about data integrity and reliability

• What database platforms you've worked with and how deep your experience is

We're reviewing applications on a rolling basis. Strong candidates will hear from us within 2 weeks. Kent Moore Cabinets is an Equal Opportunity Employer. We actively encourage applications from all qualified candidates regardless of race, color, religion, sex, national origin, age, disability, or any other legally protected status.

Physical Requirements:

II. Exertion Requirements: Light

Activity Load/Weight/Force Duration Pushing 10 - 20 lbs. of force to initiate and/or maintain Frequently Pushing 25 - 50 lbs. of force to initiate and/or maintain Occasionally Pushing 50 - 100 lbs. of force to initiate and/or maintain Rarely Pulling 10 - 20 lbs. of force to initiate and/or maintain Frequently Pulling 25 - 50 lbs. of force to initiate and/or maintain Occasionally Pulling 50 - 100 lbs. of force to initiate and/or maintain Rarely Lifting 10 - 20 lbs. Frequently Lifting 25 - 50 lbs. Occasionally Lifting 50 - 100 lbs. Rarely Carrying 10 - 20 lbs. Frequently Carrying 25 - 50 lbs. Occasionally Carrying 50 - 100 lbs. Rarely

III. Sensory Requirements: Light Activity Requirement Hearing Corrected to detect a minimum amplitude of 65 dB(A) for normal speaking voice at a distance of three feet. Vision Corrected to 20/40 Color Discrimination n/a Taste n/a Smell n/a Talk Talking with a normal voice approximates to sound pressure level 65 dB(A)

Do you have experience in System tuning?, * 3+ years hands-on database administration

• SQL Server administration (backup, recovery, performance, user management)
• Database performance tuning and query optimization
• Backup and disaster recovery implementation
• Experience with database monitoring and alerting

Strong Preferences:

• 5+ years total database administration experience
• Experience managing databases in containerized environments (Docker, Kubernetes)
• Data integration, ETL, or data pipeline experience - organizing and distributing data from external systems
• Experience in manufacturing, ERP, or business-critical database environments
• Exposure to MySQL and/or PostgreSQL in addition to SQL Server
• Experience with database automation and scripting (T-SQL, Python)
• Familiarity with high-availability and disaster recovery architectures
• Understanding of database security, compliance, and audit requirements

Certifications (Nice to Have):

• Microsoft Certified: Data Administrator (DP-900 or equivalent)
• CompTIA Security+
• Vendor certifications (SQL Server, MySQL, PostgreSQL)

What matters most: You think about databases as systems that need to be reliable first, fast second. You're comfortable with on-call responsibilities when critical databases are involved. You document obsessively and automate ruthlessly. You can explain performance concepts to non-DBA people without being condescending. You care deeply about data integrity and recovery - if a database fails, you own the recovery plan.

Pulled from the full job description

• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance, * Real database responsibility. You're not buried in support tickets. You own a critical platform that the entire company depends on.
• Meaningful performance work. KMC's ERP and manufacturing systems are under real load. You'll see the impact of your optimization work directly.
• Growing tech stack. We're modernizing our database infrastructure. You'll help guide our move toward SQL Server and PostgreSQL as primary platforms, with exploration of specialized databases like vector databases as our needs evolve.
• Clear partnership with Development. Your job is to make the Development team successful, not to be a blocker. We collaborate on database design, not fight over it.
• Manufacturing impact. Every query you optimize, every backup you validate, every disaster recovery plan you test supports real manufacturing operations. That's meaningful work.
• Competitive compensation. We pay for expertise and experience. This role reflects senior-level responsibility.

Compensation & Benefits Salary: $75,000-$95,000 annually, based on experience and qualifications Benefits include: Health, dental, vision insurance; 401(k) with company match; paid time off; professional development budget ($2,500+/year for training, certifications, conferences); on-call support compensation