Database Administrator

Job Title:  Database Administrator

Reports to: Sr Manager Database Architecture

Job Grade: Assigned by Comp.

Job Code: Click here to enter Job Code.

FLSA Status: Assigned by Comp.

FLSA Category, if Exempt: Assigned by Comp.

EEO Category: Assigned by Comp

Prepared By: Click here to enter name.

Date Approved: Entered by Comp.

Approved By: Entered by Comp.

GENERAL DESCRIPTION: If you love working with databases and interest in performance monitoring, tuning and stability; this role could be for you. The role requires working extensively with Oracle databases. This role provides focusing on SQL queries, plan review and database administration, The Database administrator is responsible for daily monitoring of SQLs performance, up-time. This role drives resolution to technical issues.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Candidate should have 3+ years of experience
• Monitor SQL performance and tuning (plan, baselines, profiles)  40%
• Develop PL/SQL Procedures/Packages and automation 20%
• Manage deployment of DDL/DMLs to the database   10%
• Familiar with CICD concepts 10%
• Assists application developers with SQL review 10%
• Database administrator activities needed for high availability 10%

SUPERVISORY RESPONSIBILITIES:

• This Job has no supervisory responsibilities but in special circumstances may lead the work of others

DECISION-MAKING RESPONSIBILITIES:

• This Job requires independent decision-making and recommendations within the context of assigned task, and work with application development team

EDUCATION/EXPERIENCE:

• Bachelor’s degree required; Oracle Database certification preferred
• Expertise in Oracle technologies, OCI, Exadata experience, Familiarity with monitoring tools like OEM ( 2+ years )
• Strong proficiency with SQL, Oracle partitioning and knowledge of Oracle PL/SQL (2+ years)
• Linux, shell scripting required (1+ year)

CERTIFICATES AND LICENSES (list special certifications/licenses that are required or desirable to perform this job):

• N/A

JOB RELATED COMPETENCIES: To perform the job successfully, an individual should demonstrate the following competencies:

• Analytical Skills -
  • Focus on data driven analysis for solutioning and problem solving.
  • Self-motivate, goal driven; Identifies opportunities to increase accuracy and optimize resources;
  • Identifies and resolves problems.
  • Demonstrates attention to detail
• Communication Skills –
  • Strong verbal and written communication skills including presentation and active listening skills.

• • Presents organized and thorough information and data appropriate for intended audience.

• Time Management Skills -

• • Demonstrates follow-up skills.
  • Provides timely and professional support to all internal application team
  • Prioritizes regular workload, tasks to ensure work is completed accurately and efficiently within established time frame.

• Other   -
  • Self-motivated.
  • Team-oriented. Consults with Team members and management as needed to complete assigned responsibilities.
  • Works with minimal supervision.
  • Establishes and maintains effective, collaborative work relationships both internally and externally.

Technical Competencies / Computer Skills  –

• Deep knowledge/experience in the following:  SQL, PL/SQL, Oracle, Unix,  DBA tasks.
• Experience with monitoring tools like OEM and SQL Tuning
• Data modeling skill and use of Entity-Relation (ER) tool is good to have.
• MSSQL database administration ( good to have )
• Keeps current with emerging trends and database technologies.

• • Other Technical / Computer Skills -

• • • Thorough knowledge of internal company software applications
    • High-level learning agility
    • Passionate, self-motivated; works with a sense of urgency under minimal supervision within a fast-paced environment.
    • Maintains strict confidentiality, high integrity, and high reliability.
    • Ability to bring resolution to highly complex and stressful situations   

WORK ENVIRONMENT & PHYSICAL DEMANDS- The Work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Hours of Work/Travel

• Extended hours including weekends (on-call).
• Hours cover early mornings, evenings and weekends.