Job Description:

Rolesand Responsibilities:

- Expertise in RDBMS S/W installation, database server builds, applying patches, upgrading, configuring, trouble shooting ofSQL SERVER 2008R2/2012/2014/2016
- Expertise in DisasterRecovery plans by configuring AlwaysOn, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
- Implementing HighAvailability in SQL 2012/2016 by configuring AlwaysOn Availability groupsacross 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 MaintenancePlan.
- Monitoring Instances, Configuring and Enabling alerts using Quest Foglight/App Dynamics or anyother 3rd part tool.
- Experience in queryoptimization and performance tuning. Experience in using SQL Profiler,Execution Plan, Performance Monitor and DBCC Commands.




- Experience inPowerShell 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 Knowledgearticles and sharing with the team on day to day activities.
- Preparing Knowledgearticles and sharing with the team on day to day activities.

Preferred:

- Providing24X7 Support and maintenance to all the Database Instances of OLTP/OLAP.

Additional Skills:

- Robust Communication & Management skillsand, expertise in Onsite/offshore and Client coordination.
- Excellentcustomer interfacing skills.
- Strongattention to detail and outstanding analytical and Problem-solving skills

#J-18808-Ljbffr

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