SQL Database Administrator

Vistas Cloud • United State
Remote
Apply
AI Summary

Manage and maintain SQL Server databases, ensuring availability, performance, and security. Collaborate with developers on database design and query optimization. Leverage AI tools for analysis and troubleshooting.

Key Highlights
Manage SQL Server databases
Collaborate with developers
Leverage AI tools
Key Responsibilities
Administer, monitor, and maintain SQL Server databases in development, test, and production environments.
Design, implement, and manage database replication and high-availability configurations.
Develop, deploy, and troubleshoot SSIS packages for ETL, data integration, and scheduled processes.
Diagnose and resolve performance issues, blocking, deadlocks, failed jobs, and data integrity problems.
Collaborate with developers and solution architects on database design, indexing strategies, and query optimization.
Create and maintain documentation, standards, and runbooks for database operations and support.
Ensure data security, access control, and compliance with internal policies and industry best practices.
Technical Skills Required
SQL Server Database Administration Relational database concepts Physical/logical database design Replication High availability Disaster recovery SSIS packages AI-based assistants (Claude)
Benefits & Perks
Remote work
Contract employment

Job Description


Company Description

VISTAS Cloud is a multinational technology solutions provider and certified Microsoft Solutions Partner. We specialize in delivering high-impact IT services across Microsoft Dynamics ERP, Business Central, CRM, Office 365, Azure, and SharePoint. Our mission is to save time and increase profitability for our clients through expert consultancy, integration, development, training, and support. With a strong focus on cloud productivity and infrastructure management, we empower businesses to modernize and scale with confidence.

Role Description

This is a contract (6+ months), fully remote role for a SQL Database Administrator. The SQL Database Administrator will be responsible for managing and maintaining SQL Server databases, ensuring the availability, performance, and security of all database environments. Day-to-day tasks include database replication, database design, SSIS package development and maintenance, and advanced troubleshooting. The role also involves monitoring system health and performance to ensure high levels of performance, availability, and security. The SQL Database Administrator will work closely with the development team to ensure proper database design, efficient ETL processes, and optimal performance. The ideal candidate will also leverage modern AI tools (such as Claude) to assist with analysis, optimization, and troubleshooting.

Responsibilities

  • Administer, monitor, and maintain SQL Server databases in development, test, and production environments.
  • Design, implement, and manage database replication and high-availability configurations.
  • Develop, deploy, and troubleshoot SSIS packages for ETL, data integration, and scheduled processes.
  • Diagnose and resolve performance issues, blocking, deadlocks, failed jobs, and data integrity problems.
  • Collaborate with developers and solution architects on database design, indexing strategies, and query optimization.
  • Use AI tools (including Claude) to analyze query performance, review execution plans, generate and refactor T-SQL scripts, and assist in root-cause analysis and incident resolution.
  • Create and maintain documentation, standards, and runbooks for database operations and support.
  • Ensure data security, access control, and compliance with internal policies and industry best practices.

Qualifications

  • Proven experience in Database Administration with Microsoft SQL Server.
  • Strong understanding of relational database concepts and physical/logical database design.
  • Hands-on experience with replication, high availability, and disaster recovery features.
  • Practical experience developing and troubleshooting SSIS packages.
  • Strong troubleshooting and performance tuning skills (indexes, execution plans, query optimization).
  • Experience using AI-based assistants (preferably Claude) for tasks such as SQL analysis, code generation/refactoring, and troubleshooting.
  • Excellent problem-solving abilities and attention to detail.
  • Ability to work independently and effectively in a remote environment.
  • Bachelor’s degree in Computer Science, Information Technology, or related field is a plus


  • Similar Jobs

    Explore other opportunities that match your interests

    IT Support Associate

    Networking
    •
    14h ago
    Visa Sponsorship Relocation Remote
    Job Type Full-time
    Experience Level Entry level

    Nava

    United State

    IT Support Technician

    Networking
    •
    15h ago
    Visa Sponsorship Relocation Remote
    Job Type Full-time
    Experience Level Entry level

    j-mack technologies, llc

    United State
    Visa Sponsorship Relocation Remote
    Job Type Contract
    Experience Level Entry level

    brotherstech

    United State

    Subscribe our newsletter

    New Things Will Always Update Regularly