Jobs
Interviews

13 Dba Support Jobs

Setup a job Alert
JobPe aggregates results for easy application access, but you actually apply on the job portal directly.

7.0 - 10.0 years

7 - 11 Lacs

Gurugram

Work from Office

Role Overview : The ideal candidate will have hands-on experience and an SME in maintaining databases, with a primary focus on performance, optimization, troubleshooting, high availability, disaster recovery, and automation. With deep expertise in Open Database technologies of PostgreSQL, Redis and MongoDB with additional expertise in containerization and orchestration tools like Docker and Kubernetes. Key Responsibilities : 1. Database Maintenance & Administration : - Perform routine maintenance tasks including backup, recovery, patching, and performance tuning. - Conduct standard database maintenance and administration tasks with attention to detail. - Monitor database activity, health, and performance, using database management system software and tools to collect performance statistics. - Optimize database performance, plan for forecast resource needs, and recommend corrective actions. - Ensure database high availability, replication, failover, and clustering. - Develop and configure tools to automate database administration tasks, enhancing efficiency and minimizing downtime. - Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects. - Implement disaster recovery strategies and maintain data integrity across environments. 2. Incident Management & Troubleshooting : - Handle critical escalations and complex troubleshooting for database issues. - Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues. - Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis). 3. Backup, Recovery & Disaster Recovery : - Design and implement backup strategies and disaster recovery plans. - Ensure data integrity, redundancy, and compliance with RPO/RTO requirements. 4. Containerization & Orchestration : - Manage databases using Docker and Kubernetes to ensure scalability and resilience. - Optimize containerized database solutions for performance optimization. - Implement CI/CD pipelines for automated deployment and maintenance of databases within containerized environments. 5. Collaboration & Communication : - Work closely with application teams to ensure seamless integration and optimal performance by understanding business logic, data models, and query patterns. - Optimize database schema and queries for application performance improvement. - Interact with customers, suppliers, and partners to deliver effective database maintenance. 6. Documentation & Reporting : - Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides. - Prepare reports detailing system health, performance metrics, and improvement plans. Required Skills and Qualifications : - Database Technologies : Deep knowledge of PostgreSQL, Redis and MongoDB. - Containerization & Orchestration : Hands-on experience with Docker and Kubernetes for deploying and managing databases. - Infrastructure and Application Integration : Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows. - Performance Tuning & Optimization : Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms.

Posted 2 weeks ago

Apply

7.0 - 10.0 years

10 - 15 Lacs

Gurugram

Work from Office

We are looking for an experienced and detail-oriented SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, ensuring the availability and consistent performance of our applications. Key Responsibilities : - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Monitor database performance, implement changes, and apply new patches and versions when required. - Perform database backups, restores, and recovery. - Manage SQL Server security (authentication, permissions, roles). - Optimize SQL queries and indexes for better performance. - Troubleshoot database-related issues including system outages and performance bottlenecks. - Implement high availability (HA) and disaster recovery (DR) solutions. - Automate repetitive DBA tasks using T-SQL, PowerShell, or other tools. - Perform capacity planning and storage management. - Create and maintain technical documentation and SOPs. - Collaborate with development and support teams on database-related issues and projects. Required Skills And Qualifications : - Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022). - Strong proficiency in T-SQL and SQL Server Management Studio (SSMS). - Experience with backup, restore, and recovery models. - Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. - Experience with monitoring tools like SQL Profiler, Extended Events, and third-party solutions (e. SolarWinds, Redgate). - Familiarity with performance tuning and optimization (PTO). - Experience working with Azure SQL Database, SQL Managed Instance, or AWS RDS is a plus. - Ability to handle multiple projects and priorities. - Strong communication and documentation skills. Preferred Qualifications : - Microsoft Certified : Azure Database Administrator Associate or similar certification. - Experience with SSIS, SSRS, and SSAS. - Knowledge of DevOps processes and CI/CD pipelines for database code deployment. - Exposure to cloud platforms (Azure, AWS, GCP).

Posted 3 weeks ago

Apply

7.0 - 10.0 years

8 - 12 Lacs

Pune

Work from Office

We are looking for an experienced and detail-oriented SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, ensuring the availability and consistent performance of our applications. Key Responsibilities : - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Monitor database performance, implement changes, and apply new patches and versions when required. - Perform database backups, restores, and recovery. - Manage SQL Server security (authentication, permissions, roles). - Optimize SQL queries and indexes for better performance. - Troubleshoot database-related issues including system outages and performance bottlenecks. - Implement high availability (HA) and disaster recovery (DR) solutions. - Automate repetitive DBA tasks using T-SQL, PowerShell, or other tools. - Perform capacity planning and storage management. - Create and maintain technical documentation and SOPs. - Collaborate with development and support teams on database-related issues and projects. Required Skills And Qualifications : - Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022). - Strong proficiency in T-SQL and SQL Server Management Studio (SSMS). - Experience with backup, restore, and recovery models. - Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. - Experience with monitoring tools like SQL Profiler, Extended Events, and third-party solutions (e. SolarWinds, Redgate). - Familiarity with performance tuning and optimization (PTO). - Experience working with Azure SQL Database, SQL Managed Instance, or AWS RDS is a plus. - Ability to handle multiple projects and priorities. - Strong communication and documentation skills. Preferred Qualifications : - Microsoft Certified : Azure Database Administrator Associate or similar certification. - Experience with SSIS, SSRS, and SSAS. - Knowledge of DevOps processes and CI/CD pipelines for database code deployment. - Exposure to cloud platforms (Azure, AWS, GCP).

Posted 3 weeks ago

Apply

4.0 - 7.0 years

8 - 12 Lacs

Hyderabad

Work from Office

We are looking for an experienced and detail-oriented SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, ensuring the availability and consistent performance of our applications. Key Responsibilities : - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Monitor database performance, implement changes, and apply new patches and versions when required. - Perform database backups, restores, and recovery. - Manage SQL Server security (authentication, permissions, roles). - Optimize SQL queries and indexes for better performance. - Troubleshoot database-related issues including system outages and performance bottlenecks. - Implement high availability (HA) and disaster recovery (DR) solutions. - Automate repetitive DBA tasks using T-SQL, PowerShell, or other tools. - Perform capacity planning and storage management. - Create and maintain technical documentation and SOPs. - Collaborate with development and support teams on database-related issues and projects. Required Skills And Qualifications : - Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022). - Strong proficiency in T-SQL and SQL Server Management Studio (SSMS). - Experience with backup, restore, and recovery models. - Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. - Experience with monitoring tools like SQL Profiler, Extended Events, and third-party solutions (e. SolarWinds, Redgate). - Familiarity with performance tuning and optimization (PTO). - Experience working with Azure SQL Database, SQL Managed Instance, or AWS RDS is a plus. - Ability to handle multiple projects and priorities. - Strong communication and documentation skills. Preferred Qualifications : - Microsoft Certified : Azure Database Administrator Associate or similar certification. - Experience with SSIS, SSRS, and SSAS. - Knowledge of DevOps processes and CI/CD pipelines for database code deployment. - Exposure to cloud platforms (Azure, AWS, GCP).

Posted 1 month ago

Apply

7.0 - 10.0 years

9 - 12 Lacs

Ahmedabad

Work from Office

We are looking for an experienced and detail-oriented SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, ensuring the availability and consistent performance of our applications. Key Responsibilities : - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Monitor database performance, implement changes, and apply new patches and versions when required. - Perform database backups, restores, and recovery. - Manage SQL Server security (authentication, permissions, roles). - Optimize SQL queries and indexes for better performance. - Troubleshoot database-related issues including system outages and performance bottlenecks. - Implement high availability (HA) and disaster recovery (DR) solutions. - Automate repetitive DBA tasks using T-SQL, PowerShell, or other tools. - Perform capacity planning and storage management. - Create and maintain technical documentation and SOPs. - Collaborate with development and support teams on database-related issues and projects. Required Skills And Qualifications : - Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022). - Strong proficiency in T-SQL and SQL Server Management Studio (SSMS). - Experience with backup, restore, and recovery models. - Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. - Experience with monitoring tools like SQL Profiler, Extended Events, and third-party solutions (e. SolarWinds, Redgate). - Familiarity with performance tuning and optimization (PTO). - Experience working with Azure SQL Database, SQL Managed Instance, or AWS RDS is a plus. - Ability to handle multiple projects and priorities. - Strong communication and documentation skills. Preferred Qualifications : - Microsoft Certified : Azure Database Administrator Associate or similar certification. - Experience with SSIS, SSRS, and SSAS. - Knowledge of DevOps processes and CI/CD pipelines for database code deployment. - Exposure to cloud platforms (Azure, AWS, GCP).

Posted 1 month ago

Apply

7.0 - 10.0 years

8 - 12 Lacs

Chennai

Work from Office

We are looking for an experienced and detail-oriented SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, ensuring the availability and consistent performance of our applications. Key Responsibilities : - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Monitor database performance, implement changes, and apply new patches and versions when required. - Perform database backups, restores, and recovery. - Manage SQL Server security (authentication, permissions, roles). - Optimize SQL queries and indexes for better performance. - Troubleshoot database-related issues including system outages and performance bottlenecks. - Implement high availability (HA) and disaster recovery (DR) solutions. - Automate repetitive DBA tasks using T-SQL, PowerShell, or other tools. - Perform capacity planning and storage management. - Create and maintain technical documentation and SOPs. - Collaborate with development and support teams on database-related issues and projects. Required Skills And Qualifications : - Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022). - Strong proficiency in T-SQL and SQL Server Management Studio (SSMS). - Experience with backup, restore, and recovery models. - Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. - Experience with monitoring tools like SQL Profiler, Extended Events, and third-party solutions (e. SolarWinds, Redgate). - Familiarity with performance tuning and optimization (PTO). - Experience working with Azure SQL Database, SQL Managed Instance, or AWS RDS is a plus. - Ability to handle multiple projects and priorities. - Strong communication and documentation skills. Preferred Qualifications : - Microsoft Certified : Azure Database Administrator Associate or similar certification. - Experience with SSIS, SSRS, and SSAS. - Knowledge of DevOps processes and CI/CD pipelines for database code deployment. - Exposure to cloud platforms (Azure, AWS, GCP).

Posted 1 month ago

Apply

7.0 - 10.0 years

8 - 12 Lacs

Mumbai

Work from Office

Job Description : We are looking for an experienced and detail-oriented SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, ensuring the availability and consistent performance of our applications. Key Responsibilities : - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Monitor database performance, implement changes, and apply new patches and versions when required. - Perform database backups, restores, and recovery. - Manage SQL Server security (authentication, permissions, roles). - Optimize SQL queries and indexes for better performance. - Troubleshoot database-related issues including system outages and performance bottlenecks. - Implement high availability (HA) and disaster recovery (DR) solutions. - Automate repetitive DBA tasks using T-SQL, PowerShell, or other tools. - Perform capacity planning and storage management. - Create and maintain technical documentation and SOPs. - Collaborate with development and support teams on database-related issues and projects. Required Skills And Qualifications : - Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022). - Strong proficiency in T-SQL and SQL Server Management Studio (SSMS). - Experience with backup, restore, and recovery models. - Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. - Experience with monitoring tools like SQL Profiler, Extended Events, and third-party solutions (e. SolarWinds, Redgate). - Familiarity with performance tuning and optimization (PTO). - Experience working with Azure SQL Database, SQL Managed Instance, or AWS RDS is a plus. - Ability to handle multiple projects and priorities. - Strong communication and documentation skills. Preferred Qualifications : - Microsoft Certified : Azure Database Administrator Associate or similar certification. - Experience with SSIS, SSRS, and SSAS. - Knowledge of DevOps processes and CI/CD pipelines for database code deployment. - Exposure to cloud platforms (Azure, AWS, GCP).

Posted 1 month ago

Apply

4.0 - 7.0 years

8 - 12 Lacs

Kolkata

Work from Office

We are looking for an experienced and detail-oriented SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, ensuring the availability and consistent performance of our applications. Key Responsibilities : - Install, configure, and maintain SQL Server instances (on-premises and/or cloud). - Monitor database performance, implement changes, and apply new patches and versions when required. - Perform database backups, restores, and recovery. - Manage SQL Server security (authentication, permissions, roles). - Optimize SQL queries and indexes for better performance. - Troubleshoot database-related issues including system outages and performance bottlenecks. - Implement high availability (HA) and disaster recovery (DR) solutions. - Automate repetitive DBA tasks using T-SQL, PowerShell, or other tools. - Perform capacity planning and storage management. - Create and maintain technical documentation and SOPs. - Collaborate with development and support teams on database-related issues and projects. Required Skills And Qualifications : - Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022). - Strong proficiency in T-SQL and SQL Server Management Studio (SSMS). - Experience with backup, restore, and recovery models. - Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. - Experience with monitoring tools like SQL Profiler, Extended Events, and third-party solutions (e. SolarWinds, Redgate). - Familiarity with performance tuning and optimization (PTO). - Experience working with Azure SQL Database, SQL Managed Instance, or AWS RDS is a plus. - Ability to handle multiple projects and priorities. - Strong communication and documentation skills. Preferred Qualifications : - Microsoft Certified : Azure Database Administrator Associate or similar certification. - Experience with SSIS, SSRS, and SSAS. - Knowledge of DevOps processes and CI/CD pipelines for database code deployment. - Exposure to cloud platforms (Azure, AWS, GCP).

Posted 1 month ago

Apply

6.0 - 10.0 years

8 - 12 Lacs

Hyderabad

Work from Office

A Database Administrator (DBA) is responsible for managing, securing, and optimizing databases to ensure high availability, performance, and data integrity. This role involves database installation, maintenance, backup strategies, query optimization, and disaster recovery planning across SQL and NoSQL databases. Mandate Skills for DBA : - Clustering - Shardening - Relational DB : Postgree sql , MYSql - Nosql DB : MongoDB, Casandra, Redis - Tool : Nagios, Prometheus, Zabbix ( any other tools if not anyone of these) Key Responsibilities : - Collaborate with software developers, system administrators, and other IT teams to ensure the database environment supports applications and business needs. - Create and maintain detailed documentation for database configurations, procedures, and best practices. - Install, configure, and maintain databases (SQL and NoSQL) to ensure high availability, performance, and reliability. - Perform regular database backups, ensuring data integrity, and restore capabilities. - Manage database migrations, upgrades, and patches. - Monitor database performance and optimize queries, indexes, and resources for optimal speed and efficiency. - Implement and maintain database security policies, including user permissions, encryption, and access controls. - Ensure the consistency and integrity of data through regular integrity checks. - Implement and test disaster recovery plans, backup strategies, and point-in-time recovery. Requirements : Experience : - 5 - 7 Years of experience in related roles. - Familiarity with tools like SQL Profiler, EXPLAIN ANALYZE, and Query Performance Analyzer for profiling and analyzing queries. - Proficiency with tools like Nagios, Prometheus, Zabbix, New Relic, or Datadog for database performance monitoring. - Knowledge of backup automation tools and scripts for scheduled backups and retention management. Skills and Competencies : - Relational DB : PostgreSQL, MySQL, MariaDB, SQLite. - NoSQL Databases : MongoDB, Cassandra, Redis, Elasticsearch. - Expertise in designing normalized database schemas, including defining entities, relationships, and integrity constraints. - Expertise in writing and optimizing SQL queries for performance, including complex joins, subqueries, and indexing strategies. - Proficiency in creating and managing indexes to improve database query performance. - Implementing regular backups (full, differential, incremental) and ensuring a recovery plan for data restoration. - Managing user permissions, roles, and database access policies. - Understanding encryption techniques for data-at-rest and data-in-transit. - Replication : Configuring and managing database replication (master-slave, peer-to-peer) for fault tolerance. - Clustering : Expertise in database clustering and load balancing techniques for ensuring high availability. - Failover Mechanisms : Implementing automatic failover systems for zero downtime in case of database failures. Education & Qualifications : - Preferably BTECH or suitable tech qualification.

Posted 1 month ago

Apply

7.0 - 10.0 years

7 - 11 Lacs

Gurugram, Gurgaon/Gurugram

Work from Office

Role Overview : The ideal candidate will have hands-on experience and an SME in maintaining databases, with a primary focus on performance, optimization, troubleshooting, high availability, disaster recovery, and automation. With deep expertise in Open Database technologies of PostgreSQL, Redis and MongoDB with additional expertise in containerization and orchestration tools like Docker and Kubernetes. Key Responsibilities : 1. Database Maintenance & Administration : - Perform routine maintenance tasks including backup, recovery, patching, and performance tuning. - Conduct standard database maintenance and administration tasks with attention to detail. - Monitor database activity, health, and performance, using database management system software and tools to collect performance statistics. - Optimize database performance, plan for forecast resource needs, and recommend corrective actions. - Ensure database high availability, replication, failover, and clustering. - Develop and configure tools to automate database administration tasks, enhancing efficiency and minimizing downtime. - Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects. - Implement disaster recovery strategies and maintain data integrity across environments. 2. Incident Management & Troubleshooting : - Handle critical escalations and complex troubleshooting for database issues. - Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues. - Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis). 3. Backup, Recovery & Disaster Recovery : - Design and implement backup strategies and disaster recovery plans. - Ensure data integrity, redundancy, and compliance with RPO/RTO requirements. 4. Containerization & Orchestration : - Manage databases using Docker and Kubernetes to ensure scalability and resilience. - Optimize containerized database solutions for performance optimization. - Implement CI/CD pipelines for automated deployment and maintenance of databases within containerized environments. 5. Collaboration & Communication : - Work closely with application teams to ensure seamless integration and optimal performance by understanding business logic, data models, and query patterns. - Optimize database schema and queries for application performance improvement. - Interact with customers, suppliers, and partners to deliver effective database maintenance. 6. Documentation & Reporting : - Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides. - Prepare reports detailing system health, performance metrics, and improvement plans. Required Skills and Qualifications : - Database Technologies : Deep knowledge of PostgreSQL, Redis and MongoDB. - Containerization & Orchestration : Hands-on experience with Docker and Kubernetes for deploying and managing databases. - Infrastructure and Application Integration : Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows. - Performance Tuning & Optimization : Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms.

Posted 1 month ago

Apply

8.0 - 12.0 years

6 - 10 Lacs

Bengaluru

Work from Office

Position Overview : You will be responsible for creating and managing databases like MongoDB, Maria, and Oracle databases. We greatly value teamwork, so working with developers, debugging, and helping them tune their queries is a highly valued facet of the DBE role. You never will be working alone you will have the skillset of many talented engineers and system admins to draw upon when you need it. Roles and Responsibilities : - Assist in design and development of database systems. - Optimize database systems for performance and reliability. - Perform database maintenance and troubleshooting activities. - Test database systems and perform bug fixes. - Provide database solutions based on technical documents and business requirements. - Develop database functions, scripts, stored procedures and triggers to support application development. - Provide technical assistance to resolve all database issues related to performance, capacity and access. - Ensure data integrity and quality in database systems. - Maintain standard policies for database development activities. - Identify and rectify database errors in a timely manner. - Create physical and logical database models as per the business requirements. - Manage and monitor performance, capacity and security of database systems. - Prepare documentations regarding database design, configuration and change management tasks. - Mentor database administrators to manage the company databases effectively. - Perform data back-up and archival on a regular basis. - Willing to take on challenging tasks under pressure. - Provide 24x7 on-call support in rotation. Must Have Skills : - Candidate with overall 8+ years experience with 3+years in database engineering, administration, and support and should have a minimum of 3+ years specifically in Mongo, Maria, and Oracle DB databases. - Expertise in Mongo/Maria/MySQL DB administration in a production environment - Must have hands-on noSQL experience from evaluation of new frameworks to deployment, maintenance, and performance tuning of clusters. - Solid understanding of SQL and noSQL landscape and available frameworks. - Strong in Linux and network maintenance. - Proficiency in one or more scripting languages, including Perl, Python, and Shell. - Strong SQL skills and experience. Good to Have Skills : - Proficiency with Elastic and Redis is a big plus. Qualification : - Bachelor of Science in Computer Science or equivalent technical training and professional work experience.

Posted 1 month ago

Apply

6.0 - 10.0 years

6 - 10 Lacs

Pune, Maharashtra, India

On-site

Roles & Responsibilities: Oracle Warehouse Builder, OWB, Oracle Workflow Builder, Oracle TBSS Oracle Warehouse Builder 9i (Client Version 9.0.2.62.3/Repository Version 9.0.2.0.0) Oracle Warehouse Builder 4 Oracle Workflow Builder 2.6.2 Oracle Database 10gTNS for IBM/AIX RISC System/6000Version 10.2.0.5.0 - Production More than 5 years experience on Oracle Warehouse Builder (OWB) and Oracle Workflow Builder Expert Knowledge on Oracle PL/SQL to develop individual code objects to entire DataMart's. Scheduling tools Oracle TBSS (DBMS_SCHEDULER jobs to create and run) and trigger based for file sources based on control files. Must have design and development experience in data pipeline solutions from different source systems (FILES, Oracle) to data lakes. Must have involved in creating/designing Hive tables and loading analyzing data using hive queries. Must have knowledge in CA Workload Automation DE 12.2 to create jobs and scheduling. Extensive knowledge on entire life cycle of Change/Incident/Problem management by using ServiceNow. Oracle Warehouse Builder 9i (Client Version 9.0.2.62.3/Repository Version 9.0.2.0.0). Oracle Warehouse Builder 4 Oracle Workflow Builder 2.6.2 Oracle Database 10gTNS for IBM/AIX RISC System/6000Version 10.2.0.5.0 - Production. Oracle Enterprise Manager 10gR1.(Monitoring jobs and tablespaces utilization) Extensive knowledge in fetching Mainframe Cobol files(ASCII AND EBSDIC formats) to the landing area and processing(formatting) and loading(Error handling) of these files to oracle tables by using SQL*Loader and External tables. Extensive knowledge in Oracle Forms 6 to integrate with OWB 4. Extensive knowledge on entire life cycle of Change/Incident/Problem management by using Service-Now. work closely with the Business owner teams and Functional/Data analysts in the entire development/BAU process. Work closely with AIX support, DBA support teams for access privileges and storage issues etc. work closely with the Batch Operations team and MFT teams for file transfer issues. Migration of Oracle to Hadoop eco system: Must have working experience in Hadoop eco system elements like HDFS, MapReduce, YARN etc. Must have working knowledge on Scala & Spark Data frames to convert the existing code to Hadoop data lakes. Must have design and development experience in data pipeline solutions from different source systems (FILES, Oracle) to data lakes. Must have involved in creating/designing Hive tables and loading analyzing data using hive queries. Must have knowledge in creating Hive partitions, Dynamic partitions and buckets. Must have knowledge in CA Workload Automation DE 12.2 to create jobs and scheduling. Use Denodo for Data virtualization to the required data access for end users.

Posted 1 month ago

Apply

5.0 - 8.0 years

8 - 14 Lacs

Coimbatore

Work from Office

Shift time : us - 7.30pm to 4.30am ist Education : Bachelor's degree in Computer Science, Information Technology, or a related field. Job description : We are looking for an experienced Core SQL Database Administrator (DBA) to manage and maintain our critical SQL Server databases. The ideal candidate will have in-depth knowledge of database design, performance tuning, and troubleshooting, along with a strong commitment to ensuring data integrity and system availability. Required Skills & Qualifications : Experience : - Minimum of 5 years of hands-on experience managing SQL Server databases. - Strong knowledge of SQL Server architecture, database design, and administration. - Expertise in T-SQL for writing and debugging scripts, stored procedures, and triggers. - Proficiency in database performance tuning and optimization techniques. - Experience with high availability and disaster recovery setups, including Always On and failover clustering. - Familiarity with backup and recovery tools and strategies. - Knowledge of security protocols and compliance frameworks for database systems. - Certification: Microsoft Certified: Azure Database Administrator Associate or similar. - Experience with cloud-based SQL services (Azure SQL Database, AWS RDS). - Exposure to monitoring tools like Redgate, SolarWinds DPA, or SQL Sentry. - Understanding of DevOps practices and database automation tools. - Knowledge of SSIS, SSRS, and Power BI for ETL and reporting tasks. - Experience with other Databases - MySQL, MongoDB etc

Posted 2 months ago

Apply
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Featured Companies