Database Administrator
-
IT/Tech
Job Description & How to Apply Below
Employment in this role is conditional upon successful execution of the contract by the client.
The Work:
The Database Administrator will be responsible for designing, implementing, and maintaining moderately complex databases while ensuring their optimization, security, and integration within the organization’s systems. The ideal candidate will have a deep understanding of database management systems, especially PostgreSQL, and the expertise to manage database environments effectively. This role requires a dedicated professional with a proven track record in ensuring data integrity, optimizing database performance, coordinating database changes, and implementing robust security measures.
This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables.
ResponsibilitiesKey Responsibilities:
- Design, implement, and maintain moderately complex databases to meet business and operational needs.
- Ensure efficient database configurations and maintain up-to-date database dictionaries.
- Integrate various systems seamlessly through effective and reliable database designs.
- Administer and test computer databases, leveraging deep technical knowledge of advanced database management systems like PostgreSQL.
- Perform thorough database testing to ensure optimal functionality and efficiency.
- Plan, coordinate, and implement robust security measures to safeguard computer databases from unauthorized access and potential data breaches.
- Administer, monitor, and maintain PostgreSQL environments, specifically version 13 or higher.
- Conduct environment setup, configuration, patching, performance tuning, and capacity planning.
- Implement and validate comprehensive backup and recovery procedures using tools such / WAL archiving.
- Configure, monitor, and manage PostgreSQL replication and ensure high availability through physical and logical replication techniques.
- Optimize database queries and indexing with advanced tools and techniques (e.g., EXPLAIN/ANALYZE, partitioning,_statements).
- Plan and execute migrations to and from PostgreSQL instances, including transitions involving cloud-managed services such as AWS RDS or Aurora PostgreSQL, and migrations from Oracle databases.
- Ensure seamless integration of PostgreSQL within existing IT infrastructures.
- Develop, configure, and deploy monitoring and alerting systems using observability tools (e.g., Prometheus, Grafana, or similar platforms).
- Continuously monitor and troubleshoot database performance metrics to proactively address potential bottlenecks.
- Other duties as assigned.
Qualifications – Here’s What You Need:
The qualifications and skills listed below are intended to provide a general overview of the requirements for this position. However, due to the anticipated nature of the contract and the absence of a finalized task order from the client, this list should not be considered all-encompassing. Additional qualifications, certifications, skills, or experience specific to the client’s requirements may be identified and requested upon award of the task order.
Candidates should demonstrate flexibility and a willingness to adapt to evolving responsibilities as outlined by the client.
- Bachelor’s degree in Information Technology, Computer Science, or a related field, or equivalent experience.
- At least 8 years of professional experience in database administration and management.
- Proven expertise in working with PostgreSQL (v13+) in medium to large-scale deployments.
- Strong technical knowledge of database management systems with significant hands-on experience in database design, administration, and…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction