Job Description :
Responsibilities
The Senior Database Administrator will be a part of a team of DBA’s that supports some critical applications. This individual will be responsible for providing DBA services to application development teams, support multiple database environments, and manage the build-out of database infrastructure. S/he will serve as a key subject matter expert on Oracle database design & features. A primary focus will be to proactively analyze, identify, and implement performance improvements to custom and vendor applications. Good communication skills are necessary for this role as the candidate will need to interface with developers, business IT and management.

Specific duties will include –
Install / configure new databases in both RAC and non-RAC environments
Install / configure new Data Guard physical standby databases
Install / configure Golden gate where needed
Troubleshoot database problems in both production and non-production environments; lead RCA process and ensure all fixes are fully implemented, collaborate across infrastructure teams to determine RCA
Use appropriate tuning methodology and tools (such as AWR, ADDM, ASH etc to triage and resolve performance problems
Collaborate with business units, application teams and administration teams to design, size and plan new environments
Research, plan and execute database upgrades
Plan for system growth and scalability
Support standard ‘mailbox’ type requests (create schemas, create objects, grant privileges, kill sessions, etc)
Support scheduled and emergency maintenance events
Participate in other infrastructure upgrades for servers, storage devices
Prepare / update storage diagrams for both ASM and non-ASM environments
Prepare / review performance reports and segment space reports
Prepare / update technical documentation including for the following: operational manual, backup / recovery, database maintenance, patching
Prepare / update non-technical documentation including for the following: system designs, operating procedures, system events and root cause analysis

Qualifications/Requirements
Bachelor’s in Computer Science, Information Systems or Engineering (or equivalent relevant work experience)
Minimum of 4-6 years of experience in database administration using Oracle databases (10g, 11g, 12c a plus) and/or Oracle Exadata; including installation, configuration, tuning, patching, upgrading, troubleshooting
Minimum of 1-3 years of experience in Sun Solaris / Linux platforms with storage and networking experience
Efficient at tuning SQL & improving Oracle performance
Experience working with Oracle Recovery Manager and Netbackup
Experience creating Unix shell scripts
Experience working with Oracle GRID Control
Strong hands on experience with RAC infrastructure, ASM, RMAN, and dataguard
Exceptional troubleshooting skills to analyze problems at all levels
Must be able to work off-hours and provide 24x7 support in on-call rotation
Must be detail-oriented and deliberate
Experience developing and documenting directions and operating procedures
Excellent communication

Desired Characteristics
Master’s degree in Computer Science, Information Systems
A knowledge of data modeling. The ability to understand and existing data model and help developers code the right way and use advanced Oracle feature to improve product efficiency and features.
Ability to collaborate both with technical and non-technical personnel
Experience in US Media & Entertainment environment
Experience with sales, traffic, and other TV systems; and/or ERP applications
Exposure to large commercial ERP applications (Oracle EBS, SAP etc
Exposure to big data, knowledge of HDFS, HBASE etc.