- Communicate and coordinate effectively across multiple internal teams and external contractors.
- Prioritize and deliver results effectively on concurrent projects in a fast-paced team-oriented environment.
Database Development Skills :
- Write and review MSSQL code and queries used in standard database objects (functions, stored procedures, triggers, and views) and queries generated by application.
- Automate, document, and demonstrate routine tasks and processes.
- Commit database administration and automation code to source control in Git repository.
- Track and apply changes to database objects and data transformations in testing and production environments.
- Maintain database continuous integration, delivery, and deployment efforts in support of DevOps initiatives.
- Leverage open-source platforms and cloud technologies to improve efficiency and scalability of data services.
Database Administration Skills :
- Deliver actionable feedback to business owners and development teams regarding SQL Server performance and scalability.
- Apply industry standard security principles and best practices.
- Provide and monitor Instance and Database level access to users and applications.
- Support audit compliance efforts by reporting on setup, configuration, and application data.
Required Experience :
- Proven track record of analyzing and solving complex data issues.
- Query tuning, optimization, and monitoring in an enterprise environment.
- Root cause analysis of performance and integrity issues.
- Data analytics and reporting using complex SQL queries.
Background :
- Degree in Computer Science or equivalent experience.
- 5-7 years of Microsoft SQL Server Database Engineer experience.
Similar jobs
We are hiring for
Product Support Engineer
1-4 yrs | Bangalore Office
Responsibilities
● Someone who are passionate and super excited to work on world’s fast growing neo banking platform and be self-directed in a fast-paced environment that gives you freedom and responsibility.
● Would be responsible for day to day maintenance of engineering system. Confer with Internal teams to identify problems, replicate them, and troubleshoot for root cause.
● Evaluate failures, bugs, systemic problems, and report on necessary steps.
● An advocate for the customer who is passionate about addressing customer pain points.
● Logging and Keeping records of various issues to help the team prioritize fixes and automations along with measuring the product quality.
● Documenting troubleshooting and problem solution steps.
● Taking ownership of technical issues and working closely with developers to resolve the problems.
● Build a deep understanding of the domain.
Responsibilty
● Passionate individual with excellent analytical and logical thinking.
● Being able to work a full-time schedule of 24*7 hours from Monday through Saturday shift wise.
● Basic knowledge of the scripting languages like PHP, Python.
● Being able to creatively come up with ideas or solutions for various problems and implement them.
● Basic/ Advanced knowledge in MYSQL and writing simple queries to get data from the Database.
● Quick troubleshooting/debugging, diagnosing, and problem solving skills.
● Interest in facilitating monitoring systems to identify issues before they happen.
● Dynamic, outgoing, enthusiastic individual and must bring a high level of energy to the table.
● Skilled in managing multiple cases
● Keen to learn.
Responsibilities of senior java developer
- Every role comes with responsibilities and the employees have to justify those responsibilities. Following are some crucial responsibilities senior java developers entitled for.
- Senior Java developers have to analyze and assess the business needs of the client to find the best solution for the client. Overall strong analytical and problem-solving skills are highly important for this role.
- Senior Java Developer responsibilities include gathering system requirements, building application specification document, draw flow charts, design application architecture and implement modernised application design and testing features before release.
- You should have hands-on experience in developing software with agile or scrum methodologies and are ready to lead our junior developer's team.
- You should have an innovative thought process and creative thinking which can bring out of box and alternate way of system implementation.
- Ensure our applications must be secure and up-to-date.
- To interact with the customer and internal teams in Identifying and analyzing requirements for development purposes.
- To perform activities related to the creation of documents for client requirements.
- Prioritizing the task and executing tasks throughout the SDLC.
- Provide technical help to junior developers.
Job Description:
As a developer in the chatbot team you’ll be responsible for expanding the scope of AERIN (Aertrip’s Chatbot) to handle all types of travel queries in a scalable and efficient manner. You will need to make AERIN as robust as possible and strive towards 100% accuracy. You should be able to design, develop, test and roll out new features quickly. You should be ready to tackle open-ended problems and build solutions for them.
Preferred qualifications & experience:
- Bachelor’s degree in Computer Science or equivalent experience.
- 1 or more years of work experience in the tech industry.
- Experience with NLP solutions.
- Experience with chatbot frameworks like RASA, DialogFlow is a bonus.
- Experience with spacy, nltk and other ML libraries.
- Familiarity with version control tools like Gitlab.
- Experience in object oriented design and programming.
- Sound programming skills to write algorithms for text analysis and context understanding.
Preferred Skills & Abilities:
- Should be able to write clean and manageable code.
- Passion for innovation.
- Out of the box thinking.
- Should be able to understand both the tech and business aspects of a system.
- Should be able to meet deadlines.
- Should be able to work in a collaborative environment.
- Should be able to work independently in small teams.
Responsible for preparing, conducting, and evaluating technical training programs. Writes literature and materials to be used in programs and designs exercises to enhance learning experience.
Responsibilities
- Provide technical training to professional personnel.
- Develop innovative and easy-to-understand training materials.logistics and tools.
- Meet organizational training needs.
- Organize instructor-led training programs.
- Prepare training schedules and programs for personnel.
- Analyze learning needs and develop appropriate training material.
- Interact with respective departments in scheduling training programs.
Requirements
- Experience in delivering technical training.
- Top-notch administrative, research and troubleshooting skills.
- Ability to host training workshops for new hires.
- Knack for detecting and removing barriers to learning.
- Strong knowledge of PHP, Python, Javascript, MySQL, NoSQL, Data Structures, Algorithms
Experience
2-3 years of experience of relevant experience is preferred.
Role / Purpose - Lead Developer - API and Microservices
Must have a strong hands-on development track record building integration utilizing a variety of integration products, tools, protocols, technologies, and patterns.
- Must have an in-depth understanding of SOA/EAI/ESB concepts, SOA Governance, Event-Driven Architecture, message-based architectures, file sharing, and exchange platforms, data virtualization and caching strategies, J2EE design patterns, frameworks
- Should possess experience with at least one of middleware technologies (Application Servers, BPMS, BRMS, ESB & Message Brokers), Programming languages (e.g. Java/J2EE, JavaScript, COBOL, C), Operating Systems (e.g. Windows, Linux, MVS), and Databases (DB2, MySQL, No SQL Databases like MongoDB, Cassandra, Hadoop, etc.)
- Must have experience implementing API Service architectures (SOAP, REST) using any of the market-leading API Management tools such as Apigee and frameworks such as Spring Boot for Microservices
- Should have Advanced skills in implementing API Service architectures (SOAP, REST) using any of the market-leading API Management tools such as Apigee or similar frameworks such as Spring Boot for Microservices
- Appetite to manage large-scale projects and multiple tracks
- Experience and knowhow of the e-commerce domain and retail experience are preferred
- Good communication & people managerial skills
• 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
What essential skills you need
- 4 -6 years’ experience in MySQL database development. You know your way around problems,logic & code but you occasionally need help with how to do things. That’s cool with us. We usestack overflow too.
- Expertise in database design & development (preferably on MySQL).
- Expertise in writing complex SQL queries, stored procedures, and functions, triggers.
- Expertise in performance tuning, query optimization, using performance monitor, SQL Profiler andother related monitoring and troubleshooting tools.
- BE/B.Tech ( or equivalent education), good written & communication Skills.
Job Title: |
Senior Cloud Service DBA |
||
Department & Team |
Technology |
Location: |
INDIA |
Reporting To: |
Senior DBA – Team Lead |
Role Purpose: |
This role will be a mix of project, BAU and innovation and will encompass typical database administration duties that you may expect in a large-scale telecommunications environment: performance tuning, replication, database design, backups, high availability, encryption, security, configuration etc.
1. Network Services Team – Responsible for IP Network and its associated components 2. Infrastructure Team – Responsible for Server and Storage systems 3. Database Services Team – Responsible for all Databases 4. Cloud Architect Team – Delivering future strategy, ongoing cloud performance optimisation.
The DBA function forms part of Client’s Tier 3 support function and works closely with the internal NOC, Service Desk, Infrastructure, IP Networks and Cloud Architect teams. To enable the business in achieving its stated objectives by assisting the other technology teams to achieve world-class benchmarks of customer service and support.
To highlight, a key requirement of the role will be involvement in defining our future strategy around database modernisation in the cloud.
|
Responsibilities: |
Operations · Involved in new solutions design discussions and to recommend suitable, secure, performance optimised database offerings based on business requirements · Ensure all databases in the AWS and Azure are configured for performance, scale and high availability where required · Take responsibility of modernisation of Clients database estate in the cloud, leveraging open source technologies and cloud native hosting platforms · Drive innovation by constantly reviewing latest public cloud platform database service releases such as Babelfish in AWS to fast track adoption of native services · Ensure security considerations are at the forefront when designing and managing database solutions · Optimise query performance · Ensure all key databases have deep insight monitoring enabled to enable improved capabilities around fault detection · Perform regular database maintenance when required and ensure databases are backed up according to agreed RTO / RPO information · Maintenance work to be planned meticulously to minimise/eradicate self-inflicted P1 outages · Monitoring database costs regularly and identify strategies to minimize cost as part of internal FinOps practices · Ability to provide technical system solutions, determine overall design direction and provide hardware recommendations for complex technical issues · Provisioning, deployment, monitoring cloud environment using automation tools like Terraform |
Skills & Experience: |
Certifications: · SQL Server Database Administration - REQUIRED · AWS Certified Solutions Architect Associate – Highly Desirable · AWS Certified Database Specialty – REQUIRED · Azure Database Administrator Associate – Highly Desirable
Skills & Experience: · Ideal candidate has been supporting traditional server based relational databases for over 8 years who then transitioned into AWS and Azure public cloud for the last 5 years · SQL Server / MSSQL 2008 / 2012 / 2014 / 2016 / 2017 / 2019 (including Always-On and Analysis Services) · Postgres / MYSQL as standalone and managed service platforms · Strong database migration experience (Particularly MSSQL to open source and leveraging AWS native platforms including RDS, Athena, Aurora) · Extensive AWS experience in a commercial environment, architecting database best practices · Strong experience supporting AWS / Azure based datalake/data warehouse environments. Required to support internal BI teams · Solid experience and understanding which workloads are best suitable for which specific database platforms in AWS and Azure · Extensive experience and understanding of database security, including appropriate encryption and authentication best practices · Good working knowledge of Microsoft Power BI · Good knowledge of Azure cloud database services · Any working experience around non-relational databases (internally hosted or managed service such as DynamoDB in AWS will be favoured) · Good working knowledge of Windows and Linux Server Operating Systems · Excellent presentation skills to both an internal and external audience · The ability to share and communicate your specific expertise to the rest of the Technology group
|
Behavioural Fit: |
· Professional appearance and manner · High personal drive; results-oriented; make things happen; “can-do attitude” · Can work and adapt within a highly dynamic and growing environment · Team Player; effective at building close working relationships with others · Effectively manages diversity within the workplace · Strong focus on service delivery and the needs and satisfaction of internal clients · Able to see issues from a global, regional and corporate perspective · Able to effectively plan and manage large projects · Excellent communication skills and interpersonal skills at all levels · Strong analytical, presentation and training skills · Innovative and creative · Visionary and strategic view of technology enablers (creative and innovative) · High verbal and written communication ability, able to influence effectively at all levels · Possesses technical expertise and knowledge to lead by example and input into technical debates · Depth and breadth of experience in infrastructure technologies · Enterprise mentality and a global mindset · Sense of humour
|
Role Key Performance Indicators: |
· Design and deliver repeatable, best in class, cloud database solutions · Pro-actively monitor service quality and take action to scale operational services, in line with business growth · Generate operating efficiencies, to be agreed with Infrastructure Services Manager · Establish a “best in sector” level of operational service delivery and insight · Help creates an effective team · Continuous improvement
|