DATABASE ADMINISTRATOR

Santee Cooper; Moncks Corner (SC); On-site; USD 84,000 - 131,000; Full time

Job summary

Santee Cooper in United States seeks an experienced Database Administrator to admin, maintain, develop, and implement policies ensuring availability, security, and integrity of enterprise database environments. You will design, implement, maintain, and automate backup/recovery policies and architectures to meet business continuity needs.

Collaborating with IT staff on projects, you will resolve issues across corporate databases and web/client/server software.

Qualifications

• Bachelor's Degree in Computer Science or related field plus 2 years IT experience.
• Strong analytical and problem solving skills with the ability to develop creative solutions.
• Experience with database design, disaster recovery, security, storage, and maintenance.

Responsibilities

• Develops and enforces policies for availability, security, and integrity of enterprise databases.
• Designs and automates backup and recovery architecture to meet business continuity requirements.
• Leads project teams with technical leadership on configuration, architecture and capacity for web-based and client/server apps.

Skills

Analytical thinking

Problem solving

Mentoring juniors

Education

Bachelor's Degree in Computer Science

Tools

SQL Server

Oracle

PostgreSQL

SolarWinds

TOAD

Oracle Enterprise Manager

SQL Developer

JIRA

WINSCP

Job description

Position Description:

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.

• 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:
• 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

Position Description (continued):

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:
• 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

Position Requirements:

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:
• 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

Compensation Information:

$84,180 - $105,210 (min. - mid.)

Database Administrator III:

• 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:
• 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

Compensation Information: $104,620 - $130,770 (min. - mid.)