SQL Database Administrator (Artesia, NM.)

Citizant Inc•Artesia, NM

About The Position

Citizant is a leading provider of professional IT services to the U.S. government. We seek to address some of our country’s most pressing challenges in the areas of Agile application development, Enterprise Data Management, Enterprise Architecture, and Program Management support services – focusing on the U.S. Departments of Homeland Security and Treasury. We strive to hire only ethical, talented, passionate, and committed “A Players” who already align with the company’s core values: Drive, Excellence, Reputation, Responsibility, and a Better Future. No matter how large we grow, Citizant will retain its collaborative, supportive, small-company culture, where successful team effort to address external and internal customer challenges is valued above all individual contributions. Position Overview: The SQL Database Administrator (DBA) is responsible for the design, implementation, maintenance, and optimization of Microsoft SQL Server databases supporting mission-critical applications in a large enterprise environment. This position ensures data integrity, performance, and availability across multiple systems and supports both operational and development teams with advanced SQL expertise. The ideal candidate will have extensive experience in Microsoft SQL Server 2012 or newer, a strong background in database architecture, and proven ability to manage, tune, and secure SQL environments at scale.

Requirements

Minimum of five (5) years of hands-on experience designing, implementing, and administering Microsoft SQL Server databases (SQL Server 2012 or newer).
Proficiency in T-SQL scripting, database architecture, and relational database design.
Experience with SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Agent.
Proven ability to manage database performance tuning, query optimization, and indexing strategies.
Understanding of backup/recovery, replication, and high availability (HA/DR) configurations (Always On, Log Shipping, Mirroring, Clustering).
Strong analytical, problem-solving, and communication skills.
U.S. Citizenship required; ability to obtain or maintain a DHS Public Trust clearance (Secret preferred).

Nice To Haves

Certifications such as Microsoft Certified: SQL Database Administrator Associate, MCSE: Data Management and Analytics, or equivalent.
Experience with cloud database technologies (Azure SQL, AWS RDS).
Familiarity with PowerShell scripting for database automation and monitoring.
Knowledge of data governance, ETL processes, and data warehousing concepts.
Experience in a federal IT or DHS enterprise environment supporting large-scale database systems.

Responsibilities

Design, install, configure, and maintain Microsoft SQL Server databases in production, test, and development environments.
Develop, implement, and monitor database policies and procedures to ensure data integrity, security, and performance.
Create and maintain database objects such as tables, views, stored procedures, triggers, and functions.
Perform database tuning, optimization, indexing, and query analysis to enhance application performance.
Manage database backup, restore, and disaster recovery strategies in accordance with organizational policies.
Monitor and troubleshoot database performance issues, connectivity errors, and replication failures.
Coordinate with application developers, system administrators, and network engineers to support integration and deployment activities.
Perform routine database upgrades, patching, and version migrations to maintain compliance and performance standards.
Implement data security and access controls consistent with DHS and enterprise cybersecurity policies.
Generate detailed reports on database health, capacity, and utilization for management and audit purposes.
Provide mentorship and technical support to development and operations teams on SQL best practices.