Database Administrator

Colorado PERA • Denver, CO

140d • $105,000 - $125,000 • Hybrid

About The Position

This position supports critical database applications by maintaining a robust database environment by ensuring data security and availability through database development, monitoring, and effective troubleshooting to enable business initiatives and operational improvements for Colorado PERA's systems. It requires proficiency in data modeling, analysis, design, troubleshooting and process improvement coupled with the ability to collaborate effectively across various IT and business functions.

Requirements

• Degree in technical (STEM) field and two years of experience in technical role preferred, or equivalent combination of education and experience
• Experience as an Oracle DBA and optionally SQL Server DBA, with a proven track record of managing databases in production environments
• Strong understanding of PL/SQL programming
• Must have experience with core DBA skill sets including account admin, patching, tuning, backups/recovery, auditing, log reviews
• Understanding of database, security, server, and network environments preferred
• Experience with change management, incident tracking and version control
• Effective verbal and written communication skills
• Demonstrated ability to work independently and with others, use productive work methods, exercise sound judgment, and display initiative and innovation on the job
• Excellent problem-solving skills

Responsibilities

• Performs database administration tasks including upgrades, patches, user administration, backup/restores
• Monitors database health and performance, troubleshoot issues, and implements tuning strategies to optimize performance and availability
• Provides technical leadership on database projects of varying size and difficulty including projects with critical time constraints and/or significant business risks associated
• Implements data security strategies to safeguard sensitive information
• Designs efficient, robust and scalable database models based on in depth understanding of business requirements and database structures
• Conducts regular database audits, ensuring compliance with internal policies
• Supports project initiation efforts by assisting in the definition of project scope and the identification/selection of targeted solution(s). Assists in the development of work plans, effort estimates, and delivery timelines
• Participates in Business Continuity through Disaster Recovery planning and testing
• Collaborates with application teams to optimize database queries and improve application performance
• Resolves complex systems issues utilizing technical skills and subject matter expertise. Coordinates issue resolution with vendors and/or cross-functional teams.
• Provides timely and thorough communication regarding issue status/resolution with end-users and other key stakeholders
• Actively contributes to enhancing systems security posture and investigates security events as necessary
• Leads database code review sessions and adheres to coding standards and best practices
• Participates in the 24/7 database systems support On-Call rotation and inter-departmental event coordination
• Adheres to Information Technology Division standards
• Participates in training and educational opportunities for ongoing professional development
• Carries out other duties as assigned

Benefits

• Health, dental and vision coverage - eligibility starts the first day of the month following the date of hire for most plans
• Generous paid time off and volunteer hours
• Pension and retirement plans, including PERA's defined benefit plan, 457 defined contribution plan, and 401(k) employer match, as applicable
• Tuition assistance
• Free, convenient on-site parking or RTD subsidy
• Free on-site fitness center to stay active
• Employee assistance program
• Training, leadership and mentoring programs

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Funds, Trusts, and Other Financial Vehicles
• Education Level: Bachelor's degree
• Number of Employees: 251-500 employees