Implementation Consultant: Database Administrator

Brooklyn, United States | Posted on 11/20/2023

InterScripts is a Information Technology business based in Chantilly,VA and established in 2017 providing technology and platform enabled service sand solutions. Historically, we have enabled our customers to realize the mostvalue from their technology and resources through our Managed Services, Archival Solution, EHR,ERP, Advisory, Virtual Care, Technology, Application Development, and Cybersecurity services.

In addition, InterScripts has substantial experience in providing Technology and Platform Enabled solutions to commercial, public sector, and government entities. We are an ISO 27001, 9001 CMMI 3 and SOC 2 certified organization, signifying our ability to lower the risks for our clients’ application modernization efforts, custom development, support,operations, and MSP projects.

Job Summary:

Responsible for maintaining database systems including database back-ups, performance tuning, capacity planning, and monitoring critical events. Provides leadership during the development and enhancement of production applications. Works with application support,technical support and operations team members during the design, development and implementation of applications and documents the process. Collaborates with other core infrastructure teams,business units, and development teams to carry out key initiatives and projects.

Keeps current with technology while applying best practices utilizing tools toanalyze, debug, and resolve database performance issues

Specific
Duties
and
Responsibilities:

• Monitor SQL Server health, growth, and proactively manage enterprise data systems toward 100% uptime
• Provide day-to-day oversight and support of production databases, data warehouse/data marts
• Assist in design,development, implementation and maintenance of application systems (web andnon- web)
• Extract, load and join data from multiple databases
• Administer SQL Server user accounts, roles and permissions
• Create, maintain and organize knowledge base of existing data systems documentation
• Produce ad-hoc SQL based reports in an on-demand environment
• Gather functional specifications and business requirements for new programming tasks including DTS packages, stored procedures, triggers etc.

• 2+Proficient in T-SQL, Stored Procedures, Triggers, Multidimensional Expressions (MDX), Cubes

• 3+ yrs Knowledge of Replication, DTS/SSIS, index management, and statistics

• 2 + yrs knowledge of relational database design

• 2 +yrs Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server

• 2+Strong SSRSand Crystal Reports report writing experience

• 2+Demonstrated strong organizational, analytical, and problem solving skills.

Required

Education:

Bachelor's Degree in Science, IS for related field.