Database Administrator III
Title: Database Administrator III
Location: Madison, WI (Primarily remote, with quarterly onsite meetings)
Duration : 12+ Months
Job Description:
The DHS Database Administrator will work closely with application developers to integrate databases with applications, ensuring efficient data modeling and database management. This role involves database security, tuning, monitoring, and compliance while collaborating with cross-functional teams across the organization.
Key Responsibilities:
- Collaborate with developers and project teams to analyze requirements and model data structures.
- Create and maintain efficient database schemas.
- Manage SQL database backups and recovery procedures.
- Act as a liaison with the Division of Enterprise Technology (DET) for:
- Server patching validation
- Software upgrades
- User access controls
- Creation of new servers or databases in the Enterprise SQL or Oracle environment
- Ensure changes follow DHS change management policies.
- Maintain database structures according to DHS security policies, compliance regulations, and business requirements.
- Work with state departments, technical administrators, business professionals, and third-party vendors.
- Ensure government security and data encryption compliance (MARS-E 2.2, HIPAA, PII).
Required Skills (Need Majority; 8+ Years):
Microsoft SQL Server (2016, 2019, 2022)
Complex SQL Queries
Data Modeling
Database Schema Design
Database Security
Database Monitoring & Performance Tuning
Logical Database Design
RedGate Tools (SQL Compare, SQL Data Compare, SQL Source Control, DLM Dashboard, SQL Clone, Data Generator, SQL Monitor)
Nice-to-Have Skills:
Experience with Oracle databases for Java applications
Oracle 19c and Oracle Database Security (synonyms, roles, privileges)
Oracle Data Dictionary Views & SQL Tuning
PL/SQL Development
Power BI for reporting & database analysis
Application database migration to new platforms
Experience with ETL Tools: Informatica, SSIS, SSRS, SSAS
Preferred Tools & Compliance Experience:
- SQL Database Services & Management Tools:
- SQL Server Management Studio (SSMS)
- Visual Studio 2022
- RedGate Comparison Tools
- Report Builder
- Oracle SQL Developer & SQL Plus
- Government Security & Compliance:
- MARS-E 2.2
- HIPAA
- PII Compliance
Additional Notes:
- Some weekend or off-hours work may be required for application upgrades or database maintenance.
- The position requires creativity and autonomy in developing database solutions.
Title: Database Administrator III
Location: Madison, WI (Primarily remote, with quarterly onsite meetings)
Duration : 12+ Months
Job Description:
The DHS Database Administrator will work closely with application developers to integrate databases with applications, ensuring efficient data modeling and database management. This role involves database security, tuning, monitoring, and compliance while collaborating with cross-functional teams across the organization.
Key Responsibilities:
- Collaborate with developers and project teams to analyze requirements and model data structures.
- Create and maintain efficient database schemas.
- Manage SQL database backups and recovery procedures.
- Act as a liaison with the Division of Enterprise Technology (DET) for:
- Server patching validation
- Software upgrades
- User access controls
- Creation of new servers or databases in the Enterprise SQL or Oracle environment
- Ensure changes follow DHS change management policies.
- Maintain database structures according to DHS security policies, compliance regulations, and business requirements.
- Work with state departments, technical administrators, business professionals, and third-party vendors.
- Ensure government security and data encryption compliance (MARS-E 2.2, HIPAA, PII).
Required Skills (Need Majority; 8+ Years):
Microsoft SQL Server (2016, 2019, 2022)
Complex SQL Queries
Data Modeling
Database Schema Design
Database Security
Database Monitoring & Performance Tuning
Logical Database Design
RedGate Tools (SQL Compare, SQL Data Compare, SQL Source Control, DLM Dashboard, SQL Clone, Data Generator, SQL Monitor)
Nice-to-Have Skills:
Experience with Oracle databases for Java applications
Oracle 19c and Oracle Database Security (synonyms, roles, privileges)
Oracle Data Dictionary Views & SQL Tuning
PL/SQL Development
Power BI for reporting & database analysis
Application database migration to new platforms
Experience with ETL Tools: Informatica, SSIS, SSRS, SSAS
Preferred Tools & Compliance Experience:
- SQL Database Services & Management Tools:
- SQL Server Management Studio (SSMS)
- Visual Studio 2022
- RedGate Comparison Tools
- Report Builder
- Oracle SQL Developer & SQL Plus
- Government Security & Compliance:
- MARS-E 2.2
- HIPAA
- PII Compliance
Additional Notes:
- Some weekend or off-hours work may be required for application upgrades or database maintenance.
- The position requires creativity and autonomy in developing database solutions.