Oracle DBA

PURPOSE OF THE FUNCTION DBAs use specialized software to store and organize data. The role includes Database support, capacity planning, installation, configuration, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery and general support of the databases.   TASKS, DUTIES & RESPONSIBILITIES

• Support Areas
  • Database Administrative support of Oracle Database Server (12c): Monitoring, maintenance and housekeeping of Server and Databases, Jobs, User Access management and regular client requests. Writing and tuning codes and highly customized jobs.
• Support of application and upgrade database (Database Migration/ upgrade) from existing versions to latest Server versions.
• Incident Management: Knowledge of Incident management process and participation in a rotational on-call schedule to support off hours production incidents
• Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
• Maintaining up-to-date documentation and procedures for all supported applications and environments.
• Maintaining 99.99% availability for all production environments.
• Evaluation of functionality and features with newer versions of the Oracle Server DBMS/ database related tools
• Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
• Monitoring and support of nightly production batch cycles.
• Regular review of database maintenance/ support tasks and performance improvement procedures
• Work Planning/Escalation: Organizing and monitoring personal workload and escalating to manager when issues arise
• Continuous Improvement: Sharing ideas for process improvement and innovative solutions to known problems

KNOWLEDGE, SKILLS & ATTITUDES

• Intermediate Knowledge
  •  Database Maintenance/ Support tasks and lower level monitoring using tools like profiler, DMV, Perfmon
  • Oracle Server Replication, Backup/ Restore, maintenance plans and DR recovery strategies.
  • Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)
  • Understanding of system tables, stored procedures, functions, triggers & tuning
  • General troubleshooting like assisting clients with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc.
  • Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, ids and Proxy accounts.
    • Desirable to have
  • Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing codes.
  • Knowledge of Oracle Server database tuning using Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs), and other third-party tools.
  • Hands-on experience with Oracle Server installations and patching.
  • PowerShell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them.
  • Some knowledge of data-mapping and logical and physical data modeling.
  • Knowledge of clustering, Always on / multi node clusters at the time of DR process.
  • Knowledge of AWS, Specifically, migration to AWS from in premise data center

POSITION DESCRIPTION (JOB SUMMARY) The candidate will be a member of a team within Data Management Services (DMS) called Database Services Client. The primary role on the team will be as Oracle Database Administrator supporting various applications, but the individual may be asked to take on additional duties including: infrastructure support and cross-training on other DBMS platforms. PRIMARY OBJECTIVES

• Resolution of reported service requests, pro-active and reactive performance analysis related to databases
• Carry out Database migrations, upgrades, patching and evaluation/roll out of new database related tools
• Minimize database downtime and manage parameters to provide fast query responses.
• Troubleshooting, monitoring and diagnose issues with Oracle Server Database and highly customized jobs.
•  Adherence to documented standards and procedures while doing database related activities like change management.