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 & MaintenanceConfigure 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 & SecurityEnsure 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 & AutomationDevelop and implement merge and transactional replication strategies.Automate routine database tasks to improve efficiency and reduce manual intervention.Troubleshooting & OptimizationDiagnose and resolve issues related to performance blocking / deadlocks replication connectivity and security.Perform data modeling query optimization and analysis of customer-provided data.Reporting & AnalysisWrite SQL queries and reports using existing data.Create and update records based on business requirements.Governance & DocumentationDevelop 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 & AvailabilityHands-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 & CollaborationExcellent communication and interpersonal skills for client interaction.Strong analytical and problem-solving abilities.Ability to work effectively in agile cross-functional development teams.Certifications & ClearanceSQL 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
Key Skills
Anti Money Laundering,Consultancy,Administration Support,Fire Alarm,Document Management,AV
Employment Type : Full-Time
Experience : years
Vacancy : 1
Yearly Salary Salary : 80000 - 95000