Opportunity For Database Analyst - CST (Fort)

Database Analyst

Location: Mumbai

Experience: 3-6 years

Job Responsibilities:

• Monitor and optimize database performance, including query tuning, indexing strategies, and resource utilization. •

Ensure database security, implementing access controls, encryption, and compliance with data protection standards.

• Design and maintain backup and recovery plans, including automated scheduling, retention policies, and disaster recovery testing.
• Manage database reliability and uptime, proactively identifying risks and implementing failover strategies.
• Perform routine maintenance tasks, such as patching, re-indexing, and archiving.
• Create and maintain audit logs, tracking changes, access events, and system anomalies.
• Document database architecture, configurations, and operational procedures for internal and cross-team clarity.
• Plan and execute database upgrades and version migrations, ensuring minimal downtime and data integrity.
• Monitor storage usage and forecast capacity needs, optimizing for cost and performance.
• Support integration efforts, including API payload validation, transaction identifiers, and schema alignment.

Qualifications:

• 36 years of experience in database analysis, administration, or engineering.

• Strong proficiency in SQL Server, including performance tuning, security configuration, and backup strategies.

• Experience with database monitoring tools (e.g., SQL Profiler, Redgate, SolarWinds, or equivalent).

• Knowledge of database security best practices, including role-based access, encryption, and audit logging.

• Familiarity with version control and CI/CD pipelines for database deployments.

• Excellent documentation skills, including schema diagrams, SOPs, and change logs.

• Experience with storage planning, capacity forecasting, and cloud/on-prem hybrid setups.

• Comfortable communicating with cross-functional teams, translating technical constraints into actionable insights.

• Bonus: Experience with multi-tenant architecture, event tracking systems, or Data Lake integrations.