RQ08360 - Database Administrator - Senior

Deliverables:

Successful delivery and completion of the internal initiatives, OPS Plan FY 24-25 projects, incident management, problem management, change management, documentation of resolved/outstanding incidents, all completed maintenance work and all configuration changes made to Ministry's infrastructures, databases and applications, and Ministry's infrastructure having availability of no less than 99.5%.

Key Responsibilities:

1. Provide scripting skills in SQL, VBScript, Python and PowerShell.
2. Provide technical expertise in the resolution of problems which may be very diverse and broad in scope; and to provide technical leadership and co-ordination for related mid-sized projects or parts of large and complex projects.
3. Complex database management, patching/updating, and monitoring.
4. Oracle RAC installation/configuration/administration on Exadata or Solaris/Linux.
5. Oracle golden gate configuration/administration.
6. Oracle 19c multitenant environment, exadata on premise and Cloud.
7. Oracle upgrade from 12c to 19c. Oracle Enterprise Manager (OEM 13.4) report creation / customization.
8. Knowledge of DB2 and SQL servers.
9. Lead project teams in identifying and evaluating information technology options for clients, developing infrastructure or system modifications, evaluating and recommending acquisition of midrange hardware, software, services or production consumables.

Technical leadership in:

• Analyzing and defining clients business and information technology requirements; design, development, testing and implementation of business or systems solutions, operational procedures, processes, and databases;
• Preparing technical documentation and technical support; make persuasive technical recommendations;
• Identify and diagnose serious incidents/problems, which may be very diverse and broad scope;
• 
  Provide viable options and solutions;
• Provide draft procedures;
• Train and explain technical concepts to others.
• Project management, and situational operational and service management skills, including costing and cost control, problem-solving techniques, to provide leadership, advice and cost-effective solutions which deal with complex infrastructure problems efficiently and effectively.
• Customer service techniques, to provide data, reports, problem resolution, advice, education and information.
• Written and oral communications, to write, explain and present complex technical reports and recommendations for staff and/or decision-makers who may not have in depth technical expertise;
• Establish effective working relationships and provide instruction for less experienced team members;
• Negotiate with and instruct vendors;
• Provide training; and draft procedures.
• Prioritizing and time and quality management to ensure outputs meet SLA and operational needs efficiently and cost-effectively.
• Ability to work independently and take initiative, as well as collaborating in work and contribute to an agile team environment.
• Advance knowledge of Change, Incident and problem management tools and practices using change management system based on BMC Remedy called eSMT.

Evaluation Breakdown

1. Oracle DBA - 30%

Parameters:

10+ years of demonstrated experience supporting/managing Oracle DB, including but not limited to architecture, installation, upgrade and patching of Oracle DB 12c, 19c, 21c+, Exadata, Oracle RAC, Oracle Golden Gate, Oracle Analytics Server.

2. Scripting Knowledge - 15%

Parameters:

10+ years experience using SQL, VBSCript, PowerShell, and Python.

3. Troubleshooting / Debugging - 10%

Parameters:

10+ years experience troubleshooting coding and identifying/correcting database design flaws.

4. OS Knowledge - 5%

Parameters:

Working knowledge of Windows, Linux and Unix.

5. Communication and Collaboration - 5%

Parameters:

10+ years demonstrated experience in effectively organizing, communicating and collaborating with partners and stakeholders to understand business rules, data and develop automation reports, demonstrated knowledge of SharePoint Online, MS Teams, Microsoft O365 Tools and documentation repositories.

6. Tools Knowledge - 5%

Parameters:

Demonstrated knowledge of infrastructure performance and fault monitoring tools, including Oracle Enterprise Manager and Remedy.

Must Haves:

10+ years of demonstrated experience supporting/managing Oracle DB, including but not limited to architecture, installation, upgrade and patching of Oracle DB 12c, 19c, 21c+, Exadata, Oracle RAC, Oracle Golden Gate, Oracle Analytics Server.

10+ years experience using SQL, VBSCript, PowerShell, and Python.

10+ years demonstrated experience in effectively organizing, communicating and collaborating with partners and stakeholders to understand business rules, data and develop automation reports, demonstrated knowledge of SharePoint Online, MS Teams, Microsoft O365 Tools and documentation repositories along with experience in Networker/Net backup scripting.