Senior Oracle DB Engineer - Design & Maintenance

Job Description

Position Overview : You will be responsible for creating and managing databases like MongoDB, Maria, and Oracle databases. We greatly value teamwork, so working with developers, debugging, and helping them tune their queries is a highly valued facet of the DBE role. You never will be working alone you will have the skillset of many talented engineers and system admins to draw upon when you need it. Roles and Responsibilities : - Assist in design and development of database systems. - Optimize database systems for performance and reliability. - Perform database maintenance and troubleshooting activities. - Test database systems and perform bug fixes. - Provide database solutions based on technical documents and business requirements. - Develop database functions, scripts, stored procedures and triggers to support application development. - Provide technical assistance to resolve all database issues related to performance, capacity and access. - Ensure data integrity and quality in database systems. - Maintain standard policies for database development activities. - Identify and rectify database errors in a timely manner. - Create physical and logical database models as per the business requirements. - Manage and monitor performance, capacity and security of database systems. - Prepare documentations regarding database design, configuration and change management tasks. - Mentor database administrators to manage the company databases effectively. - Perform data back-up and archival on a regular basis. - Willing to take on challenging tasks under pressure. - Provide 24x7 on-call support in rotation. Must Have Skills : - Candidate with overall 8+ years experience with 3+years in database engineering, administration, and support and should have a minimum of 3+ years specifically in Mongo, Maria, and Oracle DB databases. - Expertise in Mongo/Maria/MySQL DB administration in a production environment - Must have hands-on noSQL experience from evaluation of new frameworks to deployment, maintenance, and performance tuning of clusters. - Solid understanding of SQL and noSQL landscape and available frameworks. - Strong in Linux and network maintenance. - Proficiency in one or more scripting languages, including Perl, Python, and Shell. - Strong SQL skills and experience. Good to Have Skills : - Proficiency with Elastic and Redis is a big plus. Qualification : - Bachelor of Science in Computer Science or equivalent technical training and professional work experience.