Oracle database administrator Jobs in Indianapolis, IN

Work for Indiana

Begin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a range of opportunities across 60+ agencies. At the state, you'll find competitive compensation, a robust benefits package and a commitment to work-life balance. Most importantly, you'll have the chance to make a real and measurable impact on the lives of Hoosiers across Indiana.

About the Indiana Office of Technology (IOT) :

The Indiana Office of Technology provides cost-effective, secure, consistent, reliable enterprise-technology services to our partner agencies so that they can better serve our mutual customer, the Hoosier taxpayer. IOT will also act as the technology and solution enabler for the State, helping its partner agencies achieve business objectives and innovation.

Role Overview :

The Cloud Database Administrator Senior designs, implements, manages, and optimizes SQL Servers and PostgreSQL databases across both on-premise environments and cloud platforms such as AWS and Azure. The role involves ensuring data integrity, high availability, and security.  You will work closely with state agencies and cloud infrastructure teams to ensure seamless database performance and integration in hybrid environments.

This is senior-level position that requires experience with SQL Server in AWS and Azure.  You must be proficient in managing SQL Server and PostgreSQL databases in an on-premise and cloud environment.

This is an  on-site position at the Indiana Government Center in Indianapolis, Indiana.

Salary :

The salary for this position traditionally starts at $70,122 but may be commensurate with education or work experience.

Use our  Compensation Calculator  to view the total compensation package.

A Day in the Life :

The essential functions of this role are as follows :

• Install, configure, and manage cloud and SQL Server and PostgreSQL databases on both on-site servers and in cloud environments (e.g., AWS for RDS, Azure Database, Azure Managed Instance, and Azure VM).
• Perform upgrades, migrations, patching, and version control for databases.
• Monitor database health, including query performance, replication, and storage.
• Manage database security, roles, privileges, and encryption to ensure compliance with internal and external regulations.
• Develop and implement comprehensive backup strategies for hybrid environments, ensuring business continuity and disaster recovery readiness.
• Regularly test and optimize recovery processes for both on-site and cloud databases.
• Analyze, troubleshoot, and resolve performance issues, including slow queries, high-latency issues, and inefficient indexing.
• Implement performance optimization techniques such as partitioning, indexing strategies, query optimization, and cache tuning.
• Provide solutions for cost management of cloud resources.
• Proactively monitor and fine-tune databases for high availability and high performance, utilizing various on-site tools and cloud-native monitoring tools.
• Develop and advise on standards, guidelines, policies, and procedures designed to ensure the integrity of the cloud database and the on-site environment.
• Design and manage cloud-based Database instances (e.g., AWS RDS, AWS PostgreSQL, Azure SQL).
• Work on database migration from on-site to cloud platforms, ensuring data consistency and minimal downtime.
• Enforce security best practices for SQL Server and PostgreSQL databases, including encryption (at rest and in transit), SSL / TLS, and data masking.
• Work with agencies to ensure databases are compliant with security regulations (e.g., GDPR, HIPAA, SOC 2).
• Consult with and make recommendations to management and associate user groups to define information processing requirements, evaluate technology needs, and formulate solutions.
• Develop work plans for assigned projects and supervise their execution.
• Collaborate and provide technical assistance to other database analyst staff.
• Prepare reports which assist management in understanding the current hardware / software conditions, performance, and future trends.

The job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time.

What You'll Need for Success :

Credentials :

Additional qualifications :

Able to :

Knowledge of :

Additional consideration for these skills :

Supervisory Responsibilities / Direct Reports :

This role may be utilized in a supervisory capacity based on agency needs.

Benefits of Employment with the State of Indiana :

The State of Indiana offers a comprehensive benefits package for full-time employees that includes :

150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers

Equal Employment Opportunity :

The State of Indiana is an Equal Opportunity Employer and is committed to recruiting, selecting, developing, and promoting employees based on individual ability and job performance. Reasonable accommodations may be available to enable individuals with disabilities to complete the application and interview process as well as perform the essential functions of a role. If you require reasonable accommodations to complete this application, you can request assistance by contacting the Indiana State Personnel Department at jobs@spd.IN.gov .