Job Description
This is a 4 month contract to hire position. All candidates must be eligible to convert to an FTE. The State is unable to sponsor any visas. In office 2-3 days onsite first week then once a month or as needed. Local to Phoenix only.
Job Summary:
Responsible for assisting with the management of all aspects of the Arizona Department of Education's (ADE) data including but not limited to:
• Database backup and recovery
• Logical and physical database design
• Designing and writing stored procedures
• Disaster recovery
• Database maintenance, connectivity, replication, performance and tuning, upgrades, naming conventions and standards
• Installation and configuration of database software (SQL Server)
• Diagnosing and correcting database operational problems
• Strong PowerShell scripting skills for jobs automation
• Configure and support Power BI datasets, gateways, and refresh schedules
• Design and develop stored procedures, functions, and triggers
• Develop and optimize complex SQL queries and stored procedures for reporting and analytics
• Design and implement ETL processes for data integration and transformation
• Collaborate with application and BI teams to support data-driven solutions
• Implement version control and DevOps practices for database objects
• Occasional in-state travel is required for this position
The Arizona Department of Education currently utilizes a hybrid work environment, with up to two days of remote work (contingent upon business needs). Candidates should apply with an ability and willingness to work in-office up to five days per week as business needs necessitate.
Job Duties:
• Assist and cross-train in the work of other database administrators
• Review and recommend improvements to existing architecture
• Tune performance, review, and recommend improvements to existing code
• Meet with other IT staff to determine scope of 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
Knowledge, Skills & Abilities (KSAs):
Knowledge in:
• General working knowledge of physical data models, technical architecture, system interfaces, etc.
• Database Software: SQL Server 2000 - SQL Server 2022
• Hardware installation and configuration (Azure)
• SQL Server Clustering
• Transact-SQL and stored procedure design
• Database performance tuning and replication
• Disaster recovery planning
• Backup/recovery planning
• SQL Server Always On groups
• Power BI Configuration
• Powershell scripting
• A Bachelor’s degree plus five or more years of experience in database administration, or equivalent experience to substitute for the degree, is required.
? Skills can be acquired by trouble shooting software and hardware issues in a generic computer environment. Logical prowess can be cultivated in basic mathematics training, puzzle solving, formal logic training.
Skills in:
• Strong customer service skills
• Excellent interpersonal, written and oral communication skills
• Analysis and problem solving for complex information and data collection systems
• Intermediate to advanced skill in using Microsoft Outlook, Word, and Excel
Demonstrated ability to:
• Balance, prioritize and organize multiple tasks
• Work collaboratively in teams and across organizations
• Synthesize feedback and adjust plans accordingly
• Build strong relationships inside and outside the organization
• Develop and write technical documentation
• Model and design relational databases
• Install and support relational database management systems (RDMS)
• Evaluate and test emerging technologies
• Apply creative solutions to business problems to ensure business needs are most effectively
• Develop PowerShell scripts for automation and administrative tasks
• Configure and support Power BI datasets, gateways, and refresh schedules
Numbers & Facts
| Location | Phoenix, Arizona |
| Industry | Staffing/Employment Agencies |
| Company Size | 20 to 49 employees |
| Year Founded | 2004 |
| Website | http://www.novalink-solutions.com/ |
About Company
Novalink, founded in 2003 , is a leading consulting and staffing company serving clients in public and private sectors in Information Technology, Telecommunications (IT/Telecom), Technical Networks, Finance, and Administration. With government agencies as our primary clientele, our team has a proven track record of success in providing temporary personnel solutions and managing government deliverables-based projects over the past 20 years.
Skills
- Administrative Skillsunmatched
- Analysis Skillsunmatched
- Automationunmatched
- Business Intelligenceunmatched
- Communication Skillsunmatched
- Customer Support/Serviceunmatched
- Data Collectionunmatched
- Data Modelingunmatched
- Data Processingunmatched
- Data Recoveryunmatched
- Data Setsunmatched
- Data Storageunmatched
- Database Administrationunmatched
- Database Backupunmatched
- Database Designunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Management Software/Systems (DBMS)unmatched
- Database Programmingunmatched
- Database Recoveryunmatched
- Design Evaluationunmatched
- DevOpsunmatched
- Disaster Recoveryunmatched
- Emerging Technologyunmatched
- Establish Prioritiesunmatched
- Hardware Configuration Managementunmatched
- Hardware Installationunmatched
- Identify Issuesunmatched
- Interpersonal Skillsunmatched
- Mathematicsunmatched
- Microsoft Excelunmatched
- Microsoft Outlookunmatched
- Microsoft SQL Serverunmatched
- Microsoft SQL Server 2000unmatched
- Microsoft SQL Server DBA (Database Administration)unmatched
- Microsoft Transact-SQL (T-SQL)unmatched
- Microsoft Windows Azureunmatched
- Microsoft Wordunmatched
- Multitaskingunmatched
- On Callunmatched
- Operations Processesunmatched
- People Managementunmatched
- Performance Managementunmatched
- Performance Tuning/Optimizationunmatched
- Power BIunmatched
- Presentation/Verbal Skillsunmatched
- Problem Solving Skillsunmatched
- Procedure Developmentunmatched
- Query Optimizationunmatched
- Relational Databases (RDBMS)unmatched
- Replication and Remote Mirroringunmatched
- SQL (Structured Query Language)unmatched
- SQL Server Integration Services (SSIS)unmatched
- Scripting (Scripting Languages)unmatched
- Server Clustersunmatched
- Software Configuration Managementunmatched
- Source Code/Configuration Management (SCM)unmatched
- Stored Proceduresunmatched
- Systems Administration/Managementunmatched
- Team Playerunmatched
- Technical Writingunmatched
- Test Plan/Scheduleunmatched
- Testingunmatched
- User Documentationunmatched
- Virtual Machine (VM)unmatched
- Willing to Travelunmatched
- Windows PowerShellunmatched
- Writing Skillsunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder