What are the responsibilities and job description for the SQL DBA Specialist position at Pyramid Consulting, Inc?
Immediate need for a talented SQL DBA Specialist. This is a 06 months contract opportunity with long-term potential and is located in Plano, TX / McLean, VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.
Job ID: 25-65971
Pay Range: $60 - $65/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 engineering team looking for a skilled Database Engineer to provide database production support in a fast-paced operations environment supporting business critical applications using backend MS-SQL database platforms.
- As a MSSQL Database Engineer, play a critical role in ensuring the performance, security, and scalability of our databases and collaborate with cross-functional teams, including software developers, data analysts, and system administrators, to deliver efficient and reliable database solutions.
- Provide expertise in SQL programming, database architecture, and troubleshooting will be essential in optimizing database performance and resolving complex technical issues.
Key Requirements and Technology Experience:
- Key skills; SQL Server, Migration, PowerShell
- More than seven years of experience working as a production support database administrator (DBA)
- Strong database administration experience on MS-SQL Server
- Experience in installation, configuration and migration with MS-SQL database platforms.
- Refine and automate regular processes, track issues, and document changes
- Strong database performance tuning skills - query optimization and server tuning with MSSQL platforms
- Possesses deep understanding of MSSQL internals and Optimizer functioning and ability to apply the skills to trouble-shoot real time production issues
- Provide deployment support for database objects in production and test environment
- Extremely comfortably in power shell scripting with prior experience in writing and maintaining complex scripts to perform database maintenance.
- Experience in migrating SQL platform to industry standard versions.
- Execute large database migration projects independently
- Experience with standard database monitoring.
- Understanding of industry standard High Availability and DR technologies
- Experience with providing 24x7 production on-call support on rotation basis
- Effective verbal and writing communication skills
- Experience in ansible automation is preferable
- Experience with data security and compliance with industry standards
- Experience on other db platforms Sybase or PostgreSQL and No-SQL like Mongo is preferable
Our client is a leading 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, color, 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 here.
Salary : $60 - $65
