- Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
- Facilitate brainstorming meetings with clients to review, analyze, and assess business systems and needs
- In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration
- Assists in the selection of a database management system and the maintenance of database performance
- Participate in continuous process improvement
- Download and install SQL Server service packs and updates.
- Configure and maintain SQL Security controls
- Make recommendations for system architecture per Microsoft SQL Server best practices
- Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
- Create, change, and improve SQL Server Agent tasks and maintenance plans
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
- Troubleshoot application sluggishness and poor performance
- In charge of T-SQL query tuning
- In charge of database migrations and server updates
- Create documentation and training for routine database administration activities, as well as train server operations employees on them
- In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
- Integrate SQL Server with corporate applications
- T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you
- A bachelor's degree in computer science or a related discipline
- Extensive knowledge of SQL and SQL server tools
- Experience in Database Performance, Development and Maintenance
- In-depth understanding of database security, backup and recovery, and performance monitoring requirements
- Familiarity with relational and dimensional data modelling
- Extensive knowledge in database design, implementation, and conversion
- Knowledge of PowerShell and Unix shell scripting
- Experience with SSIS and SSRS
- Experience leveraging BI Tools - PowerBI or Tableau
- A solid mathematics and statistical skills
- Outstanding writing and verbal communication abilities
- Meticulous attention to detail
- MCSE/MCSA certificates preferred
- Working knowledge of Linux and Windows Server infrastructures
- Extensive knowledge of MS SQL
- Prior experience with cloud services (AWS, Microsoft Azure)
Sr. SQL DBA - Phoenix, United States - The Intersect Group
Description
***No third-party candidates, corp-to-corp, H1-B will be accepted.***
Title: SQL DBA/Developer
Location: Greater Phoenix Area
Schedule: Hybrid/Remote: Only (3) Consecutive Days In-Office per Month
Model: Direct Hire
The Role:
A database administrator (DBA) with developer experience is what is required. A professional who manages Microsoft SQL Server, including installing relational database software, provisioning users' access to the databases, securing data, tuning database performance, disaster recovery, and so on.
Database Administrators may work as a member of the IT Operations Team, the Application Support Team, or part of the Software Development Team, depending on their company. DBAs, regardless of team, generally interface with all other IT teams and, on occasion, with the business.
SQL Server DBA Responsibilities
SQL Server DBA Requirements & Skills