Intermediate Systems Database Administrator

Job Family IT Operations About Us At Transamerica, hard work, innovative thinking, and personal accountability are qualities we honor and reward. We understand the potential of leveraging the talents of a diverse workforce. We embrace an environment where employees enjoy a balance between their careers, families, communities, and personal interests. Ultimately, we appreciate the uniqueness of a company where talented professionals work collaboratively in a positive environment — one focused on helping people look forward and plan for the best life possible while providing tools and solutions that make it easier to get there. Who We Are We believe everyone deserves to live their best life. More than a century ago, we were among the first financial services companies in America to serve everyday people from all walks of life. Today, we’re part of an international holding company, with millions of customers and thousands of employees worldwide. Our insurance, retirement, and investment solutions help people make the most of what’s important to them. We’re empowered by a vast agent network covering North America, with diversity to match. Together with our nonprofit research institute and foundation, we tune in, step up, and are a force for good — for our customers and the communities where we live, work, and play. United in our purpose, we help people create the financial freedom to live life on their terms. What We Do Transamerica is organized into three distinct businesses. These include 1) World Financial Group, including Transamerica Financial Advisors, 2) Protection Solutions and Savings & Investments, comprised of life insurance, annuities, employee benefits, retirement plans, and Transamerica Investment Solutions, and 3) Financial Assets, which includes legacy blocks of long term care, universal life, and variable and fixed annuities. These are supported by Transamerica Corporate, which includes Finance, People and Places, General Counsel, Risk, Internal Audit, Strategy and Development, and Corporate Affairs, which covers Communications, Brand, and Government and Policy Affairs. Transamerica employs nearly 7,000 people. It’s part of Aegon, an integrated, diversified, international financial services group serving approximately 23.9 million customers worldwide.* For more information, visit transamerica.com . Job Description Summary Open systems database administrator supporting Microsoft SQL Server. DBA responsibilities focusing on support of DB infrastructure across Microsoft Windows, AWS, and Azure environments. Job Description Responsibilities The installation, configuration and maintenance of SQL Server DBMS environments Proactive monitoring of all databases Backup, recovery and housekeeping tasks Incident, capacity and performance management for both production and development environments and databases Disaster recovery On-call rotation and out of hours working to support incidents and changes Qualifications 4-year Computer Science Degree or equivalent work experience 2 years’ experience as a DBA with MS SQL Server including installation, configuration, maintenance, patching and upgrade of SQL instances Significant hands-on experience with SQL Server 2016 and up Logical and physical database design Backup, recovery and housekeeping Performance monitoring and tuning Experience with Windows server management Knowledge of clustering, mirroring, and replication in a SQL Server environment Preferred Qualifications Experience with in-depth performance monitoring toolsets Familiarity with Service Now and database automation Experience with Oracle, DB2, MySQL or other open system DBMS' Working Conditions Hybrid-Office Environment (Tuesdays, Wednesdays, Thursdays) Out of hours support (on-call and standby), evenings and weekends, will be required to support customer and GTS requirements Occasional Travel