Data Base Administrator
at Our Client company is into Telecommunications. (SY1)
- Design, develop and manage data on various open-source SQL databases
- End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
- Database cluster connectivity and security
- Conduct database training
- Software installation and configuration
- Database patching and upgrading
- Using monitoring and management tools
- Troubleshoot various issues with other dba’s/developers
- Point of Contact for Vendor escalation
- Point of Contact for professional service to Customers
- Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
- Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
- Ensures project documentation is complete, current, and stored appropriately
- Manages day-to-day project and scope changes
- Communicate and coordinate database changes, backups, and downtime to users
- Identifies potential security issues and recommend strategies to ensure database security
- Research and evaluate new technologies
- Proactively monitor systems for optimum performance and capacity constraints
- Establish standards and best practices for SQL
- Interact with and coach developers in SQL scripting
- Perform database backup and recovery
- Provides 24x7 support for enterprise database systems
- Must provide mentoring and training to other staff members
- Write procedural documentation including requirements for databases
- Develop and coordinate knowledge transfer
- Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
- Interacts with business units to gather, define, and organize the delivery of business solutions Data
- Modeling, design & implementation based on established standards
- Automate manual tasks
- Candidate with a college degree and relevant work experience
- 7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
- Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
- Experience in database performance tuning and strong SQL tuning skills
- Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
- Must be familiar with RDBMS concepts, practices, and procedures
- Must have knowledge of network connectivity
- Extensive experience with Export/Import, Backup and Recovery
- Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
- Extensive experience with MySQL (MariaDB, Percona) Galera cluster
- Experience with MaxScale
- Proficient in SQL Language
- Knowledge of ServiceNow, or similar Ticket Management Software
- Knowledge of SAN infrastructure including HP and NetApp
- Ability to work on projects at a time
- Knowledge of middle-tier application servers
- Strong troubleshooting and problem resolution skills
- Good knowledge of Data Modeling
- Knowledge of XML and JDBC
- Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
- Certifications on MySQL, PostgreSQL, and Aurora
Similar jobs
1. Strong knowledge of PHP web frameworks such as Laravel
2. Knowledge of object oriented PHP programming & Restful API
3. Strong knowledge of Akamai CDN, Redis, AWS services
4. Understanding of LAMP and MVC design patterns
5. Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3,
JS framework
6. Knowledge of Payment Gateway
7. Familiarity with MySQL/ PgSQL/ Mongo databases
8. Proficient understanding of code versioning tools, such as Git
9. Understanding accessibility and security compliance
10. Understanding fundamental design principles behind a scalable application.
11. User authentication and authorization between multiple systems, servers, and
environments
Roles and Responsibilities
1. Hands on experience in PHP frameworks Laravel
2. Experience in development of PHP based web applications, in Laravel PHP, Web Services (Json), MySQL. - Thorough understanding of OOPs concepts (Data Abstraction, Encapsulation, Inheritance, Polymorphism)
3. In-depth understanding of front-end technologies, such as HTML5, CSS3 and JavaScript.
4. Ability to understand project specification/requirements, coding, implementation and debugging.
5. Zeal to take up challenges provides innovative solutions, think out of the box and open to learning.
6. Able to handle multiple projects simultaneously.
7. Proficient understanding of code versioning tools, such as Git / SVN / BIT BUCKET .
Desired Candidate Profile
1. Minimum 2 years of experience in PHP Laravel Framework
2. Experience with MySQL and REST API.
3. Proficient knowledge in Javascript, JQuery, Angular 2.0
Role: Web Developer
Industry Type: IT-Software, Software Services
Functional Area: IT Software - Application Programming, Maintenance
Employment Type: Full Time, Permanent
Role Category: Programming & Design
Education:
UG :Any Graduate in Any Specialization
We are looking for a Back-End Web Developer responsible for managing the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, definition, and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front end. You will also be responsible for integrating the front-end elements built by your co-workers into the application. A basic understanding of front-end technologies is therefore necessary as well.
Responsibilities
- Actively participate in the overall application lifecycle.
- Focus on coding and debugging.
- Collaborate with front-end developers.
- Define and communicate technical and design requirements.
- Build a high-quality reusable code that can be used in the future.
- Create sustainable and functional web applications with clean codes.
- Learn about new technologies and stay up to date with current best practices.
- Conduct UI tests and optimize performance.
- Train, help, and support to other team members
Requirements
- Hands-on backend web development experience.
- Proficient knowledge of a backend programming language and an in-depth understanding of web development.
- Knowledgeable of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3.
- Proven experience creating user authentication and authorization between multiple systems, servers, and environments.
- Capability to integrate multiple data sources and databases into one system.
- Proven experience managing the hosting environment, including database administration and scaling an application to support load changes.
- Ability to set up and administer backups, data migration, transformation, and scripting.
Skills
- Coding (HTML/CSS3)
- Debugging
- Programming (JavaScript, PHP, Magento, OOPs,)
- PHP Framework
- Analytical Skills
- Web Development
- API
Responsibilities:
- Design, develop, and maintain efficient and reliable server-side applications using PHP, JavaScript, Node.js, and Laravel framework.
- Collaborate with frontend developers and other stakeholders to understand project requirements and translate them into technical specifications.
- Develop and integrate APIs, web services, and third-party services to enhance application functionality and connectivity.
- Ensure seamless integration of frontend and backend components, optimizing performance and user experience.
- Identify and troubleshoot issues, debugging and resolving defects to maintain application stability.
- Conduct thorough testing of backend components, performing unit tests and integration tests to ensure code quality and reliability.
- Collaborate with the DevOps team to deploy and maintain applications on production servers, monitoring performance and addressing scalability concerns.
- Stay up-to-date with emerging technologies, trends, and best practices in backend development, and recommend improvements to enhance overall system architecture.
- Collaborate with cross-functional teams, including frontend developers, UX/UI designers, and product managers, to ensure successful project execution.
- Document technical specifications, project details, and code changes to facilitate knowledge sharing and future maintenance.
Qualifications:
- Bachelor's or Master's degree in Computer Science, Software Engineering, or a related field.
- Proven working experience as a Backend Engineer or similar role, with a strong focus on PHP, JavaScript, Node.js, and Laravel with 2-4 years of experience.
- In-depth understanding of backend development principles, including server-side logic, database management, and API integration.
- Proficiency in PHP, JavaScript, Node.js, and experience with Laravel framework.
- Experience with version control systems (e.g., Git) and familiarity with agile development methodologies.
- Ability to write clean, maintainable, and efficient code, adhering to coding standards and best practices.
- Excellent problem-solving skills, with a keen eye for detail and the ability to debug and resolve complex issues.
- Strong communication and collaboration skills, with the ability to effectively articulate technical concepts to both technical and non-technical stakeholders.
Preferred Qualifications:
- Experience with other backend frameworks, such as Express.js or Symfony.
- Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and containerization technologies (e.g., Docker, Kubernetes).
- Understanding of microservices architecture and RESTful API design principles.
- Experience with testing frameworks and methodologies, such as PHPUnit or Jest.
Join our team as a Backend Engineer and contribute to the development of innovative web applications, leveraging your expertise in PHP, JavaScript, Node.js, and Laravel. Together, we will build robust and scalable solutions that drive our business forward.
- Support existing code of PHP webserver
- Proficient in PHP, JavaScript, jQuery, HTML, and MySQL
- Hands-on any PHP-based framework/CMS like Laravel, CakePHP, Zend, CodeIgnitor, Yii.
- Must write efficient code with documentation.
- Any Database: MySQL, MongoDB, NoSQL DBs, postgresql.
- Has experience debugging code.
- Analysis of current DB structure and change table structures as and when required
- Implementation of visual representation of DB data in the form of charts and graphs
- The eventual implementation of a new UI theme with customizations such as drop-down menu data, as well as linking the UI theme front-end with the back-end MySQL
- Implementation of new PHP web services for functions such as analytics, and new modules to existing services
- Ensure cross-platform compatibility of information retrieved from web services on
- Android and iOS platforms, in terms of Push Notifications, platform-specific issues, etc.
- Implementation of SSL security to all web services, logins, and API calls
- Familiar with XMPP would be a plus point.
Candidate should have atleast 4 years of relative experience in PHP
Candidate should be able to explain the work done in the Past
Candidate should be good in logical implementations
Candidate should be good in Communication and work approach
Candidate should have good solution oriented approach
Candidate worked with premium Institution or premium product/app will be a great plus
Technical Skills
1.Proficient knowledge of language PHP and JavaScript - Must have
2.MVC Framework like codeigniter/laravel is mandate - Must have
3.Good understanding of advanced JavaScript libraries - Must have
4.Database: Mysql Database Design, DB Query Knowledge, Development and improvements - Must have
5.Candidate should be good in writing optimized DB Queries and should know how to write effective DB Queries. - Must have
6.Good experience on dealing with JSON/REST API and Web Services.
7.Good understanding and experience of code versioning tools such as Git.
8.Proficient in Linux OS and Candidate should be able to work independently
9.Caching : Redis(optional)
10.No-sql database :Mongodb(optional)
Other Norms
- Candidate should have good machines/laptop to work.
- Candidate should have good internet connection at their work place