Note: The job is a remote job and is open to candidates in USA. OneBlood is seeking a Database Administrator to oversee database environments across cloud and on-premises implementations. The role is responsible for database operations, security, integrity, performance optimization, backup and recovery, AWS database services, and collaboration with technical stakeholders.
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
Skills
- 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
- Must have reliable internet connection at all times
- Must have the ability to travel, as needed for company meetings
- Database certification in PostgreSQL or Oracle preferred
Benefits
- Flexible work hours in a fun collaborative environment
Company Overview
Company H1B Sponsorship