iQuasar LLC ยท 2 months ago
SQL Server Database Administrator (DBA)
iQuasar LLC is seeking a SQL Server Database Administrator to manage and optimize on-premises SQL databases that support web applications. The role involves ensuring high performance, availability, security, and sustainability of database systems through proactive maintenance and strategic planning.
CRMInformation TechnologySoftware
Responsibilities
Database Management & Maintenance
Configure, install, upgrade, and maintain Microsoft SQL Server databases in a production environment
Monitor database performance and conduct tuning procedures to ensure optimal operation
Create and manage scheduled jobs, data extracts, refreshes, loads, and replication processes
Ensure high levels of database performance, availability, and data integrity
Implement and manage high availability solutions such as Always On and SQL clustering
Apply Transparent Data Encryption (TDE) and manage encrypted database backups and restores
Develop and implement merge and transactional replication strategies
Automate routine database tasks to improve efficiency and reduce manual intervention
Diagnose and resolve issues related to performance, blocking/deadlocks, replication, connectivity, and security
Perform data modeling, query optimization, and analysis of customer-provided data
Write SQL queries and reports using existing data
Create and update records based on business requirements
Develop and enforce database policies and procedures to maintain system integrity and compliance
Maintain documentation for database configurations, processes, and troubleshooting steps
Qualification
Required
5+ years of experience with Microsoft SQL Server in application support or development environments
Strong proficiency in SQL Server 2016 and newer versions
Deep understanding of database structures, principles, and best practices
Skilled in T-SQL including indexes, triggers, functions, stored procedures, and packages
Experience with SQL Server replication (merge and transactional)
Familiarity with SSAS (Analysis Services), SSIS (Integration Services), and SSRS (Reporting Services)
Proficient in Windows Server operating systems
Hands-on experience with Transparent Data Encryption (TDE)
Strong knowledge of backup strategies, restore procedures, and recovery models
Experience implementing high availability solutions (Always On, clustering)
Excellent communication and interpersonal skills for client interaction
Strong analytical and problem-solving abilities
Ability to work effectively in agile, cross-functional development teams
SQL Server certification
CompTIA Security+ certification
Must hold an ACTIVE Secret Clearance or higher
Benefits
401(k) matching
Dental insurance
Health insurance
Paid time off
Company
iQuasar LLC
iQuasar is an information technology company that provides custom software implementation services.
Funding
Current Stage
Growth StageRecent News
Company data provided by crunchbase