Rackspace Technology

SQL Server Database Administrator III

Rackspace Technology

full-time

Posted on:

Location Type: Hybrid

Location: Gurgaon • 🇮🇳 India

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

SQL

About the role

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

Requirements

  • 5 years of database related experience required
  • 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.
Benefits
  • Health insurance
  • Retirement plans
  • Paid time off
  • Flexible work arrangements
  • Professional development

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQL ServerDatabase InstallationDatabase ConfigurationDatabase MaintenancePerformance TuningT-SQLPowerShellDisaster RecoveryDatabase MirroringSQL Replication
Soft skills
Analytical skillsProblem-solving skillsCollaborationCommunicationDocumentationContinuous Learning