Database analyst serp_jobs.h1.location_city

Database Administrator (SQL DBA) / System Administrator

The Database Administrator (SQL) / System Administrator is responsible for maintaining and optimizing the organizations IT infrastructure and database systems. This hybrid position supports both system administration and database operations equally ensuring high availability performance and security across servers and SQL environments. The role combines hands-on management of Windows systems MECM and GPO administration with SQL Server database maintenance monitoring and optimization.

Primary Responsibilities

Database Administration (SQL) (50%)

Support and maintain SQL Server database environments (approximately three servers) to ensure operational stability performance and data integrity.

Monitor and resolve database alerts incidents and performance issues related to CPU memory I / O disk space blocking deadlocking replication and connectivity.

Perform daily database maintenance tasks including backups restores recovery model management DBCC commands index and statistics maintenance and capacity checks.

Implement performance tuning and query optimization using SQL Profiler Performance Monitor and related diagnostic tools.

Administer replication clustering mirroring and log shipping configurations to maintain database reliability and fault tolerance.

Review and validate backup maintenance and monitoring reports daily; ensure timely resolution of database-related issues.

Develop and maintain automation for repetitive database operations and reporting.

Provide weekly operational status reports to the COR or IT Manager summarizing performance metrics incidents and system improvements.

Collaborate with network and application teams to resolve issues requiring cross-functional support.

System Administration (50%)

Perform physical and virtual server maintenance installation patching configuration backup and restoration.

Manage and administer technologies such as Microsoft Endpoint Configuration Manager (MECM) Group Policy Objects (GPO) and Windows Server environments.

Schedule and perform operating system and firmware updates security patches and maintenance tasks to ensure compliance and optimal performance.

Configure and maintain server hardware health and ensure continuous application availability.

Tune systems for optimal performance and implement automation and scripting (e.g. PowerShell) for operational efficiency.

Develop and maintain system and application monitoring procedures and conduct daily health checks.

Generate performance metrics and analyze resource consumption trends for capacity and performance planning.

Ensure system security compliance through auditing patch management and configuration control.

Collaborate with other infrastructure and security teams to maintain high availability scalability and disaster recovery readiness.

Create and maintain detailed operational documentation including escalation procedures contact lists and configuration baselines.

Requirements

Bachelors degree in Information Technology Computer Science or related discipline or equivalent experience.

35 years of experience as a Windows System Administrator (MECM GPO patch management automation).

24 years of experience with Microsoft SQL Server administration and performance optimization.

Proficiency in PowerShell or similar scripting languages for automation.

Experience with virtualization platforms (e.g. VMware Hyper-V).

Strong understanding of system and database security compliance and auditing practices.

Excellent analytical troubleshooting and communication skills.

Ability to manage multiple systems and databases simultaneously in a fast-paced environment.

Security & Compliance

Ensure compliance with organizational and government security requirements.

Maintain and document system and database configuration baselines in accordance with security policies.

Participate in audits and assist in remediating identified vulnerabilities.

Support continuity of operations through backup redundancy and disaster recovery procedures.

Reporting

Provides weekly status and performance reports.

Benefits

Employer Health Plan 401K Holiday and Vacation.

Required Skills : DBA System Admin SQL

Required Education : DBA System Admin SQL

Key Skills

Accomodation,Database,Information Technology Sales,Insurance Paralegal

Employment Type : Full Time

Experience : years

Vacancy : 1