Broad Function:
We are Seeking a Dedicated and Experienced Database Administrator to monitor end-to-end tasks related to database consolidation, schema evaluation, and overall database architecture optimization. This role is designed to troubleshoot problems and work on development as well and make sure that data is consistent in the database and that it is clearly defined.
Data Base Administrator manages database deployment topologies, data models, and application access patterns. We are looking for candidates responsible for capacity planning and infrastructure provisioning.
Roles and Responsibilities:
-
Database Management: Administer, maintain, and optimize SQL databases (e.g., My SQL, Postgre SQL, Oracle) and No SQL databases (e.g., Mongo DB, Cosmos DB, Document DB, Redis), Perform database upgrades, migrations, and patching in coordination with development and infrastructure teams.
-
Performance Monitoring: Implement and maintain database monitoring tools to ensure optimal performance. Identify and resolve performance bottlenecks, query optimization, Partitioning, and indexing strategies. Design and implement effective sharing strategies based on the specific requirements of the application. Monitoring the performance of individual shards, and addressing bottlenecks that may arise in a sharded architecture Should be capable of planning and executing data migration strategies between shards without disrupting the overall system
-
Backup and Recovery: Develop and maintain robust backup and recovery strategies for both SQL and No SQL databases, Conduct regular testing of backup and recovery procedures.
-
Compliance and Security: Implement and enforce security best practices for database systems. Manage database access controls, encryption, and audit trails, ensure databases adhere to relevant standards (e.g., GDPR, HIPAA).
-
High Availability and Disaster Recovery: Design and implement high availability and disaster recovery solutions, Participate in incident response and recovery processes.
-
Automation: Implement automation scripts for routine database tasks using tools like Ansible, Puppet, or similar, Drive efforts to automate repetitive tasks for efficiency.
-
Collaboration: Collaborate with cross-functional teams including Development, Dev Ops, and Support to ensure seamless integration of database systems with the overall infrastructure. If working with clients, communicate effectively to understand and address their database needs.
-
Managed Database Services: Evaluate, implement, and manage managed database services (e.g., AWS RDS, Azure Cosmos DB), Stay current with industry trends and advancements in managed database technologies.
- Should be able to write Complex queries, Stored Procedure, and functions.
Requirements
Desired Candidate profile:
-
Bachelor’s degree in computer science, information technology, management information systems or a similar field.
-
Excellent technical skills in a range of programming languages.
-
Strong command of SQL and No SQL Databases
-
Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
-
Good technical knowledge of databases and query languages.
-
Strong verbal and written communication skills, to explain to users how the database works and to keep clear records of changes you have made.
- Good Knowledge of Database Design & Modelling.
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