Andersen Windows & Doors - Careers

Sr. Microsoft SQL Server Database Administrator - (21787)

Share this Job:
Apply Online    
Description
A Microsoft SQL Server Database Administrator II is responsible for the design, creation, configuration, upgrades, administration, monitoring, performance tuning, backup and maintenance of databases in the organization.  They analyze, test, and implement physical database design supporting various business applications.  They ensure data recovery, data maintenance, data integrity, and space requirements for physical databases are met through policies, procedures and standards relating to database management.  They provide excellent coordination between the user, technical representative, application, and other entities to ensure effective data management. This individual will plan and reliably implement security measures to safeguard the databases per department standards.
A Microsoft SQL Server Database Administrator II will also assist in developing database strategies, monitoring processes, improving database performance and capacity planning for future expansion requirements.  They will often participate and contribute to architectural decisions. They develop system testing strategies, monitor testing efforts; test complex operating environments and database management systems in compliance with department standards.  This position will conduct analysis of complex technical system problems, design and implements effective solutions.  This position is also expected to work closely with external service partners to plan and coordinate activities, either project-related or managed services, as necessary.

  • Install and upgrade SQL Server RDBMS and related products: Keep SQL Server RDBMS at current release and maintenance levels; provide current & stable production and development environments
  • Reorganize 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 performance
  • Perform 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 data
  • Provide first-level application support: Resolve problems and answer questions related to the SQL Server RDBMS and platform environment; contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiency
  • SQL Server RDBMS performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency
  • Maintain 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 error
  • Experience working closely with a matrix team consisting of employees, contractors, and vendors with various skills and disciplines
  • Engages with IT external partners to ensure SLAs are met and company processes and policies are adhered to
  • Ensure database availability, performance, and supportability can meet application requirements.  Ability to work with application groups to determine those requirements.
  • Engage with internal and external auditors on database security and compliance issues
  • Performance tuning expert including performance issue identification and tuning.
  • Lead incident management efforts.  Coordinate database resources and activities during infrastructure incidents.
  • Work with project leaders to determine DBA resource requirements for specific projects.
  • Identify and communicate team operational efficiencies by process improvements and / or implementing new technologies.
  • Tier 2/3 troubleshooting.  When technical issues are escalated internally, you can work until resolution.
  • Clearly articulate requirements, issues, project status, etc. to non-technical management personnel.
  • Maintain and manage contractual licensing agreements.
  • Identify and communicate licensing, sizing, upgrades, etc. requirements to technology vendors
  • Lead change management for the team.  Participate in Change Advisory Board meetings and give input to scheduled changes across the department.
  • Standard DBA tasks – installation, space management, backup & recovery, patching, upgrades, etc. in both Oracle and SQL Server environments.
  • Participate in 24/7 on-call rotation.
  • Mentoring of junior Database Administrators
  • Develop and maintain a DBA technical roadmap including proposals for financial capital planning
  • Accountable for hardware and/or software research and evaluation
  • Writes and maintain documentation for standard procedures

Qualifications
  • Bachelor degree in computer science, mathematics or similar discipline. 
  • 7-10 years of RDBMS experience (MS SQL server)
  • Technical certifications desired
  • Experience required with all the following…
    • SQL Server Database 2008R2
    • SQL Server Database 2012
    • SQL Server Database 2016
    • SQL Server Database Software Installation, Upgrade and Patching
    • SQL Server Database Restore, Recovery and Migration
    • SQL Server Management Studio
    • SQL Server on Virtual Servers
    • PowerShell scripting skills
    • SQL Server Security Practices
    • Exposure to other database technologies, e.g. Oracle
  • Microsoft Azure cloud service experience desired
  • Strong knowledge of SQL Server Database HA technologies, including AlwaysOn and Log Shipping
  • Experience leveraging IT vendor relationships (staff augmentation and managed services)
  • Experience with virtualization technologies in a database environment
  • Ability to handle multiple simultaneous projects with aggressive deadlines
  • Ability to troubleshoot issues using Microsoft Support and other online resources
  • Highly independent and motivated worker
  • Strong interpersonal skills; ability to work with cross-functional teams and within a matrixed organization.
  • Strong verbal and written communication skills
  • Strong analytical and problem-solving skills
  • Familiarity with data modeling and data mining
  • Ability to handle high stress situations
  • Good knowledge of Database replication technologies
  • Good understanding of distributed computing architectures
  • Good understanding of the underlying operating systems (Windows, Unix, Linux)
  • Good knowledge of structured Query Language
  • Good database design experience
  • General understanding of database hardware design, including disk subsystems
  • Basic project management skills, ability to develop, scope, schedule, communicate and deliver smaller projects
Job:
Information Technology
Location:
Oak Park Heights, MN US
Organization:
Andersen Corporation
Apply Online    
Join Our Talent Community