Job Information
State of Indiana Senior SQL Database Administrator in Indianapolis, Indiana
Senior SQL Database Administrator
Date Posted: Apr 25, 2024
Requisition ID: 442655
Location:
Indianapolis, IN, US, 46204
Work for IndianaBegin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a diverse 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.
At the State of Indiana, we don’t just talk about diversity and inclusion—we make it our goal to create a welcoming, accessible, and equitable workplace with a workforce that is representative of Indiana's population. As a proud equal opportunity employer, 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.
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.
About the SQL Database Services Team:
The IOT SQL Data Services team manages the data for most of the State’s agency applications. The Department of Revenue, Family and Social Services, and Department of Transportation are examples of agencies with systems that depend upon this team for maintaining their back-end data. Agency applications are dependent upon timely responses to accurate and secure data.
Salary:
Salary is commensurate with training and job experience.
Role Overview:
The SQL Database Administrator supports SQL databases to ensure data integrity, security, and stability. You will provide computer resources and an up-to-date software environment for agency customers. Key outcomes for this role include:
Monitoring and tuning database performance.
Ensuring data is appropriately protected via database backup, Always On availability, and related strategies.
Loading, or assisting with loading, database software, upgrades, and patches.
Assisting with evaluating and selecting infrastructure components and providing operational support for the databases, ensuring data integrity, database availability, and performance.
This senior-level position requires extensive experience with the latest releases of SQL Server. You must be proficient in stand-alone and clustered environments, including implementing and managing the Always On high-availability option.
A Day in the Life:
Essential functions are:
Provide operational support for the database ensuring data integrity, database availability, and performance.
Ensure that data is appropriately protected via database backup and related strategies.
Administer end-user access and security at the database level.
Load process database software and the application of fixes.
Participate in an on-call rotation that provides 24x7 support.
Implement and maintain database catalogs and dictionaries.
Monitor and tune database performance.
Determine aggregation, partitioning, and indexing strategies for physical data.
Develop and advise on standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.
Evaluate and select infrastructure components.
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:
Able to :
Administer various components of SQL Server, with a solid understanding of database architecture and performance tuning.
Work with multiple SQL Server versions, such as SQL Server 2016, 2017, 2019, or 2022, in a Windows and/or Linux environment.
Administer various multi-terabyte, 24x7 uptime SQL Server databases as a Systems/Infrastructure Database Administrator.
Install and configure SQL Server, including automated deployments.
Manage database security, users, roles, and permissions in SQL Server.
Configure SQL Server Integration Services, and SQL Server Reporting Services.
Write SQL scripts, stored procedures, functions, etc. using T-SQL.
Manage multiple hardware and software projects and priorities.
Knowledge of:
SQL Server backup and recovery methodologies.
High Availability and Disaster Recovery in SQL Server environments using Clustering, Log Shipping, Replication, and Always On.
SQL Server Management Studio (SSMS) and other SQL Server administrative tools.
Virtualization platforms such as VMware, Hyper-V, or XenServer.
Relational database techniques.
Working knowledge of computer programming, including computer languages, and testing of programs.
Data communications, including networking and firewall rules.
Additional consideration for these skills:
SQL Server Cloud Deployment model and standards, integration, and onboarding of cloud platforms.
Writing PowerShell scripts.
Database Monitoring Tools such as IDERA, Red-Gate, and AppDynamics.
Data warehouse design techniques and dimensional modeling processes.
Benefits of Employment with the State of Indiana:
The State of Indiana offers a comprehensive benefits package for full-time employees which includes:
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
Flexible work scheduling options, including the potential for hybrid remote work for employees whose work may be performed outside state facilities
Deferred compensation 457B account (similar to 401k 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
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 on 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
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. 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.
If you are a qualified individual with a disability and require reasonable accommodations to complete this application, you can request assistance by contacting the Indiana State Personnel Department at [email protected] .
The State of Indiana 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.
Current Employee? Click here (https://performancemanager8.successfactors.com/sf/careers/jobsearch?bplte_company=indianaoff) to apply.