Sr. Production Database Administrator

at Punchh Inc.

Posted by Bharat Saxena

·       Primarily responsible for working on various service requests related to maintaining database security (roles, privileges, authentication), creating schema and copying data ·       Work on installation, configuration, creation and administration of HP Vertica database clusters and AWS RDS MySQL database. ·       Work with platform, product and other support teams to participate in release and change management processes to implement new features/functions as well support mandatory patches or upgrade activities on weekends. ·       Responsible for database performance tuning, query tuning and database operations including migration and upgrade. ·       Plan and implement periodic upgrades of database schema and perform testing and verification of released database schema upgrades. ·       Configure and manage database backup and restore, participate in Disaster Recovery ·       Create and maintain documentation, procedures and best practice guides for database deployment and maintenance.

SAP Basis and System Administration Consultant Main skills: SAP Basis, Integration Architecture, AWS, Website Management, Dev-ops   Job Description SAP Basis Consultant with technical expertise on SAP ERP, SAP Solution Manager, SAP Cloud Platform & Integration, SAP HANA and exposure to AWS Platform. Working closely with technical and functional teams on managing technical issues arising in Implementation and Support projects.   Responsibilities Provide SAP BASIS technical support to Developers, Functional, and Sales/Pre-sales teams to resolve system issues. Manage and maintain SAP ERP Cloud systems covering User Authorization management, Transport Management, SAP System Client Copies, refresh and administration, SAP Router Administration, end to end SAP server admin support. Responsible for SAP systems installation, configuration, maintenance, migration, and upgrade Responsible for Solution Manager Configuration and administration. Responsible for SAP HANA Administration and support. Technical expertise in SAP Cloud Platform, SAP Cloud Integration, SAP Cloud Connector Setup. Able to design Integration landscapes for customers, help them address all security queries, provide support on SSL setup and help them in integrating SAP cloud solutions into their existing on premise landscape. Good knowledge in SAP Neo and SAP Cloud Foundry environments. Expertise in integrating SuccessFactors with On-premise SAP ECC (HCM). Manage full SAP Basis configuration of this setup covering add-on installation, soamanager setup, and web services configuration. Good knowledge on SSO. Should be able to configure SSO between SAP and AD (such as Microsoft ADFS, Azure, any SAML 2.0 AD). Good knowledge on AWS cloud solutions. Able to manage infrastructure on AWS. Good knowledge on AWS security and networking. Help Customers migrate on premise solutions to Cloud. Should be able to handle Website domain management, hosting management. Manage end to end support of domains such as domain transfer, domain renewals, SSL cert install and renewals on the domains. Closely collaborate with clients and 3rd party vendors supporting Infra and other systems connecting to SAP Requirements The ideal candidate has 4-5 years of SAP Basis Consulting experience. Experience in SAP Basis monitoring, installation, and configuration, supporting SAP Systems landscape (ECC/ S/4HANA, BW, Portal, Content Server, Solution Manager, SAP GUI and database) SAP Basis administration experience in private / public cloud-based environment Possess Database knowledge (Oracle, DB2, SQL, HANA, Sybase) Possess Operating System knowledge (UNIX, Windows, Linux) Ability to work on activities involved in Plan areas (Sizing,  Scoping, Client/ Landscape Strategy, etc.) of Implementation, Upgrades and Support projects without much supervision at the transaction level Involved in at least 3-4 end to end life cycle implementation SAP Basis SAP BASIS certified or SAP HANA certified and AWS certified will be an added advantage. Strong BASIS knowledge and skills with SAP HANA implementation experience, strong on various Cloud technologies with the ability to commission and configure SAP environment both on AWS platform. Strong knowledge in SAP Cloud Platform environment and SAP Cloud Integration areas. Skilled in change management, system analysis, requirements gathering and production control Strong troubleshooting and analytical skills, and ability to communicate progress and outcomes, and provide clear recommendations Ability to work independently, manage time effectively, and a self-starter Good team player with positive attitude and excellent communication and interpersonal skills About Rolling Arrays Rolling Arrays provides HR Software and HR System Implementation Services (SAP SuccessFactors) to customers in Singapore, Malaysia, Australia, UAE, and Hong Kong. Rolling Arrays (RA) was featured as Singapore’s Top 75 fastest growing companies by the leading newspaper of Singapore - The Straits Times in 2021 where RA was ranked 48. Rolling Arrays has 2 line of business:   HR System Implementation: In this line of business, RA has 100 Talented HR-Tech-Consultants spread across Singapore, Malaysia and India (Mumbai). Currently Rolling Arrays is regarded as number ONE mid-size firm in the South East Asian Market with a strong track record of 12 Years and more than 200 enterprise level SAP SuccessFactors projects till date. Based on market demand and established brand value, RA plans to double its consulting headcount by 2022.   HR Software: Rolling Arrays has 3 HR Software products: Rhombus HRIS Reimburse (AI Enabled Travel & Expense Management Software for Enterprises) CICO (Intelligent Time Capture Machine, a software alternative to Physical Biometric Devices)   Rolling Arrays ventured into HR Software business in 2018 and has a dedicated team of 30 handpicked Software Engineers in Singapore and Mumbai. Based on strong market demand, RA plans to expand its Engineering team rapidly over the next 3 years.

Complete involvement in the database requirement starting from the design phase for everyproject.• Deploying required database assets on production (DDL, DML)• Good understanding of MySQL Replication (Master-slave, Master-Master, GTID-based)• Understanding of MySQL partitioning.• A better understanding of MySQL logs and Configuration.• Ways to schedule backup and restoration.• Good understanding of MySQL versions and their features.• Good understanding of InnoDB-Engine.• Exploring ways to optimize the current environment and also lay a good platform for newprojects.• Able to understand and resolve any database related production outages

• 5+ years of testing experience, preferably in a product organization• Strong knowledge of SQL and ETL Testing• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing• Hands-on back-end testing skills and strong RDBMS and testing methodologies.• Expertise in test management tools and defect tracking tools i.e HP Quality Center, Jira• Proficient experience of working on SDLC & Agile Methodology•Excellent Knowledge of Database Systems Vertica /Oracle/ Teradata• Knowledge in security testing will be an added advantage.• Experience in Business Intelligence testing in various reports Using Tableau• Strong comprehension, analytical, and problem-solving skills•Good interpersonal and communication skills, quick learner, and good troubleshooting capabilities.• Good knowledge of Python Programming language.• Working knowledge of AWS

3+ years hand on experience operating as BI Administrator and BI Developer on the “Oracle Hyperion Interactive Reporting” platform o   Troubleshoot system stability and availability issues o   Identify issues with Hyperion data source systems o   Ability to understand Oracle PL\SQL scripts, and amend it as needed, to adjust\enhance the Hyperion reporting objects as needed o   Troubleshoot Hyperion Reporting objects issues, work with business users and DWH Developers to determine root causes, and address remediation actions o   Work with IT Security team to complete security assessment on the Hyperion application, as well as periodic reviews of previous security assessments o   Identify obsolete and unused Hyperion objects, and work with the business users to prepare and action object retirement plans o   Develop and maintain Hyperion Dashboards using Javascript

You will work on: You will be working on our client’s massive scale Infrastructure and CloudOps requirements. You will be directly working on the customer's cloud environment and managing their product infra life cycle.What you will do (Responsibilities):Understand how the product works and how it is used by the customersDay-to-day operational support of product infrastructure on all three major public cloud servicesInteract with customers on/off-site to troubleshoot issues, provide workarounds by leveraging your troubleshooting skillsCreate and manage processes for the secure operation of customer cloud environmentsSystem (Windows, Linux, and SQL Databases) and Network administrationsUse incident management tools used in incident analysis and troubleshooting. Identify, escalate, and communicate issues in a timely manner.Contribute to building a knowledge base centered on known incidents/defects, Frequently Asked Questions, resolved issues, applying lessons learned and previous resolutions to new incidents.Build hosting environments for clients all over the worldCollaborate with product managers and engineers to ensure that critical and time-sensitive projects run smoothly and achieve the business outcomeOn-call responsibilities to respond to emergency situations and scheduled maintenanceContribute to and maintain documentation for systems, processes, procedures, and infrastructure configuration.What you bring (Skills):Minimum 2 years of relevant experience in cloudops (mainly into MS Azure), infrastructure management, and supportStrong Windows Systems, SQL Database, and Network administration skillsStrong understanding of cloud applications, concepts, and the storage, compute, and networking componentsReadiness to work in 24x7 rotational shift modelScripting in PowerShell, Linux shell, Python or C#Proactive and self-motivated, committed to achieving deadlines, meeting SLAs, and producing resultsExcellent customer service and people skills. Excellent analytical, written, and oral communication and relationship building skillsAbility to be a good listener, and to understand customer issues. Ability to provide innovative workarounds or design a solution to fix a customer’s problemGreat if you know (Skills):AzureOps:Comfortable using TFS (Team Foundation Server) and Azure DevOps workflowsComfortable with Visual Studio and SQL Server Data ToolsExposure to deployment using Azure cloud console and ARM templatesExperience in handling Azure AD & RBAC related activities will be a plusComfortable with basic DevOps concepts like CI/CD, and Infra-automation Advantage Cognologix:A higher degree of autonomy, startup culture & small teamsOpportunities to become an expert in emerging technologiesRemote working options for the right maturity levelCompetitive salary & family benefitsPerformance-based career advancementAbout Cognologix: Cognologix helps companies disrupt by reimagining their business models and innovate like a Startup. We are at the forefront of digital disruption and take a business-first approach to help meet our client’s strategic goals.We are DevOps focused organization helping our clients focus on their core product activities by handling all aspects of their infrastructure, integration and delivery.

Responsible for preparing, conducting, and evaluating technical training programs. Writes literature and materials to be used in programs and designs exercises to enhance learning experience. Responsibilities Provide technical training to professional personnel. Develop innovative and easy-to-understand training materials.logistics and tools. Meet organizational training needs. Organize instructor-led training programs. Prepare training schedules and programs for personnel. Analyze learning needs and develop appropriate training material. Interact with respective departments in scheduling training programs. Requirements Experience in delivering technical training.  Top-notch administrative, research and troubleshooting skills. Ability to host training workshops for new hires. Knack for detecting and removing barriers to learning. Strong knowledge of PHP, Python, Javascript, MySQL, NoSQL, Data Structures, Algorithms Experience   2-3 years of experience of relevant experience is preferred.

Eligibility Criteria:  Advanced knowledge of Magento, JavaScript, HTML, PHP, CSS, and MySQL. Coding of the Magento templates. Developing Magento modules in PHP using best practices. Experience with complete eCommerce lifecycle development. Understanding of modern UI/UX trends. Knowledge of Google Tag Manager, SEO, Google Analytics, PPC, and A/B Testing. Integration of Magento to SAP or similar ERP systems

Overall 11+ years of experience, with at-least 2+ years in Architecture. Hands-on and able to go deep into the code, if needed. Mandatory Architecture & Design Skills: Design Pattern, Scalablity, Security, Resiliency, Micro-Services. Mandatory Technology Skills: Kafka, Spring WebFlux, Spring Reactor, NoSQL (at least 1 NoSQL database experience is must), Java 8+, JWT, Spring Boot, Jmeter, New Relic, JVisualVM, JVM tuning. Desirable Technology Skills: Couchbase, AWS, Docker, JProfiler, ELK, HDFS, HBase, Kubernetes.  docker   Job Responsibilities Mentor the team and guide to resolve the issues   Keyskills - Must Have design   Scalability testing   Security   Microservices   Java8   Java Workflow Tooling (JWT)   Jmeter   New Relic   Spring WebFlux   Kafka   NoSQL DB   Spring Boot Keyskills - Nice to Have Couchbase   Amazon Web Service (AWS)   Docker   ELK   Kubernetes

ENGINEERING LEAD ABOUT US: Businesses and customers have always struggled with returns, damaged, unwanted inventory. Current returns management, refurbishment, and liquidation channels are disaggregated, inefficient, and fragmented – meaning both the customer and the business are losing money & trust in the quality of products. And that is where Overcart steps in. Overcart builds a transparent ecosystem, we restore trust to consumers buying refurbished goods by ensuring quality & great pricing, as well as providing warranties & build an integrated partnership with e-commerce companies, manufacturers, and distributors. We’re a strong (yet slightly crazy) team with offices in Delhi, Gurgaon, Mumbai & Bangalore – the main HO is in Gurgaon. We’re backed by one of the largest global funds based in the Valley, Omidyar Network; one of the big Indian power-houses, JSW, and legendary Angel investor K Ganesh. YOUR ROLE: Overcart is a technology-driven company: right from a traditional online store on the frontend to a (what will be) state-of-the-art returns management software for our clients to a comprehensive market-driven algorithm that determines the right price of unboxed products. You get to build the back-end infrastructure to support a highly integrated logistics and sales platform, evolve the front-end and UI to drive higher traffic and conversion, as well as build the technology group and culture within the group. Your role as full stack engineering lead involves hands-on coding as well as understanding the business to play a strategic role. Your measure of success is determined by how effectively you are able to scale the technology to meet business needs. You will be expected to project manage tasks, review and write code, determine and scale backend architecture etc. SKILLS AND ATTITUDE: Experience with Python + JAVA , MySQL, Any NoSQL DB. Competent HTML/CSS/Javascript coding abilities - including the latest standards (HTML5, CSS3) and Web 2.0 / AJAX Good to have experience in Bootstrap and JS MVX Frameworks[AngularJS, ReactJS, KnockoutJS] Experience in Technologies like Redis, Solr, RabbitMQ, Memcache Experience using version control systems (SVN, Git) Strong written and oral communication skills - ability to write technical documentation Knowledge or expertise in managing and optimizing AWS instances is strongly preferred. Ability to self-learn new languages, and solve problems. Not thinking that UX/UI is for numpties (and boring) Ability to think outside the box and bring fresh ideas to the table Willingness to work in a start-up environment: meaning longer hours, complex work, but way more fun and a significant boost to your career. Experience in mentoring developers and task planning. Minimum 5 years experience in technology roles (incl. some full stack dev) Sense of humour essential