MS SQL Database Administrator (Mid-Level) | For Pooling

Things to know before applying:

• You must have your own work equipment
• You are able to work remotely
• You can work full-time for this role under independent contractor arrangement
• Experience working with clients/companies outside PH is an advantage
• Only candidates who meet the requirements will be contacted
• The role is currently in Active Pooling, meaning it is not fully open yet. However, we anticipate that the role will officially open within the next 1–2 months.

Job Description: We are seeking a mid-level MS SQL Database Administrator to support a critical infrastructure migration project and provide ongoing database administration thereafter. The first phase of this engagement (approximately 4 months) will focus on supporting the migration of the organization's database environment from SQL Server Standard 2019 to a new SQL Server Enterprise cluster, working under the guidance of the Lead DBA. Following the migration, the role transitions into ongoing support and administration of the new environment.

Key Responsibilities:

Migration Phase (Months 1–4)

• Assist in the setup and configuration of the new SQL Server Enterprise cluster environment
• Support the staged migration of 80+ databases from the existing SQL Server Standard 2019 environment to the new Enterprise cluster, following the migration plan set by the Lead DBA
• Execute assigned migration batches, including scripting, data transfer, and validation steps
• Perform pre- and post-migration checks, including data integrity checks and basic performance validation
• Document migration steps, issues encountered, and resolutions for each batch
• Assist in troubleshooting migration-related issues under the direction of the Lead DBA
• Support testing and validation activities during cutover windows

Ongoing Support Phase (Post-Migration)

• Perform day-to-day monitoring and maintenance of the SQL Server Enterprise cluster environment
• Execute scheduled backups and assist with disaster recovery and failover testing procedures
• Monitor database performance and assist with query and index tuning
• Manage routine user access requests and apply security configurations as directed
• Apply patches and updates under guidance from the Lead DBA
• Respond to and resolve standard database-related support tickets and troubleshooting requests
• Maintain and update database documentation

Qualifications:

• Solid experience as a SQL Server DBA, ideally with exposure to database migration projects
• Working knowledge of SQL Server Standard and Enterprise editions
• Familiarity with SQL Server Enterprise features (Always On Availability Groups, clustering, partitioning) is an advantage
• Experience with backup/recovery processes, performance monitoring, and basic index optimization
• Comfortable working with large numbers of databases in a structured, staged migration process
• Good communication skills and ability to follow documented processes and escalate issues appropriately
• Ability to work both independently on routine tasks and collaboratively within a migration team

Tech Stack requirements:

Database Platform

• SQL Server Standard 2019
• SQL Server Enterprise (target cluster environment)
• Always On Availability Groups, clustering, partitioning (working knowledge)

Tools & Languages

• T-SQL
• SSMS (SQL Server Management Studio)

Nice to Have

• Exposure to SQL Server on Azure or other cloud-hosted environments
• Basic PowerShell scripting for task automation
• Familiarity with monitoring tools (e.g., SQL Sentry, Redgate, SolarWinds)

Hiring Process:

• Phone screening
• Technical Test
• Behavioral Interview
• Client interview

About Adaca:

Adaca was founded in 2015 to assist Australian companies in their software development initiatives. Over the past 10 years, we have successfully built and scaled a distributed team across Australia and the Philippines to over 100 staff. Now, we are entering a whole new era of artificial intelligence. Our authentic, values-led approach has allowed us to attract and retain magnificent people. Adaca operates a high-performance core team with a network of customer-facing people who have catalysed our growth. This emphasises the value that each individual holds in influencing the growth of the business.