AYAN InfoTech is looking for MS SQL DBA to join an exciting project based in Sydney. The role offers you the opportunity to contribute towards an extremely well structured and mature environment, working on sophisticated enhancement projects.
Role: MS SQL DBA
Location: Sydney
Contract Duration: 6+ Months with high possible extensions
Experience: 5+ Years
Required Skills and Experience:
- Work on High Priority Incidents , High change tickets and manage vendor problem tickets.
- Check open tickets/issues and be sure issues/requests are addressed within SLA.
- Make sure to respond to all the SQL DB alerts and take proper action.
- Join bridge calls for P1(SEV1) and P2 (SEV2) incidents along with L2/L3 DBAs.
- Ensure all (Full, differential and log)backups are running fine.
- Ensure that no SQL Server job has failed and follow the SOPs if any job is failing.
- Perform the general health of the server (space, CPU utilization, memory) to confirm there are no issues.
- Setup Maintenance plans for Backups , Database integrity check , Rebuild index and Update statistics and make sure to run all the jobs without any issues.
- Troubleshoot locking issues, including deadlocks, blocking, lock timeouts and fix them.
- Experience on performance tuning like creating missing indexes.
- Work on DB Refresh and table refresh activities both in azure and onprem.
- Installation/Upgradation/Migration of SQL Servers.
- Apply any patches or service packs for SQL Server and address the issues if any.
- Configure and troubleshoot issues in AG ,log shipping, replication and cluster.
- Experience in DR activities involves AG ,log shipping, replication and cluster.
- Work closely with application developers to test, configure, and optimize servers based on application demands
- Handle database object deployment to Integration, QA, UAT, and Production
- Experience in handling SSIS packages and troubleshoot the issues.
- Experience in features like querystore, SQL audit,resource pool
- Experience in Server level and DB level encryption.
- Experience in Azure cloud.
Essential Skills:
- Should have knowledge on Database Connectivity issues, slow response, operations timed out, Database incident and error resolution.
- Excellent problem-solving skills should be able to transverse across infrastructure layers to diagnose issues.
- Write and troubleshoot shell scripting, SQL and PL/SQL Scripts.
- Proven experience in automation and orchestration and worked on automaton scenarios for one touch solutions
- Experience in Devops, Terraform integration with Ansible knowledge and knowledge on Shell & PS Scripting is added advantage
- Knowledge in Paas database maintenance ,Redis etc is added advantage
- Should have SQL tuning skills and experience in refactoring SQL queries to improve performance
- Cross functional in any other RDBMS (Oracle, Postgree SQL) or No SQL open source database is an plus.
Please note we will be able to contact only shortlisted candidates for this role. We thank you in advance for your interest.
