Database Administrator, Junior

About Us?

Indiana Public Retirement System (INPRS’) is among the largest 100 pension systems in the United States. INPRS serves the needs of approximately 473,000 members and retirees representing approximately 1,244 employers, including public universities, school corporations, public safety, municipalities and state agencies. The Indiana Public Retirement System is a public pension fund who manages approximately over $40 billion in assets, making it one of the largest in the United States. We are located in the heart of the city, in downtown Indianapolis, near the circle & across the street from our monumental state house. This position will allow a flexible (hybrid) work arrangement, but will require Indiana state residency. This position is not eligible for H-1B or any other kind of temporary or permanent sponsorship for work authorization by the Indiana Public Retirement System. Therefore, if you will require sponsorship from us for work authorization now or in the future, we cannot consider your application at this time.

Why Join?

INPRS’ believes that people are the foundation of our success. It takes people with different backgrounds, ideas, and strengths to be successful. Balance in life is important. We strive to have a flexible and supportive environment while not sacrificing service to our members. We pride ourselves by modeling a collaborative, diverse and inclusive environment for our employees. Our mission. “As fiduciaries, educate stakeholders, collect necessary contributions, and prudently manage member assets to deliver promised defined benefit and defined contribution benefits and services”.

Your Impact:

The Junior Database (DBA) will work as a member of the IT Operations – Database Administration team to support all aspects of the database environments. The incumbent will monitor performance and document metrics to measure efficiency leading to system performance improvements. This role requires critical thinking and complex problem-solving skills with the ability to follow procedures based on best practices for database security, configuration, and disaster recovery. The Junior DBA will work closely with the Senior DBA ensuring standards are met and procedures are followed. Candidate must demonstrate INPRS culture and values: Model of Integrity, Team Player, Candid, Continuous Learner, Diligent, Trust, Constructive Conflict, Commitment, and Accountability. This position will report directly to the Manager of IT Operations.

Essential Duties:

• Assists in performing database maintenance activities including installation, configuration, upgrades, patching and backup, and recovery of all databases.
• Assists in troubleshooting, diagnosing and quickly responding to database and application issues minimizing disruption to services and escalating to vendors for support as needed.
• Assists in proactively monitoring and reporting on database performance and capacity and provide trend analysis for all environments.
• Utilize Oracle Enterprise Manager (OEM) for managing and monitoring the database and hosted server environments.
• Assists in creating and debugging stored procedures, functions, packages, the interaction of triggers, and other Oracle schema objects.
• Document database operating procedures; contribute to the Service Delivery knowledge base.
• Participate in a weekly IT Operations on-call support rotation to provide effective coverage for after-hours and weekend support.

Job Requirements:

• Two plus years of experience in a technical field with good problem-solving skills.
• Database technologies (SQL Server or Oracle) and Linux skills are preferred.
• Hands-on experience utilizing Oracle Enterprise Manager and Grid Control preferred.
• Demonstrate the ability to support and maintain:
  • Oracle E-Business Suite.
  • PeopleSoft and WebLogic.
  • Oracle databases in a virtualized server environment.
  • Scripting to automate daily maintenance tasks.
  • RMAN for performing database backup and recovery.
• Experience in a virtualized server environment preferred.
• Experience with scripting to automate daily maintenance tasks
• Knowledge of Oracle 10g and higher processes and architecture.
• Troubleshoot and tune databases.
• Experience using RMAN for performing database backup and recovery.
• Ability to edit system configuration and design documentation.
• Ability to effectively present technical ideas, problems, and solutions to technical teams and all levels of management.
• Strong teamwork and interpersonal skills; ability to communicate and persuade at all management levels and thrive in a cross-functional, evolving business and technical environment.
• Ability to prioritize, plan, organize and manage multiple tasks efficiently.
• Detail-oriented and a problem solver.
• Demonstrate INPRS culture and values.

Experience and Qualifications:

• Bachelor’s degree in computer science or related field
• Must understand the core technologies that underpin modern software development, especially data management and messaging technologies.
• 1-3 years of experience working in the financial services industry preferred.

Comprehensive Benefits Package:

• Competitive compensation
• Flexible Work Arrangement (3 days in-person & 2 days remote)
• Healthcare coverage (medical / dental / vision)
• Health savings account with employer contribution
• Prescription coverage
• Employer funded retirement plan (pension plan)
• Deferred compensation plan (employer and/or employee contribution plan)
• Flexible spending account
• Work/life balance (37.5 hours weekly)
• 12 paid holidays; 14 during election year
• Paid leave (personal, sick, vacation)
• Tuition reimbursement
• Professional credential reimbursement
• Group life insurance
• Employer-paid downtown parking

If you are interested in this position, please submit your application and resume for review. For more information about our organization, please visit our INPRS Careers Page: https://www.in.gov/inprs/careers.htm.

Equal Employment Opportunity:

The Indiana Public Retirement System (INPRS) is an Equal Opportunity Employer and is committed to recruit, select, develop, and promote employees based on individual ability and job performance. Our policy is to provide equal employment opportunity to all people in all aspects of employer-employee relations without discrimination because of race, color, creed, religion, sex, national origin, ancestry, age, sexual orientation, gender identity, physical or mental disability, or veteran status. We will comply with the spirit as well as the letter of all applicable state and federal laws.

Indiana Public Retirement System has established a culture that welcomes equity, inclusion, and opportunity for all employees and applicants. We encourage you to apply if you feel you have the transferrable skills to be successful in this position and we look forward to reviewing your application.