Exp required: 3+ Years
Job Description:
As a Database Engineer in the Production Support Team, you will be responsible for maintaining, troubleshooting, and optimizing the client’s database systems to ensure maximum availability and performance. You will work closely with cross-functional teams to address production issues promptly and implement solutions to prevent recurrence. The ideal candidate will have a strong background in SQL and experience with various database technologies, including CosmosDB, Azure Data Factory, Salesforce Database, etc.
Skills and Education:
- Bachelor’s degree in computer science, information technology, or a related field.
- Proven experience as a database engineer or similar role, with a focus on production support.
- Strong proficiency in SQL and experience with database query optimization techniques.
- Hands-on experience with CosmosDB, Azure Synapse Analytics, Azure Data Factory, Salesforce Database, or similar technologies.
- Familiarity with JIRA or other issue tracking systems for task management.
- Experience with data migration projects, including schema mapping, ETL processes, and validation.
- Knowledge of database monitoring and performance tuning tools.
- Understanding of database security principles and best practices.
- Excellent troubleshooting and problem-solving skills with attention to detail.
- Strong communication skills.
Key Responsibilities:
- Monitor and maintain the health and performance of database systems, including CosmosDB, Azure Synapse Analytics, Azure Data Factory, Salesforce Database, etc.
- Respond promptly to production issues and troubleshoot database-related problems to minimize downtime and ensure service continuity.
- Collaborate with developers, system administrators, and other stakeholders to implement database changes and optimizations.
- Develop and maintain scripts for database automation, backups, and routine maintenance tasks.
- Perform database capacity planning and recommend scaling strategies to accommodate growth.
- Implement and enforce security best practices to safeguard sensitive data stored in databases.
- Manage data migration projects, ensuring smooth and accurate transfers of data between systems.
- Utilize JIRA or similar tools to track and prioritize database-related tasks, incidents, and enhancements.
- Document database configurations, procedures, and troubleshooting steps for knowledge sharing and training purposes.
- Participate in on-call rotation and provide after-hours support as needed.