Ref No.: 21-00415
Location: Bangalore -, Karnataka
Start Date: 19/11/2021
 Brief JD
Database Implementation Database Management Other Requirements
  • Upgrades, installation, and configuration of the database
  • Data ingestion and table/schema verification
  • Planned data migrations
  • Pre-deployment testing
  • Deployment to production services
  • Onsite Installation and Technical DB support
  • Root-cause analysis, problem resolution, 24/7 monitoring
  • Proactive checks
  • Configuration management
  • Performance and disaster recovery
  • Database status monitoring
  • Collect performance and resource metrics
  • Verify Backups and test restore
  • Notification of system alerts due to performance, Availability and Resources
  • Scan system log files
  • Automated performance decisions of collected metrics
  • Daily Operational DBA support
  • Available for On-call support
  • DBA monitoring and uptime report
  • Daily and Weekly report generation.
  • Minimum 7 years exp.
  • Good interpersonal skills
  • Exposure to Service Delivery and ITIL
  • Any Graduate with Academic records
  • Keen Learner
Database Consulting
 
  • Thorough evaluation of the existing systems
  • Capacity, upgrade, and migration planning
  • Security, performance, and capacity audits
 
 
Detailed JD:
  • Minimum 5 years of MySQL database administration experience.
  • Ability to effectively communicate, internally and with our Application Team.
  • Excellent knowledge of MySQL Database Administration
  • Hands-on experience with managing various vanilla HA implementations like binlog replication, GTID replication
  • Good understanding of Innodb & MyISAM architectures
  • General understanding of the design and development of applications that access MySQL.
  • Deep understanding of security & authentication models with MySQL
  • Working knowledge of MySQL on Windows and Linux
  • Strong understanding of RDBMS and SQL database concepts.
  • Strong desire to continue learning and expand the knowledge on to other RDBMS
and NoSQL architectures and administrative procedures.
  • Ability to effectively communicate with internal support personnel and Application Team.
  • Strong knowledge on enterprise MySQL implementations like galera, percona etc
  • Installs, configures, upgrades, tunes, and maintains MySQL production, development, and test databases.
  • Participates in application outage incidents to ensure database integrity and functionality.
  • Defines and maintains database problem reporting, tracking, and resolution procedures.
  • Provides proactive input into design issues/constraints, performance tuning, and impact analysis of changes.
  • Support, enforce and improve upon database development, deployment, and maintenance best practices
  • Advise on hardware and performance questions, and recommend best practices
  • Ensure that we have appropriate maintenance in place including backups, index maintenance, consistency checks and statistics maintenance
  • Continue to learn new skills involved in being a MySQL DBA as the technology evolves
  • Keep up to date with new releases of MySQL and advise that pertain to us.
  • Participate in 24x7 shift coverage & Keep time entry up to date within 24 hours
  • Strictly adhere to the internal policies, processes, and procedures
  • Implement/Support pertinent high availability solutions
  •  
 
 
Trouble shoot Disk related I/o error or data and log file error if any
• Trouble shoot SQL job monitoring issue if any
• Load balancing during EOD and SOD job
• Housekeeping jobs configuration
• Differential backup configuration.
• Log backups configuration
• Shrinking of Data and log files
• Memory configuration
• CPU allocation or MAXDOP configuration
• Instance level Security Setting
 • DR configuration
• Log shipping configuration in different domain
• Mirroring configuration in different domain
• Configuration and setup DB cluster
• Configuring / Re-configuring Always On
• Trouble shoot all jobs and maintenance plan issue
• Trouble shoot login/instance connectivity issues
• Log shipping configuration in different domain for assets in scope.
• Trouble shoot Mirroring Issues
• Reconfiguration and setup DB cluster in case of failure due to incident
• Trouble shoot DB cluster Issue
• Trouble shoot Linked Server Issue
• System database movement
 • DR drill activity
 • System Performance analysis
• Database performance analysis
• Planning and updating Backup and restoration policies for exiting assets.
• Capacity planning related to database.
• RAC related issue resolution.
• DB – Crash / Rebuild due to Incident
• DB - Instance Hung/Terminated unexpectedly
• DR reconfiguration for existing setup.
• Database security patch application.
 • Database impact analysis in case of major activities.
• DB - Flashback configuration and restoration
• Performance - ORA errors - resolve or escalate to vendor appropriately.
• Providing root cause analysis.
• Starting and stopping database, ASM, RAC services.
Perform DR, backup restoration drill.
• Preparation of RCA for Major Incidents
• Repeat Incident / Alert Analysis
• Performance tuning suggest by OEM
• Updation and maintenance of Availability, Capacity management
• Risk Analysis and providing the mitigation planning
• Continual Service Improvement Planning and executions
• Planning and execution of DR Drills based on availability of DR setup and recovery procedures • Preparing, maintaining and updation of SOP and KBase
• Maintaining and updation of Infra AS IS / Infra Documents
Version upgrade
• Trouble shoot log shipping Issues
Installation for new setup
Upgrade
backup