Senior Database Administrator

This position is fully-remote. Must meet all minimum requirements for consideration.

 

 

POSITION OVERVIEW:

The Senior Database Administrator (DBA) is responsible for designing, developing, administering, and optimizing Microsoft SQL Server databases to support both in-house applications and third-party platforms.  This role bridges application development and production operations, ensuring databases are built for performance, scalability, and stability.  The ideal candidate will work closely with developers to design efficient database structures and write optimized SQL, while also overseeing critical operational tasks such as backups, high availability, monitoring, and compliance.

 

The Senior DBA will provide technical leadership, enforce database standards, and help shape strategies for current and future database initiatives.  This position requires the ability to obtain and maintain a 6C clearance. The organization will sponsor and guide the selected candidate through the clearance process.  This position includes participating in internal and external audits, including STIG compliance reviews, to ensure compliance with security, regulatory, and organizational standards.

 

Key Responsibilities:

 

Database Administration & Operations

• Manage and maintain SQL Server environments, including installation, configuration, patching, and upgrades.
• Design and maintain high-availability solutions such as AlwaysOn Availability Groups and clustering.
• Monitor database performance and proactively address capacity and stability concerns.
• Ensure robust backup and disaster recovery strategies are implemented and tested.
• Maintain database security and compliance through roles, permissions, encryption, and auditing.
• Participate in a 24/7 on-call rotation to troubleshoot and resolve production issues, ensuring system availability and minimal downtime.
• Provide timely incident response, root cause analysis, and resolution for urgent database related issues.

 

SQL Development & Performance Tuning

• Write, review, and optimize T-SQL queries, stored procedures, and functions for performance and reliability.
• Perform code reviews and mentor developers on SQL best practices.
• Analyze and troubleshoot performance issues using execution plans, DMVs, and monitoring tools.
• Collaborate with developers to ensure efficient interaction between applications and database layers.

 

Change Management & Deployment

• Support development teams throughout the SDLC, including test, staging, and production environments.
• Utilize ServiceNow (or similar ITSM tools) to document and track incidents, problems, and change requests.
• Establish and enforce change management processes for database objects and deployments.
• Review and validate all changes prior to production release.

 

SSIS (ETL Development)

• Design, build, and maintain SSIS packages to support ETL processes, data migrations, and integrations between internal and external systems.
• Ensure SSIS workflows are optimized, error-handled, and well-documented for maintainability and scalability.
• Establish standards and templates for SSIS development to ensure consistency across environments.

PBIRS (Reporting Solutions)

• Create and maintain PBIRS reports and dashboards, delivering accurate, actionable data to business teams.
• Collaborate with stakeholders to gather reporting requirements and design solutions that balance performance and usability.
• Partner with business units to support analytics and data-driven decision-making.

 

Quality Assurance

• Validate database designs and changes align with business requirements and performance goals.
• Participate in testing, performance benchmarking, and release reviews.
• Conduct post-implementation assessments to identify areas for improvement.

 

Continuous Improvement & Mentorship

• Stay current with Microsoft SQL Server features, be