The Role
Responsible for database installation, configuration, maintenance, monitoring, performance tuning, security management, troubleshooting, documentation, capacity planning, disaster recovery, and collaboration with stakeholders.
Summary Generated by Built In
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.
- A certification in databases management would be appropriate
- 5 years of database related experience required
Certifications List
Experience List
Top Skills
Powershell
SQL Server
T-Sql
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
At Rackspace Technology, we accelerate the value of the cloud during every phase of digital transformation. By managing apps, data, security and multiple clouds, we are the best choice to help customers get to the cloud, innovate with new technologies and maximize their IT investments. As a recognized Gartner Magic Quadrant leader, we are uniquely positioned to close the gap between the complex reality of today and the promise of tomorrow. Passionate about customer success, we provide unbiased expertise, based on proven results, across all the leading technologies. And across every interaction worldwide, we deliver Fanatical Experience TM — the best customer service experience in the industry. Rackspace has been honored by Fortune, Forbes, Glassdoor and others as one of the best places to work.
