Job description
PioneerRx is an industry leading software company that provides technical solutions to over 5,500 independent pharmacies nation wide!
As a Sr. PostgreSQL DBA you will define improvements to increase system reliability, security, and performance. Document the design, operation, and troubleshooting of Disaster Recovery and Business Resumption. Function as primary ‘practitioner coach’ on the team to grow the capabilities of other members on the team.
Job Responsibilities:
- Database Administration including
- Proactive performance and resource monitoring
- Backup, high availability, and disaster recovery
- Configuring and monitoring replication clusters
- Security and compliance reviews
- Performance and load testing for table/index designs
- Partitioning, sharding, and multi-server setup
- Monitor, troubleshoot, and resolve failed tasks or database issues on a variety of database engines including Microsoft SQL Server, PostgreSQL, and MariaDB (MySQL)
- May create a database, assign permissions, and resolve connectivity issues
- Grow the current data warehouse design and implementation, as well as suggest improvements
- Experience with ETL/ELT with modern analytics architecture
- Work with / mentor development teams on performance tuning and optimization
Required Skills and Qualifications:
- Microsoft SQL Server - 2012 up to at least SQL 2016, 5+ years
- Experience in supporting large databases and distributed data environments
- PostgreSQL, 5+ years
- Extensive experience in performance and reliability improvements on multiple database engines including Microsoft SQL Server, PostgreSQL, and MariaDB (MySQL) - 5+ years
- Microsoft SQL Management Studio, SSIS, SSRS, SSAS
- Microsoft SQL Extended Events, other monitoring/performance tools
- DevOps deployments and pipelines
- Experience with database version control or data governance
- Ability to work in a complex production environment with multiple integrated systems
- Cognizant of security and compliance in a HITRUST/HIPAA/SOC2 Production environment
- Occasional after-hours deployments
- Ability to thrive in a heavily regulated environment (HITRUST/HIPAA/SOC2)
- Able to work solo and in a close team environment at the project and ad-hoc level
- Good documentation skills and willingness to provide it
- Self-starter and well-disciplined
- Good troubleshooting skills in a complex environment with thousands of servers and SQL instances
- Ability to handle multi-tasking workloads and sources of work
- Willingness to learn new systems and processes
Desired Skills & Qualifications:
- BS in Computer Science or equivalent technical training.
- Cloud and containerized deployment
- Postgres operator experience, IaC (Infrastructure as Code)
- Microsoft Windows Operating Systems - Client and Server - 5+ years
- Linux Operating Systems - Server - 5+ years
jjbodyshop.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, jjbodyshop.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, jjbodyshop.com is the ideal place to find your next job.