IT DBA Journey
About The Position
The Office of Secretary of State (OSOS) is seeking an IT DBA Journey to join their Division of Information Technology (IT). The IT DBA Journey will provide database administration, unit testing, and technical support for OSOS IT applications. This role is responsible for managing and improving statewide electronic records databases, including data storage repositories and future storage solutions like Elastic Search. The position involves designing and implementing database architectures, overseeing database performance, security, and availability, and developing strategies for database expansion. The IT DBA Journey will also be responsible for evaluating recovery scenarios, establishing backup requirements, ensuring data integrity, enforcing security protocols, and guaranteeing compliance with data regulations. Additionally, the role includes building and maintaining processing environments, requesting storage allocation, writing database scripts, preparing data for loading, managing applications for reviewing repository data, monitoring database systems, and staying current with Azure technologies. The position also supports internal staff and external customers in troubleshooting issues.
Requirements
- Four years of information technology experience such as: consulting, analyzing, designing, programming, installing and/or maintaining computer software applications; providing customer or technical support in information technology disciplines.
- OR An associate’s degree in technology or related field with 2 years of Information Technology experience.
- OR A bachelor’s degree in technology or related field.
- OR A master’s degree in technology or related field.
- OR any combination of education and experience that is equal to 4 years. (Education is credited towards experience on a year for year basis)
- At least one year of experience must be independently working on a system or project for large workgroup, or single business function in an Azure SQL or other cloud-based environment
- Ability to efficiently use a personal computer and applicable software to successfully perform the essential functions of the position.
- Ability to read and write English Language.
- Information Technology Experience is the progressive technical expertise of enterprise solution design and engineering in any of the following functional & technical IT domain areas: Software development & engineering (web, mobile, desktop, and embedded systems). Cybersecurity (network, asset, risk) Cloud computing & DevOps: (cloud architecture, management, and workflow automation) Data Science, AI & Analytics (big data, machine learning, data mining, and AI systems) Network administration (design and support) Quality Assurance (QA testing for failures, missed features and quality) Database Administration (managing and securing data stores, tuning & optimization) Emerging Tech
Nice To Haves
- Data modeling
- Physical database design
- Database documentation
- Database security
- SQL Server
- Microsoft Azure
- Design, development, and maintenance of web Environment.
- Object Oriented programming theory and principles.
- Application development for preserving and providing access to electronic records that includes data backup, versioning, storing and retrieving data.
Responsibilities
- Manages and improves statewide electronic records databases.
- Responsible for data storage repositories, including any future storage that serves as the digital object repository and future storage like Elastic Search which is used for meta data searches.
- Designs and implements database architectures, including the development and upkeep of cloud-based databases.
- Oversees and ensures the performance, security, and availability of databases.
- Develops strategies for database expansion and storage capacity needs.
- Evaluates recovery scenarios and establishes backup requirements, including designing and executing backup and recovery procedures and schedules.
- Ensures data integrity, enforces security protocols, and guarantees compliance with data regulations.
- Builds and maintains processing environments, including development, testing, and productions systems.
- Requests storage allocation, writes database scripts, and prepares data for loading.
- Maintains large data repository.
- Manages applications for reviewing repository data.
- Monitors database systems to maintain secure services and minimize downtime.
- Stays current with the latest Azure technologies, trends, and techniques.
- Responsible for creating and documenting security protocols and emergency database recovery plans.
- Supports internal staff and external customers in troubleshooting issues.
Benefits
- Potential eligibility for the federal Public Service Loan Forgiveness program.
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
Entry Level
Education Level
No Education Listed
