• 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
About xyz
Similar jobs
Key Responsibilities:
Taking ownership of customer issues reported and seeing problems through to resolution
Understand, interpret, reproduce, and diagnose issues reported by the customers.
Researching, troubleshooting and identifying solutions to resolve product issues
Should be able to handle voice calls, emails and online web sessions with the customer as part of technical troubleshooting
Should exhibit patience and empathy while working with customer with an aim to drive positive customer experience
Following standard procedures for proper escalation of unresolved issues to the appropriate internal teams
Following standard procedures for submitting tickets to the engineering team for further investigation of unresolved issues
Contributing actively towards knowledge base articles
Adherence to strict SLA’s
Ready to work in early morning, general and afternoon shifts, including weekends, on rotation basis
Should demonstrate an aptitude and appetite for learning newer technologies while expanding on the core knowledge
The engineer should be available to work in the late evening shift (4pm - 1am) if required.
Primary skills:
3-8 years of relevant experience.
Strong technical knowledge on:
- Cloud Technologies – AWS, Azure etc.
- Databases – SQL, Oracle, MySQL etc.
- Operating Systems – Linux, Windows etc
- Networking – Basic networking concepts and troubleshooting
- Programming knowledge – Java, Python (Desirable, not a must has) o Prior experience with REST and SOAP calls.
Excellent communication skills – English written and verbal
HTTP technology and principles, including REST and SOAP principles (Required)
JSON & XML Data formats (required) Javascript Regular Expression (Good to have)
Good understanding of networking protocols and applications (TCP/IP, proxies, load balancing, firewalls, etc.) (Required)
Working knowledge of database technologies and SQL (Required)
In-depth familiarity of Linux (Required) (advanced user; sysadmin experience a bonus, but not required)
Strong analytical and logical reasoning for technical troubleshooting
Ability to collaborate with cross-functional teams – Dev, QA, Infrastructure teams etc.
Should be a team player who keeps team’s success before individual achievements
Knowledge on data integration (Informatica/ Mulesoft)
• 4 - 7 years of software development / consulting / support experience is required.
• Experience working with PHP, JavaScript, and jQuery
• Extremely fluent with HTML5/XHTML and CSS
• Experience designing and developing responsive design websites
• Comfortable working with debugging tools like Firebug, Chrome inspector, etc.
• Ability to understand CSS changes to have consistent style across platforms and browsers
• Ability to convert comprehensive layout and wireframes into working HTML pages
• Experience developing web solutions in Drupal and PHP implementations in a LAMP environment
• Ability to architect enterprise Drupal solutions including data, display, and information architecture
• Advanced site-building experience including deep familiarity with Drupal 7, 8, or 9 core and contributed
modules such as CTools, Views, and Panels
• Experience creating custom Drupal modules.
• Exp in one of the following languages (in no particular order): Java, Python, Scala would be plus.
• Exp in MySQL / Maria DB must.
• Experience with Drupal 8/9 migrations and migrating data (Nice to have)
• Experience building responsive websites using HTML/HTML5, CSS/CSS3, and JavaScript/jQuery
• Knowledge of PHP, PHP files and theme functions, and knowledge of the Drupal theme layer
• Through understanding of the Software Development Lifecycle (e.g. Requirements, Design, Development,
Testing) and exposure to Agile or iterative SDLCs
- Meeting with project managers to determine CRM needs.
- Developing customized solutions within the Salesforce platform.
- Designing, coding, and implementing Salesforce applications.
- Creating timelines and development goals.
- Testing the stability and functionality of the application.
- Troubleshooting and fixing bugs.
- Maintaining the security and integrity of the application software.
- Bachelor’s degree in computer science or any other field.
- Previous work experience with application and development.
- Experience developing customer-facing interfaces.
- Advanced knowledge of Salesforce CRM platforms.
- Proficient in salesforce admin/development, MYSQL, Apex, JavaScript, Native, and Visual Force, LWC.
- Should have 3+ years of experience in salesforce.
- Good communication skills.
- Ability to problem solve high-level software and application issues.
- Ability to project manage.
• No. of Openings:- 03 Openings
• Exp:- 2+ years
• Qualification:- B.E./ MCA/ M.Sc. (I.T.)/ BCA
Job Description:-
We are looking for a PHP Developer with Laravel Experience who must be able to independently work on projects and in a team.
Desired Candidate Profile:-
• Minimum 2 years of experience
• Good Knowledge of OOPs.
• Experienced with complex SQL queries and database schema design.
• Knowledge of consuming and creating Web Services.
• MySQL and Linux understanding is a must.
• Should be strong with Web-services REST API, and JSON.
• Should have worked on a variety of projects, with experience in payment gateways, maps, graphs, etc.
• Good coding standards is a must.
• Should have experience with collaboration tools
Regards,
Vimal Patel
Homes247.in is looking for amazing Angular Developers for our Bangalore branch.
Candidates should develop application codes in the AngularJS/Angular, Rest Web Services, and Java technologies for the Application Development Centre. Should be a team player and work towards developing the brand's image.
Come and Be a Part of India's Favourite Property Portal and scale up your career to the next level.
Skills and Qualifications Required
-
Graduate - BE/B.Tech(CSE,IT)
-
Proficiency in JavaScript and HTML5
-
6 Months - 1-year Experience with Angular 6+
-
Professional and Precise communication skills
-
Extensive knowledge of HTML, CSS, and JS methods for providing per formant visual effects and keeping the frame rate above 30 fps at all times
-
Validating user actions on the client-side and providing responsive feedback
-
Knowledge about PHP & MYSQL
-
Good knowledge of Responsive developments.
-
Experience with Restful API Services.
Responsibilities
-
Delivering a complete front end application
-
Ensuring high performance on mobile and desktop. Writing tested, idiomatic, and documented JavaScript, HTML, and CSS
-
Coordinating your workflow with the graphic designer
-
Strong skills in HTML5, CSS3, Javascript, Jquery, Bootstrap (Material Design Knowledge is a plus)
- Experience in Developing QlikView / Qlik Sense BI visualizations and dashboards. QlikSense and NPrintiing experience is a must.
- Strong knowledge of building Qlik Sense dashboards applying business rules and data validations.
- In-depth understanding of Qlik Sense Server Architecture, building QVDs and QVFs, applying business rules and data validations.
- Familiarity with charts and graphs, creating complex visualizations for dynamic aggregation Good Knowledge of Incremental data loading concepts and data modeling.
- Additionally, Qlik developers have to troubleshoot issues and provide the necessary solution
1. To strive for continuous improvement of both technical and business knowledge
2. Engage proactively with stakeholders and other cross-functional team members in the
development of IT solutions
3. Ensure new database code meets company standards for readability,reliability and performance
4. Passionate about technology and applying it to business solutions
5. Work closely with business
The Ideal Candidate:
1. 3-6 years development experience with SQL SERVER / MySQL platforms
2. Strong Knowledge of T-SQL
3. A good understanding of data normalization,data modelling and database schema design
principals
4. Knowlegde of database optimization techniques
5. Monitor database performance , implement changes and apply new patches and versions when
required
6. Automate regular process, track issues and document changes
7. Assist developers with complex query tuning and schema refinement
8. Proven working experience as a Database administrator
9. Experience with backups,restores and recovery models
10. Knowledge of High-Availability (HA) and Disaster Recovery(DR) options for SQL Server
11. Experience on AWS technologies (RDS,EC2,EBS,S3,RedShift,Glue)
12. Experience in implementation & support of NoSQL technologies
redis,memcached,mongodb,
13. Hands on programming experience in Python
14. Ability to multi-task and work independently
15. Proficient in Waterfall & Agile development methodology especially when applied to stae-full
data environments
Good to have :
1. Experience with Financial Data, Capital Markets and Mutual funds industry/data
1. Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts
1. Understanding of Distributed Systems and Parallel Processing architecture