Infinity Consulting Solutions – PostGres Database Administrator – Remote – Irving, TX

Job title: PostGres Database Administrator - RemoteCompany: Infinity Consulting SolutionsJob description: Job Description - PostGres Database Administrator - RemoteTITLE: PostGres Database AdministratorLocation:Remote in the U.S. ICS is hiring a PostGres DBA to join our healthcare software client’s team! 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 a primary ‘practitioner coach’ on the team to grow the capabilities of other members on the team.What You’ll Do:• 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 setupMonitor, troubleshoot, and resolve failed tasks or database issues on a variety of database engines including bolthires SQL Server, PostgreSQL, and MariaDB (MySQL)• May create a database, assign permissions, and resolve connectivity issuesGrow 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 optimizationSkills / Experience You Will Need:• bolthires 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 bolthires SQL Server, PostgreSQL, and MariaDB (MySQL) - 5+ years• bolthires SQL Management Studio, SSIS, SSRS, SSAS• bolthires 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 processesAbout Infinity Consulting SolutionsAt Infinity Consulting Solutions our mission is to cultivate successful long term relationships with candidates and clients matching the right candidate with the right client.We believe technology cannot replace the real personal relationships we cultivate. We reject the notion that technology alone is the answer to staffing which is why we our successful partnerships rely on collaboration NOT automation. ICS has been providing flexible staffing solutions for over 20 years in Information Technology, Compliance, Accounting / Finance and Corporate Support. Our staffing solutions include Contract, Temp to Perm and Permanent Placement. ICS is an Equal Opportunity Employer. Expected salary:Location: Irving, TXApply for the job now!Apply tot his job