Responsibilities
- Oversee the design, implementation, and maintenance of SQL Server databases.
- Ensure data integrity, security, and availability.
- Develop and implement database backup and recovery strategies.
- Optimize database performance through indexing, query tuning, and other techniques.
- Collaborate with development teams to integrate databases with applications.
- Monitor database performance and troubleshoot issues.
- Implement and manage database security measures.
- Document database schemas, procedures, and policies.
- Provide technical support and training to users.
- Stay updated with the latest SQL Server technologies and best practices.
- Participate in on-call rotations for database support.
- Assist in the migration of databases to new environments.
- Conduct regular database audits and performance reviews.
- Manage user access and permissions.
- Develop and maintain database documentation.
- Ensure compliance with data protection regulations.
- Collaborate with IT teams to plan and execute database upgrades.
- Implement disaster recovery plans.
- Provide input on database design and architecture.
- Monitor and manage database storage and capacity.
- Conduct regular backups and ensure data recovery processes are in place.
- Ensure high availability and disaster recovery for critical databases.
- Work with stakeholders to understand database requirements.
- Implement and manage database replication and clustering.
Nice to Have
- Certification in SQL Server administration.
- Experience with cloud-based database solutions.
- Knowledge of other database management systems.
- Familiarity with scripting languages such as PowerShell or Python.
- Experience with data warehousing and ETL processes.
- Knowledge of database virtualization and containerization.
- Experience with database performance tuning tools.
- Familiarity with database monitoring and alerting systems.
- Knowledge of database security best practices and standards.
- Experience with database automation and scripting.
Compensation
Competitive salary
Work Arrangement
On-site
Team
Collaborative team environment
Technical Skills
- Proficient in SQL Server administration and management.
- Experience with database design, performance tuning, and optimization.
- Knowledge of database security and compliance.
- Familiarity with database backup and recovery strategies.
- Experience with database replication and clustering.
- Knowledge of database performance monitoring tools.
- Experience with database migration and upgrade processes.
- Familiarity with database security measures and best practices.
- Knowledge of data protection regulations and compliance.
- Experience with database documentation and schema management.
Education
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Relevant certifications in SQL Server administration.
Experience
- Proven experience as a SQL Server Database Administrator.
- Experience with database design, performance tuning, and optimization.
- Familiarity with database security and compliance.
- Experience with database backup and recovery strategies.
- Knowledge of database replication and clustering.
- Experience with database migration and upgrade processes.
- Familiarity with database performance monitoring tools.
- Experience with database security measures and best practices.
- Knowledge of data protection regulations and compliance.
- Experience with database documentation and schema management.
Key Responsibilities
- Oversee the design, implementation, and maintenance of SQL Server databases.
- Ensure data integrity, security, and availability.
- Develop and implement database backup and recovery strategies.
- Optimize database performance through indexing, query tuning, and other techniques.
- Collaborate with development teams to integrate databases with applications.
- Monitor database performance and troubleshoot issues.
- Implement and manage database security measures.
- Document database schemas, procedures, and policies.
- Provide technical support and training to users.
- Stay updated with the latest SQL Server technologies and best practices.
Preferred Qualifications
- Certification in SQL Server administration.
- Experience with cloud-based database solutions.
- Knowledge of other database management systems.
- Familiarity with scripting languages such as PowerShell or Python.
- Experience with data warehousing and ETL processes.
- Knowledge of database virtualization and containerization.
- Experience with database performance tuning tools.
- Familiarity with database monitoring and alerting systems.
- Knowledge of database security best practices and standards.
- Experience with database automation and scripting.
Not provided
