<p>Work for Indiana</p> <p>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.</p> <p>About the Indiana Office of Technology (IOT):</p> <p>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.</p> <p>Role Overview:</p> <p>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.</p> <p>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.</p> <p>This is an on-site position at the Indiana Government Center in Indianapolis, Indiana.</p> <p>Salary:</p> <p>The salary for this position traditionally starts at $70,122 but may be commensurate with education or work experience.</p> <p>Use our Compensation Calculator to view the total compensation package.</p> <p>A Day in the Life:</p> <p>The essential functions of this role are as follows:</p> <ul> <li>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). </li><li>Perform upgrades, migrations, patching, and version control for databases. </li><li>Monitor database health, including query performance, replication, and storage. </li><li>Manage database security, roles, privileges, and encryption to ensure compliance with internal and external regulations. </li><li>Develop and implement comprehensive backup strategies for hybrid environments, ensuring business continuity and disaster recovery readiness. </li><li>Regularly test and optimize recovery processes for both on-site and cloud databases. </li><li>Analyze, troubleshoot, and resolve performance issues, including slow queries, high-latency issues, and inefficient indexing. </li><li>Implement performance optimization techniques such as partitioning, indexing strategies, query optimization, and cache tuning. </li><li>Provide solutions for cost management of cloud resources. </li><li>Proactively monitor and fine-tune databases for high availability and high performance, utilizing various on-site tools and cloud-native monitoring tools. </li><li>Develop and advise on standards, guidelines, policies, and procedures designed to ensure the integrity of the cloud database and the on-site environment. </li><li>Design and manage cloud-based Database instances (e.g., AWS RDS, AWS PostgreSQL, Azure SQL). </li><li>Work on database migration from on-site to cloud platforms, ensuring data consistency and minimal downtime. </li><li>Enforce security best practices for SQL Server and PostgreSQL databases, including encryption (at rest and in transit), SSL/TLS, and data masking. </li><li>Work with agencies to ensure databases are compliant with security regulations (e.g., GDPR, HIPAA, SOC 2). </li><li>Consult with and make recommendations to management and associate user groups to define information processing requirements, evaluate technology needs, and formulate solutions. </li><li>Develop work plans for assigned projects and supervise their execution. </li><li>Collaborate and provide technical assistance to other database analyst staff. </li><li>Prepare reports which assist management in understanding the current hardware/software conditions, performance, and future trends. </li></ul> <p>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.</p> <p>What You'll Need for Success:</p> <p>Credentials:</p> <ul> <li>Master's degree and 4+ years of experience, or </li><li>Bachelor's degree and 7+ year of experience, or </li><li>11+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role. </li><li>Related certifications and coursework may be considered for education or experience. </li></ul> <p>Additional qualifications:</p> <p>Able to:</p> <ul> <li>Administer various components of the Azure environment (Database, Managed Instance, and Azure VM) and the AWS RDS environment. </li><li>Administer SQL Server and PostgreSQL databases, both on-site and in the cloud database environment. </li><li>SQL Server Cloud Deployment, integration, and onboarding of cloud platforms. </li><li>Administer various multi-terabyte, 24x7 uptime cloud and on-site databases as a Systems/Infrastructure Database Administrator. </li><li>Install and configure SQL Server and PostgreSQL, including automated deployments. </li><li>Manage database security, users, roles, and permissions. </li><li>Configure SQL Server Integration Services, and SQL Server Reporting Services. </li><li>Write SQL scripts, stored procedures, functions, etc. using T-SQL. </li><li>Manage multiple projects and priorities. </li></ul> <p>Knowledge of:</p> <ul> <li>Cloud database backup and recovery methodologies. </li><li>SQL Server and PostgreSQL backup and recovery methodologies. </li><li>Experience with cloud platforms such as AWS (RDS, SQL Server), Azure Database. </li><li>SQL Server Management Studio (SSMS) and other SQL Server administrative tools. </li><li>pgAdmin and other PostgreSQL administrative tools. </li></ul> <p>Additional consideration for these skills:</p> <ul> <li>Virtualization platforms such as VMware, Hyper-V, or XenServer. </li><li>Relational database techniques. </li><li>Working knowledge of computer programming, including computer languages, and testing programs. </li><li>Data communications, including networking and firewall rules for both on-site and cloud environments, is a plus. </li></ul> <p>Supervisory Responsibilities/Direct Reports:</p> <p>This role may be utilized in a supervisory capacity based on agency needs.</p> <p>Benefits of Employment with the State of Indiana:</p> <p>The State of Indiana offers a comprehensive benefits package for full-time employees that includes:</p> <ul> <li> <p>Three (3) medical plan options (including RX coverage) as well as vision and dental plans</p> </li><li> <p>Wellness Rewards Program: Complete wellness activities to earn gift card rewards</p> </li><li> <p>Health savings account, which includes bi-weekly state contribution</p> </li><li> <p>Deferred compensation 457(b) account (similar to 401(k) plan) with employer match</p> </li><li> <p>Two (2) fully-funded pension plan options</p> </li><li> <p>A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to:</p> </li><li> <p>150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers</p> </li><li> <p>Up to 15 hours of paid community service leave</p> </li><li> <p>Combined 180 hours of paid vacation, personal, and sick leave time off</p> </li><li> <p>12 paid holidays, 14 in election years</p> </li><li> <p>Education Reimbursement Program</p> </li><li> <p>Group life insurance</p> </li><li> <p>Referral Bonus program</p> </li><li> <p>Employee assistance program that allows for covered behavioral health visits</p> </li><li> <p>Qualified employer for the Public Service Loan Forgiveness Program</p> </li><li> <p>Free Parking for most positions</p> </li><li> <p>Free LinkedIn Learning access</p> </li></ul> <p>Equal Employment Opportunity:</p> <p>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.</p> <p>Current Employee? Click here to apply.</p>