Senior DB2 UDB Distributed Database Administrator

Freddie Mac
Reston, VA
May 24, 2019
Jun 12, 2019
Full Time
Database Operations is seeking Senior DB2 UDB Distributed Database Administrator who is responsible for database administration in a fast-paced operations environment supporting 24×7 business critical applications using analytical and transactional databases primarily on DB2 Linux/VM with DPF and HADR features; Secondary level expertise on Oracle, Vertica and PostgreSQL databases. Database Administrator will be able to perform database monitoring, troubleshooting any issues related to database, performance analysis, ensuring database security, evaluating new database trends and technologies, developing and testing Unix shell scripts and coding required for database administration and associated database automation.

Your Work will be focused in these Primary Areas:
  • Provide DBA operational support on all aspects of databases administration including monitoring, backup/recovery, replication, deployment and real time production troubleshooting.
  • Install, configure, upgrade and maintain database in production and non-production environments
  • Provide 24×7 DBA support for production environment on rotation and need basis
  • Flexibility to work on shifts and weekend/off-hours support
  • Provide Database deployment support for Test and Production environments
  • Diagnose and address database performance issues using performance monitors and various tuning techniques
  • Interact with Storage and Systems administrators on Linux/Unix/VM operating systems issues related to Databases
  • Knowledge on database maintenance and automation scripts
  • Configure and maintain Database High availability
  • Support database replication
  • Troubleshoot database production problems and database connectivity issues
  • Implement DR solutions
  • Ability to work well as a team and as an individual with minimal supervision


  • Bachelor's Degree and/or equivalent experience
  • 7+ years of experience in Database administration
  • Solid understanding of Database technology - DB2 UDB Distributed databases including DPF, Oracle, Vertica and Postgres.
  • IBM DB2 UDB Distributed DBA on Linux, Unix and Windows platforms
  • Oracle Database Administration
  • Unix Shell scripting
  • Extensive Database performance tuning experience
  • Deep knowledge of industry-standard, enterprise-class best practices for a large database environment
  • Good understanding of Linux/VM platform
  • Deep understanding of HA, DR Database and storage technologies like Data replication, SRDF/non-SRDF
  • Experience implementing, supporting and auditing database security
  • Experience with Unix/Linux OS platform and Unix Shell scripting and automation

Keys to Success:
  • Ability to work responsibly on a 24×7 critical database infrastructure
  • Able to follow defined process and controls requirements
  • Collaborate and work with operations, infrastructure support teams and applications teams
  • Ability to learn and support any new database technologies

Top 3 Personal Competencies:
  • Partnership
  • Drive for Execution
  • Customer Focus, both internally and externally

Preferred Skills

  • Vertica Database Administration
  • PostgreSQL
  • Experience with Big Data, NoSQL database technologies
  • Experience with Database monitoring tools such as Foglight
  • Cloud platform experience

Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you'll do important work for the housing finance system and make a difference in the lives of others. Freddie Mac is an equal opportunity and top diversity employer. EOE, M/F/D/V.

Similar jobs