We are seeking a highly skilled and detail-oriented SQL Server Database Administrator (DBA) to secure, manage, maintain, and optimize our database systems. As a DBA, you will be responsible for ensuring the security, availability, and performance of databases. You will also assist in troubleshooting issues, performing routine maintenance tasks, and implementing new database technologies to support our growing organization's data needs.
Key Responsibilities: - Database Maintenance & Management:
- Monitor and optimize database performance.
- Perform database backup, recovery, and disaster recovery operations.
- Develop, implement, and test database backup and recovery plans.
- Data Security & Integrity:
- Implement and maintain database security policies, including user access and encryption protocols.
- Ensure data integrity by performing regular audits and checks.
- Troubleshoot data-related issues, ensuring that data is accurate and reliable.
- Database Optimization:
- Analyze database performance and implement optimizations such as indexing, query tuning, and resource allocation.
- Perform periodic health checks and make recommendations for improvement.
- Database Upgrades & Migrations:
- Plan and execute database migrations and upgrades with minimal downtime.
- Implement patches and updates to ensure the database environment is up to date.
- Collaboration & Support:
- Collaborate with development teams to design efficient database structures for new applications.
- Provide support to developers for database-related queries and troubleshooting.
- Create and maintain documentation for database procedures and policies.
- Automation & Scripting:
- Develop and maintain scripts for database automation tasks.
- Use tools like PowerShell, SQL scripts, or other automation technologies to streamline tasks.
Required Qualifications: - Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
- Proven experience as a Database Administrator or similar role.
- In-depth knowledge of SQL Server, PostgreSQL is a plus.
- Experience with performance tuning, query optimization, and data integrity best practices.
- Strong understanding of backup, recovery, and disaster recovery strategies.
- Proficiency in SQL, scripting languages (e.g., PowerShell, Python), and automation tools.
Personal Attributes: - Attention to detail and a commitment to delivering high-quality results.
- Strong communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
- Proactive attitude and eagerness to learn new technologies and processes.