Database Administration Developer
- Franconnect
- 3 - 6 years
- Noida, Gurugram
- 1 month ago
- Email to a friend
- Report this job
Job Description
The Candidate
Is Database your passion? If yes, this could be the best place to explore the possibilities in the database world. Where we work on Databases configured on Bare Metal, Virtual environment, Cloud, RDBMS, NOSQL databases and data warehouse. Do you enjoy coaching and teaching junior members? If so, bring your talent to Franconnect, and join our growing engineering team.
Job Description
As a Database Base Expert, you will be expected to Coordinate and manage database activities to support application development projects. Work with programmers, QA team and security personnel to execute database projects according to customer requirements.
Provide functional and technical support to ensure performance, operation, and stability of database systems, respond to database related queries and issues in a timely fashion, monitor database activities on daily basis to ensure the reliability and security of databases. Prepare database reports for managers as needed. Monitor database performance, implement changes and check on new patches and versions when required
Primary Skills
1. MySQL
Key Responsibilities:
- Design, develop, and maintain MySQL databases with optimal performance.
- Experience with cloud-based database services (AWS RDS).
- Write efficient SQL queries, stored procedures, and triggers.
- Perform database tuning, optimization, and ensure high availability.
- Troubleshoot and resolve database-related issues, including performance bottlenecks, deadlocks, and connection issues.
- Coordinate and execute database upgrades, migrations, and patching while ensuring minimal downtime and no data loss.
- Work with development teams to integrate MySQL databases with back-end applications and services.
- Work with business analysts and project managers to translate business requirements into effective database solutions.
- Maintain documentation for all database processes, configurations, and standards.
- Monitor database performance and implement optimizations such as indexing, query optimization, and data partitioning to improve response times.
- Perform regular database health checks, identifying and resolving bottlenecks to ensure high availability and reliability.
2. MongoDB
Key Responsibilities:
- Good understanding of NoSQL principles and concepts, particularly in document-based databases.
- Design, develop, and optimize MongoDB database systems for scalable and high-performance applications.
- Good Knowledge in designing MongoDB data models, collections, and indexes.
- Familiarity with MongoDB Atlas Search.
- Conduct data migration and transformation from relational databases or other systems to MongoDB.
- Work with development teams to integrate MongoDB databases with back-end services and applications.
- Optimize database performance by analyzing query performance, creating indexes, and implementing shrading strategies.
- Monitor and manage the health of MongoDB clusters, ensuring high availability and fault tolerance.
3. AWS RDS knowledge
Key Responsibilities:
- Good experience managing databases on AWS, particularly with Amazon RDS, Amazon Aurora, and EC2.
- Good understanding of AWS services such as EC2, RDS, S3, IAM and CloudWatch.
- Experience with CloudWatch Logs for tracking and troubleshooting database logs, and CloudWatch Alarms for setting thresholds on key database metrics such as CPU utilization, memory usage, I/O operations, and latency.
Good to have
1. Amazon Redshift and PostgreSQL experience will be an additional advantage
2. Scripting
3. Python
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Developer / Engineer
Employement Type: Full time
Contact Details:
Company: FranconnectLocation(s): Noida, Gurugram
Keyskills: MySql Query Optimization Database Administration NoSQL Stored Procedures Database Design Mongodb Postgres Performance Tuning Redshift Database Development SQL
Similar positions
Franconnect
FranConnects franchise management software enables you to more effectively manage your franchise system, so you can focus on developing and delivering superior products and services. More than 600 franchisors and 110, 000 locations rely on FranConnect to grow the number of units and make them more...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in