11:11:00 AM
Role : Senior Oracle Database Administrator (Level 3)
Location : New York City, NY 07632
Duration : 1 Year
Responsibilities
The Senior Database 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 and 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
· Exposure to big data, knowledge of HDFS, HBASE etc.
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.)
Thanks & Regards,
Abraham | 678-720-3170
VDart Inc | Atlanta, GA