Database Administrator PostgreSQL
Share
Job Location:
Harrisburg, PA - USA
Monthly Salary:
Not Disclosed
Posted on:
16 hours ago
Vacancies:
1 Vacancy
Job Summary
Location: Harrisburg PA
Position Type: Hybrid
Hybrid Schedule:1 day in office per week minimum.
Must be flexible to be on site 5 days if management team requires
Contract Length: 6 months Contract to hire
This position requires participation in a 24x7x365 on-call rotation
Position Overview:
This position leads the design implementation maintenance and support of database environments. This role includes the development and design of database strategies monitoring and improving database performance and capacity and planning for future expansion requirements for the most complex projects working independently. This position requires the necessary skills to coordinate and support other database administrators as senior database administrators are expected to mentor coach and train less senior team members.
Duties:
- Manage PostgreSQL database design and architecture infrastructure high availability (HA) security performance monitoring/alerting and routine maintenance (tuning backup replication recovery).
- Understand application data storage requirements and associated business logic.
- Design and create database schemas tables indexes and other objects to optimize query performance.
- Evaluate and recommend deployment options for Aurora (AWS PostgreSQL) and/or open-source PostgreSQL on AWS and on-premises.
- Deploy and maintain PostgreSQL databases using containerization/automation tools (e.g. Terraform Ansible Rancher Kubernetes).
- Ensure scalability and maintainability aligned with future growth and data retention needs; define/configure for both AWS and on-prem environments.
- Collaborate closely with stakeholders; communicate effectively (written and oral).
- Lead projects and contribute as a self-starter/team player; solve problems proactively.
- Apply basic project management skills (create/read/update/follow plans).
Required Experience:
Senior IC
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About Company
Careers at LingaTech: Love Where You Work! Welcome to the vibrant world of LingaTech, where technology meets fun and innovation! Are you ready to join the adventure? As a premier employer of top-notch technology consultants, we're on a mission to assemble the most talented and passion ... View more
