DATABASE ADMINISTRATOR

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, database capacity issues, replication, and other distributed data issues. Demonstrates knowledge in a variety of concepts, practices, and procedures of relational database administration and other related areas. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. Develops, mentors, and trains junior database administrators. May lead and direct the work of others. Provides consultation on projects and is considered to be a contributor. A wide degree of creativity and latitude is expected.

Essential Job Tasks:

• Develops and enforces policies and procedures for ensuring the availability, security, and integrity of the enterprise database environments.
• Designs, implements, maintains, and automates the appropriate backup and recovery policies, procedures and architecture required to recover the enterprise database environments in accordance with the business continuity requirements. Provides training to others as required.
• Works on project teams providing consultation and technical leadership on the configuration, architecture and capacity required to support the organization’s web based and client/server software applications.
• Partners with various IT staff to resolve issues involving corporate databases and web/client server software applications. Serves on-call, 24 hours a day, 7 days a week, responding to database related issues.
• Reviews enhancements to production databases performed by other Database Administrators prior to implementation to ensure adherence to corporate database standards and quality control.

• General administration of the databases which includes: * + o # @ Maintaining schema objects and data access privileges. @ Monitoring, optimizing, and allocating physical data storage. @ Software installation, patching, and upgrades.

• Will consider Database Administrator II or III, + 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), and Windows batch scripting, Powershell
• Automation and Orchestration - Ansible
• Cloud - Microsoft Azure, Oracle Cloud (OCI), SaaS, PaaS, IaaS

Database Administrator II

• Bachelor’s Degree in Computer Science or related degree + 2 years experience in the Information Technology field.
• Must have strong analytical, problem solving, and conceptual skills enabling creative solutions to business and technical problems.
• Experience in the following areas is preferred, * Bachelor’s Degree in Computer Science or related degree + 5 years experience in the Information Technology field.
• Must have strong analytical, problem solving, and conceptual skills enabling creative solutions to business and technical problems.
• Experience in the following areas is preferred