SQL Database Administrator

Job Description

We are looking for an experienced SQL Database Administrator to join our team for a 3 month contract basis. In this role, you will oversee the administration, optimization, and maintenance of SQL databases while ensuring the integrity and availability of data systems. This position is based remotely and offers an opportunity to work on diverse data integration and warehousing projects.

Responsibilities:

• Administer and maintain SQL Server databases, including performance tuning, backups, and disaster recovery planning.

• Optimize and support data warehouse operations using dimensional modeling techniques such as Star and Snowflake schemas.

• Ensure smooth integration between SAP environments and SQL databases, including tools such as SAP BusinessObjects and SAP BW.

• Manage data extraction processes from SAP systems to data warehouses using tools like SAP Data Services.

• Implement and uphold high availability standards, ensuring data integrity and compliance with audit requirements.

• Perform advanced query optimization, indexing, and execution plan analysis to enhance database performance.

• Configure and manage SQL Server features like Always On, mirroring, and log shipping.

• Collaborate with cross-functional teams to support database integration and configuration management.

• Monitor and troubleshoot database clusters to ensure seamless operations.

• Develop and maintain documentation for database processes and configurations.• At least 5 years of experience in database administration, including SQL Server versions 2012 through 2019.

• Proficiency in data warehousing concepts such as Data Vault and dimensional modeling.

• Experience with SAP integrations, including SAP BW, SAP BusinessObjects, and SAP Data Services.

• Strong skills in performance tuning, query optimization, and execution plan analysis.

• Knowledge of backup technologies, high availability configurations, and disaster recovery strategies.

• Familiarity with SSIS and SSRS for database reporting and integration.

• Expertise in MySQL and Microsoft SQL Server.

• Ability to manage and troubleshoot cluster analysis and database configurations.

Fully remote