5 Dba Support Jobs

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.

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.

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.

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.

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