Address
Form of workJob Posting Title
Senior Database Administrator Agency
290 EMPLOYMENT SECURITY COMMISSION Supervisory Organization
Employment Security Commission–Executive Director Job Posting End Date (Continuous if Blank)
May 13, 2024 Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above.
Estimated Appointment End Date (Continuous if Blank)
Full/Part-Time
Full time Job Type
Regular Compensation
Commensurate upon education and experience Job Description
Job Type/Salary/Location/Benefits
- Full-time
- Vacancies: One
- Working Hours: M-F; 8-5; flexibility is allowed by Chief Innovation Officer (CIO)
- Salary: Commensurate upon education and experience.
- FLSA Status: Exempt
- Location: OKC
- Telework Status: Telework allowed with CIO approval.
- Supervisory: No
- Travel: Applicants must be willing and able to fulfill all job-related travel normally associated with this position. Typically, minimal travel is required.
****This position is based in Oklahoma City, Oklahoma. Candidates must reside in or be willing to relocate at their own expense to the Oklahoma City area.****
Benefits
- Generous leave including 15 days of vacation, 15 days of sick leave and 11 paid holidays annually.
- A comprehensive Benefit Packagewith a generousbenefit allowanceto offset the cost of insurance premiums for employees and their eligible dependents.
- Pathfinder 401(a) and 457(b) Retirement Plan:Benefit from a 4.5% mandatory contribution matched by your employer's 4.5%. Plus, receive an extra 1% employer match when contributing 2.5% or more to your 457(b) Plan.
Join Our Innovative Team: Shape the Future of IT at OESC!
Join our team at the Oklahoma Employment Security Commission (OESC) and be at the forefront of technological innovation. As a Senior Database Administrator, you'll play a pivotal role in our organization's modernization journey, leveraging cutting-edge cloud technologies to revolutionize our database infrastructure. Don't miss this opportunity to be part of a dynamic team driving change and shaping the future of our agency.
Position Essential Functions
- Lead the planning, execution, and optimization of database migration projects to cloud platforms such as Microsoft SQL Server, Azure SQL, BigQuery, and others.
- Assess current database infrastructure and identify opportunities for optimization and migration to cloud-based solutions.
- Design and implement cloud-based database solutions that meet the agency's performance, scalability, and security requirements.
- Monitor database performance and implement tuning strategies to ensure optimal performance in the cloud environment.
- Implement robust security measures and ensure compliance with regulatory requirements in cloud-based database environments.
- Develop and maintain data backup and recovery strategies to safeguard critical data in cloud databases.
- Collaborate with cross-functional teams to gather requirements and ensure successful integration of cloud databases. Document migration processes, configurations, and best practices.
- Provide training and guidance to team members on cloud database technologies and best practices for migration and management.
These job functions, responsibilities, and activities may change at any time with or without notice.
Valued Knowledge, Skills, Competencies and Abilities
Knowledge of-
- Repository/data dictionary systems
- Data security systems
- Database maintenance utilities
- Data architecture
Skills and Competencies-
- Excellent communication, collaboration, and problem-solving skills.
Abilities-
- Apply data processing analysis techniques.
- Resolve and prevent database integrity problems
- Communicate effectively
- Establish and maintain effective working relationships with others.
- Perform highly independent work in the design, analysis, and maintenance of database and/or data security systems.
Physical Demands/Work Environment
Work is typically performed in professional setting with climate-controlled settings and exposure to moderate noise level. While performing the duties of the job, employee is required to talk, stand, walk, and reach with hands and arms. This position requires regular periods of sitting or standing and daily use of computer and phone. It also requires the occasional use of the office machinery in accordance with safety and security protocols.
Minimum Qualifications
Education and Experience Requirements
Requirements include a bachelor’s degree in computer science or management information systems from an accredited college or university; a vocational or technical education course resulting in certification in computer applications equivalent to a bachelor’s degree; 5 years of database administration experience; or an equivalent combination of education and experience.
Special Skills / Preferences
- Experience in hands-on query writing
- Background in Postgres, Microsoft SQL, SSIS, Azure SQL, and BigQuery.
Equal Opportunity Employment
The State of Oklahoma is an equal opportunity employer and does not discriminate on the basis of genetic information, race, religion, color, sex, age, national origin, or disability.
Current active State of Oklahoma employees must apply for open positions internally through the Workday
Jobs Hub
.
