Sr. MS SQL Server DBA
Denver, CO

Job Description

Job FamilyData Engineering

Job Description SummaryTransamerica has been helping people feel better about the future for more than 100 years, and we're proud of the trust we've earned. But we believe our responsibility goes beyond insurance, investments, and retirement accounts. We're also in the business of helping people improve their financial and personal well-being, so they can add more years to their lives, and more life to their years.

At Transamerica, we are innovating the next generation of data solutions and capabilities to help our customers achieve a lifetime of financial security. As a Senior MS SQL Server DBA within our Enterprise Data Services team, this role will be focused on collaborating with a team of senior database administrators in the development of modern architectures to enable our data-driven digital business. You will help define our data strategies, grow our capabilities.Job Description

Responsibilities:

* Creates schemas and sub-schemas in consultation with application project team.
* Submits recommendations for solutions that require definition of the physical structure and functional capabilities of databases and require data security and data backup/recovery specifications.
* Proposes detailed specifications and flowcharts and coordinates installation of revised or new database systems.
* Sets up and performs backup and recovery procedures.
* Works with relevant staff, to identify and transform business requirements into physical data models.
* Performs monitoring and tuning for performance, and recommends Application database enhancements.
* Develops transaction logging and security features.
* Understands and uses normalization methods and design methodologies.
* Develops, documents, and enforces the standards, security procedures, and controls for access to ensure integrity of the database system.
* Works with system engineers or application developer to evaluate and implement technical enhancements.

Qualifications:

* Bachelor's degree in computer science, software engineering, or related field
* Five years of collective experience with MS SQL Server 2008/2012/2016.
* Experience with High Availability (HA), indexing strategies, index management and statistics for 500 million+ row tables.
* Experience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
* Attention to detail and results oriented, with a strong customer focus.
* The ability to work within a team environment.
* Problem-solving and communication skills.

Preferred Qualifications:

* Working knowledge of SSRS/SSAS
* Knowledge of AWS and Azure (Azure SQL and DW) platforms

Office Environment

Why Work for Us

Total Rewards at Transamerica: It's more than a paycheck.

Our comprehensive Total Rewards package is designed to help support you in many ways - throughout all stages of your life and career. We provide a competitive, market-driven program that encompasses base compensation, bonus potential, retirement, health and wellness benefits, learning and development opportunities, plus great employee perks. All designed with you in mind… to help you live your best life, grow personally and professionally - and feel valued for the work you do.

Learn more about our Total Rewards Package.

Equal Opportunity Employer:

Transamerica Life Insurance Company is an Equal Employment Opportunity employer and does not discriminate against any applicant or employee because of age, religion, sex, gender identity, genetic information, race, color, national origin, pregnancy, sexual orientation, marital status, participation in the uniformed services (e.g. U.S. Armed Forces, National Guard), physical or mental disability, or any other status protected by federal, state, or local equal employment opportunities laws.

Applicants with physical or mental disabilities may be entitled to a form of reasonable accommodation under the Americans with Disabilities Act and certain state and local laws. A reasonable accommodation is a change in the way things are normally done which will insure equal employment opportunity without imposing undue hardship on the Transamerica Companies. Please contact: applicantsupport@transamerica.com if you are a job seeker with a disability, or are assisting someone with a disability, and require assistance to apply for one of our jobs.

Ontario Applicants:

Our Company is committed to providing accessibility to those with disabilities in a manner that is consistent with the principles of independence, dignity, integration and equality of opportunity, that is in compliance with the Accessibility for Ontarians with Disabilities Act 2005 ("AODA"). Please contact applicantsupport@transamerica.com if you are a job seeker with a disability, or are assisting someone with a disability, and require assistance to apply for one of our jobs.

Technical Assistance:

If you experience technical problems during the application process, please email applicantsupport@transamerica.com.