Job Description

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

• 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.
• 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 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 $95,000 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.