State of Indiana · 1 day ago
Database Administrator Senior
Indianapolis, IN
Full-time
Onsite
Mid, Senior Level
$70K/yr - $70K/yr
4+ years expThe State of Indiana is one of the largest employers in the state, offering a range of opportunities across 60+ agencies. They are seeking a Database Administrator Senior to design, implement, manage, and optimize SQL Servers and PostgreSQL databases, ensuring data integrity and high availability across on-premise and cloud environments.
GovernmentInformation ServicesOnline Portals
Responsibilities
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
Qualification
Required
Master's degree and 4+ years of experience, or
Bachelor's degree and 7+ year of experience, or
11+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role
Able to administer various components of the Azure environment (Database, Managed Instance, and Azure VM) and the AWS RDS environment
Able to administer SQL Server and PostgreSQL databases, both on-site and in the cloud database environment
SQL Server Cloud Deployment, integration, and onboarding of cloud platforms
Able to administer various multi-terabyte, 24x7 uptime cloud and on-site databases as a Systems/Infrastructure Database Administrator
Able to install and configure SQL Server and PostgreSQL, including automated deployments
Able to manage database security, users, roles, and permissions
Able to configure SQL Server Integration Services, and SQL Server Reporting Services
Able to write SQL scripts, stored procedures, functions, etc. using T-SQL
Able to manage multiple projects and priorities
Knowledge of cloud database backup and recovery methodologies
Knowledge of SQL Server and PostgreSQL backup and recovery methodologies
Experience with cloud platforms such as AWS (RDS, SQL Server), Azure Database
Experience with SQL Server Management Studio (SSMS) and other SQL Server administrative tools
Experience with pgAdmin and other PostgreSQL administrative tools
Preferred
Virtualization platforms such as VMware, Hyper-V, or XenServer
Relational database techniques
Working knowledge of computer programming, including computer languages, and testing programs
Data communications, including networking and firewall rules for both on-site and cloud environments, is a plus
Benefits
Three (3) medical plan options (including RX coverage) as well as vision and dental plans
Wellness Rewards Program: Complete wellness activities to earn gift card rewards
Health savings account, which includes bi-weekly state contribution
Deferred compensation 457(b) account (similar to 401(k) plan) with employer match
Two (2) fully-funded pension plan options
A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to:
+ 150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers
+ Up to 15 hours of paid community service leave
+ Combined 180 hours of paid vacation, personal, and sick leave time off
+ 12 paid holidays, 14 in election years
Education Reimbursement Program
Group life insurance
Referral Bonus program
Employee assistance program that allows for covered behavioral health visits
Qualified employer for the Public Service Loan Forgiveness Program
Free Parking for most positions
Free LinkedIn Learning access
Company
State of Indiana
State of Indiana is the government website that provides information, services, news, and events related to Indiana.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Pamella Cook
Chief Financial Officer
Annie Frischkorn
Senior Human Resources Business Partner
Recent News
2025-11-08
2025-08-13
Company data provided by crunchbase