4-6 yearsNoidaGraduation/Post GraduationResponsibilities
Good to Have
Responsibilities
- Build database systems of high availability and quality depending on each end user’s specialized role
- Design and implement database in accordance to end users information needs and views
- Define users and enable data distribution to the right user, in the appropriate format and in a timely manner.
- Cross-platform data migration.
- Database migration from cloud to on-prem.
- Handling client communications and understanding the requirements.
- Attitude to learn and work in flexible working hours
- Use high-speed transaction recovery techniques and backup data
- Minimize database downtime and manage parameters to provide fast query responses
- Provide proactive and reactive data management support and training to users
- Determine, enforce and document database policies, procedures and standards
- Perform tests and evaluations regularly to ensure data security, privacy and integrity
- Monitor database performance, implement changes and apply new patches and versions when required
Requirements
- Candidates should have proven working experience as a Database administrator in MSSQL, MongoDB, MariaDB, MySql or Postgres with hands-on DBA activities.
- Good in MongoDB sharding and replication concepts with hands on experience
- Should be well versed with the installation patching of databases.
- Hands-on experience on DB upgrades DB migration activities.
- Competency in troubleshooting DB performance issues.
- Good knowledge of SQL query optimization.
- Knowledge of monitoring tools like Grafana, Newrelic, CloudWatch.
- Experience with backups, restores and recovery models.
- Awareness of SOX compliance and Comfortable in implementing DB auditing.
- Good knowledge DB cluster management.
- Familiarity with database design, documentation and coding.
- Problem-solving skills and ability to think algorithmically
- Ability to organize and plan work independently
- Ability to work in a rapidly changing environment
- Ability to multi-task and context-switch effectively between different activities and teams
- BS degree in a computer discipline or relevant certification
Good to Have
- SQL optimization
- Knowledge of database management on Cloud
- Prior experience in handling client communications
- Prior experience of any ETL tools