Job Description :
Job Responsibilities:
Operate DB2, Oracle and SQL databases ensuring that systems are running optimally ensuring availability, efficiency and recoverability.
Designing, planning and implementation of new DB2, SQL and Oracle estate on zLinux & Windows.
Consolidation/expansion of existing services
Design and implement monitoring solutions for DB2, SQL and Oracle databases
Develop and maintain automation scripts for daily operations.
Ability to establish alliances with other teams through recognition of dependencies.
Develop and enforce operational standards for DB2, SQL and Oracle
Ensure security and privacy policy follows best practices.
Acts as an expert technical resource to client and development staff in all phases of the development and implementation process
Correlation and diagnosis of events
Remediation of issues triggered through monitoring or no-impact incidents
Identify recurring incidents and establish remediation plans
Should be able to engage vendors to get issues fixed
Ability to establish alliances with other teams through recognition of dependencies.
Should be able to efficiently handover to overlapping shift across the globe
Suggest process improvements to increase efficiencies to increase organization''s capacity
Decision making provide opinion on how to work efficiently, other potential conclusions that can be drawn from the data, how to adjust the reports to draw conclusions more clearly
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
Install and configure new SQL Servers
Deploy database change scripts provided by third party vendors
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
Document the company’s database environment
To do a great job in this position, experience should include:
On-call troubleshooting experience with at least one large scale Database environment for 5 plus years.
Finding DMV queries to answer questions about server-level performance
Using free tools like sp_Blitz® and sp_WhoIsActive to diagnose server reliability and performance issues
The following skills aren’t strictly necessary, but will make you a well-rounded candidate for bonus points:
Tuning T-SQL queries to improve performance
Troubleshooting hardware using tools like Dell OpenManage, HP System Insight Manager, and IBM Director