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