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
|