Description & Requirements

 

ANDERSEN CORPORATION SUMMARY

At Andersen, we pride ourselves on our core values of Excellence, Integrity, Innovation, Partnership and being a leader in Corporate Citizenship. Headquartered in Bayport, Minn., Andersen Corporation is the largest window and door manufacturer in North America.

We’re focused on bringing more light into people’s lives by helping them create healthier, happier spaces to build memories and do what they love. This applies to our team, too.

In 2024, we were recognized as one of Newsweek’s America’s Greatest Workplaces for Women and Newsweek’s Most Trustworthy Companies in America. Earning the 2024 ENERGY STAR Partner of the Year—Sustained Excellence Award, Andersen is also committed to environmental health and sustainability. No matter your role, you’ll have the opportunity to make a difference at Andersen. 

SUMMARY

The Senior Database Administrator will also assist in developing database strategies, monitoring processes, improving database performance and capacity planning for future expansion requirements.  May participate and contribute to architectural decisions. They develop system testing strategies, monitor testing efforts, and test complex operating environments and database management systems in compliance with department standards.  This position will also assist with the analysis of complex technical system problems, and design and implement effective solutions.  This position is expected to work closely with external service partners to plan and coordinate activities, either project-related or managed services, as necessary.

PRIMARY RESPONSIBILITIES 

Provide first-level application support: Resolve problems and answer questions related to the Oracle RDBMS and MS SQL platform environment; contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiencyIdentify and implement team operational efficiencies by automation & process improvement opportunities and / or implementing new technologies.Database performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiencyMaintain database backup/recovery environment: Respond quickly to refresh data; verify implementation of correct backup strategy, develop recovery procedures; support recovery from loss of data caused by user or system errorInstall and upgrade Oracle RDBMS, MS SQL and related products: Keep environments at current release and maintenance levels; provide current & stable production and development environmentsReorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or de-fragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performancePerform database refreshes upon request: refresh data from one environment to another at the request of the application development staff, execute necessary tasks to accomplish this, to minimize impact provide application development staff optimal development environment with current dataProvide assistance in database design as needed: Research and recommend optimal design criteria; publish standards and work with development staff standardize environment and improve efficiencyExperience working closely with a matrix team consisting of employees, contractors, and vendors with various skills and disciplinesAbility to work with application groups to determine those requirements.Performance tuning experience including performance issue identification and tuning.When technical issues are escalated internally, you are able to work until resolution.Clearly articulate requirements, issues, project status, etc. to non-technical management personnel.Identify and communicate licensing, sizing, upgrades, etc. requirements to technology vendorsStandard DBA tasks – installation, space management, backup & recovery, patching, upgrades, etc. within database environments.Participate in 24/7 on-call rotation.Mentoring of junior Database AdministratorsAssist with developing and maintaining a DBA technical roadmap including proposals for financial capital planningWrites and maintains documentation for standard procedures

QUALIFICATIONS AND SKILLS 

Bachelor's degree in computer science, mathematics or similar discipline.Oracle Certified Professional DBA in Oracle Database (11G, 12G, or 19)5-8 years of Oracle RDBMS or MS SQL experienceExperience required with all of the following…Oracle Database 11g Release 2Oracle Database 12c Release 1Oracle Data Guard Physical StandbyOracle Grid Infrastructure specifically Automatic Storage Management (ASM)Oracle Recovery Manager (RMAN)Oracle SQL & PL/SQLOracle Database Software Installation, Upgrade and Patching within the OFA frameworkOracle Database Restore, Recovery and MigrationOracle Grid/Cloud ControlBasic UNIX/Linux system administrationBasic scripting skills (Bourne Shell, Korn Shell and Bash Shell)Desired experience with the following…Oracle VMOracle Application Express (APEX)Oracle Database Restore, Recovery and MigrationOracle Security PracticesQuest SharePlexExposure to other database technologies, e.g. Microsoft SQL ServerCloud (Oracle or MS Azure) service experience a plusHighly independent and motivated workerStrong interpersonal skills; ability to work with cross-functional teams and within a matrixed organization.Strong verbal and written communication skillsStrong analytical and problem-solving skillsAbility to handle multiple simultaneous projects with aggressive deadlinesAbility to troubleshoot issues using My Oracle Support and other online resourcesFamiliarity with data modeling and data miningHave a general understanding of database hardware design, including disk subsystemsGood knowledge of Database replication technologiesGood knowledge of structured Query Language

COMPENSATION

Pay is based on several factors including but not limited to work experience, education, geographic location, certifications, etc. Your recruiter can share more about the specific compensation package for your preferred role during the hiring process. Successful candidates in this role are expected to earn $99,216 to $153,784 per year.

CULTURE AND BENEFITS

“Be Orange. Be You” is how we express our belief that by embracing our differences and empowering you, we’ll be a stronger team able to accomplish what otherwise wouldn’t be possible. This Orange spirit has helped us become the #1 innovative window and door brand* and the one homeowners love the most.** It’s also why we’re committed to supporting you to approach each day with a bright outlook.

Benefits include, and are not limited to:

·       Medical/Dental/Vision/Life Insurance 

·       Health Savings Account contributions 

·       Paid holidays plus PTO 

·       401(k) plan & contributions 

·       Professional development and tuition reimbursement opportunities 

·       Charity contributions

·       Nationwide career opportunities

We look forward to seeing how your unique skills, background and experiences will inspire our team and help us continue to be the leader we are today.

Andersen is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, disability, marital status, national origin, citizenship, genetic information, protected veteran status, or any other characteristic protected by law. Andersen Corporation will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of all applicable federal, state and local laws.

Posting City: Oak Park Heights, MN