FCI CCM
Website:
fci-ccm.com
Job details:
Description
Join the Legacy of Innovation with FCI-CCM :
FCI is a leader in Customer Communication Management (CCM), empowering enterprises to deliver hyper-personalized, omnichannel, and data-driven customer experiences through its flagship platform VARTA.
With a legacy dating back to 1959, FCI combines decades of communication expertise with modern technology to help clients across banking, insurance, telecom, utilities, and healthcare transform their customer engagement into a strategic growth engine.
Broad Function
We are seeking experienced Database Administrator with strong expertise in both SQL and NoSQL databases to manage, optimize, and secure our database infrastructure.
This role requires a hands-on professional who can write complex queries, optimize database performance, ensure regulatory compliance, and implement robust backup and disaster recovery strategies, you will be responsible for database consolidation, schema design and evaluation, performance tuning, query optimization, and overall database architecture.
You will work closely with development teams to review existing queries, suggest improvements, and ensure data consistency, integrity, and security across all database platforms.
Roles And Responsibilities (not Limited To)
Database Management & Architecture :
- Administer, maintain, and optimize SQL databases (MySQL, PostgreSQL, MS SQL Server, Oracle) and NoSQL databases (MongoDB, Cosmos DB, Document DB, Redis).
- Design and implement scalable database architectures for high volume data.
- Perform database upgrades, migrations, and patching in coordination with development and infrastructure teams.
- Manage database deployment topologies, data models, and application access patterns.
- Conduct capacity planning and infrastructure provisioning for current and future database needs.
Query Development & Optimization
- Write complex SQL queries, stored procedures, functions, triggers, and views for business-critical applications.
- Develop optimized NoSQL queries and aggregation pipelines for MongoDB and other document databases.
- Review and optimize existing queries written by development teams for performance improvements.
- Conduct query analysis using execution plans, profiling tools, and database monitoring solutions.
- Establish query coding standards and best practices for development teams.
- Provide mentorship and training to developers on efficient query writing techniques.
Performance Monitoring & Tuning
- Implement and maintain comprehensive database monitoring tools and dashboards.
- Identify and resolve performance bottlenecks through query optimization, indexing, and partitioning.
- Design and implement effective sharding strategies based on application requirements.
- Monitor individual shard performance and address bottlenecks in sharded architectures.
- Plan and execute data migration strategies between shards without service disruption.
- Optimize database configurations, memory allocation, and caching mechanisms.
- Conduct regular performance audits and implement proactive optimization measures.
Backup, Recovery & Business Continuity
- Develop and maintain comprehensive backup and recovery strategies for SQL and NoSQL databases.
- Implement automated backup solutions with appropriate retention policies.
- Conduct regular disaster recovery drills and testing of backup restoration procedures.
- Design and implement high availability solutions including replication, clustering, and failover mechanisms.
- Maintain documented recovery time objectives (RTO) and recovery point objectives (RPO).
- Participate actively in incident response and database recovery processes.
Security & Regulatory Compliance
- Implement and enforce database security best practices and industry standards.
- Manage role-based access controls (RBAC), user permissions, and authentication mechanisms.
- Implement data encryption at rest and in transit for sensitive information.
- Establish and maintain comprehensive audit trails for compliance requirements.
- Ensure database compliance with GDPR, HIPAA, SOC 2, ISO 27001, and other relevant regulations.
- Conduct regular security assessments, vulnerability scans, and remediation activities.
- Implement data masking and anonymization techniques for non-production environments.
- Prepare for and support regulatory audits and compliance reporting.
- Stay current with evolving regulatory requirements and implement necessary database controls.
Managed Database Services & Cloud Platforms
- Evaluate, implement, and manage cloud-managed database services (AWS RDS, Azure SQL Database, Azure Cosmos DB, Google Cloud SQL).
- Optimize cloud database costs through rightsizing and resource management.
- Implement hybrid cloud database architectures when required.
- Stay current with cloud database innovations and best practices.
Collaboration & Documentation
- Collaborate with Development, DevOps, and Support teams for seamless database integration.
- Provide technical guidance and support to application development teams.
- Maintain comprehensive documentation of database architectures, procedures, and configurations.
- Communicate effectively with clients to understand and address their database requirements.
- Create and maintain runbooks for common database operations and :
Desired Qualifications & Experience
- Bachelors/masters degree in computer science, Information Technology, Management Information Systems, or related field.
- 5+ years of hands-on experience as a Database Administrator in production environments.
- Expert-level proficiency in SQL query writing, optimization, and performance tuning.
- Strong command of SQL databases : MySQL, PostgreSQL, MS SQL Server, or Oracle.
- Proficiency in NoSQL databases : MongoDB, Cosmos DB, Redis or Document DB.
- Advanced knowledge of stored procedures, functions, triggers, and views development.
- Experience with database design, normalization, denormalization, and data modelling.
- Expertise in indexing strategies, query execution plans, and performance profiling.
- Strong understanding of database internals, storage engines, and transaction management.
CULTURAL TRAITS (Critical Fit Requirements)
We are looking for someone who :
- Takes charge of Ownership & accountability.
- Security-first mindset.
- Performance & quality focused.
- Compliance-driven approach.
- Process & documentation oriented.
- Adaptable to new tools/tech.
- Domain-Driven Technical Expertise.
Security & Compliance
- In-depth knowledge of database security, encryption, and access control mechanisms.
- Experience implementing GDPR, HIPAA, SOC 2, PCI-DSS, and ISO 27001 compliance requirements.
- Understanding of audit logging, compliance reporting, and regulatory frameworks.
- Experience with data privacy, data masking, and sensitive data management.
Backup & Recovery
- Advanced knowledge of backup strategies, disaster recovery planning, and business continuity.
- Experience with high availability solutions : replication, clustering, and failover mechanisms.
- Proven track record of successful disaster recovery testing and execution.
Performance & Monitoring
- Expertise in database performance monitoring, tuning, and optimization.
- Experience with monitoring tools : Datadog, New Relic, Prometheus, Grafana, or similar.
- Proficiency in identifying and resolving database bottlenecks proactively.
Automation & Scripting
- Strong scripting skills in Python, PowerShell, Bash, or similar languages.
- Experience with automation tools : Ansible, Puppet, Terraform, or Chef.
- Knowledge of CI/CD pipelines and database DevOps practices.
Benefits
The company offers a range of employee benefits including :
- Cashless medical insurance for employees, spouses, and children.
- Accidental insurance coverage.
- Life insurance coverage.
- Retirement benefits including Provident Fund (PF) and Gratuity.
- ESI-.
- Complementary meal coupons.
- Company-paid transportation.
- Sodexo benefits for income tax savings.
- Paternity & Maternity Leave Benefit.
- National Pension Saving.
- EL encashment.
- Sick Leave.
(ref:hirist.tech)
Click on Apply to know more.