Sign upLog in

Oracle DBA

HCL Global Systems Inc.

WLK, MMK and SMT, TX

Apply
JOB DETAILS
SKILLS
Amazon Elastic Compute Cloud (EC2), Amazon Relational Database Service (RDS), Amazon Web Services (AWS), Brokerage, Capacity Management, Cloud Computing, Code Reviews, Computer Science, Data Modeling, Database Administration, Database Design, Database Technology, Documentation Standards, Establish Priorities, Financial Services, Housekeeping/Cleaning, Identify Issues, Information Technology & Information Systems, Internet Security, Linux Operating System, Microsoft Windows Azure, Microsoft Windows Operating System, Multitasking, Mutual Funds, On Call, Onboarding, Oracle, Oracle DBA (Database Administrator), Oracle PL-SQL, Oracle RAC (Real Application Clusters), Organizational Skills, Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Production Schedule, Production Support, Query Analysis, Query Optimization, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Snowflake Schema, Software Administration, Software Design, Software Development Lifecycle (SDLC), Systems Administration/Management, Team Player, Time Management, Unix Shell Programming, User Documentation
LOCATION
WLK, MMK and SMT, TX
POSTED
30+ days ago
The Role
The Common Data Platform team within Institutional Brokerage Database Service organization needs a highly competent and motivated Senior Database Administrator with deep technical skills to manage multiple highly complex and critically important database platforms. This position would provide an excellent opportunity to work on leading database technologies like Oracle RAC, Oracle Exadata, Oracle GoldenGate, AWS EC2/RDS, Snowflake, etc. It is a great place to experience & learn end to end enterprise database service capabilities! This role requires a service-oriented mentality, high sense of ownership of the projects, problems, and requests assigned.
Responsibilities
  • Perform applications database administration (Oracle & Snowflake) services including SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support & Engineering.
  • Proactively monitor databases servers and respond to any alerts
  • Provide database support in all phases of SDLC and agile experience is preferred
  • Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping and installs
  • Work with enterprise teams for Systems Administrators, Cyber Security and Capacity Planning groups as and when situation demands
  • Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
  • Should have strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time
  • 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
The Expertise and Skills You Bring
  • Bachelors or master's degree in Computer Science or Information Systems or equivalent
  • 6+ years of experience in Oracle DBA with Exadata and RAC expertise
  • Expertise in database performance tuning, query optimization, and assist application teams in troubleshooting and resolving performance related issues
  • 2+ years of experience in Cloud (AWS/OCI/Azure)
  • 2+ years of experience in Snowflake database administration
  • Experience with Linux shell scripting and development experience with PL/SQL.
  • Experience with cloud databases platforms (AWS/Azure certification is preferred), on both Linux and Windows environments
  • 2+ years of experience in distributed replication technologies (Oracle Goldengate), preferred but not mandatory
  • 2+ years of experience in the Mutual Fund /Financial Services industry is highly desired

About the Company

H

HCL Global Systems Inc.