SQL Database Administrator, $65/hr on C2C, Remote role, Long Term Project.

Role and Responsibilities

  • Install, configure, upgrade, and maintain on-premises Microsoft SQL Server instances (2022 or later).
  • Manage database provisioning, capacity planning, and storage allocation across physical/virtual servers.
  • Perform routine maintenance including index rebuilding, statistics updates, integrity checks (DBCC), and patching.
  • Administer user roles, permissions, and security policies following the principle of least privilege.
  • Monitor database performance and proactively identify and resolve bottlenecks.
  • Optimize T-SQL queries, stored procedures, functions, and views (often those originating from the .NET application).
  • Analyze and tune execution plans, indexing strategies, and query performance.
  • Configure and manage SQL Server Agent jobs, alerts, and automated monitoring.
  • Design, implement, and test robust backup and disaster recovery (DR) strategies.
  • Manage High Availability solutions such as Always On Availability Groups, Failover Clustering, log shipping, or replication.
  • Perform point-in-time recovery and regularly validate restore processes.
  • Collaborate with development teams to support day to day SQL database builds across multiple environments and support necessary of the .NET application.
  • Troubleshoot database connectivity, connection pooling, and performance issues originating from the application (e.g., Entity Framework, ).
  • Review and optimize database code and schema changes deployed through application releases.
  • Assist with deployment of database changes across development, testing, and production environments.
  • Support application configuration related to database connections (connection strings, IIS/app server integration).
  • Implement and maintain database security, encryption (TDE, Always Encrypted), and auditing.
  • Ensure compliance with relevant data protection regulations and internal governance policies.
  • Manage vulnerability remediation and apply security patches.
  • Maintain comprehensive documentation of database architecture, configurations, and procedures.
  • Provide on-call support for critical database and application issues (rotational, as needed).
  • Participate in incident, problem, and change management processes.

Experience

  • 9+ years of hands-on experience as a SQL Server DBA in an on-premise environment.
  • Proven experience supporting .NET applications and their backend databases.
  • Strong experience with SQL Server versions 2022 and above.
  • Expert knowledge of SQL (writing, debugging, and optimizing).
  • Strong understanding of database internals, indexing, and performance tuning.
  • Hands-on experience with High Availability / Disaster Recovery (Always On, Clustering, Replication, Log Shipping).
  • Proficiency with SQL Server tools: SSMS, SQL Profiler, Extended Events, SQL Server Agent.
  • Familiarity with Windows Server administration and Active Directory integration.
  • Understanding of how .NET applications connect to and consume SQL Server data (, Entity Framework, connection strings, IIS).
  • Experience with backup/recovery tools and monitoring solutions (e.g., Redgate (recommended)).
  • Experience with SSIS, SSRS, and SSAS.

Technical Skills: Advanced SQL Server Administration

  • Microsoft SQL Server 2012/2014/2016/2019/2022
  • SQL Server Always On Availability Groups
  • Failover Clustering. Database Mirroring , Log Shipping and Replication
  • SQL Server Agent, SQL Server Profiler and Extended Events

Database Design

  • Normalization and Denormalization
  • Data Modeling and design & support complex Database Architecture with supporting of 10+ TB of data
  • OLTP, Data Warehouse Design and Capacity Planning

Automation

  • PowerShell, SQL Agent
Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...