Crescens - Durham, NC
posted 2 months ago
The SQL Database Administrator position at Indigent Defense Services in Durham, NC, is a part-time role requiring 20 hours per week. This position is crucial for maintaining the continuity of business operations related to an existing SQL database, MS Access frontend, and SQL Data Portal. The organization is currently facing a vacancy due to retirement and is seeking IT support to ensure that operations run smoothly during this transition. The selected candidate will play a key role in managing and enhancing the existing data systems while preparing for future updates. The responsibilities include conducting data analysis and database management, which involves maintaining and enhancing data dictionaries, as well as designing both physical and logical database models. Performance tuning is also a significant aspect of this role, ensuring that the database operates efficiently. The administrator will be responsible for the administration of application objects within the database, which includes maintaining business requirements for the database, database schema, data maps, and entity-relationship diagrams (ERDs). Additionally, the role involves performance tuning of database applications to optimize their functionality. Another critical duty is to inventory and catalog the existing SQL and MS Access data systems. This task is essential for improving the organization’s readiness for future development projects. The administrator will also be tasked with creating ad-hoc reports and editing existing reports as requested by end users. Supporting existing applications and workflows is another key responsibility, ensuring that all systems function effectively and meet the needs of the organization.