5 days a week onsite locals to OHIO

We are seeking a highly skilled and experienced Database Architect and Administrator to join our team.

The candidate will have a strong background in both SQL and NoSQL databases, including MS-SQL, PostgreSQL, MongoDB, data lake etc. This role involves designing, implementing, and maintaining database systems to ensure optimal performance, security, and reliability of OPTO Products and Projects.  

• Design and implement database architectures for both SQL and NoSQL databases.

• Administer and maintain MS-SQL, PostgreSQL, MongoDB databases.

• Ensure database security, backup, and recovery processes are in place and effective.

• Implement data warehousing best practices to ensure data quality, performance, and scalability.

• Monitor database performance and optimize queries for efficiency.

• Collaborate with development teams to design and implement database solutions that meet business requirements.

• Design, implement, and test backup, recovery, and disaster recovery procedures with minimal downtime.

• Develop and maintain database documentation, including data models, schemas, and procedures.

• Troubleshoot and resolve database-related issues in a timely manner.

• Conduct regular database performance reviews and provide recommendations for improvements.

• Implement and manage database clustering, replication, and failover strategies to ensure high availability and disaster recovery.

• Develop and enforce database standards, guidelines, and best practices.

• Work closely with the IT security team to ensure compliance with data security policies and regulations.

• Provide technical support and guidance to other team members and stakeholders.

• Evaluate and recommend new database technologies and tools to enhance the database infrastructure.

• Manage database access controls and permissions to ensure data integrity and security.

• Perform database migrations and upgrades as needed.

• Create and maintain automated scripts for database maintenance tasks.

• Create and maintain comprehensive documentation for data architecture, ETL processes, and data models.

• Provide training and support to other team members and end-users on data-related best practices and tools.  

• BS in Computer Science. Masters Preferred.

• 10+ years of experience as a Database Architect and Administrator.

• Strong knowledge of MS-SQL, PostgreSQL, and MongoDB and tools to develop and maintain the databases. 

• Self-starter with the ability to investigate and understand business requirements, translate them into technical specifications, and implement the required design.

• Experience with database design, performance tuning, locks, and query optimization

• Experience as a standalone DBA. Willing to work independently, drive critical efforts, and plan and manage work.

• Excellent problem-solving and analytical skills. Strong communication and collaboration skills.

• Experience with database security best practices. Experienced in the warehouse (3PL) domain.