Benefits:
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
MSM Technology is seeking to fill the SQL Database Administrator position. We strive to provide the next generation of cutting-edge technologies. Our growth means exciting career opportunities for talented professionals in engineering software development and other key areas. We offer competitive compensation and benefits including Health Vision and Dental Insurance a matching 401k plan and other benefits given below excellent training and a vibrant working environment. Our employees are exceptional giving us a competitive advantage by innovating solutions with a strong sense of mission and integrity.
o Position: SQL DBA
o Position Type: On-site
o Clearance: Secret or Higher
Description
As a SQL Server Database Administrator you will be responsible for managing and optimizing on-premises SQL databases that support web applications. Your role will ensure high performance availability security and sustainability of database systems through proactive maintenance and strategic planning.
Key Respsibilities:
- Database Management & Maintenance
- Configure install upgrade and maintain Microsoft SQL Server databases in a production environment.
- Monitor database performance and conduct tuning procedures to ensure optimal operation.
- Create and manage scheduled jobs data extracts refreshes loads and replication processes.
- Performance Availability & Security
- Ensure high levels of database performance availability and data integrity.
- Implement and manage high availability solutions such as Always On and SQL clustering.
- Apply Transparent Data Encryption (TDE) and manage encrypted database backups and restores.
- Replication & Automation
- Develop and implement merge and transactional replication strategies.
- Automate routine database tasks to improve efficiency and reduce manual intervention.
- Troubleshooting & Optimization
- Diagnose and resolve issues related to performance blocking/deadlocks replication connectivity and security.
- Perform data modeling query optimization and analysis of customer-provided data.
- Reporting & Analysis
- Write SQL queries and reports using existing data.
- Create and update records based on business requirements.
- Governance & Documentation
- Develop and enforce database policies and procedures to maintain system integrity and compliance.
- Maintain documentation for database configurations processes and troubleshooting steps.
Requirements
Technical Expertise
- 5 years of experience with Microsoft SQL Server in application support or development environments.
- Strong proficiency in SQL Server 2016 and newer versions.
- Deep understanding of database structures principles and best practices.
- Skilled in T-SQL including indexes triggers functions stored procedures and packages.
- Experience with SQL Server replication (merge and transactional).
- Familiarity with SSAS (Analysis Services) SSIS (Integration Services) and SSRS (Reporting Services).
- Proficient in Windows Server operating systems.
- Security & Availability
- Hands-on experience with Transparent Data Encryption (TDE).
- Strong knowledge of backup strategies restore procedures and recovery models.
- Experience implementing high availability solutions (Always On clustering).
- Soft Skills & Collaboration
- Excellent communication and interpersonal skills for client interaction.
- Strong analytical and problem-solving abilities.
- Ability to work effectively in agile cross-functional development teams.
- Certifications & Clearance
- SQL Server certification.
- CompTIA Security certification.
- Must hold an ACTIVE Secret Clearance or higher.
Please check the Job Description and let me know if you are interested. If you feel curious please send me your salary expectations updated resume and the best time to reach you on
Usman Khan
Sr. Recruitment Professional
Representing:
MSM Technology LLC
Direct:
Main: Ext.: 502
Please consider the environment before printing this email.
MSM Technology is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race color religion gender national origin sexual orientation gender identity disability status protected veteran status or any other characteristic protected by law.
Compensation: $80000.00 - $95000.00 per year
Required Experience:
Unclear Seniority
Benefits:401(k) matchingDental insuranceHealth insurancePaid time offMSM Technology is seeking to fill the SQL Database Administrator position. We strive to provide the next generation of cutting-edge technologies. Our growth means exciting career opportunities for talented professionals in engineer...
Benefits:
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
MSM Technology is seeking to fill the SQL Database Administrator position. We strive to provide the next generation of cutting-edge technologies. Our growth means exciting career opportunities for talented professionals in engineering software development and other key areas. We offer competitive compensation and benefits including Health Vision and Dental Insurance a matching 401k plan and other benefits given below excellent training and a vibrant working environment. Our employees are exceptional giving us a competitive advantage by innovating solutions with a strong sense of mission and integrity.
o Position: SQL DBA
o Position Type: On-site
o Clearance: Secret or Higher
Description
As a SQL Server Database Administrator you will be responsible for managing and optimizing on-premises SQL databases that support web applications. Your role will ensure high performance availability security and sustainability of database systems through proactive maintenance and strategic planning.
Key Respsibilities:
- Database Management & Maintenance
- Configure install upgrade and maintain Microsoft SQL Server databases in a production environment.
- Monitor database performance and conduct tuning procedures to ensure optimal operation.
- Create and manage scheduled jobs data extracts refreshes loads and replication processes.
- Performance Availability & Security
- Ensure high levels of database performance availability and data integrity.
- Implement and manage high availability solutions such as Always On and SQL clustering.
- Apply Transparent Data Encryption (TDE) and manage encrypted database backups and restores.
- Replication & Automation
- Develop and implement merge and transactional replication strategies.
- Automate routine database tasks to improve efficiency and reduce manual intervention.
- Troubleshooting & Optimization
- Diagnose and resolve issues related to performance blocking/deadlocks replication connectivity and security.
- Perform data modeling query optimization and analysis of customer-provided data.
- Reporting & Analysis
- Write SQL queries and reports using existing data.
- Create and update records based on business requirements.
- Governance & Documentation
- Develop and enforce database policies and procedures to maintain system integrity and compliance.
- Maintain documentation for database configurations processes and troubleshooting steps.
Requirements
Technical Expertise
- 5 years of experience with Microsoft SQL Server in application support or development environments.
- Strong proficiency in SQL Server 2016 and newer versions.
- Deep understanding of database structures principles and best practices.
- Skilled in T-SQL including indexes triggers functions stored procedures and packages.
- Experience with SQL Server replication (merge and transactional).
- Familiarity with SSAS (Analysis Services) SSIS (Integration Services) and SSRS (Reporting Services).
- Proficient in Windows Server operating systems.
- Security & Availability
- Hands-on experience with Transparent Data Encryption (TDE).
- Strong knowledge of backup strategies restore procedures and recovery models.
- Experience implementing high availability solutions (Always On clustering).
- Soft Skills & Collaboration
- Excellent communication and interpersonal skills for client interaction.
- Strong analytical and problem-solving abilities.
- Ability to work effectively in agile cross-functional development teams.
- Certifications & Clearance
- SQL Server certification.
- CompTIA Security certification.
- Must hold an ACTIVE Secret Clearance or higher.
Please check the Job Description and let me know if you are interested. If you feel curious please send me your salary expectations updated resume and the best time to reach you on
Usman Khan
Sr. Recruitment Professional
Representing:
MSM Technology LLC
Direct:
Main: Ext.: 502
Please consider the environment before printing this email.
MSM Technology is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race color religion gender national origin sexual orientation gender identity disability status protected veteran status or any other characteristic protected by law.
Compensation: $80000.00 - $95000.00 per year
Required Experience:
Unclear Seniority
View more
View less