Database Administrator for Data Warehouse and Analytics Technology
- Employer
- Ball State University
- Location
- Indiana, United States
- Salary
- Salary Not Specified
- Date posted
- Sep 10, 2021
View more
- Position Type
- Faculty Positions, Science, Technology & Mathematics, Computer Sciences & Technology, Administrative, Business & Administrative Affairs, Computer Services & Information Technology, Technology Administration/Other, Development & Advancement, Chief Technology & Information Officers
- Employment Type
- Full Time
You need to sign in or create an account to save a job.
Job Details
Posting Details
Position Title
Database Administrator for Data Warehouse and Analytics Technology
Additional Information
Ball State University is seeking an energetic person interested in working with the latest enterprise and warehouse database technologies. If you have a passion for technology and a hunger to learn, we’d like to talk to you about taking your career to the next level. If you are excited about the challenge of managing the warehouse databases of a large university, you may be the candidate we’re looking for. As the Database Administrator for Warehouse Systems, you’ll be responsible for managing the warehouse databases to ensure continuous uptime and fast response time. Your role will also work collaboratively with Institutional Research and Decision Support and others in the campus community to enhance warehouse systems to fit the needs of the university and support their data needs. This position has the potential for partial remote work. If you are ready for a new challenge, we’d like to talk with you.
Inclusive Excellence Statement
At Ball State University, inclusiveness and freedom of expression are a part of our enduring values and inform all of our efforts. We encourage applicants to familiarize themselves with our Inclusive Excellence Plan to learn more about our commitment and to identify how you might contribute to these efforts.
Benefits and Community
https://www.bsu.edu/about/administrativeoffices/humanresources/jobs/benefits-and-community/professional-staff
Relocation
https://www.bsu.edu/about/administrativeoffices/humanresources/jobs/working-at-ball-state/relocation
FLSA
Learned Professional Exemption
Hrs/Week
40
Length of Assignment
Full-Time At-Will
Position Function
This position will maintain the enterprise data warehouse; provide database administrative support for Ball State’s enterprise database servers, including Redshift, Oracle and Microsoft SQL Servers; provide database solutions and support to clients of Enterprise Information Systems ( EIS ); effectively utilize the resource areas available within and outside of EIS in order to implement appropriate solutions that address the needs of clients. Help to ensure the high reliability and availability of applications running on local or remotely hosted enterprise systems. Additionally, work with the ERP Administrators in Banner.
Minimum Education
1. Bachelor’s degree from an accredited college or university by date of appointment, or
2. Associate’s degree plus an additional combination of education or experience in IT equivalent to two years, or
3. High school diploma or GED plus an additional combination of education or experience in IT equivalent to four years
Minimum Experience
One year of demonstrated knowledge and experience in database server support, system analysis, design or application development. Experience gained through professional employment or internship experience will count towards this requirement.
Minimum Other
Demonstrated expertise in IT project leadership spanning all phases of development; proven verbal and written communication skills.
Authorization to work in the US
Candidates for searches must have current authorization to be employed in the U.S. without employer sponsorship.
Preferred Education
Preferred Experience
Relational database administration experience with Microsoft Oracle and/or SQL Server in an enterprise server environment. Demonstrated competency in SQL or SQL -like languages and creating ETL / ELT packages or procedures. Data Warehousing, three or more years Redshift, Oracle or Microsoft SQL Server experience. Experience with Ellucian Banner systems, StarRez, Canvas, Tableau, or AWS .
Preferred Other
Demonstrated expertise in enterprise application development environments used by IT for the development of Intranet/Internet applications; demonstrated expertise in administering relational database management systems; and experience in data warehouse support. Experience in process improvement projects.
Pre-Employment Screening
Requires successful completion of a background check.
Position Title(s) Supervised
None.
Required Certifications
EEO Statement
Ball State University is an Equal Opportunity/Affirmative Action employer that is strongly and actively committed to diversity within its community. Women, minorities, individuals with disabilities and protected veterans are strongly encouraged to apply. All qualified applicants will receive equal consideration for employment without regard to race, color, ethnicity, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, disability, protected veteran status or any other legally protected status.
About Ball State University
Ball State University is located in Muncie, Indiana, on an attractive campus 45 miles northeast of Indianapolis. Approximately 22,000 graduate and undergraduate students enroll in one of eight academic colleges that offer 120 undergraduate programs. We offer more than 140 master’s, doctoral, certificate, and specialist degrees, with many of them ranking among the best in the nation. We engage students in educational, research, and creative endeavors that empower our graduates to have fulfilling careers and meaningful lives enriched by lifelong learning and service, while we enhance the economic, environmental, and social vitality of our community, our state, and our world.
Department
Information Technology Services:120040
Department Information
This position has the potential for partial remote work.
Department Email or Phone Number
285-6761
Duties & Responsibilities
Ranking
1
Job Duty
Support the enterprise database server environment (Oracle and Microsoft SQL Servers), providing analysis, design, development, implementation, documentation, backup, restore and additional routine types of database support.
Ranking
2
Job Duty
Maintain database servers and software to ensure that it is up to date and configured with best practices as defined by the software vendor and university policies.
Ranking
3
Job Duty
Build and maintain a working knowledge of warehouse systems. Support data management and reporting from the warehouse.
Ranking
4
Job Duty
Perform performance testing, monitoring, and analysis on databases and servers to ensure the smooth and efficient operation of all systems.
Ranking
5
Job Duty
Evolve existing systems, processes and procedures with best practices in database analysis, design, and creation. Support process improvement within and outside of IT.
Ranking
6
Job Duty
Support creating and migrating ETL processes into production, and documenting system changes.
Ranking
7
Job Duty
Resolve data issues as directed by the supervisor and data stewards.
Ranking
8
Job Duty
Provide rapid incident response and speedy resolution for database problems. Document resolutions to incidents and prepare operational plans to ensure that the incident is not repeated.
Ranking
9
Job Duty
Establish and maintain working relationships with service providers, vendors, other IT departmental units and other areas of the university.
Ranking
10
Job Duty
Support the use of appropriate information security controls to protect systems. Manage user access to all enterprise databases in accordance with the policies determined by the Director of Enterprise Information Systems.
Ranking
11
Job Duty
Perform other related duties as assigned.
Posting Number
202100807P
Number of Vacancies
1
Desired Start Date
10/25/2021
Position End Date (if temporary)
Open Date
09/10/2021
Applications Accepted Through Date
10/10/2021
Open Until Filled
No
Information regarding transcripts
The option to upload transcripts is available. Original, official transcripts showing the highest related degree earned is required at the time of hire (even if obtained at BSU). Degree verification will be conducted.
Special Instructions Summary
Supplemental Questions
Required fields are indicated with an asterisk (*).
Applicant Documents
Required Documents
Position Title
Database Administrator for Data Warehouse and Analytics Technology
Additional Information
Ball State University is seeking an energetic person interested in working with the latest enterprise and warehouse database technologies. If you have a passion for technology and a hunger to learn, we’d like to talk to you about taking your career to the next level. If you are excited about the challenge of managing the warehouse databases of a large university, you may be the candidate we’re looking for. As the Database Administrator for Warehouse Systems, you’ll be responsible for managing the warehouse databases to ensure continuous uptime and fast response time. Your role will also work collaboratively with Institutional Research and Decision Support and others in the campus community to enhance warehouse systems to fit the needs of the university and support their data needs. This position has the potential for partial remote work. If you are ready for a new challenge, we’d like to talk with you.
Inclusive Excellence Statement
At Ball State University, inclusiveness and freedom of expression are a part of our enduring values and inform all of our efforts. We encourage applicants to familiarize themselves with our Inclusive Excellence Plan to learn more about our commitment and to identify how you might contribute to these efforts.
Benefits and Community
https://www.bsu.edu/about/administrativeoffices/humanresources/jobs/benefits-and-community/professional-staff
Relocation
https://www.bsu.edu/about/administrativeoffices/humanresources/jobs/working-at-ball-state/relocation
FLSA
Learned Professional Exemption
Hrs/Week
40
Length of Assignment
Full-Time At-Will
Position Function
This position will maintain the enterprise data warehouse; provide database administrative support for Ball State’s enterprise database servers, including Redshift, Oracle and Microsoft SQL Servers; provide database solutions and support to clients of Enterprise Information Systems ( EIS ); effectively utilize the resource areas available within and outside of EIS in order to implement appropriate solutions that address the needs of clients. Help to ensure the high reliability and availability of applications running on local or remotely hosted enterprise systems. Additionally, work with the ERP Administrators in Banner.
Minimum Education
1. Bachelor’s degree from an accredited college or university by date of appointment, or
2. Associate’s degree plus an additional combination of education or experience in IT equivalent to two years, or
3. High school diploma or GED plus an additional combination of education or experience in IT equivalent to four years
Minimum Experience
One year of demonstrated knowledge and experience in database server support, system analysis, design or application development. Experience gained through professional employment or internship experience will count towards this requirement.
Minimum Other
Demonstrated expertise in IT project leadership spanning all phases of development; proven verbal and written communication skills.
Authorization to work in the US
Candidates for searches must have current authorization to be employed in the U.S. without employer sponsorship.
Preferred Education
Preferred Experience
Relational database administration experience with Microsoft Oracle and/or SQL Server in an enterprise server environment. Demonstrated competency in SQL or SQL -like languages and creating ETL / ELT packages or procedures. Data Warehousing, three or more years Redshift, Oracle or Microsoft SQL Server experience. Experience with Ellucian Banner systems, StarRez, Canvas, Tableau, or AWS .
Preferred Other
Demonstrated expertise in enterprise application development environments used by IT for the development of Intranet/Internet applications; demonstrated expertise in administering relational database management systems; and experience in data warehouse support. Experience in process improvement projects.
Pre-Employment Screening
Requires successful completion of a background check.
Position Title(s) Supervised
None.
Required Certifications
EEO Statement
Ball State University is an Equal Opportunity/Affirmative Action employer that is strongly and actively committed to diversity within its community. Women, minorities, individuals with disabilities and protected veterans are strongly encouraged to apply. All qualified applicants will receive equal consideration for employment without regard to race, color, ethnicity, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, disability, protected veteran status or any other legally protected status.
About Ball State University
Ball State University is located in Muncie, Indiana, on an attractive campus 45 miles northeast of Indianapolis. Approximately 22,000 graduate and undergraduate students enroll in one of eight academic colleges that offer 120 undergraduate programs. We offer more than 140 master’s, doctoral, certificate, and specialist degrees, with many of them ranking among the best in the nation. We engage students in educational, research, and creative endeavors that empower our graduates to have fulfilling careers and meaningful lives enriched by lifelong learning and service, while we enhance the economic, environmental, and social vitality of our community, our state, and our world.
Department
Information Technology Services:120040
Department Information
This position has the potential for partial remote work.
Department Email or Phone Number
285-6761
Duties & Responsibilities
Ranking
1
Job Duty
Support the enterprise database server environment (Oracle and Microsoft SQL Servers), providing analysis, design, development, implementation, documentation, backup, restore and additional routine types of database support.
Ranking
2
Job Duty
Maintain database servers and software to ensure that it is up to date and configured with best practices as defined by the software vendor and university policies.
Ranking
3
Job Duty
Build and maintain a working knowledge of warehouse systems. Support data management and reporting from the warehouse.
Ranking
4
Job Duty
Perform performance testing, monitoring, and analysis on databases and servers to ensure the smooth and efficient operation of all systems.
Ranking
5
Job Duty
Evolve existing systems, processes and procedures with best practices in database analysis, design, and creation. Support process improvement within and outside of IT.
Ranking
6
Job Duty
Support creating and migrating ETL processes into production, and documenting system changes.
Ranking
7
Job Duty
Resolve data issues as directed by the supervisor and data stewards.
Ranking
8
Job Duty
Provide rapid incident response and speedy resolution for database problems. Document resolutions to incidents and prepare operational plans to ensure that the incident is not repeated.
Ranking
9
Job Duty
Establish and maintain working relationships with service providers, vendors, other IT departmental units and other areas of the university.
Ranking
10
Job Duty
Support the use of appropriate information security controls to protect systems. Manage user access to all enterprise databases in accordance with the policies determined by the Director of Enterprise Information Systems.
Ranking
11
Job Duty
Perform other related duties as assigned.
Posting Number
202100807P
Number of Vacancies
1
Desired Start Date
10/25/2021
Position End Date (if temporary)
Open Date
09/10/2021
Applications Accepted Through Date
10/10/2021
Open Until Filled
No
Information regarding transcripts
The option to upload transcripts is available. Original, official transcripts showing the highest related degree earned is required at the time of hire (even if obtained at BSU). Degree verification will be conducted.
Special Instructions Summary
Supplemental Questions
Required fields are indicated with an asterisk (*).
Applicant Documents
Required Documents
- Resume
- Cover Letter
- Undergraduate Transcripts
- Master's Transcripts
Company
Founded in 1918 in Muncie, Indiana, the public research university has grown to more than 22500 students
Spirited and motivated, we learn, grow, and take flight. Our faculty and staff—everyone in our community—embrace students as learning partners from day one. In classrooms and labs, in immersive learning projects, on the sports fields—with creativity and determination—Cardinals Fly. We are grounded in our values, lifted by our knowledge, and go confidently upward toward ever greater opportunities. Ours is a simple promise: to challenge each other to excel. And with Beneficence as our guide—We Fly.
We are committed to excellence through a talented and diverse faculty and staff. Inclusiveness and freedom of expression are a part of our enduring values and inform all of our efforts. We engage students in educational, research, and creative endeavors that empower our graduates to have fulfilling careers and meaningful lives enriched by lifelong learning and service, while we enhance the economic, environmental, and social vitality of our community, our state, and our world. We are excited that you want to join us in these endeavors!
The university offers excellent benefits, including health care and retirement plans, tuition assistance for employees and dependents, and generous time off with pay.
You need to sign in or create an account to save a job.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert