What are the responsibilities and job description for the Database Administrator position at Velocitor Solutions Llc?
We are seeking a highly skilled and motivated Microsoft SQL Server Database Administrator to join our talented IT team. If you possess strong expertise in managing large-scale databases, and are passionate about ensuring optimal performance and reliability, we want to hear from you.
Responsibilities:
-
Database Administration:
- Manage, monitor, and maintain Microsoft SQL Server databases, ensuring high availability and performance.
- Implement and manage Always-On AG to provide fault tolerance and high availability.
- Handle TB-sized databases, optimizing performance and resource utilization.
-
Sharding or Partitioning Experience:
- Design and implement database sharding strategies for efficient horizontal scaling.
- Monitor and manage sharded databases to ensure even distribution of data and optimal query performance.
-
Azure SQL Server:
- Experience in handling VM’s in Azure, Manage SQL Instances, and SQL Databases in Azure.
- Utilize Azure services for scalability, security, and performance enhancements.
-
Backup and Recovery:
- Develop and maintain robust backup and recovery strategies for large databases.
- Perform regular database backups and conduct periodic recovery tests to ensure data integrity.
-
Performance Tuning:
- Analyze and optimize query performance, indexing, and database configuration.
- Proactively identify and resolve performance bottlenecks to ensure optimal database responsiveness.
- Query Store experience required.
-
Security:
- Implement and enforce database security measures to protect sensitive data.
- Stay current with industry best practices and security trends to ensure databases are protected against potential threats.
-
Collaboration:
- Collaborate with cross-functional teams, including developers and system administrators, to address database-related issues and ensure smooth operations.
- Participate in the planning and execution of database-related projects.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Proven experience as a Microsoft SQL Server Database Administrator.
- In-depth knowledge of Always-On Availability Groups.
- Experience managing TB-sized databases in a production environment.
- Strong SQL scripting skills and expertise in performance tuning.
- Familiarity with database security best practices.
- Azure certifications and experience deploying SQL Server databases on Azure are a plus.
- Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.