Oracle DBA

• Perform applications database administration( Oracle) functions including SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support
• Actively monitor databases servers and respond to any alerts
• Work with development teams in the database design process and make suggestions/recommendations based on the data manipulation needs of the application.
• Works with customers on fixing production issues
• Provide database support in all phases of SDLC
• Work with team members to come up with solutions in line with the group's standards
• Participate in 24X7 on-call rotation schedule for various production support, database maintenance, housekeeping and installs
• Collaborate with Operations Database group, Systems Administrators and Capacity Planning groups as and when the situation demands
• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
• Evaluation and recommendation of software products in the database management arena

• Should have strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time
• Proactive with strong team, interpersonal and communication skills
• Setup DR and HA strategy and support routine DR testing
• Establish database standards for operations, upgrades, migrations, and onboarding new applications and/or clients
• Write clear, concise, well-organized user documentation to maintain standards and procedures
• Balance various database infrastructure projects

Skills and Knowledge:

• 10+ years of experience in Oracle DBA with Exadata and RAC expertise
• 3+ years of DBA experience in other DBMS systems ( Postgres, MariaDB, SQL Server, and Snowflake)
• 5+ years of experience in Distributed replication technologies ( Oracle Goldengate, EDB Replication, etc)
• 5+ years of experience in the Mutual Fund /Financial Services industry is highly desired
• Ability to work well in a team environment, as well as maintaining a flexible attitude is a must
• Ability to develop and drive database administration strategies and initiatives as per the needs of the team
• Ability to quickly synthesize ideas, options, and thoughts into solutions to management to aid in decision-making