The Multiplatform Database Administrator Senior will serve as a technical authority on complex database migration and upgrade initiatives. In this role, you will actively participate in end-to-end project implementations, offering hands-on guidance to execution teams while ensuring strict adherence to enterprise standards and best practices. Success in this position requires not only deep technical expertise, but also adaptability and a proactive, solutions-oriented approach to troubleshooting. You will be expected to think creatively and step beyond conventional boundaries to resolve software challenges and drive project success.
Sound interesting? Read on!
Our Impact
The Development Factory helps provide efficient and rapid delivery for IT scope affecting applications across the enterprise. The Dev Factory model promotes a more collaborative and productive work environment by bringing development, testing and operations together. It is the combination of skills, process, practices, and tools that enhances our ability to deliver services at large scale with high velocity and reliability.
Your Impact
Technical Leadership
Lead database upgrade projects from analysis to implementation, owning and executing all activities involved for various RDBMS platforms (SAP ASE, Oracle, PostgreSQL, DB2, MSSQL Server, AWS Aurora, etc.)
Be able to provide subject matter expertise in AWS Aurora and at least two of the above technologies.
Contribute to technical decisions in collaboration with engineering teams, providing insights based on a deep understanding of the architecture and technologies involved.
Lead performance troubleshooting and tuning tasks.
Provide technical leadership and strategic direction for database transformation initiatives from one platform to another.
Document standard operating procedures and platform level checklists for the team to follow and ensure compliance across the board.
Mentor junior team members and provide direction wherever necessary.
Identify areas for continuous improvement and automate tasks, wherever possible.
Ability to multitask and provide DB SME support to a large group of developers and testers, sometimes in parallel.
Provide troubleshooting support for application/database issues involving multiple technologies during development/testing and deployment phases and provide solutions.
Work with TS counterparts and coordinate server/instance and database builds, database refreshes and security implementations.
Employ extensive professional experience and creativity to resolve sophisticated technical problems
Document lessons learned, help maintain knowledge database
Technology/Business Partnership
Collaboratively work with all other IT Teams to identify “Win/Win” opportunities and improve efficiency
Championing and influencing technology decisions with business partners, IT management and Team members on matters concerning multiple sophisticated projects which requires the ability to negotiate while maintaining effective relationships
Champion current trends in the industry partnering with Engineering and Architecture Services
Driving technical solutions in alignment with architectural roadmaps
Engage with Engineering and other technology partners in the project inception phase to understand environment complexities and define remediation strategy and test strategy
Qualifications
Bachelor's degree in Computer Science or Engineering or equivalent experience; advanced studies/degree preferred.
Production / Application DBA with a minimum of 5-7 years of experience in database administration.
Proficient in multiple RDBMS platforms including SAP ASE (Sybase), Oracle, MSSQL Server, PostgreSQL, DB2 and AWS Aurora.
Hands-on experience with AWS database services (Amazon RDS, Aurora, DMS, SCT).
Understanding of AWS networking, security (IAM, VPC, Security Groups), and storage options.
5 + years of experience in database version upgrades and cross-platform migrations.
Experience migrating from on-prem databases to AWS Aurora
Proficient in different replication technologies/high availability solutions for databases.
Strong UNIX knowledge and proficiency in shell scripts.
Working knowledge of PERL, Python and other similar scripting languages.
Strong troubleshooting and problem-solving skills.
Good understanding of hardware performance, memory and I/O.
Experience with DBMS specific tools for query/explain plans, database advisors, query snapshots, ability to understand them and troubleshoot the problems.
Strong understanding of database interfacing technologies such as ODBC, JDBC and DBMS Native clients.
Working knowledge of Snowflake and data pipelines is a plus.
Keys to Success in this Role
Good interpersonal, communication, relationship building and team working skills
Proven ability to communicate optimally with various teams, both business and technical, to achieve goals.
Ability to communicate clearly, efficiently, persuasively.
Motivated to learn new technologies and identify process improvements and efficiencies.
Current Freddie Mac employees please apply through the internal career site.
We consider all applicants for all positions without regard to gender, race, color, religion, national origin, age, marital status, veteran status, sexual orientation, gender identity/expression, physical and mental disability, pregnancy, ethnicity, genetic information or any other protected categories under applicable federal, state or local laws. We will ensure that individuals are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
A safe and secure environment is critical to Freddie Mac’s business. This includes employee commitment to our acceptable use policy, applying a vigilance-first approach to work, supporting regulatory mandates, and using best practices to protect Freddie Mac from potential threats and risk. Employees exercise this responsibility by executing against policies and procedures and adhering to privacy & security obligations as required via training programs.
CA Applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit www.BountyJobs.com and register with our referral code: MAC.
Time-type:Full time
FLSA Status:Exempt
Freddie Mac offers a comprehensive total rewards package to include competitive compensation and market-leading benefit programs. Information on these benefit programs is available on our Careers site.
This position has an annualized market-based salary range of $116,000 - $174,000 and is eligible to participate in the annual incentive program. The final salary offered will generally fall within this range and is dependent on various factors including but not limited to the responsibilities of the position, experience, skill set, internal pay equity and other relevant qualifications of the applicant.
