Job Description
Job Description
Job Title: Database Administrator (DBA)
Department: Information Technology
Reports To: IT Director
Job Type: Full Time Position
Job Summary:
The Database Administrator (DBA) is responsible for designing, implementing, managing, and maintaining the organization's database systems. The DBA 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 maintain data integrity.
Key Responsibilities:
Database Installation and Configuration:
- Install, configure, and manage database systems. We use SQL Server.
- Plan and deploy database updates, patches, and upgrades.
Database Monitoring and Maintenance:
- 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.
- Ensure compliance with data protection standards and regulations (PCI, PII, FERPA, HIPAA).
Performance Tuning and Optimization:
- Optimize database performance through indexing, partitioning, and query optimization.
- Analyze and improve database structure to ensure efficiency.
- Manage database storage, ensuring scalability and performance alignment with business needs.
Data Integrity and Backup:
- Ensure data consistency, integrity, and accuracy across all systems.
- Implement robust backup and recovery processes to prevent data loss.
- Test and document database recovery procedures.
Collaboration and Support:
- Work with developers, analysts, and IT staff to design and support database-driven applications.
- Provide technical support and troubleshooting for end-users.
- Collaborate on projects involving database integration, reporting.
Documentation and Reporting:
- Maintain up-to-date documentation for database systems, processes, and configurations.
- Generate regular reports on database health, performance, and usage.
Qualifications:
Required:
- Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
- 3+ years of experience as a Database Administrator or in a related role.
- Proficiency in managing databases such as SQL Server
- Strong understanding of database structures, theories, principles, and practices.
- Experience with backup, recovery, and disaster recovery strategies.
- Knowledge of database security principles and data protection compliance.
- Experience configuring, managing, and developing modern cloud based platforms (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL).
Preferred:
- Certification in database systems (such as Microsoft SQL Server).
- Familiarity with scripting languages (e.g., Python, Shell, or PowerShell).
- Knowledge of performance tuning and query optimization techniques.
Skills and Competencies:
- Strong analytical and problem-solving skills.
- Excellent attention to detail and organizational abilities.
- Ability to work both independently and collaboratively in a team environment.
- Strong communication skills for technical and non-technical audiences.
- Time management and ability to prioritize tasks in a fast-paced environment.
Working Conditions:
- Remote/hybrid
- May require on-call support for critical issues or maintenance windows.
Company DescriptionAimHire IT is a WBE certified with the State of Indiana since 2017. We work with many clients; small to medium companies, allowing for individual growth. We have a strong focus on providing the best customer service to everyone we work with. We take pride in hiring only the top resources to ensure mutual success. We'd love to talk to you about joining our team!
Company Description
AimHire IT is a WBE certified with the State of Indiana since 2017. We work with many clients; small to medium companies, allowing for individual growth. We have a strong focus on providing the best customer service to everyone we work with. We take pride in hiring only the top resources to ensure mutual success. We'd love to talk to you about joining our team!