What are the responsibilities and job description for the Microsoft SQL Server Administrator position at California Creative Solutions Inc.?
Job Description
Job Description
Primary Responsibilities
Administer and maintain databases (MSSQL, MySQL, PostgreSQL) to ensure optimal performance and availability.
Perform database lifecycle activities, including installation, configuration, upgrades, patching, and monitoring.
Implement disaster recovery strategies, index maintenance, and database performance optimization.
Monitor database health using tools like SQL Server Management Studio, ensuring CPU, memory, and disk usage remain within thresholds.
Enhance database configurations to improve performance and reduce costs.
Manage access controls, audit logs, and user accounts to uphold database security and integrity.
Produce documentation, SOPs, reports, and presentations for both technical and non-technical audiences.
Troubleshoot database issues in a high-security environment.
Build and maintain strong relationships with government customers, communicating effectively across diverse teams.
Basic Qualifications
Requires a Bachelor's degree and 10 years of relevant experience, or Masters degree with 8 years of experience. Additional years of experience may be considered in lieu of a degree
10 years of hands-on experience in MS SQL Server database administration.
Proven expertise with MSSQL, MySQL, and PostgreSQL databases.
Proficiency in database performance monitoring, tuning, and optimization.
Experience with containerization (e.g., Docker) and orchestration (e.g., Kubernetes).
Skilled in backup strategies and shell scripting for database management.
Knowledge of Agile methodologies and experience working in Agile environments.
Strong communication and teamwork skills, with a track record of achieving project objectives.
Candidate must, at a minimum, meet DoD 8570.11- IAT Level II certification requirements (currently Security CE, CCNA-Security, GICSP, GSEC, or SSCP along with an appropriate computing environment (CE) certification). An IAT Level III certification would also be acceptable (CASP , CCNP Security, CISA, CISSP, GCED, GCIH, CCSP).
Preferred Qualifications
MCSA SQL Server certification.
AWS certification or hands-on experience with cloud services (e.g., AWS).
Familiarity with NMEC operations or related agency experience.
Experience troubleshooting in secure environments.
Proven ability to lead teams and manage project deliverables.
