LaunchCode-posted 30 days ago
$52 - $62/Yr
Full-time • Mid Level
Remote • Saint Louis, MO
51-100 employees
Professional, Scientific, and Technical Services

The Database Architect is a member of the Software Support team, responsible for diagnosing, resolving, and preventing technical issues in the company's web applications and infrastructure. This position combines advanced troubleshooting with hands-on technical work, including database administration, server maintenance, bug fixes, and implementation of technical change requests to meet end-user specifications. This role focuses heavily on database performance, integrity, and tuning, and works closely with internal teams and external stakeholders to ensure the company's products and systems are reliable, performant, and secure. This role is with a partner company in the healthcare industry; name disclosed during the interview process.

  • Investigate and resolve application-level bugs by analyzing logs, reviewing code, and debugging in collaboration with development teams
  • Restart, monitor, and maintain application and database servers to ensure high availability and optimal performance
  • Respond to technical change requests, implementing enhancements or configuration changes within the company's web applications as specified
  • Perform database administration tasks including backup/restore, indexing, partitioning, and monitoring database health
  • Proactively tune SQL Server databases to improve performance and resolve bottlenecks
  • Write, modify, and optimize T-SQL queries, stored procedures, triggers, and views to meet business needs
  • Monitor and maintain database high availability configurations, clusters, and failover mechanisms
  • Troubleshoot and resolve database-related issues, including deadlocks, blocking, growth, and fragmentation
  • Document technical processes, fixes, and change implementations to ensure knowledge transfer and compliance
  • Work with developers, QA, and other IT teams to validate and deploy fixes and updates into production environments
  • Support the implementation of security best practices for databases and applications, including STIG compliance and access controls
  • Participate in UAT (User Acceptance Testing) and assist with deployments to test and production environments
  • Provide on-call support and respond to critical incidents as needed to maintain service levels
  • Advanced expertise with Microsoft SQL Server (2016 and newer) administration, tuning, and troubleshooting
  • Experienced in setting up, tuning and maintaining AWS RDS database instances.
  • Strong understanding of database high availability, clustering, mirroring, and disaster recovery strategies
  • Proficiency in T-SQL development and query optimization
  • Working knowledge of Windows Server, IIS, VMware, and related infrastructure components
  • Familiarity with STIG compliance, server hardening, and data security practices
  • Excellent analytical and problem-solving skills with attention to detail
  • Strong written and verbal communication skills, able to convey technical information clearly
  • Ability to prioritize and manage multiple complex tasks in a fast-paced environment
  • Proactive and customer-focused mindset
  • Associate's or Bachelor's degree in Computer Science, Information Technology, or related field; equivalent experience considered
  • 3+ years' experience in SQL Server database performance tuning and application support
  • Experience supporting web-based applications and maintaining enterprise-scale databases
  • Experience implementing and tuning SQL Server clusters, mirroring, and high availability setups
  • Knowledge of application development and debugging in .NET (C#/ASP.NET) environments is a plus
  • LaunchCode Benefits
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service