Senior Database Administrator

Position: FCI CCM - Senior Database Administrator
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 No

SQL 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, Postgre

SQL, MS SQL Server, Oracle) and No

SQL databases (Mongo

DB, 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 No

SQL queries and aggregation pipelines for Mongo

DB 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 No

SQL 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, Dev Ops, and Support teams for seamless database integration.
Provide technical guidance and support to application development teams.
Maintain comprehensive documentation of database architectures,…