RealPage

SQL Server Architect - REMOTE

Job Locations US-TX-Richardson
ID
22-14396
Category
Information Technology
Position Type
Full-Time
Education
Bachelor's Degree
Travel
None

WHO WE ARE

RealPage is changing the technology real estate industry and our teammates know how to think big and leave their mark. If you want to join a globally progressive and inclusive company devoted to excellence, we are looking for you!


We are the leading global provider of software and data analytics to the real estate industry. We navigate clients toward the right decisions with data and technology insights they can only get from RealPage. Serving our clients is our highest priority and RealPage teammates are our greatest asset.


Come join a team where your work makes an impact every day!

ABOUT THE TEAM

This is a critical role for supporting one of the largest Microsoft database environments in the United States. The team consists of 14 members working in India and the United States working together to provide exceptional customer service. The SQL Server Architect will help align business goals with technical design, focusing on performance tuning existing SQL Server databases.

WHAT YOU’LL DO

RealPage is looking for a SQL Server Performance Architect for our SQL Server environment working alongside other Database Architects and senior DBAs. You will be responsible for designing, implementing, and administering various database management systems in an Enterprise environment to support our many product lines on Microsoft Windows. You will also be involved in reviewing, analyzing and documenting existing architecture. Recommend best practices for reconfiguring existing databases (technologies, coding standards, connectivity, etc.). Be part of finding Root cause configuration issues while focusing on Database Performance Tuning.

PRIMARY RESPONSIBILITIES

  • Expert level proficiency in SQL Server - architecture, configuration, stored procedures, queries
  • Highly skilled in urgent real time troubleshooting
  • Experience with performance tuning
    • Understanding of index design and performance-tuning techniques
    • Query Tuning Techniques
    • Parameter Sniffing
    • Expert Knowledge of SQL Internal & DMVs
    • Storage optimization and Monitoring.
  • Excellent understanding of database design and development
  • Experience working with Extended events/SQL profiler and other troubleshooting tools.
  • Experience with very large databases and/or data warehousing
  • Familiarity with RDBMS principles, database design and normalization
  • Ability to develop scripts to load test data
  • Perform problem determination (root cause analysis) and document the source of problems and their resolution.
  • Microsoft Best Practices with regards to developing T-SQL queries and stored procedures.
  • Microsoft Best Practices with regards to database maintenance thresholds for consistency checks, index fragmentation, statistics, backups, restores.
  • Reviewing execution plans and not only determine possible indexing changes, but also know how to refactor T-SQL statements to achieve optimal performance.
  • porting Services, Integration Services, Analysis Services
  • Highly responsive communication #LI - RR1

REQUIRED KNOWLEDGE/SKILLS/ABILITIES

  • Bachelor's or Master's Degree in Computer science or related field is strongly desired. MCTS, MCITP, and/or MVP certifications a plus
  • 10+ years of experience with SQL database engineering and administration
  • SQL Server 2008/2008R2/2012/2014/2016/2019
  • Experience with data migration from legacy systems.
  • Strong scripting skills and working knowledge of Powershell.
  • Strong experience with performance optimization and tuning with database applications
  • Expert knowledge on Always-On Availability Groups and Listener
  • Strong Windows systems, clustering and scripting proficiency.
  • Familiarity with database backup and recovery strategies.
  • Strong familiarity with SSIS, SSRS and Analysis Services.
  • Experience with TDE encryption.
  • SQL Server STIG hardening and accreditation.

PREFERRED KNOWLEDGE/SKILLS/ABILITIES

  • Good Communication skills
  • Working knowledge of Azure and other Public clouds.
  • Experience with working in a Collorative environment (onshore & Offshore)
  • Take Ownership of projects
  • Development experience to work with Product team #LI-JL1 #LI-REMOTE

WHAT WE OFFER

At RealPage, we’re always looking for talented professionals who thrive in a learning work environment that continually supports individual greatness. We foster a culture of innovation and creativity. It is the things you do that bring out the best of you and RealPage.

 

RealPage considers qualified applicants without regard to gender, sexual orientation, gender identity, religion, race, national origin, age, veteran, or disability status. We celebrate diversity and are committed to building an inclusive work environment where all teammates feel a sense of belonging while bringing their authentic self to the table and being valued for it.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.