Job Information
Belcan Database Architect & Administrator in Cincinnati, Ohio
Database Architect & Administrator
Job Number: 349311
Category: -Software & Systems SBU
Description: A hybrid Database Architect & Administrator position is currently available at Belcan in Cincinnati, OH 45242. This is a full time, direct hire opportunity. The database architect is a skilled professional who designs and oversees the development of database systems that efficiently store, manage, and organize data. They play a crucial role in determining the structure, security, and performance of databases to meet the needs of organizations. Database Architects collaborate with IT teams, data analysts, and software developers to ensure data integrity, availability, and optimal performance. This role will also perform typical SQL server database administration functions, with the responsibility for the administration, monitoring, and troubleshooting of a database system's servers and infrastructure. You will need to 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. You will also need to be able to work well across functional teams.
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
-Flexible, team player, 'get-it-done' personality
-Ability to work independently, with little or no direct supervision.
-Ability to work in a rapidly changing environment
-Strong customer-service skills
-Life-long learner attitude
-Ability to multi-task and context-switch effectively between different activities and teams
-Strong ITIL foundation, Continual Service Improvement and Total Quality Management experience
-Bachelor's degree in Computer Science or equivalent
We provide a competitive pay and benefits package. This position offers a pay range of $140,000-175,000 per year. 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/Disability/Veterans
Location: Cincinnati , OH
Minimum Experience (yrs): 7-10
Required Education: Bachelor (BA, BS...)
Benefits:
Return to search results Email this job to a friend (emailjobs.asp?jo_num=349311)
If you have previously registered with us, pleaseLog in (memberlogin.asp) to apply for this position.
*Logged in members may also add jobs to their job cart