Jobs
>
Cochin

    Senior Application DBA - kochi, India - Intelligent Office

    Intelligent Office
    Intelligent Office kochi, India

    2 hours ago

    Default job background
    Description

    Role Purpose:

    We are currently seeking a highly skilled and experienced Senior Application Database Administrator (DBA) to join our dynamic team. As a Senior DBA, you will play a pivotal role in ensuring the performance, reliability, and scalability of our database systems while leading efforts to optimize and maintain our SQL infrastructure. The ideal candidate will possess a strong background in SQL experience, database administration, optimization, and maintenance, coupled with expertise in AWS cloud services, particularly RDS advanced configuration, PostgreSQL, Aurora, and a keen willingness to learn and lead in Amazon DynamoDB or other AWS cloud-native database technologies.

    Key Responsibilities :

    Database Design and Architecture :

  • Lead database design and architecture discussions, collaborating with application developers, architects, and infrastructure teams to ensure optimal database solutions.
  • Design and implement database schemas, tables, indexes, views, stored procedures, and functions to support application requirements efficiently.
  • Evaluate and recommend database technologies, tools, and methodologies enhance performance, scalability, and reliability, leveraging expertise in SQL and cloud-native solutions such as AWS RDS, PostgreSQL, Aurora, and DynamoDB.

    • Database Administration :

  • Perform database installations, upgrades, and patching in accordance with best practices and security guidelines.
  • Configure and maintain database instances, including monitoring, tuning, backup, recovery, and disaster recovery strategies.
  • Manage database security, access controls, permissions, and auditing to ensure data integrity and compliance with regulatory requirements.

    • Performance Tuning and Optimization :

  • Identify, analyse, and rectify performance bottlenecks in SQL queries through comprehensive SQL profiling, query optimization, and utilization of performance monitoring tools.
  • Develop and implement performance tuning strategies aimed at enhancing database queries, indexes, and configurations to achieve superior response times and optimize resource utilization.
  • Lead capacity planning and scalability assessments to facilitate seamless expansion of applications and data volumes, ensuring robust support for evolving business needs.

    • High Availability and Disaster Recovery :

  • Implement and manage high availability solutions, such as database clustering, replication, and failover mechanisms, to minimize downtime and ensure business continuity.
  • Develop and maintain disaster recovery plans and procedures, including regular testing and validation of backup and recovery processes.

    • Monitoring and Automation :

  • Establish proactive monitoring and alerting systems to detect and respond to database-related issues in a timely manner.
  • Automate routine database administration tasks, such as backups, maintenance, and provisioning, using scripting languages and automation frameworks.

    • Documentation and Knowledge Sharing :

  • Maintain comprehensive documentation of database configurations, processes, and procedures for reference and training purposes.
  • Share expertise and best practices with other team members, providing mentorship and training on database technologies and methodologies.

    • Essential Skills

  • Bachelor's degree in computer science, Information Technology, or related field.
  • In-depth knowledge of SQL language, including complex query optimization, indexing, and performance tuning techniques.
  • Proficiency in database design, schema modelling, and database architecture principles.
  • Strong proficiency in AWS cloud services, particularly RDS advanced configuration, and experience with PostgreSQL, Aurora, or similar database technologies.
  • Hands-on experience with database installation, configuration, and administration in both on-premises and cloud environments (e.g., AWS, Azure, GCP).
  • Strong understanding of high availability, disaster recovery, and backup/restore methodologies for database systems.
  • Knowledge of database security best practices and regulatory compliance standards.
  • Excellent analytical and problem-solving skills, with a keen attention to detail, and the ability to troubleshoot complex database issues under pressure.
  • Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
  • Passion for staying up-to-date with the latest cloud database technologies and best practices.
  • Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, Oracle Certified Professional (OCP), or equivalent, are a plus.

    • Experience

  • 10+ years of experience in database administration, with a focus on SQL-based database systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL).
  • Experience with database monitoring and performance tuning tools (e.g., SQL Profiler, Performance Monitor, AWR, EXPLAIN).
  • Experience with Amazon DynamoDB or willingness to learn and lead in cloud-native database technologies.

    • Additional Information :

  • This is a senior-level position requiring a deep understanding of database technologies and a proven track record of successfully managing and optimizing database systems in enterprise environments.
  • The Senior Application DBA will work closely with software development teams, system administrators, and business stakeholders to support the organization's strategic objectives through effective database management and optimization.
  • This role may involve occasional after-hours support and participation in on-call rotations to address critical database issues and perform maintenance activities outside of regular business hours.
  • Anlage Infotech

    Oracle Database Administrator

    1 week ago

    Anlage Infotech Kochi, India

    Client : Translab Technologies · Location : Kochin,kerala · Oracle DBA L2 · Max budget : 12 LPA · Relevant exp : 4+ yrs · **Job Description**: · ORACLE DBA Professionals having good understanding of RDBMS concepts. Experience in · installation, configuration, maintenance, Upgrada ...

  • ChiSquarelabs

    Database Administrator

    2 days ago

    ChiSquarelabs Kochi, India

    **Engineer (DBA - Postgres/MongoDB)** · - Full-time · **About this Job**: · We're looking for a database administrator.The individual in this role will be responsible for design, implementation and administration for our databases, as well as mentoring of lower level database adm ...

  • PAMP TECHNOLOGIES

    Oracle DBA

    2 hours ago

    PAMP TECHNOLOGIES kochi, India

    Qualifications: · Minimum of 10+ Years as Oracle Database Administrator · Good hands-on Oracle Core DBA and Oracle Application · Must Have : At least one or two DB migration to have done · Experience on Oracle EBS R12.1, R12.2 implementations with 19c RAC, · Upgradation of ...