Apply on Employer Site

Citizant · 2 months ago

SQL Database Administrator (Onsite: Artesia, NM. - REF1884H)

1300 W Richey Ave, Artesia, NM 88210, USA

Full-time

Onsite

Mid, Senior Level

$95K/yr - $95K/yr

5+ years exp

Citizant is a leading provider of professional IT services to the U.S. government. 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.

Data IntegrationEnterprise ApplicationsEnterprise SoftwareInformation TechnologyProject Management

Comp. & Benefits

No H1B

Security Clearance Required

U.S. Citizen Only

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

Qualification

Microsoft SQL ServerT-SQL scriptingDatabase architecturePerformance tuningSQL Server Management StudioSQL Server Integration ServicesSQL Server Reporting ServicesBackup/recovery strategiesCloud database technologiesAnalytical skillsPowerShell scriptingData governance knowledgeProblem-solving skillsCommunication skills

Required

Bachelor's degree in Computer Science, Information Systems, System Analysis, or a related field

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)