What are the responsibilities and job description for the SQL Database Administrator position at Zachary Piper LLC?
Zachary Piper Solutions is seeking a SQL Server Database Administrator to join a Federal Program located in Colorado Springs, CO. The SQL DBA will support Homeland Security by overseeing database administration, performance tuning, troubleshooting, and ensuring the availability, integrity, and security of our SQL databases.
Responsibilities of the SQL Server Database Administrator include:
- Administer and maintain SQL Server database environments, including installation, configuration, and patch management.
- Ensure operational status and performance monitoring of databases.
- Oversee database replication monitoring and fault correction.
- Monitor database performance, identify bottlenecks, and implement optimization strategies to ensure optimal throughput and responsiveness.
- Perform database design, data modeling, and schema management to support application requirements and performance goals.
- Implement and maintain database security measures, including user access controls, data encryption, and auditing mechanisms.
- Conduct database capacity planning and forecasting to accommodate future growth and changing business requirements.
- Develop and maintain database backup and recovery strategies to ensure data availability and integrity.
- Collaborate with development teams to optimize SQL queries, database code, and stored procedures for improved performance.
- Create and maintain documentation related to database configurations, procedures, and troubleshooting guides.
Qualifications for the SQL Server Database Administrator include:
- 5 years of relevant experience
- Must have an Active Secret Clearance.
Compensation for the SQL Server Database Administrator includes:
- Salary Range: $75,000 - $85,000 depending on experience
- Enjoy job security with a fully funded program guaranteed for five years.
- Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays
This job opens for applications on 4/8/2025. Applications for this job will be accepted for at least 30 days from the posting date.
Keywords:
SQL Database Administrator, federal, SQL DBA, mission critical systems, Homeland defense, database administration, performance tuning, troubleshooting, availability, integrity, security, SQL databases, SQL Server, installation, configuration, patch management, operational status, performance monitoring, replication monitoring, fault correction, bottlenecks, optimization strategies, throughput, responsiveness, database design, data modeling, schema management, application requirements, performance goals, security measures, user access controls, data encryption, auditing mechanisms, capacity planning, forecasting, future growth, business requirements, backup strategies, recovery strategies, data availability, data integrity, development teams, SQL queries, Secret, cleared, clearance, TS, TS/SCI, top secret
#LI-KG1
#LI-ONSITE
#PANDOLOGIC
Job Id:
139613
Job Category:
Job Location:
Colorado Springs, CO
Security Clearance:
Secret
Business Unit:
Zachary Piper
Division:
Zachary Piper Solutions
Position Owner:
Kaitlyn Golding
Salary : $75,000 - $85,000