Integrated Resources, Inc.
Sr SQL Server Database Administrator
Integrated Resources, Inc., Atlanta, Georgia, United States, 30383
Sr SQL Server Database Administrator
Location: Atlanta, GA (hybrid)
Duration: 04+ Months
Job Description Under limited supervision, coordinates, designs, and secures computer databases to store, track, and maintain a large volume of critical business information. Serves as the highest advanced-level subject matter expert, providing authoritative guidance for professional staff. May also serve in a lead role. Local Candidates Only.
Job Responsibilities
Manage all aspects of physical database administration, including schema management, security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning, and capacity planning for SQL Server.
Support application teams and their projects to enhance, troubleshoot, and performance tune
Support SQL Server databases in Production, Test, and Development environments and within Microsoft SharePoint farm
Install, upgrade, configure ALWAYS ON, test, and deploy complex database software
Develop and implement database recovery plans and procedures
Analyze the performance of databases and recommend tuning and application changes
Implement user authentication and validate database security protocols across systems
Reviews system design and develop new database systems as needed
Modifying database structure or deploying schema changes as a result of new requirements
Scripting batch data loads and operational job automation
Working Knowledge of Cohesity Backup Appliance.
Working Knowledge of Cloud Technology and governance.
Qualifications
Bachelor's degree in computer science or a related field from an accredited college or university
Seven years of experience in support of an operating system, database management system, or a related field
Skill Matrix
Hands-on administrative experience with SQL Server RDBMS – 6 Years
Hands-on experience in managing backup, recovery and high availability scenarios – 6 Years
Hands-on development and tuning of databases in SQL Server with Performance Tuning – 6 Years
Hands-on experience in Microsoft Operating Systems and SQL Server clustered environments (Optimization and TSQL programming) – 6 Years
Hands-on query experience with SQL and scripting skills – 6 Years
Strong knowledge and experience on Always ON High Availability groups – 4 Years
Strong Knowledge and Experience on Migrations – 4 Years
SQL Server database space management/storage design and capacity planning according to best practices – 3 Years
Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management – 4 Years
Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture – 3 Years
#J-18808-Ljbffr
Duration: 04+ Months
Job Description Under limited supervision, coordinates, designs, and secures computer databases to store, track, and maintain a large volume of critical business information. Serves as the highest advanced-level subject matter expert, providing authoritative guidance for professional staff. May also serve in a lead role. Local Candidates Only.
Job Responsibilities
Manage all aspects of physical database administration, including schema management, security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning, and capacity planning for SQL Server.
Support application teams and their projects to enhance, troubleshoot, and performance tune
Support SQL Server databases in Production, Test, and Development environments and within Microsoft SharePoint farm
Install, upgrade, configure ALWAYS ON, test, and deploy complex database software
Develop and implement database recovery plans and procedures
Analyze the performance of databases and recommend tuning and application changes
Implement user authentication and validate database security protocols across systems
Reviews system design and develop new database systems as needed
Modifying database structure or deploying schema changes as a result of new requirements
Scripting batch data loads and operational job automation
Working Knowledge of Cohesity Backup Appliance.
Working Knowledge of Cloud Technology and governance.
Qualifications
Bachelor's degree in computer science or a related field from an accredited college or university
Seven years of experience in support of an operating system, database management system, or a related field
Skill Matrix
Hands-on administrative experience with SQL Server RDBMS – 6 Years
Hands-on experience in managing backup, recovery and high availability scenarios – 6 Years
Hands-on development and tuning of databases in SQL Server with Performance Tuning – 6 Years
Hands-on experience in Microsoft Operating Systems and SQL Server clustered environments (Optimization and TSQL programming) – 6 Years
Hands-on query experience with SQL and scripting skills – 6 Years
Strong knowledge and experience on Always ON High Availability groups – 4 Years
Strong Knowledge and Experience on Migrations – 4 Years
SQL Server database space management/storage design and capacity planning according to best practices – 3 Years
Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management – 4 Years
Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture – 3 Years
#J-18808-Ljbffr