Database Administrator Senior

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.

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.

The Database Administrator Senior designs, implements, manages, and optimizes SQL Servers and Postgre

SQL 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 Postgre

SQL databases in an on-premise and cloud environment.

This is anonsite position at the Indiana Government Center in Indianapolis, Indiana.

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.

The essential functions of this role are:

• Database Management: Lead the design, development, deployment, and maintenance of complex database systems to ensure high availability and quality.
• Performance Tuning: Develop and implement strategies for database performance tuning, and optimization of database systems, including indexing, query optimization, and resource management.
• Backup and Recovery: Develop, manage, and enhance backup and recovery strategies to protect data integrity and availability.
• Security: Implement and enforce robust database security measures, including access controls and monitoring for potential security breaches.
• Data Integrity: Ensure data integrity, accuracy, and consistency across databases through regular audits, validations, and quality checks.
• User Support: Provide advanced support to end-users, diagnose and resolve complex database-related issues on database-related issues and queries.
• Documentation: Create and maintain detailed documentation of database configurations, policies, and procedures.
• Collaboration: Work closely with developers, system administrators, IT staff, and other stakeholders to design and implement new database-related projects and initiatives
• Compliance: Ensure compliance with database vendor license agreements and industry regulations.
• Mentorship: Provide guidance and mentorship to junior database administrators and other IT staff.

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.

• Master’s Degree and 1+ years of experience, or
• Bachelor's Degree and 3+ year of experience, or
• Associate's Degree and 5+ years of experience, or
• 7+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role.
• Related certifications and coursework may be considered for education or experience.

• Expertise in database management and administration.
• In-depth understanding of database structures, theories, principles, and practices.
• In-depth knowledge of database design, documentation, and coding.
• Expertise in database backup, recovery, security, and integrity.
• Extensive experience with database performance tuning and optimization.
• Proficiency in database security best…