SantaAnaRecruiter Since 2001
the smart solution for Santa Ana jobs

Lead SQL Database Administrator and Developer

Company: Xome Realty Services LLC
Location: Santa Ana
Posted on: May 3, 2021

Job Description:

When you click 'Apply', you will need to click on 'Create Account'. By creating an account, you will be able to view your applications and their statuses. Your password must contain 8 characters, 1 upper case letter, 1 number and 1 special character. Please make sure your name is formatted correctly and not in all uppercase.WHO WE AREA subsidiary of Mr. Cooper founded in 2012, Xome was built on the belief that the process of buying/selling a home shouldn't undermine the excitement of home ownership. In working to bridge the offline and online worlds of real estate, we've opened new possibilities for home buyers/sellers and more business for real estate professionals.Xome is comprised of industry leading real estate and technology companies, including Title365, and Xome Labs, united by the shared goal of forever transforming the real estate experience. Learn more at http://www.xome.comJOB SUMMARYThe Principal SQL Server DBA is responsible for the management of Database Operations and Administration at Xome. The Principal SQL Server DBA will ensure the support, maintenance, and monitoring of all components of Xome's Production and lower-environment Microsoft SQL Server Database infrastructure, including MS-SQL versions 2008, 2012, and 2014 (Availability Groups) keeping in mind business continuity and disaster recovery.ESSENTIAL JOB FUNCTIONSDevelop, implement, administer, and maintain policies and procedures for ensuring the security and integrity of the company's databases.Implement database backup & recovery, data models, database designs, data access and table maintenance codes.Design and Management of SQL Security and Disaster recovery systemsResolve database performance and capacity issues, and replication and other distributed data issues.Work closely with development, and infrastructure teams for the release management.Install, configure, test/benchmark, and maintain the general health of database servers and related infrastructure, monitor system logs for alerts, errors and warnings, and available/free space on the OS and storage volumes, and analyze space usage history and recommend changes as needed.Create/update documentation for new/existing maintenance and installation processes.Troubleshoot SQL Server service outages as they occur.Participate in On-Call rotation.Perform other duties and responsibilities as assigned.Must Have:Must have experience in Performance Auditing, Optimizing / Tuning, Monitoring, Troubleshooting all platforms (on-prem and cloud).In depth knowledge of SQL Server internals to be able to explain and work with application teamsExperience with replication.Able to effectively communicate and collaborate with server, storage and network infrastructure teams, in the implementation of database-server migrations/upgradesProactively identify and rectify security issues, and ensures SOX/GDPR compliance in database environmentDatabase encryption, column, row level encryption implementation experienceExperience with SQL Server CLR Integration.Understanding of the .NET Framework Library.Proficiency in C# and development tools.Writing reusable libraries.Data access using ADO.NET.On call rotation for DBA prod supportNice to HaveExperience implementing AlwaysOn high availability.Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL ServerExperience in Azure Databases, Managed instances management and cost optimizationsExperience in Linux/Ubuntu PostgreSQL administrationEnd-to-End automation/deployment processKnowledge of concurrency patterns and multithreading.Code Version Control Tools such as GIT.JSON serialization and deserialization.Knowledge of Application Programming Interfaces, REST and SOAP.Critical thinker and problem-solving skillsXome is committed to nurturing a diverse and inclusive environment where every employee is empowered to be their authentic self. We know that a large part of our success as a business is directly tied to our ongoing efforts to attract and retain diverse talent and maintain an inclusive environment where each employee can thrive. Embracing and leveraging diversity through an inclusive work environment fosters new ideas, new insights, and constant innovation. We strive to weave the principles of diversity and inclusion throughout the fabric of how we work, how we interact, and how we engage with our customers and the community.Job Requisition ID:013997Job Category:Information TechnologyPrimary Location City:Santa AnaPrimary Location Region:CaliforniaPrimary Location Postal Code:92705Primary Location Country:United States of AmericaPosting Organization:XomeLine of Business:Information TechnologyAdditional Posting Location(s):Lake Vista 1 - Lewisville TXAlternate Requisition:No

Keywords: Xome Realty Services LLC, Santa Ana , Lead SQL Database Administrator and Developer, IT / Software / Systems , Santa Ana, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Santa Ana RSS job feeds