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.

• 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.

• 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.

• ·       High school diploma or equivalent required. Bachelor’s degree in Computer Science, Computer Information Systems, Management Information Systems, or a directly related field.

• A certification in databases management would be appropriate

•        5 years of database related experience required