• Database Administrator (Remote)

    Location(s) US-TX-San Antonio | US-TX-Remote
    Req #
    39164
    Category
    DBA
  • About Rackspace

    Rackspace is modernizing IT in today’s multi-cloud world. We have been honored by Fortune, Forbes, Glassdoor and others as one of the best places to work. We serve over 50% of the Fortune 100 companies & customers in 120 countries around the globe. Our achievements are powered by our people – we call them Rackers.  We grow & thrive through world-class development opportunities, learning & selling bleeding-edge technologies & solutions, and most importantly, connecting with each other (the best & brightest in the industry). Are you a Racker? Join us!

     

    More on Rackspace

     

    Rackers aren’t all alike. We look different. We think uniquely. We are from many places and our beliefs & backgrounds vary. But, being a Racker — a valued member of a winning team on an inspiring mission – is what connects us all. Rackers are encouraged to bring their whole self to work every day, as we know that unique perspectives fuel innovation and enable us to best serve our customers & communities around the globe. We welcome you to apply today and want you to know that we are committed to offering equal employment opportunity without regard to age, color, disability, gender, gender reassignment or identity or expression, genetic information, marital or civil partner status, pregnancy or maternity status, military or veteran status, nationality, ethnic or national origin, race, religion or belief, sexual orientation, or any legally protected characteristic. If you have a disability or special need that requires accommodation, please let us know.

    Overview & Responsibilities

    JOB OVERVIEW:

     

    Architect, transform, design, upgrade, migrate, and deploy databases for Rackspace Professional Services customers.  Assist customers in deploying databases to the cloud, update on-prem customers' architectures to improve performance or support new loads. Update indices, optimize ETL, analyze performance and recommend infrastructure and database changes, recommend application access strategies. Consultatively discover requirements for RTO/RPO and build fault-tolerant solutions. Design and deploy DR environments. Configure database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.  Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.  Refine and automate regular processes, track issues, and document changes.  Assist developers with complex query tuning and schema refinement.  Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. 

     

    PROFESSIONAL SERVICE'S MISSION STATEMENT: Provide the expertise needed to address the end to end customer journey by transforming, migrating and optimizing workloads in a multi-cloud world, fully leveraging Racker-delivered and/or Partner-Enabled Services.

     

    JOB REQUIREMENTS:

    • 5+ years MS SQL Server Administration experience required
    • Experience upgrading from EOL MSSQL versions to latest and greatest running on different platforms.
    • Expert knowledge of SQL syntax, including Stored Procs and triggers.
    • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
    • Expert in troubleshooting resource contention issues related to CPU, memory, I/O, disk space etc.
    • Expert knowledge of performance tuning at the server and application levels.
    • Expert in using Query Store and SQL profile traces to troubleshoot perf issues.
    • Strong understanding of indexes, index management, integrity checks and statistics.
    • Experience in administering MSSQL Active-Active, Active-Passive Cluster, Peer to peer replication and transactional replication
    • Expert knowledge in HA and DR solutions including MS Clustering Services, Availability Groups, Database Mirroring, Log Shipping and SQL Replication.
    • Expert knowledge in Backup design and support.
    • Expert skill in SQL Server 2005, 2008, 2008R2, 2012, 2016, 2017.
    • Expert in building and improving ETL workflows using SSIS, SSRS, SSAS, DTS
    • Expert in PowerShell scripting.
    • Experience working with Windows server, including Active Directory
    • Excellent written and verbal communication
    • Flexible, team player, “get-it-done” personality
    • Ability to organize and plan work independently
    • Ability to work in a rapidly changing environment with ambiguous requirements
    • Ability to multi-task and context-switch effectively between different activities and teams
    • MCTS, MCITP, and/or MVP certifications a plus

    Qualifications

    SUPERVISION:  Works with general supervision; works autonomously with general instruction on new projects or assignments.  Decisions impact the quality, efficiency and effectiveness of own team. May impact closely related teams through quality of output and service provided. Adopts and implements business and process improvements.

     

    EXPERIENCE/EDUCATION:  High school diploma or equivalent required. Associate’s degree in technical field preferred.  7 - 9 years of relevant technical experience required, including a minimum of 4 years of engineering experience in migration, implementation, and production management.  Advanced knowledge and experience across multiple technologies in a single domain (Cloud, Security, DevOps, etc).  OS certification and Rackspace Cloud Savvy/Smart certification strongly preferred. At least one top tier technical certifications in a highly desired technology domain preferred.

     

    PHYSICAL DEMANDS:  General office environment.  May require long periods sitting and viewing a computer monitor.  Moderate levels of stress may occur at times.  No special physical demands required.  Occasional domestic travel, up to 50%.

     

    #LI-DD1