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

Ask IT Consulting, Inc.; Washington (District of Columbia); Sur place; USD 120 000 - 150 000; Plein temps

Résumé du poste

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.

Responsabilités

• 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.

Connaissances

MS SQL Server

Database administration

SSRS

T-SQL

Database security

Upgrades & migrations

Change management

Agile teamwork

Documentation

Data integrity

Formation

Bachelor's Degree

Outils

SSIS

Description du poste

Ask ITC Inc. which is backed by a $500 million Microtek group company, provides an industry leading blend of technology, business consulting, and outsourcing services.

Ask IT is a minority-owed enterprise; it has been founded on providing the highest quality possible and on the devotion to customer satisfaction.

Job Description

Support development and maintenance of OSSE applications. Provide database administrative support to production and non-production databases in Microsoft SQL RDBMS platforms and ensure database availability

The Senior SQL Database Administrator will also install and configure RDBMS software, periodically patch applications, troubleshoot problems, provide performance tuning, software configuration, capacity planning, architecture recommendations, data migrations, database backup and database recovery. Provide production system support 24X7 on a rotation basis. Proactively monitor and tune databases as needed; define backup, restore, and recovery requirements. Provide recommendations for large database sizing, provide batch scripting support and provide technical documentation. Install and interface with emerging technologies databases to include SAML protocols, SOAP, Net 2.0 technologies.

Qualifications

• Production DBA support for custom and COTS systems: MS SQL Server
• Support system implementation with database installation/configuration
• Experience as a Database Administrator
• Experience with SSRS, both creating and modifying
• Bachelor's Degree
• Experience in database design and development using SQL Server
• Experience with advanced level of writing T-SQL Code including stored procedures, functions and triggers, developing SSIS, SSRS packages
• Experience in developing database structure, developing database utilization policies, procedure, security, in coordination with DBA.
• Experience in performing platform upgrades and migrations, monitoring performance, and coordinating actions
• Experience in DBA change management support including code releases and hot fixes
• Experience with embedded within an agile product development team working on a multi-tenant database
• Experience in creating technical and architectural documentation
• Experience with insuring the integrity and security of the data

Additional Information

All your information will be kept confidential according to EEO guidelines.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply