Roles and 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 AlwaysOn, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).

· Implementing High Availability in SQL 2012/2016 by configuring AlwaysOn 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.

· Preparing Knowledge articles and sharing with the team on day to day activities.

Skills /Competencies:

Preferred:

· Providing 24X7 Support and maintenance to all the Database Instances of OLTP/OLAP.

Additional Skills:

· Solid Communication & Management skills and, expertise in Onsite/offshore and Client coordination.

· Excellent customer interfacing skills.
Robust attention to detail and outstanding analytical and Problem-solving skills

📌 Sql Dba Sydney
🏢 XPT Software Australia Pty
📍 Sydney