Senior Database Administrator

FCI CCM, Inc.; Dadri; On-site; INR 1,400,000 - 2,100,000; Full time

Benefits offered by this job

Cashless medical insurance

Accidental insurance

Life insurance

Provident Fund & Gratuity

Job summary

Friends Color Images Pvt Ltd in Noida, India seeks an experienced Database Administrator to manage SQL and NoSQL databases, optimize performance, and ensure data security. You will work closely with development teams to review queries, design scalable schemas, and implement backup/recovery strategies.

The role requires 5+ years of production DBA experience, strong SQL/NoSQL skills, and knowledge of cloud or on-premise deployments. This is a full-time position with competitive benefits.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, IT, MIS or related field.
• 5+ years of hands-on experience as a Database Administrator in production environments.
• Working knowledge of Kubernetes / Docker is a plus.
• Expert-level SQL query writing, optimization, and performance tuning.
• Strong command of SQL databases: MySQL, PostgreSQL, MS SQL Server or Oracle.
• Proficiency with NoSQL databases: MongoDB, Cosmos DB, Redis or Document DB.

Responsibilities

• Administer, maintain, and optimize SQL databases (MySQL, PostgreSQL, MS SQL Server, Oracle) and NoSQL databases (MongoDB, Cosmos DB, Document DB, Redis).
• Design scalable database architectures for high-volume data.
• Perform upgrades, migrations, and patching in coordination with teams.
• Manage deployment topologies, data models, and access patterns.
• Conduct capacity planning and infrastructure provisioning for DB needs.
• Write complex SQL queries, procedures, functions, and views.
• Develop optimized NoSQL queries and aggregation pipelines.
• Review and optimize existing queries for performance.

Skills

SQL

NoSQL

Query optimization

Database performance tuning

Kubernetes / Docker (基础)

Education

Bachelor’s or Master’s degree in Computer Science or related field

Tools

MySQL

PostgreSQL

MS SQL Server

Oracle

MongoDB

Cosmos DB

Redis

Job description

Friends Color Images Pvt Ltd | Full time

• Weekly Off 5 Day working with Saturday and Sunday off
• Work Experience 7-9 Years
• City Noida
• Country India
• Postal Code 201303

Job 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):

• 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
• 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 troubleshooting

Requirements

Desired Qualifications & Experience:

• Bachelor’s/master’s 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.
• Good to have working knowledge on Kubernetes/ Docker
• 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
• Performance & quality focused
• 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

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