SQL Database Administrator (Onsite Artesia, NM. REF1884H)

Position Summary: 

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.

Qualifications :

Required Qualifications

• Bachelors degree in Computer Science Information Systems System Analysis or a related field.
  • Advanced degree preferred or equivalent combination of education and professional experience.
• 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:

• Bachelors degree in a relevant field

Clearance Requirement:

• U.S. Citizenship is required to be considered
• Active Public Trust or have the ability to obtain one.

Salary Range Artesia:

• The expected pay range for this position is up to $95000 yearly. 
• The exact pay rate will vary based on skills experience and location.

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.

Remote Work :

No

Employment Type :

Full-time