PostgreSQL DBA (5-10 yrs)
At Agilysys, Inc. we are proud of our 3,000+ customers including some of the world’s most recognizable resort, casino and cruise line brands. We specialize in market-leading point-of-sale, property management, inventory and procurement, and mobile and wireless solutions that are designed to streamline operations, improve efficiency and enhance the guest experience. We serve casinos, resorts, hotels, food service venues, stadiums, cruise lines, grocery stores, convenience stores, general and specialty retail businesses and partners. With extensive operations, throughout North America, and additional sales and support offices in Singapore and Hong Kong, as well as software development in India, we are growing. For more information, visit: www.agilysys.com.
We are looking for a capable resource to Responsible for understanding operational requirements including Hardware, Architecture,
configuration, Integration and maintaining mission critical production MS SQL Server /PostgreSQL databases both On-Prem and Cloud.
- Experience as DBA MS SQL/Azure SQL/ PostgreSQL Hyper-Scale Database
- Experience in monitoring, managing, and maintaining mission-critical 24*7 mission critical databases.
- Good understanding of SQL & PostgreSQL Architecture
- Installation / Configuration / Administration MS SQL/PostgreSQL On-Prem/Cloud
- Exposure in Data Migration between different databases
- Knowledge on Table Partitions / Shading – Scripting and Managing
Implementing high-availability solutions
- Experience in Installation /configuration of Replication, Connection pooling etc.
- Expert in Backup Recovery including like PG dump, setting up WAL archiving.
- Setting up monitoring tools and tune different database metrics to monitor
- Implement database security policies.
- Server level / OS level / DB level optimization.
- Working knowledge of operating system internals.
- Experience in Performance-tuning consultation by working closely with development team to tune the database and meet application specific needs.
- Should work on various MSSQL / PostgreSQL in house utilities/ scripting.
Other Desired Experience
- Hospitality experience.