Information Technology Specialist

- 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 database[s].
- 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: