Responsible for developing, maintaining, and supporting mission-critical internal applications in a high-volume, high-availability OLTP environment. Perform standard development duties including T-SQL scripting and ad-hoc queries, creating scheduled jobs, SSIS packages, automated ETL processes, stored procedures, functions, and triggers. Design and maintain database systems for internal software applications with consideration to potential long-range business requirements, performance, and scalability. Utilize query execution plans, optimization techniques, and monitoring to take a proactive approach towards issue identification and resolution. Ensure data integrity and cleanliness for reports, dashboards, and applications. Collaborate with application developers, project managers, quality assurance, and business stakeholders during the development lifecycle from requirements gathering, effort estimates, database design, status updates, and mentoring end users.