3 Database Troubleshooting Jobs

Strong experience min 8 years in Oracle, Maria DB, Mongo DB, PostgreSQL and any other additional Database. Manage, maintain, and optimize Oracle databases (including versions 11g onwards up to 19c). Migrating data to SQL AND NOSQL DATABASES. Good to have knowledge in Administration, configuration, deployment, management, architecture, security of NOSQL Databases like REDIS, KEYDB, COUCH DATABASE. Install, configure, and upgrade Oracle database software, patches, and tools. Knowledge of regular database backups and implement robust disaster recovery solutions. Monitor database performance and take necessary actions to improve performance and scalability. Provide expert support in database troubleshooting, performance tuning, and query optimization. Implement and maintain database security policies, user access management, and auditing. Ensure compliance with internal security policies and external regulations. Tune database queries, optimize SQL performance, and improve indexing strategies. Monitor database resource usage and implement measures for optimal performance. Implement, Manage, maintain, and ensure high availability and manage Oracle Real Application Clusters (RAC). Implement, Manage, maintain, and ensure high availability and manage Oracle Data Guard, Oracle Golden Gate. Work closely with development teams to optimize database queries, applications, and configurations. Provide support to application teams for database-related issues and troubleshooting. Create and maintain documentation related to database architecture, standards, and procedures. Work on database consolidation and cloud database migration as required. Develop and maintain shell scripts and PL/SQL procedures for automation of database tasks. Lead database-related projects and ensure timely delivery of deliverables. Provide regular reports on database performance, health, and capacity. Required Qualifications: Education: Bachelors or Masters degree in Computer Science, Information Technology, or related field. Experience: Minimum of 8 years of hands-on experience as an DBA. Understanding of cloud databases (AWS RDS, Oracle Cloud, etc.) is a plus. Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) certification. Mandatory Certified (Any one) 1) MONGODB/ REDIS/ CouchDB Certification from MONGODB University/REDIS University/ CouchBase 2) MARIADB or MYSQL Certification from OEM Soft Skills: Excellent problem-solving and troubleshooting skills. Strong communication skills to interact with various teams and stakeholders. Ability to work under pressure and manage multiple tasks in a fast-paced environment. Strong attention to detail and organizational skills. Knowledge of ITIL practices and database management best practices.

Overview This career opportunity within our career framework is at Consultant level and is for the Domain & Consulting business unit. The role as a Manhattan Active Warehouse Management Analyst will lead growth of the consulting business across strategic account(s) by leveraging both; existing & emerging capabilities, in addition to creating new strategic growth areas to deliver significant profitable growth for the accounts and consulting globally. As a Manhattan Active WMS Techno Functional Consultant, this position focuses on leading the functional and technical implementation of the Manhattan Active WMS. Responsibilities include leading the functional design, system configuration and working with customers to test and implement interfaces between Manhattan Active WMS and external systems. The WMS Techno Functional Consultant is also responsible for developing project documentation and supporting the testing of the application. Responsibilities Accomplishes business objectives by identifying and solving customer information and processing problems. Identifies project requirements by interviewing customers and stakeholders; analyzing operational processes and implementing technical solutions (Warehouse Management Systems, MHE/Automation, RF, Printing, and Shipping Solutions); determining project objectives; documenting results; preparing findings and follow-ups. Develops problem solutions by describing requirements in a work-flowchart and diagram; studying system capabilities; analyzing alternative solutions; preparing system specifications. Works directly with the customer project team during configuration, testing, training, and implementation. Works with customers to test and implement interfaces between Manhattan Associate products or external systems. Prepares reports by collecting, analyzing, and summarizing information. Maintains and shares professional and technical knowledge with clients and peers. Collaborate and produce deliverables and client collateral to include: Functional flow documents Process descriptions and diagrams High-level system context diagrams Configuration plans Conversion plans Training plans Cut-over plans Training Job Guides, QRGs, SOPs Skills and Qualifications Bachelors degree in Logistics/Supply Chain, Business Administration, Information Technology or a related field strongly preferred Strong experience with Manhattan Active software packages 3 years of experience deploying software 1 year of experience with database troubleshooting (SQL) Provides senior level design for client specific enhancements Proactively troubleshoots and resolves issues that arise during the implementation Minimum 4 years of experience in Business Process Definition, Support, and Design Functional Flows Process Descriptions Future State Models Root Cause Analysis Minimum 4 years of WMS utilization experience and integration with other process areas Tier 1 or Tier 2 WMS experience WMS application to and support of warehouse operations Printing solutions:documents and labels Past experience as a WMS SME with knowledge of Inbound Processing, Outbound Processing, Physical Inventory, RF Transactions, cycle counting, general warehousing, and MHE/Automation integration Set-up Configuration Day-to-day Support Strong experience working in warehouse and fulfillment operations with a keen sense of: Strong leadership skills with past experience in leading workstreams and teams in problem resolution, new development of processes, and implementation of WMS applications, modifications, or extensions. Strong experience in SCI and other BI/BA tools, reports, and dashboards Understanding of data and system integration tools, methods, and platforms Excellent verbal and written communication and presentation skills Tier 1 WMS experience:Manhattan Active WM Reporting packages/ Tools

ob Description:TLM Consultant, Developer We are looking for Consultant with strong hands-on experience in a building and supporting reconciliations on TLM Premium 2.5 or higher version platform. The candidate, expected to have good knowledge on various types of the reconciliation controls (Nostros, Depos, Inter Accounts, Intersystem, FOBO, FOCL) for the various Capital Markets asset classes, which will be required to understand business and build recs for the same. Candidate must have- Reconciliation build experience using TLM Premium 2.5 or higher. Strong Oracle database development skill. Hands on experience on the Unix Shell scripting commands Production Support experience is good to have. Exposure to any reporting tool (BIRT, Crystal / SAP BO etc.) UNIX Solaris, Linux Shell scripting (bash/Vi Editors / PowerShell) What you will do: The candidate, expected to perform comprehensive requirement analysis, development, testing (UNIT / SIT / UAT) and implementation of the reconciliations on the Recs platform TLM Premium 2.5 or Higher into production environment. Expertise in Smart stream TLM tool with hands on experience On TLM premium 2.5 or higher version. Should have detailed hands-on experience With TLM TOOLS as SMART STUDIO/ Smart Schema/ Recon Admin/ web Connect/ Control &CT tools. Expertise in Oracle (Specially TLM tables knowledge)/ good hands on write sql stored procedure. TLM database table linkages, for analyzing production issue from the backend. Expertise in the exception management and breaks allocation automation on the TLM platform Expertise in Unix shell scripting should be well versed with the most frequently used UNIX commands and the Vi Editor. Well versed in TLM services/ usage & logs validation for debugging. Develop stored procedures, triggers and functions for recs and end-user reports using Oracle database. Production Support will also be one of the responsibilities of the team, which goes on a rotational basis. Must have knowledge of Oracle Database Troubleshooting, using profiler, database backup procedures. Should have environment knowledge like troubleshooting windows issues, understanding Unix logs and Linux/Unix Solaris services knowledge, patching, server maintenance, application installation, building environments, security patching, network maintenance. Should have exposure to Agile and DevOps culture. Very good communication skills to convey clear details to end users/ clients for any challenges faced during build or testing. Knowledge of automated deployment tools will be an added advantage.