Senior SQL DBA: 24/7 Production Support & T-SQL Expert

Ask IT consulting; Washington (District of Columbia); On-site; USD 120,000 - 150,000; Full time

Job summary

Ask ITC Inc. seeks a Senior SQL Database Administrator to support MS SQL Server environments, ensure database availability, and lead data architecture decisions. The role includes installation, configuration, patching, performance tuning, backups, and 24x7 production support on a rotation basis.

The ideal candidate will have extensive T-SQL experience, SSRS/SSIS skills, and a proven track record in security, upgrades, and multi-tenant database design within an agile development setting.

Qualifications

• Production DBA support for MS SQL Server and similar environments.
• Experience with installing/configuring database systems and troubleshooting.
• Proficiency in T-SQL, stored procedures, functions, triggers, SSIS/SSRS.
• Designing database structures, security, and utilization policies.
• Experience with platform upgrades, migrations, performance monitoring, and batch scripting.
• Ability to work in an agile team and produce technical docs.
• Strong data integrity and security practices.

Responsibilities

• Provide 24x7 production support on a rotation basis.
• Install, configure, patch, and tune MSSQL databases for performance and availability.
• Develop and modify SSRS reports; create SSIS packages as needed.
• Guide archive sizing, backups, restores, and disaster recovery.
• Collaborate with agile teams on multi-tenant database design and migrations.
• Document architecture, procedures, and change management steps.

Skills

MS SQL Server

Database administration

SSRS

T-SQL

Database security

Upgrades & migrations

Change management

Agile teamwork

Documentation

Data integrity

Education

Bachelor's Degree

Tools

SSIS

Job description

Ask ITC Inc. seeks a Senior SQL Database Administrator to support MS SQL Server environments, ensure database availability, and lead data architecture decisions. The role includes installation, configuration, patching, performance tuning, backups, and 24x7 production support on a rotation basis.

The ideal candidate will have extensive T-SQL experience, SSRS/SSIS skills, and a proven track record in security, upgrades, and multi-tenant database design within an agile development setting.