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:
·
Robust Communication & Management skills
and, expertise in Onsite/offshore and Client coordination.
·
Excellent
customer interfacing skills.
Strong
attention to detail and outstanding analytical and Problem-solving skills

📌 Sql Dba (New South Wales)
🏢 XPT Software Australia Pty
📍 New South Wales