SQL Server DBA - Vector Talent Resources, Inc.
Washington, DC 20037
About the Job
Our Company: Vector Talent Resources is comprised of the industry's top recruiting talent that works aggressively and diligently to stay on top of market trends, technology, methodologies to source, attract, and acquire talent for our clients and opportunities for our Talent.
Title: SQL DBA
Positions Open: Currently 1 position open to hire, fulltime position
Location:Onsite Position, Washington, DC - Herndon, VA β Overland Park, KS β Atlanta, GA
Compensation: Salary Range $70k to $90k
Term Length: Full-time Employment, Onsite Position
W-2 Employees:"Applicants must be currently authorized to work in the U.S. on a full-time basis and will not require future sponsorship for this position or work transfers.β
- Must obtain a US Citizenship !!
Job Summary:
The SQL Server DBA will be responsible for the implementation, configuration, maintenance, performance and support of critical SQL Server DB systems, to ensure the availability and consistent performance of our corporate and business applications. This is a "hands-onβ position requiring solid technical skills, as well as excellent interpersonal and communication skills.
The successful candidate will be responsible for the development and support of different versions of SQL server and other database technologies like MySQL, Oracle, etc., ensuring their optimal functioning (security, health, performance, etc.).
The successful candidate must be capable of working independently or collaboratively with other team members.
Responsibilities:
- Manage SQL Server databases and other RDBMS through different product lifecycle from development to mission-critical production systems.
- Install, Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Support 24x7 operational database support including periodic on-call rotation.
- Conduct diagnostic tests and evaluate performance metrics on the databases.
- Monitor the databases to ensure system health, functionality and remediate problems/issues in a timely manner.
- Migrate/convert databases from Oracle 11g, 12c and 19c to MS SQL server.
- Execute & maintain SQL scripts and utility jobs for MS SQL database maintenance.
- Implement & manage MS SQL database backups and restore, clustering, always on, failover and load balancing technologies.
- Perform DB refreshes from Prod to lower environments.
- Monitor database status, logs, space utilization, extents, locks, blockings and deadlocks and clearing them accordingly.
- Implement and support MS SQL (Active/Passive & Active/Active), Multi Node Clustering for four node clusters.
- Apply data modeling techniques to ensure that development and implementation support efforts meet integration and performance expectations
- Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution.
- Refine and automate regular processes, track issues, and document changes
- Assist developers and application owners with complex query tuning and optimization.
- Perform scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Perform all other DB related tasks and activities as assigned.
- 3+ years of experience supporting MS SQL Server Databases
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- Experience with backups, restores and recovery models
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Experience working with Windows server, including Active Directory
- Experience creating and deploying SSRS, SSIS and SSAS packages.
- Ability to organize and plan work independently
- Ability to multi-task and context-switch effectively between different activities and teams
- Experience with MySQL, Oracle and MariaDB running on Linux
- Experience with VMware, NetApp and SSRS a plus
- Ability to write, keep and maintain SOP, documentation, etc.
- Oracle DB knowledge in a Unix environment
- Knowledge with Rubrik MS SQL backup technology.
- Knowledge with SQL Monitor MS SQL performance monitoring tool.
- Knowledge with Power Script/DBATools.
- Excellent written and verbal communication
Vector is an equal opportunity employer. We celebrate diversity and do not discriminate based on race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability status, or any other applicable characteristics protected by law.
Vector Talent Resources is an Equal Opportunity/Affirmative Action employer. All qualified candidates will receive consideration for employment without regard to disability, protected veteran status, race, color, religious creed, national origin, citizenship, marital status, sex, sexual orientation/gender identity, age or genetic information.