What are the responsibilities and job description for the MS SQL Database Administrator position at Diverse Lynx?
Job title : MS SQL Database Administrator
Job Location : Plano, TX
Work Model : Remote
Subcontracting Permitted : Yes
Job Summary :
We are seeking a highly skilled MS SQL Database Administrator with 8 to 9 years of experience in SQL Server DB Administration and MS SQL Server. This role is crucial in ensuring the integrity and performance of our data systems, which are vital for our company's operations and societal impact.
Experience : 8 to 9 years
Required Skills :
MS SQL DB Administration (Creating new Database, backup & restore, Troubleshooting at DB level, Security, Performance analysis, DB Maintenance)
MS SQL Server
Responsibilities : Production :
Creating new database for re-shell
Restore in secondary nodes
Would require access to production
New DB created .. back up needs to be taken and restore to secondary nodes - HA & DR / DAG
Ability to request or create storage on servers
Troubleshooting database related issues - only DB level not Server level - during cutover
Security - users / roles
Creating jobs
Assigning DB users security
Performance analysis includes access to every tools in production, like Solar winds
During prod cutover period
Non- Production :
Restore data from production to stage - DBA
Create new Databases in stage, includes file storages - DBA
Would require access to production
Ability to request or create storage on servers
Troubleshooting database related issues - DBA
Running DB maintenance on DB - DBA
Security - users / roles
Creating jobs
Assigning DB users security
Performance analysis includes access to tools, ability to install Solar winds etc.
Qualifications :
Extensive experience in SQL Server DB Administration and MS SQL Server.
Strong analytical and problem-solving skills.
Detail-oriented and capable of managing multiple tasks simultaneously.
Excellent communication and collaboration skills.
Ability to work independently and as part of a team.
Strong understanding of database security and compliance requirements.
Proactive in identifying and addressing potential issues.
Experience with database performance tuning and optimization.
Familiarity with backup and recovery best practices.
Commitment to continuous learning and professional development.
Ability to create and maintain comprehensive documentation.
Years of Experience : 8-9 Years of Experience
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a MS SQL Database Administrator?
Sign up to receive alerts about other jobs on the MS SQL Database Administrator career path by checking the boxes next to the positions that interest you.