MSSQL Database Architect

Talent Group - Consultoría de Recursos Humanos - Cary, NC

Full-time

Cary, NC

Administrative and Support Services

About the position

The MSSQL Database Architect role involves advising on the design of SQL server databases within OneStream, ensuring data integrity, optimizing performance, and developing database architecture. The position requires collaboration with the Red Hat development team to implement strategic improvements and ensure databases meet scalability and security requirements.

Responsibilities

• Advise on design of SQL server databases within OneStream that meet business requirements, ensure data integrity, and optimize performance
• Develop database architecture including data modeling and indexing strategies, database and datatable copies, data reloads
• Collaborate with Red Hat development team to identify strategic recommendations for improvements
• Ensure databases run efficiently and meet scalability requirements
• Implement security measures including SSO, login, global level app security, and data encryption/decryption
• Provide overall guidance on best practices and compliance with industry standards
• Design and develop automation possibilities, leveraging task scheduler in OneStream

Requirements

• 8 years of experience with MSSQL (Preferred)
• 2 years of experience as a Database Architect (Preferred)
• 8 years of experience with SQL server databases (Preferred)
• 3 years of experience with Red Hat (Preferred)

Benefits

• Dental insurance
• Health insurance
• Vision insurance