Database Administrator (DBA): Job at Akaasa Technologies, Remote

MEx0Qkc3Uk1sYVFBUkJvZVlUSVE0U0pWV0E9PQ==
  • Akaasa Technologies
  • Remote

Job Description

Job Description

Overview

The Database Administrator oversees the design, implementation, operation, security, and integrity of production, non-production, and redundant database environments across cloud and on-premises implementations. This role will maintain reliable database services, guide database standards and strategy, support backup and recovery readiness, and advise technical and organizational leaders on database capabilities and improvements.

Actual pay will be determined based upon a candidate's job-related knowledge, skills, education, experience, geographic location, and may include other job-related factors such as certification(s), professional licensure, or internal equity considerations.

Responsibilities

  • Oversees daily operations of production, non-production, and redundant database environments across internal and customer environments.
  • Formulates and maintain database management policies, procedures, and standards, and monitor transaction activity and database utilization.
  • Reviews database designs and system integrations and recommend enhancements or improvements.
  • Develops, manages, and tests backup and recovery plans to confirm that procedures function properly.
  • Maintains database security and integrity controls.
    Installs, configures, upgrades, patches, monitors, and troubleshoots PostgreSQL database environments.
  • Optimizes PostgreSQL performance through query optimization, index strategy, vacuum and analyze tuning, and database parameter configuration.
  • Administers Amazon RDS and Amazon Aurora for PostgreSQL and supports database migration and data integration activities using AWS Database Migration Service and AWS Glue.
  • Monitors database performance, resource utilization, availability, and operational health, and take appropriate corrective action.
  • Collaborates effectively with architecture, engineering, security, and other stakeholders while organizing work for timely completion.

Qualifications

  • Bachelor's degree in a computer-related field from an accredited college or university and five or more years of related experience, or an equivalent combination of education, certification, training, and experience.
  • 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 and analyze tuning, and parameter configuration.
  • Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability.
  • Experience administering Amazon RDS and Amazon Aurora for PostgreSQL.
  • Strong SQL development skills across online transaction processing and analytical data platforms.
  • Ability to communicate effectively in English, both orally and in writing, and to follow complex oral and written instructions.
  • Ability to organize work for timely completion and maintain effective, cooperative working relationships.
  • Experience with AWS Lake Formation and data lake deployment and administration.
  • General understanding of Amazon Redshift architecture and service model, including role-based access control, user and group management, and security permissions.
  • Experience with AWS Glue and AWS Database Migration Service.
  • Database certification in PostgreSQL or Oracle preferred.

Working Conditions:

  • Flexible work hours in a fun collaborative environment
  • Must have reliable internet connection at all times
  • Must have the ability to travel, as needed for company meetings

Job Tags

Flexible hours

Similar Jobs

Spectrum Healthcare Partners

Radiologist - Pediatric Radiologist - Portland, Maine Job at Spectrum Healthcare Partners

 ...Pediatric Radiologist Opportunity in Beautiful Portland Maine Spectrum Healthcare Partners is seeking a Board Eligible/Board Certified Diagnostic Radiologist with Pediatric Radiology fellowship training to join our team. We provide Pediatric Radiology services to... 

EUREKA MULTIFAMILY GROUP

Leasing Agent- La Casita Apartments Job at EUREKA MULTIFAMILY GROUP

Reports To: Property ManagerDivision: Affordable HousingDepartment: Leasing Position Status: Full Time FLSA Status: Non - Exempt JOB SUMMARY:The Leasing Agent is responsible for performing allactivities related to apartment rentals, resident move-ins, and lease renewals... 

Guardian Angel Senior Services

Caregiver for senior citizens in Boston MA area Job at Guardian Angel Senior Services

 ...PCA / CNA - Build Your Own Schedule & Change LivesDo you have a caring heart and a passion for helping others? Join Guardian Angel Senior Services and turn that compassion into a rewarding career. You'll help seniors and disabled adults stay safe, happy, and independent... 

Carle Health

Family Medicine - Physician Job at Carle Health

 ...is seeking an additional BE/BC Family Medicine physician to join our Curtis location in...  ...Family Medicine is housed in a larger primary care center with Internal Medicine, Geriatrics...  ...scene, the University of Illinois, Big 10 sports and an exciting college town atmosphere... 

Michaels Fence & Supply

Residential Fence Installer Job at Michaels Fence & Supply

Job Description Michaels Fence has been the industry leader since 1971, holding the standard high in this profession. We specialize in vinyl, ornamental iron, and chain link fencing. After being voted the #1 'Local Best' Fence Contractor in Sioux Falls for 18 straight...