Remote Sr. SQL DBA

Lensa; Nashville (TN); Remote; USD 90,000 - 130,000; Full time

Job summary

Lensa is seeking a Senior Database Administrator to lead the operational support of critical database systems. This role requires expertise in Microsoft SQL Server, T-SQL, and troubleshooting complex database issues, along with strong communication skills to collaborate effectively with IT teams.

Qualifications

• Minimum 5 years of experience administering Microsoft SQL Server.
• Experience writing T-SQL queries.
• Strong understanding of database concepts and security.

Responsibilities

• Monitor database server health and performance.
• Install, patch, and maintain SQL Server.
• Provide 24x7 on-call support as required.

Skills

SQL Server administration

T-SQL writing

Troubleshooting

Database security

Relational databases

Microsoft Azure

Tools

SQL Server Management Studio (SSMS)

SQL Server Reporting Services (SSRS)

Job description

Get AI-powered advice on this job and more exclusive features.

Lensa is a U.S. career site that helps job seekers discover job opportunities. We are not a staffing firm or agency. We promote jobs on behalf of our clients, which include employers, recruitment agencies, and marketing partners.

Job Description

This position is part of the team responsible for the operational support of business-critical database systems. The DBA Level 3 (Sr. DBA), performs tasks needed to administer Microsoft SQL Server. The Sr. DBA demonstrates strong communication skills, the ability to build functional relationships with team members and users, and excellent problem-solving and troubleshooting skills.

This position is to lead the team responsible for the operational support of business-critical database systems.

Duties and Responsibilities

• Monitor database server health and performance
• Install, patch, configure, and maintain SQL Server
• Analyze and resolve common and complex issues/faults in SQL Server and related infrastructure, providing issue resolution end-to-end
• Query and understand data from SQL Server system dynamic management objects
• Write T-SQL queries and scripts to investigate issues
• Maintain a high degree of security by implementing changes to access rights in SQL Server and Windows Server
• Work with other IT teams to identify and understand technical needs and solutions
• Work with other IT teams to analyze and resolve issues
• Review relational database designs and T-SQL code for application development teams
• Upgrade SQL Server to newer versions
• Migrate databases between servers and platforms
• Research and implement improvements to database system performance, integrity, and security, and compliance
• Create, maintain and follow database administration team standards and procedures
• Provide 24x7 on-call support on a rotating basis
• Flexible to work off-hours, including weekends and holidays, as required
• Perform other tasks and functions as required as needed
• Able to challenge, mentor, and grow the skills of junior DBAs (and possibly developers)
  
  

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf) .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills And Requirements

• A minimum of 5 years of experience administering Microsoft SQL Server in production environments
• A minimum of 5 years of experience writing T-SQL
• A minimum of 5 year of experience working with relational databases concepts
• SQL Server administration experience including:
  
  

oSQL Server Management Studio (SSMS)

oSQL Agent

oDatabase auditing and control

oDatabase security

oDatabase design and code development

oTroubleshooting and resolving faults in SQL Server and related infrastructure

oSQL Server Reporting Services (SSRS)

• Microsoft Azure database administration experience
• Knowledge of Microsoft Windows Server
• Strong understanding of relational database concepts (e.g., tables, columns, rows, primary keys, foreign keys, indexes, normalization).
• Strong understanding of security and permissions in SQL Server
• Proven troubleshooting skills
• Strong analysis and critical thinking skills
• Strong documentation skills null
  
  

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].

If you have questions about this posting, please contact [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Lensa by 2x

Get notified about new Senior Sql Database Administrator jobs in Nashville, TN.

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.