AssetWorks Inc

SQL Server Administrator

AssetWorks Inc

full-time

Posted on:

Location Type: Remote

Location: Remote • Pennsylvania • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AzureCloudOracleSQL

About the role

  • Administer, monitor, and maintain on-premises SQL Servers, Azure SQL Databases , and Azure SQL and SQL Managed Instances
  • Perform database installation, configuration, patching, upgrades, and migrations between platforms
  • Ensure high availability, disaster recovery, backup, and recovery planning for all SQL environments
  • Monitor database performance and health, implementing tuning and optimization strategies
  • Collaborate with development, QA, and operations teams to support application deployments
  • Implement and maintain security policies, including user access, roles, and permissions
  • Troubleshoot and resolve database-related issues in both on-premises and cloud environments
  • Manage capacity planning, storage optimization, and database growth strategies
  • Automate routine tasks using PowerShell, T-SQL, Azure CLI, and other scripting tools
  • Maintain documentation for database architecture, configuration, and best practices
  • Provide 24/7 on-call support for critical database issues
  • Manage database conversions between SQL Server and Oracle platforms

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field
  • 5+ years of experience managing SQL Server environments
  • Strong experience with Azure SQL Databases and Managed Instances
  • Proficiency in T-SQL, PowerShell, and database automation scripting
  • Knowledge of backup/recovery strategies, HA/DR solutions, and performance tuning
  • Experience with database monitoring tools and troubleshooting
  • Familiarity with cloud networking, security, and compliance standards in Azure
  • Experience with database migration tools (Azure Database Migration Service, Data Migration Assistant)
  • Knowledge of Azure security features (Azure AD integration, TDE, Always Encrypted)
  • Strong problem-solving and collaboration skills
  • Effective communicator and self-starter
  • Willingness to participate in on-call rotation
  • Microsoft SQL and Azure certifications (Azure Database Administrator Associate preferred)
  • Experience with cross-platform database conversions between SQL Server and Oracle (preferred)
Benefits
  • Generous Paid Time Off
  • 11 Paid Holidays
  • Medical, Dental, Vision, Life insurance benefits with various choices and generous employer contribution
  • 401k with employer match which immediately vests
  • Annual Company Bonus
  • Career growth and mentoring opportunities as a smaller business unit within the Volaris Group
  • Tuition Reimbursement Program
  • Employee rewards and recognition programs
  • Optional Employee Stock Purchase Program with company match
  • Pet insurance
  • TicketsatWork program, discounted entertainment tickets to movies, sporting events, hotels, live performances, etc.
  • Referral bonuses
  • Employee engagement events
  • Flexible remote work arrangements

Applicant Tracking System Keywords

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

Hard skills
SQL ServerAzure SQL DatabasesT-SQLPowerShelldatabase automation scriptingbackup/recovery strategiesperformance tuningdatabase migration toolscross-platform database conversionsdisaster recovery
Soft skills
problem-solvingcollaborationeffective communicationself-starterwillingness to participate in on-call rotation
Certifications
Bachelor's degree in Computer ScienceBachelor's degree in Information TechnologyAzure Database Administrator Associate