SQL/Sybase Database Technical Lead

Company: freddie mac
Location: Dallas
Posted on: February 25, 2021

Job Description:

Job DescriptionAt Freddie Mac, you will do important work to build a better housing finance system and you'll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation. Position Overview: Do you have a passion for database administration and can perform under-the-hood operations for cloud hosted Database Platform along with supporting modern development methodologies? We are looking for a seasoned cross-trained DBA Tech Lead in SQL (primary) and Sybase (secondary) to join our fast-paced and highly hardworking Freddie Mac Database Operations team. Someone who has the right attitude towards DB platform health, standard methodologies and efficient management. A self-starter, fast learner who's comfortable driving DB specific RCA to conclusion. Someone who can write DB maintenance/automation scripts one day and able to drive team discussions and solutions the very next day. Our Impact: * Responsible for and encouraged to 24x7 coordinating, configuring, solving problems and supporting Database Platform including production and non-production environments. * Protect production by exercising good judgment and following operational practices and procedures * Writing and managing scripts and utilities to automate day to day database administration. * Assist with the monitoring performance analysis of existing applications and ensuring that the system is consistent with ongoing need. * Write technical documentation, operational procedures, Incident and problem communications and reporting. * Quickly restore service during system outages, provide troubleshooting support to team members, perform proactive problem prevention, and escalate technical details to technical lead and/or to vendor support. Your Impact: * Provide leadership on enterprise projects and initiatives related to Database Operations and work across team lines and with vendors on delivering solutions to complex database performance problems, standard methodologies, conducting and developing configuration and compliance audits. * Cross-trained technical leadership in SQL Server (primary skillset) and Sybase Server (secondary skillset) database administration. * Drive performance enhancements and operations approach with our infrastructure and product development teams to maximize the value of our products for our external and internal customers. * Maximize quality of the production operations service to exceed the contractual SLAs (e.g., performance, availability, RTO, RPO) for each of our products. * Make recommendations on how to reduce hosting complexity/improve operational agility and efficiency * Lead/coordinate with a world class DBA team and be an individual contributor. * Communicates effectively with clients to identify needs and evaluate alternative technical solutions and strategies * Be part of the team for on-call rotation and issues resolution activities as required * Perform regular health checks on environments * Write and manage scripts and utilities to automate day to day SQL/Sybase server administration * Familiarity with issues surrounding the use of SQL and Sybase Server in AWS cloud environment Qualifications: * BS or MS in Computer Science or equivalent work experience * Over 10 years of DBA SME in SQL Server * Over 5 years of cross-trained tech lead DBA expertise in SQL and Sybase Server * Solid understanding of SQL Server Administration and HA setup and ability to automate the process in a complex environment * Ensures data governance and follows ITIL process closely * Working knowledge of Sybase ASE and Sybase Rep Servers/Rep Agents * Strong working knowledge of setting up and using monitoring tools like Quest Foglight for SQL/ Sybase server monitoring * Strong scripting knowledge using PowerShell and shell * MCSA DBA and (or) Sybase Certified. * Nice to have AWS SysOps Associate desired * Solid grasp of Windows and Red Hat Enterprise Linux (RHEL) operating systems * Experience with scripting tools to automate routine operation tasks using Ansible/Python/Jenkins. Keys to Success in this Role: * Result oriented and able to propel discussions forward. Collaborator and fantastic teammate * Able to zero down on root cause with supporting data. Current Freddie Mac employees please apply through the internal career site. 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. We are an equal opportunity employer and value diversity and inclusion at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by applicable law. We will ensure that individuals with differing abilities are provided reasonable acco

Keywords: freddie mac, Dallas , SQL/Sybase Database Technical Lead, IT / Software / Systems , Dallas, Texas