What are the responsibilities and job description for the Database Administrator position at Noblesoft Technologies?
Job Title : Database Administrator
Location : Minneapolis MN / Remote
Mode : Contract (6 Months)
Key Responsibilities :
Independently perform all aspects of relational database management for MySQL and Oracle / MS SQL, including but not limited to installation, configuration, patching, migration, PLM / upgrade, and operational support in on-premises and public cloud environments.
Automate repeatable database tasks using shell scripting, Chef and / or Ansible to drive efficiency, enhance quality and reduce human errors.
Design and implement effective backup and recovery strategy for databases to ensure timely restoration, as needed.
Establish and maintain database security policies, manage user access, and monitor databases to ensure data is protected from unauthorized access, ransomware. or breeches.
Design and implement strategies to ensure high availability and database resiliency in the event of a disaster.
Proactively analyze database systems for performance tuning, remove bottlenecks, and make recommendations to reduce database response times and enhance efficiency.
Collaborate with peer DBAs, application development groups, system administrators, and other IT professionals to support database-related projects and address operational issues.
Refresh lower environments as needed by other teams to facilitate testing and development.
Develop infrastructure, infrastructure tools, and documentation during project phases.
Provide on-call operational support for Production databases and answer severity calls for problem resolution.
Required Skills :
Experience with all aspects of MySQL database management on UNIX, including but not limited to installation, configuration, patching, migration, PLM / upgrade, and operational support.
On-call experience in supporting multiple mission critical MySQL production databases.
3 years of experience in developing shell scripts and Chef recipes to automate database installs and maintenance activities on UNIX platform.
3 years of experience in supporting Oracle databases on UNIX, or MS SQL databases on Windows.
Preferred Skills :
Experience in migrating MySQL databases from on-premises to Public Cloud, preferably Microsoft Azure.
Experience in developing PowerShell scripts for MS SQL databases on Windows platform or supporting Oracle databases in multi-tenant architecture on Exadata platform.
Working knowledge of Ansible.
