Senior SQL Server Database Administrator

Position: Senior SQL Server Database Administrator
Location: Washington, DC
Duration: Long term

THIS IS AN ONSITE ROLE 5 DAYS/WEEK.
NEED ONLY LOCALS TO WASHINGTON, DC
INTERVIEW PROCESS: 2 ROUNDS (VIRTUAL, INPERSON)
CLEARANCE REQUIRED: PUBLIC TRUST

Manager update:
They want candidates that are more senior (10 years).
Should be well versed in scripts and stored procedures.

Primary job duties and responsibilities may include, but are not limited to the following:
1 . Database Administration: Design, install, configure, upgrade, monitor, and maintain SQL Server databases to ensure high levels of performance, availability, and security.
2. Performance Tuning: Identify and resolve database performance issues, such as slow running queries, inefficient database design, and indexing problems, to ensure optimal database performance.
3. Backup and Recovery: Develop and implement backup and recovery strategies to protect the integrity and availability of the database, including disaster recovery planning and testing.
4. Security Management: Implement and maintain database security measures, including user access control, auditing, encryption, and compliance with regulatory requirements such as GDPR or HIPAA.
5. Troubleshooting: Analyze and resolve database-related issues, such as connectivity problems, data corruption, and system failures, in a timely and efficient manner.
6. Automation: Develop and maintain scripts, automation tools, and monitoring solutions to streamline database management tasks and improve operational efficiency.
7. Capacity Planning: Monitor database growth, analyze resource usage, and forecast capacity requirements to ensure that the infrastructure can support current and future needs.
8. Collaboration: Work closely with developers, system engineers, and other IT staff to support application development, deployment, and integration with the database platform.
9. Documentation: Create and maintain comprehensive documentation for database configurations, processes, and procedures to ensure knowledge transfer and compliance with organizational standards.

The successful candidate will have:
1. Education: Bachelor's degree in computer science, information technology, or a related field. A master's degree or relevant certifications
2. Experience: Several years of experience in SQL Server database administration, including experience with performance tuning, high availability, disaster recovery, and security.
3. Technical Skills: Proficiency in SQL Server administration, T-SQL, database design, troubleshooting, and performance optimization. Familiarity with cloud-based database platforms (e.g., AWS SQL Database) is a plus.
4. Tools and Technologies: Experience with database management tools such as SQL Server Management Studio, monitoring tools (e.g., SQL Profiler, Extended Events), and automation frameworks (e.g., PowerShell, T-SQL scripts).
5. Communication and Collaboration: Strong interpersonal and communication skills, as well as the ability to work effectively in a team environment and interact with stakeholders at all levels of the organization.
6. Problem-Solving: Analytical mindset and the ability to troubleshoot complex database issues, identify root causes, and implement effective solutions.
7. Compliance and Security: Knowledge of data protection regulations and best practices for securing sensitive data, as well as experience with implementing and maintaining security controls in a database environment.

Salary : $90 - $100