Job Description:
Primary Responsibilities:
- 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