Database Administrator

POSITION SUMMARY:

We are looking for a Database Administrator to maintain our PostgreSQL databases. DB Admin duties include analyze, design, develop, test, implement, maintain, and support application databases and their related test and production environments. This position reports to the IT Director and works closely with Development Team to suggest recommendations for optimization and outline specifications required for project completion with regards to table and parameter structures.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Monitor performance of database systems resources and query throughput
• Optimize SQL Code as necessary
• Monitor and maintain database storage resources
• Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
• Maintain database documentation as required
• Maintaining the tuning, indexing, and performance of our existing database infrastructure
• Perform database Ad-hoc backups and restores
• Trouble-shoot and resolve database connectivity and performance issues
• Scheduling jobs and job monitoring
• Assist in testing new or changed software/database processes and procedures before they are released to users.
• Proactively monitor and respond to database Alerts.
• Ad-Hoc SQL Queries. Maintenance of existing SQL processes and procedures
• Assist with periodic changes, adjustments, or fixes to the existing queries
• Establish and promote design guidelines, best practices, and standards
• Closely follow trends and developments in technology and integrate them into our environment and practices
• Collaborate with product, interaction, and team on project requirements
• Performs additional duties as required and or requested.

REQUIREMENTS & QUALIFICATIONS:

• 1+ years of experience in Information Technology, PostgreSQL Server Database Administration
• Excellent problem solving and analytical skills
• Motivated self-starter
• Academic background in Computer Science or Engineering is a plus * Strong organizational, analytical, and collaborative skills.
• Provide "after hours" support as required
• Able to work well with other team members
• Excellent documentation skills
• Capacity to develop a clear understanding of the business needs and incorporate these needs into technical solutions
• Ability to work under time constraints
• Excellent written and oral communication skills

PHYSICAL REQUIREMENTS:

The physical demands described herein represent those that must be met by the employee to successfully perform the essential functions of the job. Reasonable accommodation(s) may be made to enable individuals with a “legal” disability to perform the essential functions of this position. This position is semi- active and requires occasional standing, walking, bending, kneeling, stooping, and climbing periodically through the day. The employee may frequently lift and/or move items weighing up to 50 pounds.

Job Type: Full-time

Schedule:

• Monday to Friday
• On call
• Overtime
• Weekend availability

COVID-19 considerations:
Online ordering and curbside pick up is available

Work Location: One location

rave-on-records.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, rave-on-records.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, rave-on-records.com is the ideal place to find your next job.