Job Description :
SQL Server DBA
Requirements:
Strong understanding and experience in the use Visual Studio Database Projects, including creating, managing, and deployment of new code.
Strong understanding and experience in the use TFS Source Control and workflows, including process creation and automation of deployments.
Strong understanding of source control, branching strategies, GIT, etc. and how to apply to various projects within an organization.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Strong understanding of good database development practices and T-SQL
Experience in implementing operational automation using scripts.
Experience with Azure SQL, Azure DW, and OLTP environments.
Knowledge of backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Knowledge of indexes, index management, and statistics.
Good communication and documentation skills.
Preferred:
Experience optimizing code for tables with over 1 billion records.
Experience in indexing strategies for 100+ million table environments in an AlwaysOn Replica setup.
Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.
Certification is a plus; MCTS, MCITP, MVP
Experience with DB2, Oracle, and/or SAP environments
General understanding of Linux CLI commands
Previous experience in either a teaching or a volunteer role.
Requirements:
Experience with Database Administration for MSSQL Server and DB2
Experience in troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Experience with DB2 replication
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Knowledge of indexes, index management, and statistics.
Knowledge of Windows OS, Linux OS, and Azure systems to help support MS SQL Server, DB2, and Azure environments.
Good communication and documentation skills.
Must be willing to participate in a weekly on-call rotation.