Senior DBA (Java)

Job Description

As a Staff/Senior Database Administrator with Java knowledge at CloudBees, your role involves designing, optimizing, and maintaining robust database systems while developing efficient backend services for reliability, performance, and scalability across the platform.**Key Responsibilities:**- Design, develop, and maintain scalable, high-performance database systems.- Optimize database architecture, queries, indexing, and ORM mappings (JPA/Hibernate) for maximum efficiency and data integrity.- High proficiency in writing, tuning, and debugging complex SQL queries and PL/SQL stored procedures, functions, and packages.- Monitor database usage, predict future storage and performance needs, and plan for capacity expansion.- Collaborate with application development teams to optimize database designs, queries, and stored procedures (PL/SQL).- Provide technical support for database environments, including testing and installation of DBMS upgrades.- Manage database deployments, monitoring, replication, backups, and performance tuning.- Troubleshoot and resolve performance bottlenecks and other database-related issues.- Collaborate with DevOps to automate and streamline database operations in CI/CD pipelines.- Enforce data integrity, security, and compliance with internal and regulatory standards.- Contribute to architecture design and decision-making across data and backend layers.- Build and enhance backend services and APIs using Java.- Use Liquibase (or similar tools) to manage schema versioning, migrations, and rollbacks.- Document database policies, procedures, and standards, and ensure they are followed.**Qualifications:****Required:**- 8 years of experience in database engineering (MSSQL, Oracle, PostgreSQL, or MySQL).- Deep expertise in SQL query optimization, indexing strategies, and database performance tuning.- Proven hands-on experience in Java backend development (minimum 2 years).- Solid understanding of JPA/Hibernate, including entity mapping, lazy loading, and cascading behaviors.- Practical experience with Liquibase or similar schema migration/versioning tools.- Proficiency in database deployment, replication, and upgrade processes.- Solid understanding of RESTful APIs, microservices, and distributed systems.- Skilled in diagnosing and resolving complex database and application performance issues.- Basic understanding of any one of the cloud services (AWS/GCP/etc.).- Excellent written and verbal communication skills.**Preferred (not mandatory):**- CI/CD practices.- Containerization (Docker, Kubernetes).- Experience working in Agile methodologies.- Advanced Java concepts.At CloudBees, you will work standard hours from 9 am to 6 pm, Mon-Fri, or as per business needs, with a remote work location/travel expectations. Benefits offered include health insurance, provident fund, paid leave, remote allowance, and a 5% variable bonus. All personal information collected during the recruitment process will be handled following applicable Indian data protection laws and Cloudbees privacy policy. This job description provides a summary of the position and its responsibilities, subject to evolution based on organizational requirements. As a Staff/Senior Database Administrator with Java knowledge at CloudBees, your role involves designing, optimizing, and maintaining robust database systems while developing efficient backend services for reliability, performance, and scalability across the platform.**Key Responsibilities:**- Design, develop, and maintain scalable, high-performance database systems.- Optimize database architecture, queries, indexing, and ORM mappings (JPA/Hibernate) for maximum efficiency and data integrity.- High proficiency in writing, tuning, and debugging complex SQL queries and PL/SQL stored procedures, functions, and packages.- Monitor database usage, predict future storage and performance needs, and plan for capacity expansion.- Collaborate with application development teams to optimize database designs, queries, and stored procedures (PL/SQL).- Provide technical support for database environments, including testing and installation of DBMS upgrades.- Manage database deployments, monitoring, replication, backups, and performance tuning.- Troubleshoot and resolve performance bottlenecks and other database-related issues.- Collaborate with DevOps to automate and streamline database operations in CI/CD pipelines.- Enforce data integrity, security, and compliance with internal and regulatory standards.- Contribute to architecture design and decision-making across data and backend layers.- Build and enhance backend services and APIs using Java.- Use Liquibase (or similar tools) to manage schema versioning, migrations, and rollbacks.- Document database policies, procedures, and standards, and ensure they are followed.**Qualifications:****Required:**- 8 years of experience in database engineering (MSSQL, Oracle, PostgreSQL, or MySQL).- Dee

Keyskills :
SQLPLSQLLiquibaseJavaRESTful APIsMicroservicesDistributed Systems