Database Architect & Administrator

A hybrid Database Architect & Administrator position is currently available at Belcan in Cincinnati, OH 45242. This is a full time, direct hire opportunity. Well qualified applicants will have a strong understanding of Microsoft SQL servers, Windows servers, related hardware and software, and the technical and programming requirements for building database applications and architecture.

JOB DUTIES:

• Database Design: Design and create database systems that align with organizational needs, considering data relationships, schemas, and integrity.
• Data Modeling: Develop data models, entity-relationship diagrams, and data dictionaries to define the structure and relationships within the database.
• Database Security: Implement security measures, access controls, and encryption protocols to safeguard sensitive data.
• Performance Optimization: Optimize database performance by designing efficient query structures, indexing strategies, and database partitioning.
• Scalability Planning: Plan for database scalability by designing architectures that can handle increased data volumes and user loads.
• Backup and Recovery Planning: Develop strategies for data backup, disaster recovery, and business continuity to ensure data availability.
• Database Migration: Plan and execute database migration projects, ensuring smooth transition between different database systems or versions.
• Data Integration: Integrate databases with other systems, applications, and data sources to facilitate data sharing and synchronization.
• Data Governance: Establish data governance practices, including data quality, metadata management, and data lifecycle management.
• Collaboration: Collaborate with development teams, data analysts, and stakeholders to understand requirements and ensure database solutions meet business goals.
• Database Administration: Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Database Configuration: Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Database performance tuning.
• Database Troubleshooting: Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Database Environment Support: Provide support for critical production systems.Perform scheduled maintenance and support release deployment activities after hours.
• DBA team growth: Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

REQUIRED QUALIFICATIONS:

Education and Experience:

• A bachelor's or master's degree in computer science, information technology, or a related field is typically required.
• Relevant work experience in database architecture, database administration, or related roles is highly beneficial.
• Database Management Systems: Proficiency in database management systems such as SQL Server, Oracle, MySQL, PostgreSQL, NoSQL databases, etc.
• Data Modeling Tools: Experience with data modeling tools (e.g., ERwin, Lucidchart) to create effective data models and diagrams.
• Query Optimization: Strong understanding of query optimization techniques to improve database performance.
• Security Practices: Knowledge of database security best practices, including authentication, authorization, and data encryption.
• Database Design Principles: Familiarity with normalization, denormalization, indexing, and data partitioning concepts.
• Problem-Solving Skills: Analytical thinking and problem-solving abilities to address complex database challenges.
• Communication Skills: Effective communication skills to collaborate with technical and non-technical stakeholders.
• Project Management: Ability to manage database architecture projects, timelines, and resources effectively.
• Must be a US Citizen

PREFERRED QUALIFICATIONS/SKILLS:

• Experience with Microsoft Fabric
• MCTS, MCITP, and/or MVP certifications a plus Excellent written and verbal communication, problem solving skills
• Strong ITIL foundation, Continual Service Improvement and Total Quality Management experience

We provide a competitive pay and benefits package. This position offers a pay range of $65-85 per hour. Belcan considers several factors when extending an offer, including but not limited to education, experience, geographic location, and discipline. Benefits offered may include health care, dental, vision, life insurance; 401(k); education assistance; paid time off including PTO, holidays, and any other paid leave required by law.

As an employee with Belcan, you will be part of one of the largest engineering firms in the United States. We maintain a small company atmosphere as well as open communication at all levels of our organization, allowing for much more dynamic decision-making processes. We offer flexible schedules as well as an excellent mentoring system to ensure that you have all the knowledge and tools you need to meet a diverse range of engineering challenges. You will also have opportunities to advance to positions of greater responsibility, including management roles. Your hard work and professional dedication will be rewarded with a competitive compensation package. Build a challenging and rewarding career with an industry leader!

www.belcan.com

EOE/F/M/D/V