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

Greetings from "HCL Software"

"HCL Software: - Is a Product Development Division of HCL Tech: That operates its primary Software business. At HCL Software we Develop, Market, Sell and Support over 20 Product families in the areas of Customer Experience, Digital Solutions, Secure DevOps, Security & Automation.

About Unica Product: - HCL Unica is Cloud Native: Adopt the whole new HCL Unica - Cloud native integrated marketing platform that can be deployed with the choice and flexibility to scale on any cloud & any environment - public, private, or hybrid - in minutes.

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 .

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.