Senior SQL Database Administrator
Posted on Apr 3, 2021 by Mohawk Industries
Administers policies and procedures relative to multiple Versions of Microsoft SQL Server. Consult/Guide DBA's within the team. Has comprehensive technical knowledge of the database environment, understanding how to apply this knowledge to achieve optimal database and application performance. Assure High Availability synchronization with ability to perform production fail over when necessary. Consult/Guide Developer and Application teams on database related issues.
FUNCTION AND SCOPE:
Support Mission critical SQL databases. Advanced troubleshooting skills for performance and tuning.
Understands business requirements and works with end customers to support their business objectives.
Translates technical requirements and issues into common language for end users and management.
Understanding of using SQL in virtualized environments.
Installs, configures SQL databases, installs required patches and upgrades.
Performs version migrations.
Performs monitoring, troubleshooting and optimizing performance of the database.
Performs capacity planning including future storage requirements.
Analyzes and troubleshoots SAN, network, memory, and CPU specific performance issues in a high volume SQL Server Environment.
Develop, implement, and administer data security and integrity policies and procedures
Develop, implement, and administer data retention policies and procedures
Develop, implement, and administer table purge and reorganization policies and procedures
Develop, implement, and administer data archiving policies and procedures
Develop, implement, and administer high availability database synchronization procedures, including Clustering and virtualization.
Perform planned and unplanned server failovers
Develop methodology for test databases on development system and support necessary software
Consult with members of the Application Development group on file design and optimization issues as necessary
Adheres to internal change management, configuration management, security management, and PMO processes
Other duties as required
KNOWLEDGE & EXPERIENCE:
B.S. Degree or equivalent experience (8+ Years)
Microsoft Certified DBA.
Microsoft Windows Server Certification a plus.
Minimum 8-10 years All Supported SQL Servers Versions.
Installation, configuration, customization, Security, maintenance and performance tuning.
Patching and version migrations.
Minimum 8-10 All Supported SQL Server Versions.
Analyzing and troubleshooting SAN, network, memory, and CPU specific performance issues in a high volume SQL Server Environment.
Minimum 4-6 Years SQL Server clustering in a large environment.
Minimum 4-6 years Data Warehouse/BI Environments
Minimum 8-10 years Windows Server OS
Minimum 4-6 years T-SQL, SSIS, stored procedures.
Microsoft development and technical skills, knowledge of scripts and clustering software
Knowledge of VMWare and hypervisor use with SQL databases
Demonstrated ability to achieve results through team efforts, willingness to challenge
Established practices and draws relevant conclusions, ability to persuade market and sell new ideas and the ability to work effectively in a diverse work group.
Ability to exercise good judgment, problem solving ability and resourcefulness in the absence of formalized guidelines and procedures
Ability to work independently, set priorities, handle multiple tasks with concentration, speed and accuracy to meet deadlines
Ability to adapt to rapidly changing technology and apply to business needs
Strong written and oral presentation skills.