Database Architect
About The Position
The Department of Economic Security (DES), Division of Technology Services (DTS), is seeking an experienced and highly motivated individual to join our team as a Database Architect. The Database Architect determines database structural requirements by analyzing client operations, applications, and programming while also reviewing objectives with clients, and evaluating current systems. This position identifies solutions by designing proposed systems solutions, defines database physical structures and functional capabilities, security, back-up, and recovery specifications. This position may offer the ability to work remotely within Arizona based upon the department's needs and continual meetings of expected performance measures. The state of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, commissions, many State employees participate in the State's Remote Work Program and are able to work remotely in their homes, in offices, and in hoteling spaces. All work, including remote work, should be performed within Arizona unless an exception is properly authorized in advance.
Requirements
- Understand multiple programming languages, database, software frameworks, management systems, and development platforms
- Considerable working knowledge of various industry standards for data capture
- Agile development process, databases SQL queries, Oracle applications/design
- Familiar with No Code/Low Code development (Quick Base/Power Apps); data structures and algorithms
- Debugging knowledge source control, Cloud platforms
- Report development (Power BI), Telerik
- Software Development Life Cycle (SDLC); Microsoft Excel
- Senior level application development with Microsoft Visual Studio
- .NET Framework/Core, Angular/TypeScript, C#, data contracts and data serialization; LINQ;
- TFS/TFS (Team Foundation Server)
- Build, Git; Microsoft SQL database access methods; API (Application Programming Interface)
- Strong customer service and customer centric approach
- Effective written and oral communication
- Attention to detail
- Strong analytical skills
- Evaluate and test emerging technologies and apply creative solutions to business problems
- Work independently and / or collectively remaining open to others’ ideas and adapting to change
- Lead initiatives to develop solutions and processes to meet needs of the agency
- Learn department policies and procedures;
- Balance, prioritize, and organize multiple tasks with voluminous data
- Prioritize work deliverable
- Develop and write technical documentation and reports
- Bachelor’s degree plus 7 or more years of experience in database administration and analysis (or equivalent experience).
Nice To Haves
- N/A
Responsibilities
- Manage SQL Server databases. Configure and maintain database servers and processes. Monitor system's health and performance and provide operational support. Ensure high levels of performance, availability, sustainability, and security.
- Utilize Microsoft SQL Server for extraction and analysis of data from multiple sources with demonstrated ability to effectively decipher, analyze and report data. Develop reports and dashboards using data visualization tools. Work with large data sets to create data insights for business partners.
- Refine and automate regular processes, track issues, and document changes. Assist developers with query tuning and schema refinement. Perform scheduled maintenance and support release deployment activities after hours when needed.
- Provide development and leadership in finding solutions to multiple, cross-disciplinary business intelligence, analytics, data visualization or data warehousing/data architecture projects. Collaborate directly with peers and business leaders to transform ideas into actions.
- Assist with preparation and automation of recurring / ad hoc reporting. May train, mentor, and coach other lead junior analysts.
Benefits
- Affordable medical, dental, life, and short-term disability insurance plans
- Participation in the Arizona State Retirement System (ASRS) and long-term disability plans
- 10 paid holidays per year
- Paid vacation and sick time
- Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child.
- Deferred compensation plan
- Wellness plans
- Tuition Reimbursement
- Stipend Opportunities
- Infant at Work Program
- Rideshare and Public Transit Subsidy
- Career Advancement & Employee Development Opportunities
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
