Irth Solutions

Database Administrator

Irth Solutions

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

SeniorLead

Tech Stack

AWSAzureEntity FrameworkMS SQL Server.NETNoSQLSQL

About the role

  • Investigate and resolve database performance issues in live production environments experiencing slowdowns or overload conditions
  • Respond to database-related incidents with urgency, conducting root cause analysis and implementing both immediate and long-term resolutions
  • Monitor database health metrics and proactively identify potential issues before they impact users
  • Participate in on-call rotation for critical database support
  • Analyze slow-running queries and provide optimization recommendations to development teams
  • Review and optimize database indexes based on query patterns and execution plans
  • Conduct regular performance tuning of SQL queries, stored procedures, and ORM-generated queries
  • Identify and resolve N+1 query problems, inefficient joins, and other common performance SQL anti-patterns
  • Participate in code reviews to identify database-related issues before they reach production
  • Provide guidance on database schema design, normalization, and data modeling best practices
  • Advise developers on efficient data access patterns and ORM usage (Entity Framework, LINQ)
  • Create and maintain database coding standards and best practices documentation
  • Assist Infrastructure teams with database capacity planning, growth analysis, and scaling strategies
  • Advise on database backup, recovery, and disaster recovery procedures
  • Advise Infrastructure teams on plans for database migrations, upgrades, and maintenance windows
  • Develop database performance monitoring and alerting strategies
  • Identify opportunities for database architecture improvements and modernization
  • Contribute to technical debt reduction efforts related to database performance
  • Mentor developers on database optimization techniques and best practices

Requirements

  • 7-10+ years of experience as a Database Administrator or Database Engineer
  • Expert-level knowledge of Microsoft SQL Server (version 2016 or later)
  • Proven track record of troubleshooting and resolving production database performance issues
  • Deep understanding of query optimization, execution plans, and indexing strategies
  • Experience with database monitoring tools and performance analysis
  • Strong knowledge of T-SQL, stored procedures, and database programming
  • Familiarity with ORM frameworks (Entity Framework preferred) and their performance implications
  • Experience with database backup, recovery, and high availability solutions
  • Excellent problem-solving skills and ability to work under pressure during incidents
  • Strong communication skills to explain technical concepts to developers and stakeholders
  • **Preferred Qualifications**
  • Experience with Azure SQL Database or AWS RDS
  • Knowledge of database DevOps practices and CI/CD pipelines
  • Familiarity with .NET development and understanding of application architecture
  • Experience with database migration strategies and tools
  • Background in utility or energy sector applications
  • Certifications such as Microsoft Certified: Azure Database Administrator Associate
  • Experience with NoSQL databases and polyglot persistence patterns
  • Knowledge of data warehousing and analytics platforms
Benefits
  • - Join a dynamic, growing company that is well respected in its industry.
  • - Competitive salary
  • - Health plans options including medical, dental, & vision
  • - 401k (US), RSP (Canada) + company match
  • - Flexible PTO policy plus company-paid holidays
  • - Benefits options such as health insurance, life insurance, discounts and perks programs
  • - Generous “work from home” stipend to get you started
  • - Team events including monthly lunches for everyone, volunteer outings, and quarterly gatherings
  • - Hybrid employees have access to snacks, beverages and coffee at our Columbus office
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Microsoft SQL ServerT-SQLstored proceduresquery optimizationindexing strategiesdatabase performance tuningORM frameworksdatabase backupdatabase recoveryhigh availability solutions
Soft Skills
problem-solvingcommunicationmentoringcollaborationurgency in incident response
Certifications
Microsoft Certified: Azure Database Administrator Associate