SQL Database Administrator (Artesia, NM.) at Citizant

Artesia, New Mexico, United States -

Full Time

Start Date

Immediate

Expiry Date

21 Apr, 26

Salary

0.0

Posted On

22 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Database Administration, T-SQL Scripting, Database Architecture, Relational Database Design, Performance Tuning, Query Optimization, Backup Recovery, High Availability, Data Security, Disaster Recovery, Cloud Database Technologies, PowerShell Scripting, Data Governance, ETL Processes, Data Warehousing

Industry

IT Services and IT Consulting

Description

Description Company Description 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. Primary 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. 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). Preferred Qualifications 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. Education: Bachelor’s degree in Computer Science, Information Systems, System Analysis, or a related field. Advanced degree preferred, or equivalent combination of education and professional experience. Clearance Requirement: U.S. Citizenship is required to be considered Active Public Trust or have the ability to obtain one. Citizant offers a competitive benefits package, including: Medical, dental, and vision insurance 401(k) Generous PTO Company-paid life and disability insurance Flexible Spending Accounts (FSA) Employee Assistance Program (EAP) Tuition Assistance & Professional Development Program Additional information Citizant strives to be an employer of choice in the Washington metropolitan area. Citizant associates accept challenging and rewarding work and in return receive excellent compensation and benefits, as well as the opportunity for personal and professional development. Citizant is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Responsibilities

The SQL Database Administrator is responsible for the design, implementation, maintenance, and optimization of Microsoft SQL Server databases. This includes ensuring data integrity, performance, and availability across multiple systems while supporting both operational and development teams.