Job Description

Requirements Elicitation, Understanding, Analysis, & Management Understand the project's Vision and requirements, and contribute to the creation of the supplemental requirements, building the low-level technical specifications for a particular platform and/or service solution. Project Planning, Tracking, & Reporting Estimate the tasks and resources required to design, create (build), and test the code for assigned module(s). Provide inputs in creating the detailed schedule for the project. Support the team in project planning activities, in evaluating risks, and shuffle priorities based on unresolved issues. During development and testing, ensure that assigned parts of the project/modules are on track with respect to schedules and quality. Note scope changes within the assigned modules and work with the team to shuffle priorities accordingly. Communicate regularly with the team about development changes, scheduling, and status. Participate in project review meetings. Tracking and reporting progress for assigned modules Design: Create a detailed (LLD) design for the assigned piece(s) with possible alternate solutions. Ensure that LLD design meets business requirements. Submit the LLD design for review. Fix the detailed (LLD) design for the assigned piece(s) for the comments received from team. Development & Support Build the code of high-priority and complex systems according to the functional specifications, detailed design, maintainability, and coding and efficiency standards. Use code management processes and tools to avoid versioning problems. Ensure that the code does not affect the functioning of any external or internal systems. Perform peer reviews of code to ensure it meets coding and efficiency standards. Act as the primary reviewer to review the application code created by software engineers to ensure compliance to defined standards. Recommend changes to the code as required. Testing & Debugging Attend the Test Design walkthroughs to help verify that the plans and conditions will test all functions and features effectively. Perform impact analysis for issues assigned to self and software engineers. Actively assist with project- and code-level problem solving, such as suggesting paths to explore when testing engineers or software engineers encounter a debugging problem, and escalate urgent issues. Documentation Review technical documentation for the code for accuracy, completeness, and usability. Document and maintain the reviews conducted and the unit test results. Process Management Adhere to the project and support processes. Adhere to best practices and comply with approved policies, procedures, and methodologies, such as the SDLC cycle for different project sizes. Shows responsibility for corporate funds, materials and resources. Ensure adherence to SDLC and audits requirements. Adhere to best practices and comply with approved policies, procedures, and methodologies. Job Description Must have skills: • 7+ years of MySQL DBA experience • MySQL replication experience • SQL coding and tuning experience • Shell scripting and automation experience • MySQL Enterprise Manager experience • AWS/Cloud Services experience: EC2, RDS, and Aurora • Cloud deployments experience: Jenkins, Bitbucket, Terraform • Hands-on, technically adept DBA, capable of performing required DB tasks experience • Strong troubleshooting/performance tuning skills • Ability to assess and improve SQL performance • Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM • Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc. • Profile server resource usage, optimize and tweak as necessary • Expert level MySQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments • Strong commitment to following SDLC/Change-Management principles • Self-starter and be able to perform work with minimal supervisory direction • Knowledge of data quality, data management, and data testing strategies and practices • Strong communication skills, both oral and written • Strong experience working with ticketing tools such as ServiceNow, Zenoss or any other monitoring tool, Cloud monitoring tools (CloudWatch, CloudTrail), AppDynamics (or similar APM tool) • Strong problem-solving and troubleshooting skills • Keen analytical and structured approach to problem solving • Ability to accommodate flexible work schedules Desired skills: • Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers) • Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniques • Experience in DB2 UDB, Oracle, Postgres, Microsoft SQL Server, MongoDB is plus • Experience with configuration management tools: SCCM; Puppet; or Ansible. • Development or enhancement of training and upskilling programs • Bachelor’s Degree or similar required You will • Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changes • Perform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root cause • Process all support requests within SLA by following procedural requirements • Escalate to vendors, where necessary, to ensure timely resolution • Thoroughly document steps taken to resolve incidents and fulfil catalog requests within ServiceNow tickets • Develop, document, and update standard operating procedures and knowledgebase articles • Identify, address, and resolve repeating alert trends to improve stability and performance • Suggest defects and product/infrastructure enhancements to improve stability and automation • Participation in periodic skills enhancement sessions and training courses • Be a project lead, as well as a project participant for various activities: cloud migration, lifecycle management, application modernization, capacity planning, financial optimization, performance, and stability optimization, build and design state configuration automation, etc. plication, network, database, server, or storage tiers). Ability to implement automation to reduce manual administrative tasks through use of jobs, shell scripts, PL/SQL, cron, or other techniques. Expert level of SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments. Experience with very complex database environments. Experience in SQL and/or PL/SQL. Experience in working controlled environment, change control, and validated systems. Experience with Foglight is a plus Experience on Oracle/MySQL/Postgres/MongoDB/DB2 UDB is a plus Customer service orientation. Location: This position can be based in any of the following locations: Gurgaon For internal use only: R000106310