Database Analyst, Officer

Overview

The Database Analyst will support the day-to-day operation, stability, readiness, and recoverability of end-to-end QA environments used for application releases, patches, hotfixes, integration workflows, automation runs, and client-like testing scenarios. The role owns database and cache readiness, reliable test data, environment consistency, troubleshooting, and coordination across QA, Development, Release Management, and Platform teams.

What you'll do

• Provide daily operational support for end-to-end QA, integration, patch, hotfix, release candidate, smoke test, automation, and client-like non-production environments.
• Monitor database and cache readiness before, during, and after deployments by validating connectivity, data availability, schema compatibility, permissions, job completion, and environment-specific configuration.
• Serve as the primary database analyst for end-to-end environment-related issues by triaging incidents, identifying root cause, coordinating fixes, and communicating status to stakeholders.
• Support repeatable setup, teardown, refresh, and re-seeding activities so QA teams can execute tests against predictable and consistent baselines.
• Maintain environment parity across supported QA and end-to-end landscapes by identifying drift in schemas, configuration, reference data, security grants, or cache state.
• Define and own the unified data platform for QA, including architecture, governance, component reusability, synthetic data generation, data shape simulation, and data readiness.
• Enable self-service data capabilities across the broader end-to-end platform to support autonomous data provisioning for QA automation.
• Design and scale reusable test data services for workflow-driven automation by building data components, data profiles, synthetic data generation, and autonomous provisioning capabilities across UAP.
• Partner with pillar teams to enable data-aware, environment-independent workflow execution while ensuring data quality, security, governance, and CI/CD integration at enterprise scale.
• Support QA standards and act as a Data Steward; this is not solely a production DBA role.
• Generate synthetic test data and simulate data shapes to seed realistic client-like datasets for QA workflows, automation, regression, and end-to-end testing.

What you'll need

• Minimum 10 years of experience as a Database Analyst.
• Hands-on experience supporting database environments in QA, UAT, integration staging, and other non-production settings.
• Strong SQL skills, including joins, data validation queries, data comparison, troubleshooting, and ad hoc analysis.
• Practical experience with at least two of the following platforms: SQL Server, Oracle, Postgres, Cosmos DB, Snowflake, RocksDB, or Redis.
• Willingness to learn the remaining listed platforms.
• Ability to analyze data-flow issues across upstream and downstream systems, including batch jobs, workflow execution, and integration services.
• Familiarity with cloud-hosted environments, Azure services, Kubernetes-based deployments, data pipelines, or workflow orchestration tools.
• Proven ability to design and execute data-driven and workflow-driven automation test scenarios.
• Exposure to synthetic test data generation techniques, such as using Python, Faker libraries, or custom generators.
• Strong understanding of test data management concepts, including data setup, teardown, and dependency handling.
• Experience integrating automation with CI/CD pipelines.
• Experience working in data-intensive environments such as data warehouses, data lakes, and ETL or data pipeline systems.
• Strong experience writing complex SQL queries for large-scale data validation and reconciliation.
• Experience with data masking, anonymization, or production data scrubbing techniques, including maintaining referential integrity.
• Understanding of data security and data privacy best practices, especially related to handling sensitive or PII data.

Details

• Location: Hyderabad, India.