• Job Description:
MySQL Database Administrator (DBA) who will be responsible for ensuring the
Performance, Database Tuning, Database Cleanup, Database Migration, Database Availability, and Security of Clusters of MySQL
Instances. The candidate will also be responsible for Orchestrating Upgrades,
Backups, and Provisioning of Database Instances. The candidate will also work in
tandem with the other teams, documentation, and specifications as required.
.
• Key Responsibilities:
✓ Provision MySQL instances, both in Clustered and Non-Clustered Configurations
✓ Ensuring the Performance, Database Tuning, Database Availability, and Security
of Clusters of MySQL Instances
✓ Development of Database Schema
✓ Development of ERD
✓ Find the Root Cause of Database related issues & Database Clean-up
✓ Migrating Data from Customer Database to Serosoft Product Database
✓ Prepare Documentation and Specifications
✓ Handle common database procedures, such as upgrade, backup, recovery,
migration, etc.
✓ Profile server resource usage, optimize and tweak as necessary
✓ Collaborate with other team members and stakeholders
• Skills and Qualifications:
✓ Strong proficiency in MySQL database management
✓ 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
✓ Proficient in Database Clean-up and Migrations
✓ Knowledge of De-Facto Standards and Best Practices in MySQL
✓ Proficient in Writing and Optimizing SQL statements
✓ Proficient in Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc.
✓ Should be able to decide when to create Views (Standard Views, Indexed views,
and Partitioned views)
✓ 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.
✓ Knowledge of limitations in MySQL and their workarounds in contrast to other
popular relational databases
✓ Proficient understanding of code versioning tools such as SVN / Git
✓ DBA Certification would be added advantage
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs
Python
ChatGPTThe AI Trainer will be responsible for delivering engaging and practical training sessions on Artificial Intelligence to students of the School of Innovation. The role includes designing content, conducting hands-on sessions, mentoring students on real-world AI projects, and staying updated with AI trends and tools.
- Vendor Outreach: Initiate outbound calls to vendors, introducing the e-commerce platform, and establishing or maintaining relationships.
- Order Confirmation: Communicate with vendors to confirm orders, ensuring accurate product details, quantities, and delivery timelines.
- Issue Resolution: Address and resolve any issues related to orders, payments, or product discrepancies by liaising between vendors and internal teams.
- Feedback Collection: Gather feedback from vendors regarding their experiences with the e-commerce platform, identifying areas for improvement.
- Contractual Agreements: Communicate and ensure vendors adhere to contractual agreements, including pricing, terms, and conditions.
- Inventory Management: Coordinate with vendors to manage and update inventory information, ensuring product availability and accuracy on the platform.
- New Vendor Onboarding: Assist in the onboarding process for new vendors, providing necessary information and documentation requirements.
- Payment Follow-Up: Follow up on payment-related issues, ensuring timely and accurate processing of vendor payments.
- Performance Tracking: Monitor vendor performance metrics, identifying trends and areas for improvement, and providing feedback to vendors.
- Market Intelligence: Gather information on industry trends, competitor activities, and market conditions to provide insights for vendor management strategy.
Requirements:
- Communication Skills: Excellent verbal communication skills, with the ability to convey information clearly and professionally.
- Relationship Building: Strong interpersonal skills to build and maintain positive relationships with vendors.
- Problem-Solving: Ability to identify and solve problems efficiently, especially in the context of order discrepancies or vendor-related issues.
- Detail-Oriented: Attention to detail is crucial, particularly when confirming orders, managing inventory, and reviewing contractual agreements.
- Negotiation Skills: Basic negotiation skills to ensure mutually beneficial terms with vendors.
- Time Management: Efficiently manage time to handle multiple vendor interactions and tasks simultaneously.
- Tech-Savvy: Comfortable using e-commerce platforms, CRM systems, and other tools relevant to vendor management.
JavascriptSkill: Dellboomi Integration Developer
Work Mode: 6 Months
Location: Gurugram / Hyderabad / Pune / Delhi / Noida
Technical Skills: Dellboomi Integration, Groovy Script, Java Script, ATOM.
Job Description
- Bachelor’s Degree in computer science or relevant degree
- 3-5 years of experience in integration development.
- Experience with modern Groovy Script, JavaScript libraries and frameworks such as XLST.
- Strong communication skills with the ability to effectively interface with clients
- Good business analysis/design skills.
- Excellent time management and organizational skills.
- API / REST / SOAP experience
- Able to work with project management systems and time allocation.
- Good knowledge of Atom Management and Deployment
Vue.js
AngularJS (1.x)
Angular (2+)
React.jsJavascriptWe are looking for an experienced Full Stack PHP Developer for immediate hiring.Candidate must have at least 1 years of experience in working on PHP based projects with MySQL backend. The ideal candidate should have the drive and passion to thrive in a startup environment. Should be involved in all aspects of the development cycle of a project. Skills Required:
- Strong experience in PHP with deep understanding of Codeigniter framework
- Working experience with SQL, table design, and entity relationships.
- Familiarity with relational databases mySQL or MS SQL Server
- Deep knowledge of how the web works (Servers, Sockets, HTTP, Rest API).
- Up-to-date knowledge of modern HTML5, CSS3/4, Bootstrap.
- Developing APIs and RESTful services
- Version control systems like Git and GitHub ·
- Proficient in data structures and algorithms.
- Helping with the design and development of software
- Testing and debugging software to keep it optimized
- Writing clean code for the front and back end of the software
- Creating servers and databases for the back end of the software
- Ensuring cross-platform compatibility and optimization
- Testing and maintaining the responsive design of applications
- Working with graphic designers to design new features
Education: Bachelor's Degree in Computer Science or any equivalent experience Experience: Minimum 1 years of experience.
Job Type: Full-time
Google AnalyticsWe're looking for hard-working digital marketers to help us grow faster. As a Digital Marketer at CloudQA, you will:
- Implement marketing strategies to scale lead generation
- Update and optimize the website regularly for conversion
- Work in collaboration with freelance content writers to blog high-quality content
- Help the team with sales collaterals
- Engage potential customers via our social media accounts
- A strong communicator
- Data-driven decision maker
- Meticulous when it comes to details
- Customer obsessed
- Team player
Adobe IllustratorVIDEO EDITOR
Tesseract Esports is looking for an experienced Video Editor to provide to provide digital content such as frag movies, hype videos, highlights and various ancillary content for Esports. This role is responsible for pre and post-production of all video deliverables.
You will interact with creative and broadcast teams and other client staff to produce the deliverables for internal and external use.
About Tesseract Esports
Tesseract Esports was founded in 2015 with an intent to elevate and transform the nascent gaming scene in South and Southeast Asia into a high profile and professional esport. We played a pioneering role by being the first to launch and introduce mobile esports in the region. We were also among the first to produce the biggest and most successful esports events and gaming activations in India at an unprecedented scale, paving the way for the growth of esports in the country.
We have since gone to partner with game publishers, developers, brands and media platforms to produce large scale esports events and engagements and become one of the leading esports production houses in the Asia-Pacific. We have worked with Qualcomm, MPL, Tencent Games, Razer, Garena, Acer and several other partners on many successful live and online esports activations. We are a growing team of highly skilled and passionate individuals focused on delivering the best competitive experiences. We are headquartered at our state of the art production studio in Hyderabad, India which also happens to be the largest esports facility in South Asia.
You are good at (Technical skills)
- Adobe Illustrator, Photoshop, After Effects, Premiere Pro, Da-Vinci Resolve etc.
- Ability to storyboard and narration.
- Strong sense and understanding of Colour and Composition in film making.
- Strong technical understanding on digital film making.
- Ability to conceptualise and communicate design ideas clearly.
- Deliver ideas using Quick mockups and prototypes.
You will be responsible for (not limited to)
- Create evocative videos for various digital mediums.
- Participate in conceptualising sessions and put forward holistic ideas.
- Coordinate with other designers and deliver consistent visuals.
- Manage and adhere to timelines.
- Collaborate with other team members to ensure all requirements are met with designs.
- Handle multiple projects at a time.
- Highly collaborative and can work well in a fast-paced team environment.
Your experience
3+ years in the related field.
Your academic qualifications
We prefer an inspired mind over an academic qualification.
What we will be excited to see in you (Technical & Non-technical skills)
- 3D software’s such as cinema 4d, blender, 3DS Max.
- Video editing software like Premier Pro, Da-Vinci resolve.
- Ability to lead and build a design team.
- Self-learning.
Employment Type
Full-time
.NET
C#AngularJS (1.x)
Amazon Web Services (AWS)- Maintaining the central databases, ensuring high performance, and responding to requests from the front-end.
- Creating a secure API for our mobile applications.
- Optimizing the application for maximum speed and scalability.
- Implementing security and data protection.
- Designing and implementing data storage solutions.
- Compiling and analyzing data, processes, and codes to troubleshoot problems and identify areas for improvement.
- Recording data and reporting it to respective parties
- Participating in all phases of the development life cycle
- Developing additional server level functionality and tools using a .NET language (C# preferred).
- Troubleshooting and fixing bugs/ flaws to ensure servers are running optimally.
- Managing Integration of user-facing elements developed by front-end developers with server side logic
Desired Candidate Profile
What you need to have:- 3 years + Experience and exposure to working on problems of scale.
- .Net Fullstack Developer with Angular(Must) and MS SQL
- Must have mobile based app development experience.
- Familiarity with the challenges involved in scaling applications from a single machine to a large deployment.
- Experience with cloud environments like Amazon's AWS is a plus.
- Experience with in working with gaming servers like SmartFox multiplayer server is a plus.
- Added advantage to those who have worked on C#, Web API , WCF, MVC, MS SQL and Angular JS in business env.
- Collaborating with the front-end developers and other team members to establish objectives and design more functional, cohesive codes to enhance the user experience.
Python
Data Analytics● Ability to do exploratory analysis: Fetch data from systems and analyze trends.
● Developing customer segmentation models to improve the efficiency of marketing and product
campaigns.
● Establishing mechanisms for cross functional teams to consume customer insights to improve
engagement along the customer life cycle.
● Gather requirements for dashboards from business, marketing and operations stakeholders.
● Preparing internal reports for executive leadership and supporting their decision making.
● Analyse data, derive insights and embed it into Business actions.
● Work with cross functional teams.
Skills Required
• Data Analytics Visionary.
• Strong in SQL & Excel and good to have experience in Tableau.
• Experience in the field of Data Analysis, Data Visualization.
• Strong in analysing the Data and creating dashboards.
• Strong in communication, presentation and business intelligence.
• Multi-Dimensional, "Growth Hacker" Skill Set with strong sense of ownership for work.
• Aggressive “Take no prisoners” approach.
Android Development
JavaAndroid Testing- Strong experience in Android UI development,
- Expertise in API implementation
- Experience in using GMAPS, FIREBASE, SQLlite
- Familiar with Android & its related technologies like Android SDK, Java.
- Experience with GIT, XML, JSON & Web Services.
JavaJavascript
NodeJS (Node.js)
MongoDBReact.js
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon