Immediate need for a talented MSSQL Database Administrator . This is a 06+months contract opportunity with long-term potential and is located in Mclean VA/ Plano TX (Onsite). Please review the job description below and contact me ASAP if you are interested.
Job ID:26-02876
Pay Range: $55 - $60/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
- Database Administration:
- 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.
- Cloud Migration:
- 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.
- Automation & Scripting:
- 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.
- Documentation & Support:
- 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.
Key Requirements and Technology Experience:
- 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 MMSSQL Server DBA.
- Hands-on experience with at least one major cloud platform (Azure, AWS, or Google Cloud Platform).
- 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.
- Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.
Our client is a leading Banking and Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .