Date Posted: Nov 29, 2021
Position Title: Database Administrator
Location: Fisher Building, 3011 W. Grand Blvd., Detroit, MI 48202
Salary Range: $85,000.00 - $110,000.00
Reports to: Deputy Executive Director of Business Solutions
Bargaining Unit: N/A
Benefits Eligible: Yes
This position is funded through Federal COVID Relief funding. The position will expire on June 30, 2022 and is not guaranteed to be funded beyond that date.
The Database Administrator is a key member of the Business Solutions Department within the Information Technology Division. Business Solutions is responsible for systems integration, application maintenance and support, business process development, project management and the extraction of meaning insights for district data as well as implementation of new business applications. This department manages the support and maintenance for the District’s enterprise resource planning systems for Human Resources and finance management, as well as supporting SharePoint, the District’s knowledge management system and Cherwell, the District’s IT service management system.
As a significant member and contributor of the Business Solutions team, the Database Administrator designs, builds, and maintains PeopleSoft development, test, and production environments for Human Capital Management (HCM), and Financials while also supporting system implementation.
· Bachelor’s degree in Information Technology, Computer Science, Business Administration or related discipline.
· At least four (4) years of experience working with PeopleSoft applications
· Experience with Database Administration including Oracle Multi-tenant 12.2
· Experience patching all areas of PeopleSoft middleware including Elastic Search
· Experience developing cross functional systems.
· Evidence of strong, effective verbal and written communication skills with the ability to convey technical information to a non-technical audience.
· Strong coding, debugging, and troubleshooting skills with a solid understanding of relational databases and data models.
· Experience working with end users to gather requirements to build technical solutions.
· Strong analytical, problem-solving and decision-making skills.
· Ability to multi-task and adapt to changes quickly.
· Self-motivated with the ability to work in a fast-moving environment.
1. Monitor and evaluate PeopleSoft database environments to optimize performance; plan, organize, test and execute migration of databases, data models, data sets, indexes and other database optimizations from development and test to production environments.
2. Serve as technical expert for applications, including technical troubleshooting, root cause analysis, correction of software defects, production application validation and responding to assigned help desk ticket requests.
3. Contribute to enterprise system architecture and develop end-to-end system design.
4. Ensure data security protocols are maintained and backup/recovery processes are completed as scheduled.
5. Troubleshoot operational and systems issues ranging from difficult to highly complex, including problems with multiple solutions and potential significant consequences.
6. Document solutions and designs that are implemented to address issues, bugs, poor system performance, etc.
7. Develop SQL script tuning, execution plans, and hints.
8. Organize and optimize PeopleSoft Integration Broker traffic across multiple PeopleSoft environments
9. Provide sound judgment for solving complex technical issues. Including effectively communicating the problem to management with recommendations for action to resolve the issue.
10. Serve as technical contact with vendors including attending vendor meetings and participating in quality assurance and testing as appropriate.
11. Conduct performance assessments and system audits regularly to identify areas for improvement, possible risks and exposures for mitigation and proactive resolution.
12. Assist with the development of appropriate real-time dashboards and insights to inform District stakeholders of the current health and maturity of all enterprise systems.
13. Serve as technical expert for applications, including technical troubleshooting, root cause analysis, correction of software defects, production application validation and responding to assigned help desk ticket requests.
14. Build effective relationships with staff members to implement the District’s strategic plan.
15. Assist with project management routines that support teams in breaking down projects into key tasks with owners, developing timelines and shared expectations for work, and communicating progress with appropriate stakeholders.
16. Help design systems, policies, and procedures to streamline core district functions, minimize duplication of efforts and redundancies, and ensure alignment with school needs.
17. Provide training, technical support, and direct consultative support across divisions.
18. Maintain familiarity with currently implemented and new technology, including new versions of software/firmware, implementation of upgrades, and changes to procedures/commands.
19. Research, recommend and implement policy, processes and procedures, and serve as an agent to inform, advocate and administer new policies, procedures and change orders.
20. Perform other duties as assigned by supervisor.
If you are a current Detroit Public Schools Community District employee, you do not have to submit to a new security clearance, unless your new role requires a different type of criminal background check.
In alignment with Michigan law, if you are hired to fill a position, you will be required to submit to a Detroit Public Schools Community District criminal background check. Information regarding required background checks will be shared at point of hire.
Method of Application:
Applicants must apply through the online application system. Only applications submitted through the online application system will be considered for any posted position and all applications require a resume to be considered.
Successful candidates are required to submit official transcript(s) at point of offer to hire. Teaching service outside of the Detroit Public Schools Community District must be verified by the applicant's prior employer(s) prior to hire. It is the applicant's responsibility to provide all documentation (including copies) as requested.
Applicants requesting assistance during the application process should contact the Office of Human Resources via email at [email protected] or phone at (313) 873-6897.
DPSCD does not discriminate on the basis of race, color, national origin, sex, sexual orientation, transgender identity, disability, age, religion, height, weight, citizenship, marital or family status, military status, ancestry, genetic information, or any other legally protected category, in its educational programs and activities, including employment and admissions opportunities. Contact the Civil Rights Coordinator for more information at (313) 240-4377 or detroitk12.org/compliance.