Sql Database Administrator

Role: SQL DB SME
Contract duration: 6 months
Extension:  Possible
Work option: Hybrid 
Eligibility: VISA with full working rights / PR / Australian citizen
Experience Required: 5 years
Location: Sydney
Kindly share your CV to Responsibilities:
• Expertise in RDBMS S/W installation, database server builds, applying patches, upgrading, configuring, trouble shooting of SQL SERVER 2008R2/2012/2014/2016• Expertise in Disaster Recovery plans by configuring Always On, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).• Implementing High Availability in SQL 2012/2016 by configuring Always On Availability groups across Windows Server Failover Clustering.• Expertise knowledge in database encryption• Expertise in database Back Up, Restore, Recovery, updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.• Monitoring Instances, Configuring and Enabling alerts using Quest Foglight/App Dynamics or any other 3rd part tool.• Experience in query optimization and performance tuning. Experience in using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.• Experience in PowerShell or SSIS to automate the day-to-day activities and troubleshoot/enhance the existing scripts.• Monitoring/Troubleshooting Log shipping /DB Replication/Always ON.• Respond and Troubleshoot database related problems reported by customers.• Automate the routine tasks.• Preparing Knowledge articles and sharing with the team on day-to-day activities.Skills /Competencies:
• Essential: Tertiary Qualification in IT / Computer Science / related discipline.• Preferred: Providing 24X7 Support and maintenance to all the Database Instances of OLTP/OLAP.
#J-18808-Ljbffr