DATABASE ADMINISTRATOR

About the Role

Administers, maintains, develops, and implements policies and procedures for ensuring the availability, security, and integrity of the enterprise database environments. Implements data models and database designs, data access, and table maintenance. Resolves database performance issues, capacity issues, replication, and other distributed data issues. Provides consultation on projects and contributes to technical leadership. Develops, mentors, and trains junior database administrators. A wide degree of creativity and latitude is expected.

Responsibilities

• Develops and enforces policies and procedures for ensuring the availability, security, and integrity of enterprise database environments.
• Designs, implements, maintains, and automates backup and recovery policies, procedures, and architecture to meet business continuity requirements.
• Provides training to others as required.
• Works on project teams to provide consultation and technical leadership on configuration, architecture, and capacity for web-based and client/server software applications.
• Partners with IT staff to resolve issues involving corporate databases and web/client-server applications.
• Serves on-call 24/7 to respond to database-related issues.
• Reviews enhancements to production databases to ensure adherence to corporate standards and quality control.
• Performs general database administration tasks, including:
  • Maintaining schema objects and data access privileges.
  • Monitoring, optimizing, and allocating physical data storage.
  • Software installation, patching, and upgrades.

Requirements

For Database Administrator II:

• Bachelor’s Degree in Computer Science or related field + 2 years of experience in Information Technology.
• Strong analytical, problem-solving, and conceptual skills.

For Database Administrator III:

• Bachelor’s Degree in Computer Science or related field + 5 years of experience in Information Technology.
• Strong analytical, problem-solving, and conceptual skills.

Skills

Preferred experience in the following areas:

• Linux and Microsoft Windows system administration best practices and fundamentals.
• Database Design, Disaster Recovery, Security, Storage, Networking, Backup, and Maintenance Best Practices.
• Database Optimizations and Enhancements.
• Database Administration in Microsoft SQL Server, Oracle, and PostgreSQL.
• Database Triage and Resolutions.
• Database Management, Monitoring Tools, and Features:
  • SolarWinds, Database Performance Analyzer, SQL Tuning Advisor, SQL Developer, TOAD, SQL Server Management Studio, Database Security Analyzer Tool, Automatic Workload Repository, Oracle Enterprise Manager, DataGuard, SQL Server AlwaysOn, MSSQL Replication, Oracle Advanced Queuing, ORAchk, PGAdmin, Partitioning, SQL Server Reporting Services, Warehouse, Cohesity, Xming, PuTTY, JIRA, WinSCP.
• Application Database Products:
  • Oracle E-Business Suite, Oracle Business Intelligence Enterprise Edition, Oracle Application Express.
• Job Schedulers: Crontab, Windows Task Scheduler, IBM Workload Scheduler.
• Virtualization technologies: VMWare.
• Coding: PL/SQL, T-SQL, shell scripting (bash, ksh), Windows batch scripting, PowerShell.
• Automation and Orchestration: Ansible.
• Cloud: Microsoft Azure, Oracle Cloud (OCI), SaaS, PaaS, IaaS.

Pay

Database Administrator II: $84,180 - $105,210 (min. - mid).

Database Administrator III: $104,620 - $130,770 (min. - mid).

Schedule

On-call responsibilities, 24 hours a day, 7 days a week.