Application Database Administrator

Job Description Title: Application Database Administrator The Opportunity This position plays a critical role in the development, management, and administration of Appliclations & Databases. The Senior Application Database Administrator will be responsible for designing and implementing new data structures, managing existing databases, securing all data, and administering all Microsoft SQL Server database instances on Linux, Windows, and Amazon RDS. This role is primarily SaaS Appliclation support with traditional DBA tasks being secondary. 90% of this role query, script, and appliclation optimization. Primary Responsibilities Ensure 24/7 availability, security, and performance of mission‑critical application databases across multiple platforms (SQL Server, MySQL, Amazon RDS). Design, implement, and optimize high‑quality data structures and schemas to meet business needs and support specific applications. Architect and consolidate data from multiple sources into cohesive, accessible structures. Monitor, troubleshoot, and resolve complex database issues, implementing performance improvements as needed. Manage database security, access control, and data distribution to appropriate users. Collaborate with software developers and application teams to integrate efficient database requests into applications. Support and optimize complex SQL Server processes and SQLite database generation for mobile applications. Ad hoc reporting requiring advanced query skills. Document existing data models and transform raw data into actionable business intelligence. Become the resident expert on the data, how it is stored and used. Design, implement, and test backup, recovery, and disaster recovery procedures with minimal downtime. Lead database‑related projects for application upgrades, migrations, and patch management. Manage and refresh test data for application development teams. Empower business users through SQL training, report generation, and transition of routine tasks. Job Type Full‑time, based in Castle Rock, CO Required education Bachelor of Science degree in a computer discipline or relevant certifications. Required experience and job qualifications 10+ years’ experience in Microsoft SQL Server database administration. Experience as a standalone DBA. Willing to work independently, drive critical efforts, and plan and manage work. Excellent knowledge of Microsoft SQL Server data backup, recovery, security, and integrity. Experience implementing complex stored procedures, reports, and queries. Experience with database design and development. Experience administering SQL Server on Linux a plus. Experience administering SQL Server on Amazon RDS a plus. Experience with third‑party tools such as Redgate SQL Compare and SQL Data Compare. Strong analytical and problem‑solving skills. The ideal candidate can take the 20 and figure out the 80, has situational awareness and understands the chain of command as they represent others before they represent themselves. The ideal candidate is output‑oriented, knows when to yield and when not to yield, has a relentless willingness to raise the bar, hold themselves and others accountable, and excels in a diverse international environment across different nationalities, geographies and cultures. Be prepared to be unprepared when you apply! Compensation/Benefits: 100k-140k base 4% 401K match 3 weeks PTO starting out 12 paid holidays / 4 floating 6 sick days 80% health, vision, dental premiums covered by company! Flexible in and out times depending on commutes/family needs Equal Opportunity Employer/ Veterans/ Disabled The Company will consider qualified applicants with arrest and conviction records subject to federal contractor requirements and/or security clearance requirements. #J-18808-Ljbffr 6AM City, LLC