Database Administrator (Information Technology)
JOB SUMMARY
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.
IDEAL CANDIDATE
Our ideal candidate can support our existing complex on-premises database environment then use their expertise to align to our mission of leveraging data as a strategic asset across the organization to better serve our membership. We are looking for someone that is versatile and is interested in modernizing their data management skills as we further embrace our data cloud strategy.
ESSENTIAL FUNCTIONS
- 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
RESPONSIBILITIES TO INCLUDE
- 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
QUALIFICATIONS
- 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
WORKING CONDITIONS
- Standard office environment with constant computer use
- Required regular on-call assistance outside of normal business hours
- All employees are expected to present themselves in a professional manner in alignment with the financial services industry
WORK FROM HOME OPTION
- Opportunity to work from home up to two days per week. Eligibility dependent upon factors detailed in PERA's Work from Home Policy.
JOB DESCRIOTION DISCLAIMER
This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of an employee. Duties, responsibilities, and activities may change or new ones may be assigned with or without notice.
Unfortunately, at this time, we cannot consider candidates that require sponsorship (now or in the future), or are located outside of the US.
All Colorado PERA employees are subject to PERA's Ethics Policy and some employees are subject to the Personal Trading Policy. These policies include restrictions on outside business activities and employment and have certain requirements on personal trading. You may request copies of these policies from PERA's talent acquisition team and any questions can be answered by PERA's Investment Administration team.
INTERESTED CANDIDATES
Complete the employment application online at https://www.copera.org/careers. Please have copies of your resume and cover letter available to upload. Please review the following questions. You will be asked for a response to these as part of your application:
- Explain some common uses for data pump.
- Share details of a particular situation where you were able to successfully tune a problematic query
- How might you troubleshoot alert logs?
- Do you enjoy code refactoring to increase maintainability and to increase performance?
- How do you stay current in your field?
- What is your greatest career achievement?
ABOUT COLORADO PERA
Looking for a career where you can make a difference? Colorado PERA offers benefit services to public employees across Colorado, including teachers, state troopers, snowplow drivers, correctional officers and many others who provide valuable services. As Colorado's largest pension plan, we serve and educate over 700,000 members who are former and current public employees.
At PERA you will earn more than a paycheck. PERA is a culture where you can grow your potential and work in an inclusive environment, where diverse perspectives are valued. We hire exceptional employees and recognize that our people are our best asset. Not only do we make sound investments for our members, PERA invests in our employees' growth through training and leadership opportunities.
To promote wellbeing, we offer hybrid or flexible working options for most roles and a total rewards and benefit program including 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 and more. PERA is a Public Service Loan Forgiveness qualifying employer.
To learn more about life at PERA, watch this video or visit www.copera.org/careers.
Position Title: Database Administrator
Division: Information Technology
Reports to: Investments Technical Services Manager
Job Status: Full Time/Exempt
Salary: $105,000– $125,000 Annually, Commensurate with experience
Posting Dates: 05/30/2025 - 06/15/2025
