Be an early applicantLess than 25 applicantsPosted by Agency

Company

ACS Consultancy Services, Inc · 9 hours ago

MSSQL Developer

United States

Full-time

Remote

Mid Level

Maximize your interview chances

ConsultingInformation Services

No H1B

U.S. Citizen Only

Security Clearance Required

Insider Connection @ACS Consultancy Services, Inc

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Design, implement, and optimize database structures and objects, including tables, views, indexes, stored procedures, and functions.

Write and troubleshoot complex T-SQL queries to support application requirements.

Monitor and analyze database performance, identifying bottlenecks and implementing solutions to enhance efficiency.

Optimize SQL queries and indexes for improved system performance.

Develop, implement, and maintain ETL processes using SQL Server Integration Services (SSIS) or other tools.

Ensure the accurate extraction, transformation, and loading of data between systems.

Perform regular database maintenance tasks, including backups, restoration, and integrity checks.

Implement security measures to safeguard data, including access controls, encryption, and auditing.

Work closely with application developers, business analysts, and other stakeholders to understand data requirements and deliver database solutions.

Maintain comprehensive documentation of database designs, processes, and systems.

Develop and maintain reports using SQL Server Reporting Services (SSRS) or other reporting tools.

Support business intelligence efforts by designing and maintaining data warehouses.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL ServerT-SQLDatabase AdministrationPerformance TuningSSISSSRSDatabase ModelingAzure SQL DatabaseAWS RDSDatabase SecurityCloud DatabaseFederal ExperienceSecurity ClearanceDocumentation

Required

Bachelor’s degree in Computer Science, Information Systems, or a related field.

Experience in SQL Server development and database administration.

Strong proficiency in T-SQL programming and performance tuning.

Experience with SSIS, SSRS, or similar tools.

In-depth knowledge of SQL Server architecture and components (e.g., database engine, SQL Agent).

Experience with database modeling and design (ER diagrams, normalization).

Experience with cloud database environments such as Azure SQL Database or AWS RDS.

Required Security clearance.

Preferred

Federal Experience is a plus.

Company

ACS Consultancy Services, Inc

ACS Consultancy Services Inc is a Small Business that is New York State and New York City Certified Minority and Women-Owned Business Enterprise (MWBE).

Founded in 2011