SQL Server Database Administrator II

Job Profile Summary Perform database engineering and administration activities including design, planning, configuration, monitoring, automation, self- serviceability, alerting, and space management, database backup and recovery. Plan computerized databases, including base definition, structure, documentation, long- range requirements, operational guidelines and protection.Career Level Summary List ·General instruction on routine tasks, detailed instruction on new assignments.Key Responsibilities Database Installation and Configuration: Configuring SQL Server software on servers post Installation and ensuring proper configuration settings for optimal performance and security.  Database Maintenance: Performing regular backups, restoration, and recovery of databases to ensure data integrity and minimize downtime in case of failures. Database Monitoring and Performance Tuning: Monitoring the performance of databases, identifying and resolving performance issues, optimizing queries, and fine-tuning server configurations to ensure efficient and smooth operation. Security and Access Management: Implementing security measures such as user authentication, authorization, and auditing to protect sensitive data. Managing user access, roles, and permissions within the database. Database Troubleshooting: Investigating and resolving database-related issues, such as connectivity problems, data corruption, and performance bottlenecks. Applying patches and fixes to address bugs and vulnerabilities. Database Documentation: Maintaining accurate and up-to-date documentation of database configurations, procedures, and troubleshooting guides to ensure easy reference for future tasks and knowledge sharing. Database Capacity Planning: Monitoring database growth and resource utilization to anticipate and plan for future storage requirements and performance enhancements. Making recommendations for hardware upgrades or additional resources as needed. Disaster Recovery Planning: Developing and implementing disaster recovery strategies and procedures to ensure business continuity in case of system failures or disasters. Testing and validating backup and recovery processes regularly. Collaboration and Communication: Collaborating with application developers, system administrators, and other stakeholders to understand and address their database requirements and concerns. Communicating effectively to provide timely updates and resolutions. Continuous Learning: Keeping up-to-date with the latest SQL Server features, best practices, and industry trends. Participating in training programs, attending conferences, and exploring relevant resources to enhance your skills and knowledge. Participate in 24X7 production support for SQL Server infrastructure along with senior members of the other database services teams Remember that specific responsibilities may vary depending on the organization, its size, and the complexity of the SQL Server environment you're working with. Additionally, as a Level 1 DBA, you may also be responsible for assisting Level 2 or senior DBAs with more complex tasks and projects. Knowledge List General knowledge in DR strategies including Database Mirroring, Log Shipping, SQL Replication, and AlwaysOn. · Good analytical and problem-solving skills. · Ability to demonstrate understanding of SQL Database Management System application's architecture, data structures, and functionality. · Proficient in SQL database engine administration, setup and maintenance of user and group security. · PowerShell and T-SQL Scripting: Learn PowerShell scripting to automate administrative tasks in SQL Server. Also, have a strong understanding of T-SQL (Transact-SQL) scripting language to write complex queries, stored procedures, and functions. · SQL Server Upgrades and Migrations: Understand the process of upgrading SQL Server to newer versions and migrating databases to new servers. Familiarize yourself with the associated risks and best practices. · Best Practices and Industry Standards: Stay updated with the latest best practices, industry standards, and security guidelines for SQL Server. Follow Microsoft's official documentation and online resources to ensure you're using recommended practices. Good written and verbal communication skills. Ability to communicate technical info and ideas so others will understand. Education Requirements List · High school diploma or equivalent required. Bachelor’s degree in Computer Science, Computer Information Systems, Management Information Systems, or a directly related field. Certifications List A certification in databases management would be appropriate Experience List 5 years of database related experience required We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.