Senior Database Architect & Administrator (Combo Role)

Job Description : Senior Database Architect & Administrator (Combo Role)

Location- Cincinnati, OH ( 5 Days Onsite )

Overview

We are seeking a highly experienced and well-rounded Senior Database Architect & Administrator who excels in both architectural design and hands-on administration of enterprise-scale database environments. This is a true combo role that requires deep expertise in crafting robust data architectures while also ensuring optimal performance, security, and reliability through effective administration.

The ideal candidate brings a balanced blend of strategic thinking and practical execution—someone who can architect complex database solutions and manage day-to-day operations with equal proficiency.

The candidate will have a strong background in both SQL and NoSQL databases, including MS-SQL, PostgreSQL, MongoDB, 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.
• 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.
• Design, implement, and test backup, recovery, and disaster recovery procedures with minimal downtime.
• 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.

Requirements

• 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 with database security best practices.
• 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.

What We’re Looking For

We are not seeking candidates who are solely administrators or solely architects.

The right fit is someone who can design robust database systems at a high level and also take hands-on responsibility for managing, tuning, and maintaining them.