· Primarily responsible for working on various service requests related to maintaining database security (roles, privileges, authentication), creating schema and copying data
· Work on installation, configuration, creation and administration of HP Vertica database clusters and AWS RDS MySQL database.
· Work with platform, product and other support teams to participate in release and change management processes to implement new features/functions as well support mandatory patches or upgrade activities on weekends.
· Responsible for database performance tuning, query tuning and database operations including migration and upgrade.
· Plan and implement periodic upgrades of database schema and perform testing and verification of released database schema upgrades.
· Configure and manage database backup and restore, participate in Disaster Recovery
· Create and maintain documentation, procedures and best practice guides for database deployment and maintenance.
About Product MNC
Similar jobs
Role: My SQL DBA
Work Location: Noida/Hyderabad
Exp : 3+ Yrs
About the Role:
The ideal candidate would be working on the servers which impact various SaaS AI/ML products and
1000+ models in AI/ML. As a DBA administrator the server support would be provided for various
industry verticals like Finance, Telecom, Travel & Transportation, Healthcare, Government etc. This role
would give an opportunity working on multiple and complex databases for fortune 500 customers which
have impact on their data related to AI/ML products/models of the company.
About the Company:
We are America’s oldest machine learning solutions company. With offices across US, China and India,
we hire people with a broad set of technical and domain skills who can contribute to the creation of
machine learning solutions across verticals such as financial services, telecommunications, healthcare,
consumer products etc.
Preferred Qualification:
(Must have)
· Three years or above working experience, more than two years in MySQL, familiar with MySQL
database architecture.
· Have good experience in database troubleshooting and solutions for the whole system chain,
including OS, Database, storage, network, application, cloud and so on.
· Familiar with SQL tuning, know about how to split large tables in MySQL.
· Familiar with the daily backup and restore operations of MySQL, and know about the HA
principles of MySQL replication and MySQL Cluster. Experience in PostgreSQL is preferred.
· Familiar with Linux operating system, be able to write daily scripts with Shell/Python.
· Experience about NoSQL databases is preferred, such as MongoDB, Redis.
· Experience about distribution databases is preferred, such as Greenplum, Clickhouse.
· Oracle DBA or SQL Server DBA working experience is preferred.
· Careful work, strong sense of responsibility, good learning ability and team spirit.
Responsibilities:
· Responsible for the daily maintenance and troubleshooting for all Databases, such as MySQL
and postgreSQL, make sure all database system running safely and stably.
· Establish MySQL daily backup and recovery policies, and data security policies.
· Responsible for the design and implementation of Database tables, and large table split policy.
· Provided daily support to the development team and application team, such as database design
specification and performance tuning suggestions.
• 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
Company profile.
Actuate Microlearning is a thirteen-year-old HR-Tech and Learning solution, operating in the B2B space, providing the following solutions to our clients:
- eLearning (off-the-shelf and custom)
- Gamified learning
- Learning Management Systems (under the brand name CalyxLMS)
- 360-degree surveys (under the brand name Calyx360)
- Standalone and blended-format instructor-led trainings (under the brand name CitrusLearning Systems)
Our client list includes top brands in across industry verticals, including the top BFSI, Pharmaceutical, Manufacturing, Logistics, Automotive, Consumer Goods, Consumer Durables, IT, ITES, eCommerce, Retail, Public Sec, Petrochem., Infrastructure, firms
We are a highly ambitious, steadily growing and profitable organization with a focus on employee development and well-being.
Our work culture and employee policies are designed to ensure our employees are happy, productive and growing in skill and character.
Job Summary:
Are you passionate about revolutionizing the HR-Tech and Learning space? Actuate Microlearning, a thirteen-year-old B2B Learning solutions provider, is seeking a talented Full-Stack Developer to join our innovative team. In this role, you will be at the forefront of developing and maintaining our Learning Management System (LMS), implementing robust security measures, and elevating the overall UI/UX.
Key Responsibilities:
- Front-end and Back-end Development: Spearhead the development of both the front-end and back-end of our Learning Management System (LMS), ensuring a cohesive and user-friendly experience.
- Security Implementation: Implement comprehensive security measures to safeguard user data, ensuring the confidentiality and integrity of information within the LMS. (Good to have)
- UI/UX Enhancement: Play a key role in enhancing the User Interface (UI) and User Experience (UX) of the LMS, creating an engaging and intuitive learning environment.
- System Maintenance and Updates: Take charge of maintaining and updating the system to ensure it aligns with industry standards, remains technologically advanced, and meets evolving user expectations.(Good to Have)
Qualifications and Skills:
- Master’s or Bachelor's degree in Computer Science, Computer Engineering, Information technology, Computer Applications or a related field.
- Proficiency in HTML, CSS, JavaScript, and PHP, MySQL databases and optimizing database performance
- Proven 2 plus experience in Full-Stack Development.
- Expertise in front-end and back-end technologies.
- UI/UX design proficiency.
- Continuous learner with the ability to adapt to new technologies.
As a Database Administrator, you will be responsible for designing, testing, planning,
implementing, protecting, operating, managing and maintaining our company’s
databases. The goal is to provide a seamless flow of information throughout the
company, considering both backend data structure and frontend accessibility for endusers. You get to work with some of the best minds in the industry at a place where
opportunity lurks everywhere and in everything.
Responsibilities
Your responsibilities are as follows.
• Build database systems of high availability and quality depending on each end
user’s specialised role
• Design and implement database in accordance to end users’ information needs
and views
• Define users and enable data distribution to the right user, in appropriate format
and in a timely manner
• Use high-speed transaction recovery techniques and backup data
• Minimise database downtime and manage parameters to provide fast query
responses
• Provide proactive and reactive data management support and training to users
• Determine, enforce and document database policies, procedures and
standards
• Perform tests and evaluations regularly to ensure data security, privacy and
integrity
• Monitor database performance, implement changes and apply new patches
and versions when required
Required Qualifications
We are looking for individuals who are curious, excited about learning, and navigating
through the uncertainties and complexities that are associated with a growing
company. Some qualifications that we think would help you thrive in this role are:
• Minimum 4 Years of experience as a Database Administrator
• Hands-on experience with database standards and end user applications
• Excellent knowledge of data backup, recovery, security, integrity and SQL
• Familiarity with database design, documentation and coding
• Previous experience with DBA case tools (frontend/backend) and third-party
tools
• Familiarity with programming languages API
• Problem solving skills and ability to think algorithmically
• Bachelor/Masters of CS/IT Engineering, BCA/MCA, B Sc/M Sc in CS/IT
Database Administrator (DBA)
EDUCATION,EXPERIENCE REQUIRED:
BE/MCA/ B.TECH / BCA
Exp - Min 4 yrs
CTC – Upto 12 LPA
Job Description:
- Installing, Configuring, Managing, Monitoring and troubleshooting SQL Server 2005/2008/2008R2/2012/2014/2016
- Database administration activities like Installation, Configuration, Backup & Recovery, and Database Security.
- Providing availability solutions like Mirroring, Log Shipping, Replication and Always on.
- Database Up gradation and Migration
- Ensure performance monitoring, backup, restore, and security recovery solutions.
- Troubleshooting expertise in SQL server issues under production environment.
- Handling the entire production servers with skills and understanding client's requirement Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
- Automating process by creating jobs, and error reporting using Alerts by SQL Server Agent.
- Backup and Recovery strategy, Database Refreshes.
- Creation and maintenance of Databases, creating Roles and managing user permissions.
- Setting up, trouble shooting and maintenance of production server databases.
- Providing Production support for Database and Applications.
- SQL Server store procedure, functions, View, Index and trigger development.
Job requirement:
- Deep understanding of OS and its management including kernel space management
- Experience with Linux servers in virtualized environments
- Experience installing, configuring, and maintaining services such as Bind, Apache, MySQL, Nginx, etc.
- Experience in Monitoring tools like Nagios.
- Familiarity with load balancing, firewalls, etc.
- Proficient with network tools such as iptables, Linux IPVS, HA Proxy, etc.
- Experience with virtualization technologies, such as Xen KVM and VMware.
- Ability to build and monitor services on production servers
ABOUT US.
Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.
As a team culture, Ashnik is a family for its team members. Each member brings in different perspective, new ideas and diverse background. Yet we all together strive for one goal – to deliver best solutions to our customers using open source software. We passionately believe in the power of collaboration. Through an open platform of idea exchange, we create vibrant environment for growth and excellence.
THE POSITION
Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.
QUALIFICATION AND EXPERIENCE
- Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
- Experience of working in a production support environment
- Engineering or Equivalent degree
- Passion for open-source technologies is desired
ADDITIONAL SKILLS
- Install & Configure PostgreSQL, Enterprise DB
- Technical capabilities PostgreSQL 9.x, 10.x, 11.x
- Server tuning
- Troubleshooting of Database issues
- Linux Shell Scripting
- Install, Configure and maintain Fail Over mechanism
- Backup - Restoration, Point in time database recovery
- A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
- A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.
RESPONSIBILITIES
- Monitoring database performance
- Optimizing Queries and handle escalations
- Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
- Implement security features
- DR implementation and switch over
LOCATION: Pune
Experience: 8 yrs plus
Package: upto 17 LPA
project.
• Deploying required database assets on production (DDL, DML)
• Good understanding of MySQL Replication (Master-slave, Master-Master, GTID-based)
• Understanding of MySQL partitioning.
• A better understanding of MySQL logs and Configuration.
• Ways to schedule backup and restoration.
• Good understanding of MySQL versions and their features.
• Good understanding of InnoDB-Engine.
• Exploring ways to optimize the current environment and also lay a good platform for new
projects.
• Able to understand and resolve any database related production outages
- 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.
About this role
We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career. You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and MongoDB/ Cassandra.
What You’ll Do
- Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team.
- Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.
- Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.
- Work with our developers to optimize and tune their SQL queries.
- Assist in application development, debugging, and optimization with respect to data concerns.
- Provide input in the design and implementation of backup, recovery, and DR strategy
- Review application and database design for compliance.
What You’ll Need
- Ability to script in a high-level language like Python, Ruby, etc for Automation.
- 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ Cassandra.
- 4+ years of experience in database design and DevOps on AWS.
- Must demonstrate a clear understanding of logical and physical database design and standards.
- Experience in columnar data warehouse solutions like Redshift or Snowflake.
- Must have extensive hands-on experience with MySQL in a large scale 24x7 production environment with millions of records.
- Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience
Bonus Points If You Have
- Experience with NoSQL solutions such as Cassandra/MongoDB etc.
- Experience with software development life cycle (SDLC) in an agile environment
- Hands-on production experience with Big Data applications such as Spark.
- Knowledge of development best practices (source control with Git, continuous integration, automated testing).
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
|