Database Administrator

Posted 3hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Database Administrator overseeing design, implementation, and operation of organization’s databases for ARC-One Solutions. Ensuring security, integrity, and performance across platforms.

Responsibilities:

  • Oversees daily operations of production, non-production and redundant database environments on the cloud and on-premises implementations
  • Formulates policies, procedures, and standards relating to database management and monitors transaction activity and utilization
  • Reviews database design and integration of systems and makes recommendations regarding enhancement and/or improvements
  • Develops, manages and tests back-up and recovery plans ensuring that all procedures are functioning properly
  • Maintains security and integrity controls over the databases
  • Contributes to the development of a strategy for use of relational databases technology
  • Advises organization leaders on database concepts and functional capabilities and recommends system changes to programming staff.

Requirements:

  • Bachelor’s Degree in Computer Science, Information Technology, Business or related field and five (5) or more years of experience in related field; or an equivalent combination of education, certification, training, and/or experience
  • Database Certification (Postgres or Oracle) preferred
  • Skill in AWS Glue and AWS Database Migration Service
  • Strong SQL development skills across OLTP and analytical data platforms
  • Skill in Amazon RDS and Amazon Aurora for PostgreSQL administration tasks
  • General understanding of Amazon Redshift architecture and service model, including role-based access control, user/group management, and security permissions
  • Hands-on experience with PostgreSQL database administration, including installation, configuration, upgrades, and patching
  • Strong expertise in PostgreSQL performance tuning, including query optimization, index strategy, vacuum/analyze tuning, and parameter configuration
  • Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability
  • Skill in AWS Lake Formation, data lake deployments and administration
  • Ability to organize work for timely completion
  • Ability to speak, write, read, and understand English
  • Ability to follow complex oral and written instructions
  • Ability to communicate effectively orally and in writing
  • Ability to establish and maintain effective and cooperative working relationships with those contacted in the course of work
  • Skill in Microsoft Office applications
  • Ability to travel up to 5% of the time