Application DBA and Developer

Job Description

*Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.As a member of the software engineering division, you will assist in defining and developing software for tasks associated with the developing, debugging or designing of software applications or operating systems. Provide technical leadership to other software developers. Specify, design and implement modest changes to existing software architecture to meet changing needs.Duties and tasks are varied and complex needing independent judgment. Fully competent in own area of expertise. May have project lead role and or supervise lower level personnel. BS or MS degree or equivalent experience relevant to functional area. 4 years of software engineering or related experience., *Preferred QualificationsThe Monitoring Automation team is looking for a proficient Application DBA to join our team of engineers enhancing control, reliability, stability and capabilities of our Monitoring tool sets and integration to other platforms such as provisioning automation and asset management.We would like to fill this role in Bangalore office.What Youll Do

• Assesments of DB usage patterns, analysis of pain points for example by examining common repetitive processes and their impact on the database and evolve improved housekeeping functionality and working through MOS and OEM Dev to define improvements we can implement within or outside the product portfolio
• Create self monitoring controls with appropriate alerting for key database metrics, growth and issues and develop suggestions or recommendations on changes to work processes that will improve DB utilisation
• Improve performance of extracts for other systems by clearer understanding of the underlying db and working with teams expecting to receive data via Goldengate or other methods
• Develop all updates, analytics and changes to be packaged and deployed through normal change processes in all managed OEM databases allowing for differences between EM versions and DB versions
• Evaluation of similar information across our non sql databases and advise, for example where multiple extracts are producing almost identical data
• Document and provide knowledge transfer to non-db team members who will act on the information or correlate to other monitoring performance metrics.
• Provide technical leadership in relation to OEM DBs to other software developers and consumers of the OEM Data.

Skills You Have: Education and Work Experience

• Bachelor s degree in Computer Science or equivalent work experience in a relevant field
• Experience in Database Administration with focus on managing it from application perspective, unpicking application DB schemas and following sql trace information to understand table relationships
• Experience developing within a continuous integration (CI) and continuous deployment (CD) pipeline with working knowledge of automation tools such as Jenkins
• Track record of delivering assigned projects on time, using Agile and DevOps practices

Skills You Have: Technical QualificationsPreference for demonstrated practical experience with the following technologies:

• Advanced Experience with DB tuning and required deep investigation for oltp processes into understanding underlying schemas
• Advanced level skill with PL/SQL
• Intermediate level skills working with chef and coding with python and ruby
• Familiarity with several scripting/automation languages (Perl, Bash, Powershell etc.)
• Intermediate level skill in operating system configuration for Linux and Windows

Skills You Have: Soft Skill Qualifications

• Good written and oral communication skills, should be able to clearly convey your thoughts and ideas to others
• Committed self-starter who enjoys working in a collaborative environment with personnel at all levels in the organization
• Ability to create troubleshooting guidelines and workflow instructions that can be handed off for others to follow

What The Perfect Candidate Will HaveIn addition to the knowledge, skills, and experience listed above, you will score some extra points if you also have:

• Oracle Database PL/SQL Developer Certified Professional
• Experience with ExaData hardware
• Experience with cloning, datapump, extracts and consolidations
• Experience with monitoring toolsets (RMM) and extrapolating underlying control requirements into discrete processes
• Hands-on experience with Chef, including writing cookbooks and developing Policy based configurations

Keyskills :
work processescomputer scienceautomation toolsproduct portfoliooral communicationknowledge transfercommunication skillssoftware engineeringtechnical leadershipsystem configuration