Database Administrator

About the position

As a Database Administrator, you will be responsible for maintaining the integrity, security, availability, and compliance of databases throughout their life cycle in accordance with business processes. Your key responsibilities will include performing disaster recovery, conducting performance analysis and tuning, maintaining indexes, and monitoring database performance. Additionally, you will evaluate and recommend database management system products, administer both databases and application servers, and organize and format data for efficient querying and storage. Overall, your role will ensure that databases operate smoothly and meet the organization's needs.

Responsibilities

• Performing disaster recovery
• Conducting performance analysis and tuning
• Maintaining indexes
• Monitoring database performance
• Evaluating and recommending database management system products
• Administering both databases and application servers
• Organizing and formatting data for efficient querying and storage

Requirements

• Knowledge in use of the following databases: Microsoft SQL Server, MariaDB, Postgres
• Create/Maintain bash scripts to dump and load databases as well as perform various maintenance tasks (Rebuild Indexes, Update Statistics)
• Able to run SQL agent jobs for MSSQL, familiar with installing software on Linux platforms
• RedHat Ansible
• Identify management via Active Directory and Centify
• Use Salt to deploy config files to end nodes and do various interrogations (Ping, DNS)
• NxLog, SALTSstack, Wazuh, NIFI for reading end node logs, HAproxy load balancer
• Ability to Request, Renew, and Install/Update PKI certs. Convert from pkcs12 to various formats
• Basic familiarization with nLyte, NEO datacenter inventory management application
• NIFI - ability to automate dataflows between software systems
• Ranger/Docker - the ability to configure containerized applications, primarily for distributed applications
• Kubernetes - the ability to configure open source platforms for container orchestration
• Experience with Wazuh, Nxlog, Saltstack - deploy config files to end nodes and various interrogations, GIT and HAProxy load balancer
• Experience with Vcenter/Vsphere - Building VMs