Database Administrator Advanced

Elegant Enterprise- Wide Solutions Inc

Job Location:

Columbia, IN - USA

Monthly Salary: Not Disclosed

Posted on: 13 hours ago

Vacancies: 1 Vacancy

Job Summary

About this Position:

Job Title: Database Administrator

Responsibilities:

Database Administration: Administer and maintain SQL Server (2016) instances across multiple judicial environments managing security authentication models and contained users.
Operational Maintenance: Configure and monitor SQL Agent jobs maintenance plans and index strategies while validating backup/restore and disaster recovery procedures.
High Availability & Scale: Support Always On and clustering configurations while optimizing large-scale tables used for court case data.
Performance Tuning: Analyze and tune complex workloads including stored procedures dynamic SQL CTEs and cross-database queries to reduce blocking and deadlocks.
ETL & Data Optimization: Review ETL loops across multiple CMS databases implementing partitioning and incremental load strategies where appropriate.
Data Integrity & Remediation: Assist with referential integrity enforcement foreign key reconciliation identity reseeding and large-scale data cleanup.
Statewide Standardization: Support the alignment of county codes circuit mappings and court types to meet the Chiefs data and reporting standards.
Reporting & Analytics Support: Optimize fact/dimension loading and perform back-end query tuning to support Power BI reporting and aggregation tables.
Security & Compliance: Harden instances against unauthorized access and ensure strict compliance with judicial confidentiality and court system standards.
DevOps & Automation: Create reusable administrative scripts for multi-database updates and assist in scripting deployment pipelines for schema and code changes.

Required Skills:

7 years of experience with SQL Database Administration & Operations.
3 years of experience with Performance Tuning & Optimization.
3 years of experience with Data Integrity & Governance Support.
3 years of experience with Data Warehouse Architecture & Reporting Support.
3 years of experience with Security & Compliance.
3 years of experience with Automation & DevOps Support.

Preferred/Nice to Have Skills:

Experience in judicial government or public sector environments.
Power BI backend optimization.
.NET application data access patterns.
Always On Availability Groups.
Azure DevOps.
Experience cleaning legacy data structures across multiple counties or jurisdictions.

About this Position: Job Title: Database Administrator Responsibilities: Database Administration: Administer and maintain SQL Server (2016) instances across multiple judicial environments managing security authentication models and contained users. Operational Maintenance: Configure and monitor ...

About this Position:

Job Title: Database Administrator

Responsibilities:

Database Administration: Administer and maintain SQL Server (2016) instances across multiple judicial environments managing security authentication models and contained users.
Operational Maintenance: Configure and monitor SQL Agent jobs maintenance plans and index strategies while validating backup/restore and disaster recovery procedures.
High Availability & Scale: Support Always On and clustering configurations while optimizing large-scale tables used for court case data.
Performance Tuning: Analyze and tune complex workloads including stored procedures dynamic SQL CTEs and cross-database queries to reduce blocking and deadlocks.
ETL & Data Optimization: Review ETL loops across multiple CMS databases implementing partitioning and incremental load strategies where appropriate.
Data Integrity & Remediation: Assist with referential integrity enforcement foreign key reconciliation identity reseeding and large-scale data cleanup.
Statewide Standardization: Support the alignment of county codes circuit mappings and court types to meet the Chiefs data and reporting standards.
Reporting & Analytics Support: Optimize fact/dimension loading and perform back-end query tuning to support Power BI reporting and aggregation tables.
Security & Compliance: Harden instances against unauthorized access and ensure strict compliance with judicial confidentiality and court system standards.
DevOps & Automation: Create reusable administrative scripts for multi-database updates and assist in scripting deployment pipelines for schema and code changes.

Required Skills:

7 years of experience with SQL Database Administration & Operations.
3 years of experience with Performance Tuning & Optimization.
3 years of experience with Data Integrity & Governance Support.
3 years of experience with Data Warehouse Architecture & Reporting Support.
3 years of experience with Security & Compliance.
3 years of experience with Automation & DevOps Support.

Preferred/Nice to Have Skills:

Experience in judicial government or public sector environments.
Power BI backend optimization.
.NET application data access patterns.
Always On Availability Groups.
Azure DevOps.
Experience cleaning legacy data structures across multiple counties or jurisdictions.