About Company:
Our client is a trusted global innovator of IT and business services. They help clients transform through consulting, industry solutions, business process services, digital &; IT modernization and managed services. Our client enables them, as well as society, to move confidently into the digital future. We are committed to our clients long-term success and combine global reach with local client attention to serve them in over 50 countries around the globe.
JOB DESCRIPTION
Cassandra DBA
- Install/Design and help implement new Cassandra deployments.
- Manage Cluster / maintain / Evaluate existing clusters and provide recommendations on best practices.
- Provide performance and forecast reports on the health and load of critical business processes to help ensure the infrastructure has adequate capacity.
- Install/configure/upgrade/maintain/tune and administration of Apache Cassandra.
- In-depth knowledge of Cassandra read-write paths and internal architecture.
- Experience in creating Column Families: Bootstrapping, decommissioning, removing, and repairing nodes.
- Adding, removing, and replacing nodes, repairing, clean up, rebuild, troubleshooting, and monitoring the Cassandra cluster.
- Taking snapshots, recovering from snapshot, disaster recovery and incremental backup of Cassandra cluster.
- Performance tuning Apache Cassandra.
- Experience in creating key spaces, tables and secondary indexes in Cassandra and working with Cassandra Query Language.
- Experience in setting up the required replication factor for key space. Participate in DBA team on-call pager rotation and on-call support duties.
- Daily operation support on DB tasks on incidents, requests, and change activities. Set up automation like running repairs/compaction.
MYSQL DBA
- Provision MySQL instances, both in clustered and non-clustered configurations
- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
- Strong proficiency in MySQL database administration.
- Decent experience with recent versions of MySQL
- Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM
- Experience with replication configuration in MySQL
- Knowledge of de-facto standards and best practices in MySQL
- Proficient in writing and optimizing SQL statements
- Knowledge of MySQL features, such as its event scheduler
- Ability to plan resource requirements from high level specifications
- Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. if required
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
Job Title: SYSTEM ADMIN
Location: NOIDA (WORK FROM HOME)
Experience: 6 to 8 Years
Employment Type: Fulltime
Work Mode: Work from Home
Notice Period: Immediate to 20 Days Only
CTC: 9,00,000 PA
