Pyramid Consulting, Inc · 2 hours ago
MSSQL Database Administrator
Pyramid Consulting, Inc. is a leading company in the Banking and Financial Industry, and they are seeking a talented MSSQL Database Administrator. The role involves database administration, cloud migration strategies, and automation of routine tasks, ensuring optimal performance and security of database environments.
ConsultingInformation TechnologyLegalProfessional ServicesSoftwareStaffing Agency
Responsibilities
Install, configure, upgrade, and patch Microsoft SQL Server instances
Monitor database performance, tune queries, and optimize indexes
Implement and maintain high availability and disaster recovery solutions (e.g., Always On, Log Shipping, Replication)
Perform regular backups and restores; ensure data integrity and security
Manage users, roles, and permissions following best practices
Assess existing on-premises SQL Server environments and plan cloud migration strategies
Execute migrations to cloud platforms (preferably Azure SQL Database, Managed Instance, or AWS RDS)
Use migration tools such as Data Migration Assistant (DMA), Azure Database Migration Service (DMS), or equivalent
Test and validate data integrity and application performance post-migration
Optimize cloud database resources for cost, performance, and scalability
Develop and maintain scripts for automation of routine tasks using PowerShell, T-SQL, or cloud-native tools
Monitor and automate alerts, reports, and maintenance jobs
Create and maintain detailed documentation of database architecture, configurations, and migration processes
Provide technical support for application and development teams
Troubleshoot and resolve database-related incidents and service requests
Qualification
Required
Must have skills: - MSSQL, migration from on prem to AWS RDS
Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience)
10+ years of experience as a MSSQL Server DBA
Hands-on experience with at least one major cloud platform (Azure, AWS, or GCP)
Proven experience in database migrations from on-premises to cloud
Strong knowledge of database security, backup/recovery, and performance tuning
Proficiency in T-SQL and PowerShell scripting
Experience with cloud-native database monitoring and management tools
Excellent communication and documentation skills
Preferred
Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus
Benefits
Health insurance (medical, dental, vision)
401(k) plan
Paid sick leave (depending on work location)
Company
Pyramid Consulting, Inc
Pyramid Consulting, a global leader in workforce and technology solutions, empowers individuals and organizations to transform and thrive in the most challenging and competitive markets.
H1B Sponsorship
Pyramid Consulting, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (178)
2024 (112)
2023 (95)
2022 (62)
2021 (50)
2020 (117)
Funding
Current Stage
Late StageRecent News
2025-08-18
Company data provided by crunchbase