Overview
On Site
$60 - $63
Full Time
Skills
SQL server
Linux
PL / SQL
SQL
clustering
database administration
data migration
Oracle
debug
Database analysis
Develop procedures
clustering techniques
memsql
code review
communication skills
computer science
information systems
troubleshooting
interpersonal
performance tuning
server clustering
shell scripts
sql loader
Job Details
Job Description
You will be a production/development oriented Sr. Database and PL/SQL Administrator that would thrive working closely with other Database Administrators and PL/SQL Developers locally and US counterpart team supporting a multi-database environment including Oracle, SQL server and in memory databases like memsql.
You will have the opportunity to work with our Senior DBAs and developers playing a key role in supporting supply chain of data from data generation to data delivery.
Roles and Responsibilities
Understand and apply advanced database administration, management and performance tuning techniques
Provide advanced technical troubleshooting for applications and database systems
Configure and tune oracle and Linux OS parameters to ensure optimum performance and resource utilization
You may be required to work in morning or afternoon shift and one weekend day.
Understand server clustering techniques and its impact on database configuration and performance
Manage standby databases, snapshots and other advanced database features
Use databases replication tools like Goldengate etc.
Manage Oracle Real Application Clusters (RAC) environments and be able to perform troubleshooting with RAC nodes
Participate in design and review of application codes
Develop shell scripts for monitoring
Develop procedures and processes for data migration and application development
Participate in meetings and conference calls related to project and troubleshooting activities
Perform exports, rman backups and data extracts as required
Develop strong working knowledge of key applications and their interaction with the database(s)
Provide application development, enhancements, modifications, performance tuning, and support services for assigned projects.
Work with IS technical resources to provide high availability monitoring and maintenance for assigned applications.
Skills and experience
Bachelor s degree in computer information systems, computer science or related discipline preferred
Must have 7 plus years of database administration experience with Oracle cluster environment
Must have performed Oracle version upgrades and migrations
Experience with Oracle11g/12c/19c RAC Enterprise installation and its troubleshooting
Database analysis and design expertise through code review, AWR and ASH reports.
Experience with Oracle tools and utilities like Toad, PL/SQL developer
Ability to write, debug and tune SQL and PL/SQL, packages, procedures, functions, triggers, etc.
Skills and attributes that would be great to have
Comfortable with highly dynamic customer driven environment
Experience with database monitoring and tuning tools such as OEM
Solid experience with the linux operating system and command set
Thorough knowledge of physical and logical disk systems and their impact on database performance.
Understanding of storage experience a plus.High degree of skill with database commands and utilities such as exp, imp, sql loader, etc.
Advanced knowledge of database administration tasks such as hot and cold backups, database recovery, tablespace additions, security, etc.
Advanced installation and configuration experience.
Must have excellent interpersonal and written communication skills
Ability to work independently and in shift with US counterpart team
Capable of working and managing multiple diverse projects
Familiarity with VPD (Virtual Private Database) is preferred