PostgreSQL DBA

3 months ago


Wood Dale, United States Alrek Business Solutions Inc Full time

SQL/Postgres DBA - Lead

The Database Administrator will work with all aspects of database administration including but not limited to Design, installation, configuration, upgrades, capacity planning, performance tuning, backup/recovery, and patch management

Ability to work across multiple Database Management Platforms e.g., Oracle, PostgreSQL (Clustering experience is mandate), MS SQL, MySQL

Must have extensive experience working with Cloud database offerings and migrating applications/data from legacy databases.


Responsibilities:

  • Fully support, configure, maintain, and upgrade database environments on premise and in the cloud
  • Manage all database efforts including day to day workloads and large, high-impact projects
  • Monitor and support Oracle WebLogic Middleware
  • Develop and maintain standards and procedures for the DBA team and automate routine tasks
  • Lead migration efforts of legacy on-prem databases to SaaS or IaaS options
  • Responsible for application deployments, configurations, certificate management, analyzing error logs, tuning, and http server troubleshooting
  • Performs database modifications as required to support system enhancements, implementations, maintenance, and data recovery
  • Monitors database integrity in a proactive manner with respect to hardware corruption, software malfunctions, and user error
  • Supports the AAR development staff in the areas of database design as it relates to reliability, resource utilization, practical operations, database environment, bug fixes, and interaction with vendor support
  • Database backup and recovery
  • Disaster recovery planning and testing
  • Provide analysis for system updates
  • Monitor environment performance
  • Resolve problems reported by end users and remote admins

Research and make recommendations on environment administration