HCL Unica Product _Sr. Database Administrator (SQL & NoSQL)_F2F Interview 10th Jan_Pune (Hinjawadi)

0 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Greetings from "HCL Software"

"HCL Software”: -


About Unica Product: -


Imp Note: Are you available for a F2F Interview on Saturday (10th Jan) In Pune HCL Software office?

Location/Venue: Mekong 2nd Floor, Embassy TechZone, Hinjewadi Rajiv Gandhi Infotech Park, Hinjawadi Phase 2, Pune, Maharashtra 411033.


Qualifications: -

We are looking for a Sr. Database Administrator (SQL & NoSQL) with 4+ Yrs experience in our Unica Product team who possess the following skills: -

Role Context: -

Own Database Administration and operational excellence for both SQL and NoSQL data stores across on-prem and cloud-managed environments. The DBA will partner with engineering, data, and QA teams to provide performance guidance, define operational runbooks, and ensure systems are tuned, resilient, secure, and calibrated for evolving workloads (ETL, APIs, analytics, and ML workloads where applicable).

Must Have: -

  • Strong DBA experience across at least one major RDBMS: PostgreSQL / MySQL / Oracle / SQL Server.

  • Practical experience with at least one NoSQL system: MongoDB / Cassandra / Redis / Elasticsearch (as applicable to your stack).

  • Advanced SQL expertise including execution plans, indexing strategies, lock analysis, and performance tuning.

  • Experience with cloud-managed database services on AWS/Azure/GCP:

  • Examples: RDS/Aurora, Azure SQL/Managed Instance, Cloud SQL, Cosmos DB, DynamoDB, etc.

  • Strong understanding of HA/DR patterns: replication, failover, backups, PITR, and recovery testing.

  • Operational discipline: change management, release readiness, environment standardization, SOPs/runbooks.

  • Delivery/DevOps fundamentals: Git-based configuration/versioning, CI/CD awareness for DB changes (migration tooling), automation mindset.

  • Non-technical: strong collaboration, ability to communicate performance recommendations clearly, ownership during incidents.

Key Responsibilities: -

  • Administer and support SQL and NoSQL databases across environments (DEV/QA/UAT/PROD).
  • Own database performance management: indexing, partitioning, query plan analysis, parameter tuning, and workload optimization.
  • Provide performance guidance to teams: schema design feedback, query rewrite recommendations, and access pattern optimization.
  • Define operational guidelines: backup/restore, DR, replication, patching, maintenance windows, capacity planning.
  • Calibrate systems for workload patterns: concurrency, connection pooling, cache sizing, I/O tuning, and resource governance.
  • Implement monitoring and alerting for DB health (availability, latency, slow queries, locks, storage).
  • Manage security: roles/permissions, encryption, key management integrations, auditing and compliance practices.
  • Support incident response: troubleshooting outages, RCA, preventive actions, and reliability improvements.
  • Collaborate with DevOps/SRE teams on infrastructure provisioning and automation.


Good To Have: -

  • Experience with data platforms/warehouses: Snowflake/Redshift/BigQuery/Synapse.
  • Knowledge of database migration tooling (Flyway/Liquibase) and schema versioning practices.
  • Observability tooling exposure (CloudWatch/Azure Monitor/Stackdriver, Prometheus, Grafana, ELK).
  • Familiarity with Kubernetes operators for databases or DB on containers (where relevant).
  • Exposure to ETL workload patterns and data engineering ecosystems.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
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.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You