Sonata Software Overview Sonata is a global technology company specializing in platform-based digital transformation, supporting businesses to become connected, open, intelligent and scalable. Sonata’s Platformation™ methodology brings together industry expertise, platform technology excellence, adesign innovation and strategic engagement models to deliver sustained value to customers. A trusted partner of world leaders in the retail, manufacturing, distribution, travel, services and software industries, Sonata’s software portfolio includes the Brick & Click Retail Platform©, Modern Distribution Platform©, Rezopia Digital Travel Platform©, Kartopia E-commerce Platform©, Halosys enterprise development automation Platform©, CTRM Commodity Trading and Risk Management Platform© and KODO - AI Powered Customer Experience (CX) Platform. Sonata’s Platformation approach ensures services built on Microsoft Dynamics 365, Microsoft Azure, AWS, Cloud Engineering and Managed Services deliver on the Platformation promise. As world leaders in digital technologies including IoT, Artificial Intelligence, Machine Learning, Robotic Process Automation, Chatbots, Block Chain and Cyber Security, Sonata’s people and systems are nurtured to deliver on our commitment to excellence in business technology solutions. Job Title : PostgreSQL DBA Location : 100 % Remote Duration : Long Term Contract Interview Process : L1 Internal and Client Primary Responsibilities: Database architecture, engineering, design, optimization, security, and administration Data modelling, big data development, Extract, Transform, and Load (ETL) development Storage engineering, data warehousing, data provisioning and other similar tasks Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems Management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments Analyses current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities Design schemas, write SQL or other data markup scripting and helps to support development of Analytics and Applications that build on top of data Required Qualifications: 5+ years of experience as DBA on one or more of the following database platforms: PostgreSQL, AWS Aurora 5+ years of experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues 5+ years of experience in Performance Tuning using platform specific tools 5+ years of experience in implementing operational automation 3+ years of experience as DBA on Cloud Platforms (AWS) Advanced level of understanding and application of database concepts and their integration with business problem solving skills Expert knowledge of backups, restores, recovery models, database storage operations, Clustering, Database mirroring, Replication Expert knowledge of how to use indexes, index management, integrity checks, configuration, patching, how indexes are stored, how they can be created and managed effectively Demonstrated ability to detect and troubleshoot database server related CPU, memory, I/O, disk space and other resource contention Preferred Qualifications: Experience with planning, organizing and leading database projects and initiative High volume, transaction processing background Health care industry experience Experience in business analysis, process improvement, workflow, benchmarking, or evaluation of business processes Ability to work in a self-directed environment Ability to work with less structured, more complex issues Why join Sonata Software? At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next. Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law