Data Engineer/SQL Database Administrator
il y a 2 jours
Indianapolis
Job Description Job Title: Data Engineer and Database Administrator Department: Goodwill Information Technology Reports To: IT Director Job Type: Full Time Position Job Summary: The Database Administrator / Engineer is responsible for designing, implementing, managing, and maintaining the organization's database systems. The individual ensures data availability, security, and performance while optimizing database functionality to support business operations. This role involves close collaboration with IT teams, developers, and other stakeholders to meet organizational goals and engineer and maintain data integrity. Data Engineer 70%, DBA 30% approximately. Key Responsibilities: Data Engineering: • Extracting Data, • Data Integration, • Engineering Solutions - Looking for Data Solutions based off requirements, • Install, configure, and manage database systems. Goodwill uses SQL Server., • Monitor database performance and system health., • Troubleshoot and resolve database performance issues, slow queries, and connectivity problems., • Schedule and oversee database backups, recovery processes, and disaster recovery plans. Database Security: • Implement and maintain security policies, including user permissions, access controls, and encryption., • Perform regular security audits and apply security patches to protect against vulnerabilities., • Optimize database performance through indexing, partitioning, and query optimization., • Analyze and improve database structure to ensure efficiency., • Ensure data consistency, integrity, and accuracy across all systems., • Implement robust backup and recovery processes to prevent data loss., • Work with developers, analysts, and IT staff to design and support database-driven applications., • Provide technical support and troubleshooting for end-users., • Maintain up-to-date documentation for database systems, processes, and configurations., • Generate regular reports on database health, performance, and usage.