AZED Information Technology Division (IT)
Share
Job Location:
Phoenix, NM - USA
Monthly Salary:
Not Disclosed
Posted on:
4 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Summary:
The Database Administrator is responsible for managing all aspects of the Arizona Department of Educations (ADE) data including database backup and recovery design maintenance performance tuning and security. This role involves designing and writing stored procedures implementing disaster recovery plans and configuring database software (SQL Server). The administrator will also work with Power BI datasets and ETL processes collaborate with application and BI teams and implement version control practices. Occasional in-state travel may be required.
The Database Administrator is responsible for managing all aspects of the Arizona Department of Educations (ADE) data including database backup and recovery design maintenance performance tuning and security. This role involves designing and writing stored procedures implementing disaster recovery plans and configuring database software (SQL Server). The administrator will also work with Power BI datasets and ETL processes collaborate with application and BI teams and implement version control practices. Occasional in-state travel may be required.
Location:Phoenix Arizona United States
Responsibilities:
- Assist and cross-train in the work of other database administrators.
- Review and recommend improvements to existing architecture and code.
- Meet with IT staff to determine system requirements related to data storage retrieval and performance.
- Design and code stored procedures and scripts to facilitate database administration (Powershell experience desired).
- Develop database administration tools/utilities/operation procedures.
- Assist in developing purge/archive criteria and procedures for historical application data.
- Proactively solve complex problems.
- Review evaluate design implement and maintain company databases.
- Implement and review appropriate security guidelines/mechanisms.
- Implement database migrations and changes.
- Management of Azure database virtual machines.
- Troubleshoot application key selection creation of appropriate indexes and query needs.
- Ensure that databases are operational and functioning properly.
- Perform database maintenance functions.
- Move rebuild or change database objects as required in production.
- Develop and test database migration procedures.
- Manager Power BI Configuration.
- Assist in interviewing and training new hires and provide guidance to Junior Developers when required.
- Manage SQL Server Always On configurations.
- Provide on-call support to correct database issues or assist with other processes that require off-hours support.
- Educate users and maintains database documentation.
- Establish database procedures and standards; assists in database design.
- Writing PowerShell scripting.
- Design develop and optimize stored procedures functions and queries.
- Implement indexing strategies for performance improvement.
- Build and maintain SSIS packages for ETL workflows.
- Other duties as assigned as related to the position.
- Assist and cross-train in the work of other database administrators.
- Review and recommend improvements to existing architecture and code.
- Meet with IT staff to determine system requirements related to data storage retrieval and performance.
- Design and code stored procedures and scripts to facilitate database administration (Powershell experience desired).
- Develop database administration tools/utilities/operation procedures.
- Assist in developing purge/archive criteria and procedures for historical application data.
- Proactively solve complex problems.
- Review evaluate design implement and maintain company databases.
- Implement and review appropriate security guidelines/mechanisms.
- Implement database migrations and changes.
- Management of Azure database virtual machines.
- Troubleshoot application key selection creation of appropriate indexes and query needs.
- Ensure that databases are operational and functioning properly.
- Perform database maintenance functions.
- Move rebuild or change database objects as required in production.
- Develop and test database migration procedures.
- Manager Power BI Configuration.
- Assist in interviewing and training new hires and provide guidance to Junior Developers when required.
- Manage SQL Server Always On configurations.
- Provide on-call support to correct database issues or assist with other processes that require off-hours support.
- Educate users and maintains database documentation.
- Establish database procedures and standards; assists in database design.
- Writing PowerShell scripting.
- Design develop and optimize stored procedures functions and queries.
- Implement indexing strategies for performance improvement.
- Build and maintain SSIS packages for ETL workflows.
- Other duties as assigned as related to the position.
Required Skills & Certifications:
Preferred Skills & Certifications:
Special Considerations:
Scheduling:
Key Skills
- Business Process
- Active Directory
- Customer Service
- Information Technology
- HIPAA
- Information Security
- Infrastructure
- Linux
- Project Management
- Nist
- Risk Assessments
- Procedures
- hardware
- Data Analysis
- Technical Support
