67 applicantsPosted by Agency

Company

ACS Consultancy Services, Inc · 12 hours ago

SQL Server Database Administrator

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

Install, configure, and upgrade SQL Server databases across various environments (development, testing, production).

Monitor and maintain database performance, capacity, and availability.

Analyze database performance issues and implement solutions for performance tuning.

Optimize queries, indexes, and database structures.

Develop, implement, and test backup and recovery strategies.

Ensure data integrity and business continuity through disaster recovery planning.

Implement and manage database security, including user roles, permissions, and encryption.

Conduct regular audits and compliance checks to meet organizational and regulatory requirements.

Configure and manage high-availability solutions such as AlwaysOn Availability Groups, clustering, and log shipping.

Set up and maintain database replication strategies.

Design and implement database schemas, stored procedures, and triggers.

Collaborate with development teams to support database design and query optimization.

Utilize monitoring tools to proactively identify and resolve database issues.

Respond to incidents and outages, performing root cause analysis and corrective actions.

Maintain comprehensive documentation for database configurations, processes, and procedures.

Ensure adherence to database design and coding standards.

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-SQLHigh availability solutionsSSISSSRSSSASMicrosoft Azure SQL DatabaseDatabase security practicesMonitoring toolsAzure Data FactoryPower BI integrationDevOps practicesScripting skillsNoSQL databasesOther RDBMS platformsFederal ExperienceSecurity clearance

Required

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

Experience as a SQL Server DBA

Strong knowledge of T-SQL, SSIS, SSRS, and SSAS

Hands-on experience with high availability and disaster recovery (HADR) solutions

Understanding of database security practices and regulatory compliance

Experience with monitoring tools such as SQL Server Profiler, Extended Events, or third-party solutions (e.g., Redgate, SolarWinds)

Scripting skills (PowerShell, Python, or similar)

Required Security clearance

Preferred

Proficiency with SQL Server (versions 2016 and later preferred)

Experience with cloud database solutions, especially Microsoft Azure SQL Database

Knowledge of Azure Data Factory and Power BI integration

Experience with DevOps practices and tools for CI/CD in database environments

Experience with NoSQL databases or other RDBMS platforms

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