Job Description :
Role: Sr. Oracle DBA
Location: Merrimack, NH
Tenure: 12+ Months/ Contract
Start: ASAP
Mode of Interview: 02 Video Rounds [1st with the manager followed by 2nd with a Lead on the Team]
End-Client Domain: Financial Services
Job Summary:
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:
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 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