Database Administrator
Overview:
The Database Administrator oversees the design, implementation and operation of the organization’s databases in order to maintain security and integrity controls.
The base salary range for this position is $95,178-$149,566.
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 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.
Qualifications Required
- 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
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