Job Description:Roles
and Responsibilities:· Expertise in RDBMS S/W installation, database
server builds, applying patches, upgrading, configuring, trouble shooting of
SQL SERVER ****R****************· Expertise in Disaster
Recovery plans by configuring AlwaysOn, Clustering, Log-shipping, Mirroring and
Replication (Snapshot and Transactional).
· Implementing High
Availability in SQL ********* 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:· Strong Communication & Management skills
and, expertise in Onsite/offshore and Client coordination.
· Excellent
customer interfacing skills.
Solid
attention to detail and outstanding analytical and Problem-solving skills

📌 Sql Dba (Sydney)
🏢 XPT Software Australia Pty
📍 Sydney