Negotiable
Outside
Hybrid
USA
Summary: The Database Administrator Lead role involves overseeing database operations in a clustered SQL Server environment, focusing on migration and integration projects. This senior, hands-on position requires collaboration with cross-functional teams to ensure database performance, security, and reliability. The role is remote or hybrid based in New York and is expected to start in early October. The contract duration is one year, with a schedule of 35 hours per week.
Key Responsibilities:
- Administer and maintain SQL Server databases (2016 - 2022) in clustered environments.
- Perform backups, restores, and disaster recovery planning to protect data integrity.
- Manage user permissions and security controls for database access.
- Write and optimize T-SQL queries, stored procedures, views, and functions.
- Develop and maintain SSIS packages for ETL processes and SSRS reports.
- Collaborate on discovery and migration projects, ensuring smooth transitions.
- Participate in project meetings with technical teams, providing database expertise.
- Oversee CRM database control and ensure accurate data integrations.
- Act as a senior technical resource and provide guidance on database best practices.
Key Skills:
- 6 - 10 years of experience in database administration, preferably in lead or senior roles.
- Proven expertise with SQL Server 2016 - 2022 in high-availability clustered environments.
- Strong T-SQL skills (complex queries, stored procedures, performance tuning).
- Hands-on experience with SSIS and SSRS development.
- Knowledge of backup/restore processes, permissions management, and security best practices.
- Ability to manage multiple projects, coordinate with different teams, and provide clear communication.
- Experience in CRM data management and supporting enterprise-scale applications.
Salary (Rate): undetermined
City: New York
Country: USA
Working Arrangements: hybrid
IR35 Status: outside IR35
Seniority Level: Senior
Industry: IT
Detailed Description From Employer:
Database Administrator Lead SQL Server (Clustered Environment)
Location: Remote or Hybrid in New York (EST Time Zone)
Schedule: 9:30 AM 5:30 PM EST (35 hours per week)
Contract Duration: 1 Year
Start Date: Early October
About Us
CIMA Consulting Group is a certified women- and minority-owned staffing firm that partners with top companies across the U.S. to provide white-glove staffing solutions. We pride ourselves on building strong relationships, supporting our clients business goals, and helping talented professionals find meaningful opportunities.
About the Role
We are seeking a Database Administrator Lead to support a series of migration and integration projects. This is a senior, hands-on role where you will take ownership of database operations, collaborate with cross-functional teams, and ensure database performance, security, and reliability in a clustered SQL Server environment.
What You ll Do
- Administer and maintain SQL Server databases (2016 2022) in clustered environments.
- Perform backups, restores, and disaster recovery planning to protect data integrity.
- Manage user permissions and security controls for database access.
- Write and optimize T-SQL queries, stored procedures, views, and functions.
- Develop and maintain SSIS packages for ETL processes and SSRS reports.
- Collaborate on discovery and migration projects, ensuring smooth transitions.
- Participate in project meetings with technical teams, providing database expertise.
- Oversee CRM database control and ensure accurate data integrations.
- Act as a senior technical resource and provide guidance on database best practices.
What We re Looking For
- 6 10 years of experience in database administration, preferably in lead or senior roles.
- Proven expertise with SQL Server 2016 2022 in high-availability clustered environments.
- Strong T-SQL skills (complex queries, stored procedures, performance tuning).
- Hands-on experience with SSIS and SSRS development.
- Knowledge of backup/restore processes, permissions management, and security best practices.
- Ability to manage multiple projects, coordinate with different teams, and provide clear communication.
- Experience in CRM data management and supporting enterprise-scale applications.
Nice-to-Haves
- Previous experience leading or mentoring other DBAs.
- Exposure to data migration projects in large enterprise environments.
- Familiarity with project management methodologies (Agile/Waterfall).
CIMA Consulting Group, LLC is an Equal Opportunity Employer