Job Description:
This role requires a service oriented attitude, high sense of ownership of the problems and requests assigned, focus on balancing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.
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 database design process and make suggestions/recommendations based on 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 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 situation demands
- Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
- Evaluation and recommendation of software products in 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:
- 8+ 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 are 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
Education and Experience:
- B.S./B.A. in Computer Science or Information Systems