Database Administrator

Engineering Blacksburg, Virginia


Description

SUMMARY: Plan and implement computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Develop database tools. Formulate and monitor policies, procedures and standards relating to database management. Propose and implement enhancements that will improve the performance and reliability of the system.

JOB DESCRIPTION:

Key Responsibilities:

  • Create and manage multiple databases and assist in capacity planning.
  • Monitor, maintain database systems and troubleshoot problems that may arise.
  • Maintain data integrity and security (manage roles and permissions of database users).
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues and resolve them.
  • Develop strategies and implement solutions for managing back-ups, restoration and replication.
  • Create architecture maximizing up-time and allowing for upgrades and patching with minor downtime.
  • Create and manage constraints and indexes.
  • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
  • Manage production, staging and development database environments.
  • Coordinate and communicate with all stakeholders including the Corporate Data team.

Other Responsibilities:
  • Create detailed documentation including diagrams of database infrastructure.
  • Learn relevant business processes and understand data flow, criticality and dependencies.
  • Effectively coordinate and communicate with all stakeholders (internal teams and clients).
  • Set up and maintain database infrastructure for the company's transactional and analytical needs.
Technical Expertise:
  • Strong expertise in SQL Server Clustering and HA technologies.
  • Strong expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
  • Extensive experience with RDBMS concepts, database architecture and SQL/ T-SQL.
  • Experience with other databases especially MySQL multi-master databases, No SQL databases and In-memory databases.
  • Extensive experience writing T-SQL and stored procedures and query tuning on high-transaction systems.

#LI-DD1

About Rackspace
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. We have been honored by Fortune, Forbes, Glassdoor and others as one of the best places to work. Join us on our mission to build the world’s best technology services company.

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.