Job Description :
Need GC/Citizens or H4 EAD
Oracle DBA
Reston, VA
4+ years of related experience, including hands-on production support
Provide production support for medium and highly complex database and applications
Trouble-shooting production incidents requiring detailed analysis of issues on Autosys batch jobs and databases.
Create, investigate, and track solutions to database errors reported
Escalate unresolved issues to L2 team and Primary DBA''s
Support application releases requiring execution of Autosys jobs, Unix and database script execution
as well as interfacing with business team/s
Update user documentation and conducting training
May mentor or guide work of less experienced support personnel
Experience in a fast-paced production environment and the ability to handle multiple, simultaneous problems
with changing priorities
Work in a team environment supporting a 24x7x365
Need to work at FreddiMac Location / Carry a cell phone during Shift hours (Evening, Night and Weekend)
Core Key Skills:
Very strong *Hands ON* experience in DB Platforms - Oracle, DB2/UDB
Knowledge of UNIX, ETL, Oracle, DB2/UDB Platforms
4+ years of understanding RDBMS and UNIX/Linux
In depth understanding of object-oriented methodology, data structures and design patterns
Pre-Implementation Production Support Analysis
High Level (4+ years) Unix expertise - navigation, scripting, command level
Will also support other Key Platforms using SOP Documents - Actian/Paraccel-Matrix, Hadoop Hortonworks 2.5.3, MongoDB 3.4.2 & ETL (Datastage, Informatica & CDC)
Excellent problem solving and analytical skills
Ability to troubleshoot complex issues
Service Now or other ticketing system (ticket life cycle)
Autosys or other job scheduling system (Debugging failed job)
Support Infrastructure, Database and Application releases
Excellent written and oral communication skills