29+ DBA Jobs in India
Apply to 29+ DBA Jobs on CutShort.io. Find your next job, effortlessly. Browse DBA Jobs and apply today!
Snowflake Administrator Acquired skills:
- Identify the various aspects of compute and storage management
- Illustrate administrative tasks within the detailed architecture of Snowflake
- Review Snowflake best practices & considerations for managing load operations and performance
- Describe data governance in Snowflake, including column-level data security using secure views and
- dynamic data masking features
- Manage multiple accounts across the Organization
- Describe the DDL operations that work with fundamental database objects
- Discuss transaction and concurrency models and DML considerations
- Employ recovery methods and agile development with Time Travel & Cloning
- Implement advanced techniques for Snowflake performance-tuning methodologies
- Design and develop secure access to objects in Snowflake with Role-Based Access Control (RBAC)
- Recommend the Snowflake best practices for management, monitoring, and optimization
- Use data replication for data sharing across accounts and for failover scenarios
- Share data securely both within and without your organization
Detailed Snowflake Architecture and Overview
- Snowflake Technical Overview
- Overview of Three-Tiered Architecture
Compute Management
- Scaling Virtual Warehouses Up & Out
- Creating and Managing Virtual Warehouses
Mandatory Skills:
Compute & Storage Management, Load Operations Management, Snowflake Architecture, Data Governance, Column-Level Data Security, Dynamic Data Masking, DDL/DML Operations, Transaction & Concurrency Models, Recovery Methods, Agile Development, Time Travel, Role-Based Access Control (RBAC), Data Replication, Secure Data Sharing
Good to Have Skills:
Talend Admin Experience, Cost Optimization
• 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
PostgreSQLProject Overview: We are looking for expert level Postgres database developer to work on a software application development project for a fortune 500 US based telecom client. The application is web based and used across multiple teams to support their business processes. The developer will be responsible for developing various components of the Postgres database and for light administration of the database.
Key Responsibilities: Collaborate with onshore, offshore and other team members to understand the user stories and develop code. Develop and execute scripts to unit test. Collaborate with onshore developers, product owner and the client team to perform work in an integrated manner.
Professional Attributes: Should have the ability to work independently and seek guidance as and when necessary - Should have good communication skills - Flexible working in different time zones if necessary - Good team player - Mentoring juniors
Experience preferred:
- Extensive experience in Postgres database development (expert level)
- Experience in Postgres administration.
- Must have working experience with GIS data functionality
- Experience handling large datasets (50-100M tables)
- Preferred – exposure to Azure or AWS
- Must have skillsets for database performance tuning
- Familiarity with web applications
- Ability to work independently with minimal oversight
- Experience working cohesively in integrated teams
- Good interpersonal, communication, documentation and presentation skills.
- Prior experience working in agile environments
- Ability to communicate effectively both orally and in writing with clients, Business Analysts and Developers
- Strong analytical, problem-solving and conceptual skills
- Excellent organizational skills; attention to detail
- Ability to resolve project issues effectively and efficiently
- Ability to prioritize workload and consistently meet deadlines
- Experience working with onshore-offshore model
- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support for critical production systems
- Installing and maintaining the Oracle database software.
- Creating storage database structures with high-level security features.
- Altering storage structures to meet the evolving needs of the company.
- Setting up database user accounts.
- Training users on how to access the information in the database.
- Finding and debugging malfunctioning programs affecting the database integrity.
- Creating autonomous database backups.
- Regularly updating the database security protocols.
- Design, develop, implement and maintain our core Oracle applications.
- Maintain our SQL / PLSQL processes.
- Ensure DB availability.
- Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
- Actively seek to optimise and simplify our architecture.
- Take ownership of performance and capacity monitoring aspects of the DB.
- Execution of data migration jobs and scripts as required.
- Assist the infrastructure team in sizing hardware used for the DB.
- Support and collaborate with product developers.
- Contribute to the creation and maintenance of disaster recovery plans.
- Work closely with the application vendors, co-ordinate and manage the DBA activities.
- Own and follow up with Vendors/Stakeholders & their DBAs when required.
- Create a reliable backup strategy. Ensure database backups are appropriately
- executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards.
- Performance testing and evaluation to ensure data security, privacy and integrity.
- Identification of bottle necks and deadlock issues.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
- Install upgrades and security patches.
- Alter storage structures to meet the evolving needs of the company.
- Set up database user accounts.
- Train users on how to access the information in the database.
- Find and debug malfunctioning programs affecting the database integrity.
- Create autonomous database backups.
- Regularly update the database security protocols.
Desired Skills:
- Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
- Technical degree preferable (B.E. / B. Tech).
- Must experience with an organisation that has 24x7 reliability on its database.
- Must have experience with Oracle Exadata.
- Must Operating system experience in Linux.
- Must hands on knowledge of Shell scripting on Linux Platform
- Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
- Must hands on knowledge of SQL / PLSQL.
- Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
- Knowledge of Partitioning.
- Knowledge of architecture design principles.
- Good problem solver, focused and dedicated developer with ability to work on
- your own as well as with a team.
- Hands on experience with DB standards and end user applications-translating
- capacity requirements into infrastructure deployment technology.
- Strong practical experience of ORACLE in a production environment (Ver 19c).
- Must be a self-starter with a strong attention to detail.
PostgreSQL SQL Server DBA duties and responsibilities
- Experience in both sql server DBA and DBA developer
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Perform scheduled maintenance and support release deployment activities
• Database programming skills(writing and understanding Procedures , scripts..)
Good to have experience to SSIS,SSAS SSRS or any reporting tools.
KubernetesRelevant work experience:
- 5+ years working in the Information Technology Industry
- 2+ years system engineering or platform engineering
We are a fast-growing digital, cloud, and mobility services provider with a principal market being North
America. We are looking for talented database/SQL experts for the management and analytics of large
data in various enterprise projects.
Responsibilities
Translate business needs to technical specifications
Manage and maintain various database servers (backup, replicas, shards, jobs)
Develop and execute database queries and conduct analyses
Occasionally write scripts for ETL jobs.
Create tools to store data (e.g. OLAP cubes)
Develop and update technical documentation
Requirements
Proven experience as a database programmer and administrator
Background in data warehouse design (e.g. dimensional modeling) and data mining
Good understanding of SQL and NoSQL databases, online analytical processing (OLAP) and ETL
(Extract, transform, load) framework
Advance Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server
Integration Services (SSIS)
Familiarity with BI technologies (strong Tableu hands-on experience) is a plus
Analytical mind with a problem-solving aptitude
MongoDBJob description
The role encompasses administration of and responsible for MongoDB database and will be responsible for ensuring the database performance, high availability, and security of clusters in MongoDB instances.
- The candidate will be responsible for ensuring that database management policies, processes and procedures are followed, adhering to ITIL good practice principles and are subjected to continuous improvement as per PCI standards.
- He / She will be responsible for reviewing system design changes to ensure they adhere to expected service standards and recommend changes to ensure maximum stability, availability and efficiency of the supported applications.
- The candidate should understand the application functionality, business logic and work with application stakeholders to understand the requirement and discuss the new application features and propose the right solutions.
What you'll do
- Install, deploy and manage MongoDB on physical and virtual machines
- Create, configure and monitor large-scale, secure, MongoDB sharded clusters
- Support MongoDB in a high availability, multi-datacenter environment
- Administer MongoDB Ops Manager monitoring, backups and automation
- Configure and monitor numerous MongoDB instances and replica sets
- Automate routine tasks with your own scripts and open-source tools
- Improve database backups and test recoverability regularly
- Study the database needs of our applications and optimize them using MongoDB
- Maintain database performance and capacity planning
- Write documentation and collaborate with technical peers online
- All database administration tasks like backup, restore, SQL optimizations, provisioning infrastructure, setting up graphing, monitoring and alerting tools, replication
- Performance tuning for high throughput
- Architecting high availability servers
What qualifications will you need to be successful?
Skills and Qualifications
- Minimum 1 years of experience in MongoDB technologies, Total should be 3 years in database administration.
- Install, Deploy and Manage MongoDB on Physical, Virtual, AWS EC2 instances
- Should have experience on MongoDB Active Active sharded cluster setup with high availability
- Should have experience on administrating MongoDB on Linux platform
- Experience on MongoDB version upgrade, preferably from version 4.0 to 4.4, on production environment with a zero or very minimum application down time, either with ops manager or custom script
- Experience on building the database monitoring using tools like, AppD, ELK, Grafana etc.
- Experience in Database performance tuning which include both script tuning and hardware configuration and capacity planning.
- Good Understanding and experience with Mongodb sharding and Disaster Recovery plan
- Design and implement the backup strategy and BCP process across the MongoDB environments. Maintain the uniform backup strategy across the platform
- Define the database monitoring, monitoring thresholds, alerts, validate the notifications and maintain the documents for the future references
- Database performance tuning based on the application requirement and maintain the stable environment. Analyse the existing mongodb queries behalf of the performance improvement program
- Work with engineering team to understand the database requirement and guide them the best practice and optimize the queries to get the better performance
- Work with application stake holders to understand the production requirement and propose the effective database solutions
- Review and understand the ongoing business reports and create new adhoc reports based on the requirement
The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance.
What will I be doing?
- A professional Database Administrator (DBA) will be responsible for the architecture, performance, integrity, and security of a database.
- Design and build highly available microsoft MySQL and SQL solutions, making use of log shipping, mirroring and always on technologies
- Ensure performance, security, and availability of databases
- Prepare documentation and specifications
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Design, create and implement database systems based on the end user's requirements.
- Collaborate with other team members and stakeholders
- Collaborate with the engineering and production support teams to create forward-looking service improvement plans and roadmaps.
- Installation, configuration and upgrading of application software and related products
What Skill do I need ?
- Minimum 5 years of experience in database administration, information technology, database architecture, or a related field
- Installation, configuration and upgrading of MS SQL/Oracle/MySQL/ Server software and related products
- Strong proficiency with Microsoft SQL, and ideally its variants in other popular RDBMS
- Skilled at optimizing large complicated SQL statements
- Proven working experience as a Database Administrator and expert in MongoDB
- Install server software, configure database servers, monitor and maintain system health and security
- Excellent knowledge of data backup, recovery, security, integrity
- Familiarity with database design, documentation and coding
- Previous experience with DBA case tools (frontend/backend) and third-party tools
- Problem solving skills and ability to think algorithmically
- Experience with large databases and complex process models
Required Qualification :
- Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study
- Proven knowledge of SQL Servers, Cpanels, MySQL
- Strong analytical, problem-solving, and decision-making skills
- Advanced working SQL and MySQL knowledge and experience working with relational databases, query authoring (SQL)
- Excellent knowledge of Performance tuning, DB administration, data backup, recovery, security, integrity
- Experience working with both structured and unstructured data.
- Excellent problem-solving and analytical skills
- Good communication, teamwork and negotiation skills
NodeJS (Node.js)
React Native
Elastic SearchJob Description
What is the role?
Expected to manage the product plan, engineering, and delivery of Plum Integration activities. Plum is a rewarding and incentive infrastructure for businesses. It's a unified integrated suite of products to handle various rewarding use cases for consumers, sales, channel partners, and employees. 31% of the total tech team is aligned towards this product and comprises 32 members within Plum Tech, Quality, Design, and Product management. The annual FY 2019-20 revenue for Plum was $ 40MN and is showing high growth potential this year as well. The product has a good mix of both domestic and international clientele and is expanding. The role will be based out of our head office in Bangalore, Karnataka however we are open to discuss the option of remote working with 25 - 50% travel.
Key Responsibilities
- Scope and lead technology with the right product and business metrics.
- Directly contribute to product development by writing code if required.
- Architect systems for scale and stability.
- Serve as a role model for our high engineering standards and bring consistency to the many codebases and processes you will encounter.
- Collaborate with stakeholders across disciplines like sales, customers, product, design, and customer success.
- Code reviews and feedback.
- Build simple solutions and designs over complex ones and have a good intuition for what is lasting and scalable.
- Define a process for maintaining a healthy engineering culture (Cadence for one-on-ones, meeting structures, HLDs, Best Practices In development, etc.).
What are we looking for?
- Manage a senior tech team of more than 5 direct and 10 indirect developers.
- Should have experience in handling e-commerce applications at scale.
- Should have experience working with applications like HubSpot salesforce and other CRM.
- Should have experience in B2B integrations.
- Should have at least 10+ years of experience in software development, agile processes for international e-commerce businesses.
- Should be extremely hands-on, with an Automate as much as possible mind set full-stack developer.
- Should exhibit skills to build a good engineering team and culture.
- Should be able to handle the chaos with product planning, prioritizing, customer-first approach.
- Technical proficiency
- Frameworks like React, React Native, Node.js, GraphQL
- Databases technologies like Elasticsearch, Redis, MySQL, MongoDB, Kafka
- Dev ops to manage and architect infra - AWS, CI/CD (Jenkins)
- System Architecture w.r.t Microservices, Cloud Development, DB Administration, Data Modeling
- Understanding of security principles and possible attacks and mitigate them.
Whom will you work with?
You will lead the Plum Integration Engineering team and work in close conjunction with the Tech leads of Plum with some cross-functional stake with other products. Your will report to the CTO directly.
What can you look for?
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
Go Programming (Golang)
Ruby on Rails (ROR)
Ruby
Python
JavaJob Description
Job Description SQL DBA - Trainee Analyst/Engineer
Experience : 0 to 1 Years
No.of Positions: 2
Job Location: Bangalore
Notice Period: Immediate / Max 15 Days
The candidate should have strong SQL knowledge, Here are few points
- Implement and maintain the database design
- Create database objects (tables, indexes, etc.)
- Write database procedures, functions, and triggers
Good soft skills are a must (written and verbal communication)
Good team player
Ability to work in a 24x7 support model (rotation basis)
Strong fundamentals in Algorithms, OOPs and Data Structure
Should be flexible to support multiple IT platform
Analytical Thinking
Additional Information :
Functional Area: IT Software - DBA, Datawarehousing
Role Category: Admin/ Maintenance/ Security/ Datawarehousing
Role: DBA
Education :
B.Tech/ B.E
Skills
SQL DBA, IMPLEMENTATION, SQL, DBMS, DATA WAREHOUSING
PostgreSQLABOUT 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
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
MongoDB. Sound knowledge of NoSQL databases like mongo.
. Experience with replication , sharding and scaling.
. Design, install, maintain highly available systems (includes monitoring, security, backup, and performance tuning)
. Implement secure database and server installations (privilege access methodology / role based access)
. Help application team in Cyper query writing, performance tuning & other D2D issues
• Deploy automation techniques for d2d operations
. Must possess good analytical and problem solving skills
. Must be willing to work flexible hours as needed
. Scripting experience a plus
. Ability to work independently and as a member of a team
. Strong verbal and written communication skills
Python- Key responsibility is to design, develop & maintain efficient Data models for the organization maintained to ensure optimal query performance by the consumption layer.
- Developing, Deploying & maintaining a repository of UDXs written in Java / Python.
- Develop optimal Data Model design, analyzing complex distributed data deployments, and making recommendations to optimize performance basis data consumption patterns, performance expectations, the query is executed on the tables/databases, etc.
- Periodic Database health check and maintenance
- Designing collections in a no-SQL Database for efficient performance
- Document & maintain data dictionary from various sources to enable data governance
- Coordination with Business teams, IT, and other stakeholders to provide best-in-class data pipeline solutions, exposing data via APIs, loading in down streams, No-SQL Databases, etc
- Data Governance Process Implementation and ensuring data security
Requirements
- Extensive working experience in Designing & Implementing Data models in OLAP Data Warehousing solutions (Redshift, Synapse, Snowflake, Teradata, Vertica, etc).
- Programming experience using Python / Java.
- Working knowledge in developing & deploying User-defined Functions (UDXs) using Java / Python.
- Strong understanding & extensive working experience in OLAP Data Warehousing (Redshift, Synapse, Snowflake, Teradata, Vertica, etc) architecture and cloud-native Data Lake (S3, ADLS, BigQuery, etc) Architecture.
- Strong knowledge in Design, Development & Performance tuning of 3NF/Flat/Hybrid Data Model.
- Extensive technical experience in SQL including code optimization techniques.
- Strung knowledge of database performance and tuning, troubleshooting, and tuning.
- Knowledge of collection design in any No-SQL DB (DynamoDB, MongoDB, CosmosDB, etc), along with implementation of best practices.
- Ability to understand business functionality, processes, and flows.
- Good combination of technical and interpersonal skills with strong written and verbal communication; detail-oriented with the ability to work independently.
- Any OLAP DWH DBA Experience and User Management will be added advantage.
- Knowledge in financial industry-specific Data models such as FSLDM, IBM Financial Data Model, etc will be added advantage.
- Experience in Snowflake will be added advantage.
- Working experience in BFSI/NBFC & data understanding of Loan/Mortgage data will be added advantage.
Functional knowledge
- Data Governance & Quality Assurance
- Modern OLAP Database Architecture & Design
- Linux
- Data structures, algorithm & data modeling techniques
- No-SQL database architecture
- Data Security
Amazon Web Services (AWS)
|
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
|
1. Implement high-quality cloud architectures that meet customer
requirements and are consistent with enterprise architectural standards.
2. Deep understanding of cloud computing technologies, business
drivers and emerging computing trends.
3. The ideal resource will have experience across enterprise-grade hybrid
cloud or data centre transformation.
4. Install, configure and upgrade MySQL/Postgres cluster database
software.
5. Experience in setting-up DR for RDBMS DBs in Linux environments.
6. Create, configure, manage and migrate NoSQL databases (Redis,
Cassandra and MongoDB).
7. Manage day to day operations from development to production
databases.
8. Monitor the health of cloud services and databases.
9. Good understanding of NoSQL/relational databases.
10. Troubleshoot NoSQL/RDBMS databases general/performance
issues.
11. Experience in Linux OS and scripting.
12. Hands on experience on Azure, GCP and AWS clouds and its services.
13. Knowledge in python/ansible is an added advantage.
14. Leveraging open source technologies and cloud native hosting
platforms.4
15. Design and recommend suitable, secure, performance optimised
database offerings based on business requirements.
16. Ensure security considerations are at the forefront when designing
and managing database solutions.
17. Maintenance work to be planned meticulously to minimise/eradicate
self-inflicted P1 outages.
18. Ability to provide technical system solutions, determine overall
design direction and provide hardware recommendations for complex
technical issues.
19. Provisioning, deployment, monitoring cloud environment using
automation tools like Terraform.
20. Ensure all key databases have deep insight monitoring enabled to
enable improved capabilities around fault detection.
Required Qualifications:
• Minimum 6-8 years of experience as an Database Administrator
preferably in a cloud environment.
• Application migration experience that involves migrating large
scale infra between clouds.
• Experience in executing migration cutover activities. Support UAT,
troubleshoot during and post migration issues
• Ability to work independently on multiple tasks with minimal
guidance Ability and desire to work in a fast paced environment5
• Contribute to overall capacity planning and configuration
management of the supporting infrastructure
• Review recommendations around Security, Availability,
Performance, and from Cloud platform
• Ability to remain flexible in a demanding work environment and
adapt to rapidly changing priorities.
PythonMongoDBIn 2018-19, the mobile games market in India generated over $600 million in revenues. With close to 450 people in its Mumbai and Bangalore offices, Games24x7 is India’s largest mobile games business today and is very well positioned to become the 800-pound gorilla of what will be a $2 billion market by 2022. While Games24x7 continues to invest aggressively in its India centric mobile games, it is also diversifying its business by investing in international gaming and other tech opportunities.
Summary of Role
Position/Role Description :
The candidate will be part of a team managing databases (MySQL, MongoDB, Cassandra) and will be involved in designing, configuring and maintaining databases.
Job Responsibilities:
• Complete involvement in the database requirement starting from the design phase for every 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.
Job Requirements:
• BE/B.Tech from a reputed institute
• Experience in python scripting.
• Experience in shell scripting.
• General understanding of system hardware.
• Experience in MySQL is a must.
• Experience in MongoDB, Cassandra, Graph db will be preferred.
• Experience with Pecona MySQL tools.
• 6 - 8 years of experience.
Job Location: Bengaluru
Responsible for cloning databases from production to test / development environments and maintain the users data integrity on the test / development environments
Strong Knowledge on Upgradation of database from Oracle 9.x to Oracle 10g,11g and 12c,18c
Strong Knowledge on Upgradation of Application – 12.1.x to 12.2.x
Patch Analysis and Patching of both Apps, DB tier.
AD utilities (adop,adpatch, adclone, adadmin, adctrl etc.)
Troubleshooting of Application.
create custom responsibilities, request groups and menus
creating and Managing Concurrent Managers and Concurrent Programs.
Cloning of the Applications using Rapid Clone and adclone.
Secondary
Experience in installation and configuring Oracle database servers on multiple operating environments like Red Hat Linux, OEL, IBM AIX,HP-UX Platforms
Installation, configuration and administration of Oracle Application 11i,R12 and 12.2 in a Multi- tier architecture.
Shell scripting.
Web-logic administration and troubleshooting.
Knowledge Tomcat administration.
Knowledge MySQL administration
Knowledge on could like AWS, Oracle Public cloud, Azure.
· 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.
10+ years of experience in SQL Server Administration
Should be hands on
Able to handle customer communication and expectation management
Proactively plan and implement the project/support activities
Focus on continuous improvements
Must have experience in managing team of SQL Server DBAs
should have good customer and client management skills
should have good communication skills
Job Title – Sr. Database Developer and DBA MS SQL Server
Job Location – Bangalore
Experience – 8 to 10 years
CTC – 10-12 LPA
Job Description
- 8-10 years of industry experience with an appropriate University technology degree (BE,BTech,MCA)
- Should have extensive Hands-on experience in managing RDBMS Production and application DBA for MS-SQL Database.
- Must be proficient in MS-SQL programming and can handle complex logic.
- Knowledge of data structure and algorithms is a plus.
- Must have good experience in SSIS and SSRS using MSSQL Sever 2016 or later
- Monitoring, maintaining, Query tuning, performance tuning, cluster management for all RDBMS Production and application (MS-SQL).
- Database server administration with focus on security, automation, tuning, optimization, and standardization of new and deployed systems.
- Be able to work as a DBA lead and individual contributor for RDBMS platform.
- Will be responsible for database server planning with regards to scalability, redundancy, and data preservation of backend systems.
- Will develop High Availability Clustered server/network RDBMS topologies.
- Write comprehensive documentation, help develop tools to monitor systems performance, and work on optimization and tuning of various systems.
- Working with Production support teams on troubleshooting Incidents on a 24x7 basis. Looking for Sr. Sql Server DBA Who Would Provide Technical Support In Analysis, Design, Testing, And Deployment Of All Database Platform.
Proxy SQL
Galera Cluster
MongoDB- Experience: 3-5 Years
- Scripting: PowerShell and either of ( JavaScript, Python)
- Kubernetes and docker Hands-On
- Good to have either (Azure / AWS )
- Any of DB technologies Hands-ON: No SQL - Admin, COSMOS DB, MONGO DB, Maria DBA
- Good to have Analytics knowledge
Hi,
Greeting from Acess Meditech Pvt Ltd. is into providing of business process outsourcing services for Insurance industry.
Job Title:SQL server (DBA)(2008,2012,2016) versions
Experience: 3-4 Yrs Min
Location: Hyderabad
Qualification :Any Degree.
Job Responsibility
SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience working with Windows server, including Active Directory
Ability to organize and plan work independently
Perform scheduled maintenance and support release deployment activities after hours.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Follow Cutshort