Rackera - McLean, VA

posted 3 months ago

Full-time - Senior
McLean, VA

About the position

The Sr SQL DBA position is a critical role responsible for managing and maintaining SQL Server databases across various environments, including development, testing, and production. The ideal candidate will have over 12 years of experience in database administration, with a strong focus on SQL Server. This role involves performing database installations, configurations, upgrades, and patching, ensuring that the databases are secure, efficient, and reliable. The Sr SQL DBA will implement and manage database backups, restores, and disaster recovery strategies to safeguard data integrity and availability. In addition to database administration, the role requires a strong emphasis on security management. The Sr SQL DBA will ensure database security by implementing and maintaining user roles, permissions, and encryption. Regular audits of database security will be conducted to ensure compliance with company policies and industry standards. The candidate will also be responsible for responding to and managing database security incidents, ensuring that any vulnerabilities are addressed promptly. Performance tuning and optimization are key responsibilities of this role. The Sr SQL DBA will analyze and optimize database performance using various tools and techniques, including indexing, query optimization, and storage management. Collaboration with developers is essential to optimize application performance, which includes writing and optimizing queries. The candidate will also design and implement high availability (HA) and disaster recovery (DR) strategies, including clustering, replication, and log shipping. Regular testing and documentation of these strategies will be required to ensure business continuity. Furthermore, the Sr SQL DBA will provide strategic direction for database architecture, including schema design, data modeling, and normalization, while evaluating and recommending new database technologies and tools. Automation and scripting are also integral to this role. The Sr SQL DBA will develop and maintain automation scripts for routine database tasks, utilizing scripting languages such as PowerShell or Python for automation and task management. This position is a contract role for 12 months, located in McLean, VA, and is open to H1B and USC visa holders.

Responsibilities

  • Manage and maintain SQL Server databases across multiple environments (development, testing, production).
  • Perform database installations, configurations, upgrades, and patching.
  • Implement and manage database backups, restores, and disaster recovery strategies.
  • Monitor database performance, identifying and resolving performance bottlenecks.
  • Ensure database security by implementing and maintaining user roles, permissions, and encryption.
  • Regularly audit database security to ensure compliance with company policies and industry standards.
  • Respond to and manage database security incidents.
  • Analyze and optimize database performance using tools and techniques such as indexing, query optimization, and storage management.
  • Collaborate with developers to optimize application performance, including query writing and optimization.
  • Design and implement high availability (HA) and disaster recovery (DR) strategies, including clustering, replication, and log shipping.
  • Test and document HA and DR strategies regularly to ensure business continuity.
  • Provide strategic direction for database architecture, including schema design, data modeling, and normalization.
  • Collaborate with development teams to design scalable and efficient database solutions.
  • Evaluate and recommend new database technologies and tools.
  • Develop and maintain automation scripts for routine database tasks (e.g., backups, indexing, monitoring).
  • Use scripting languages like PowerShell or Python for automation and task management.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  • Over 12 years of experience as a SQL Database Administrator, with a strong focus on SQL Server.
  • Expertise in database performance tuning, optimization, and troubleshooting.
  • Proven experience with SQL Server High Availability (HA) and Disaster Recovery (DR) strategies.
  • Strong knowledge of SQL Server security best practices, including data encryption and auditing.
  • Proficiency in scripting languages such as T-SQL, PowerShell, or Python.
  • Experience with database design, data modeling, and schema management.
  • Familiarity with cloud database solutions (e.g., Azure SQL, AWS RDS) is a plus.
  • Strong communication and collaboration skills, with the ability to work effectively in a team environment.

Nice-to-haves

  • Microsoft Certified: Azure Database Administrator Associate
  • Microsoft Certified: Azure Solutions Architect Expert
  • Microsoft Certified: SQL Server Database Administration certification (MCDBA)
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service