SQL Database Administrator/Senior Database Developer

Carman Solutions Group; Union (NJ); On-site; USD 114,000 - 166,000; Full time

Job summary

A leading company is seeking a SQL Database Administrator/Senior Database Developer to analyze, design, and implement scalable database solutions. The role involves optimizing performance, ensuring high availability, and collaborating with development teams. Ideal candidates will have extensive SQL Server experience and a strong background in database architecture.

Qualifications

• 8+ years of experience in SQL Server database design, development, and administration.
• Experience with large-volume databases (100TB+) and performance tuning.

Responsibilities

• Assess and improve SQL Server database architecture for scalability and performance.
• Design and implement high-performance database architecture for 5M daily transactions.

Skills

Problem Solving

Communication

Education

Bachelor's or Master's degree in Computer Science

Tools

T-SQL

ERwin

PowerDesigner

Job description

SQL Database Administrator/Senior Database Developer

Join to apply for the SQL Database Administrator/Senior Database Developer role at Carman Solutions Group

SQL Database Administrator/Senior Database Developer

Join to apply for the SQL Database Administrator/Senior Database Developer role at Carman Solutions Group

Get AI-powered advice on this job and more exclusive features.

Job Title: SQL Database Administrator/Senior Database Developer

Location: Union, NJ / Germantown, MD (Onsite)

Job Type: Contract

Visa: Only US Citizen, Green Card

Job Summary: The SQL Database Administrator/Senior Database Developer will be responsible for analyzing, designing, and implementing a scalable and high-performance database solution. The ideal candidate should have extensive experience with SQL Server, performance tuning, and designing scalable database architectures that support microservices-based applications and AI-driven systems.

Key Responsibilities

• Assess the current SQL Server database architecture and identify areas for improvement in scalability, performance, and maintainability.
• Design and implement a new high-performance, future-ready database architecture to support a 5M daily transaction load and integration with microservices and AI-driven systems.
• Develop and implement a comprehensive archival strategy for cold, warm, and hot data storage to efficiently manage a large-scale system of 100TB.
• Work closely with application developers to ensure database design aligns with the microservices architecture.
• Optimize database performance by identifying and resolving bottlenecks, indexing strategies, and query tuning.
• Develop and implement best practices for database design, partitioning, indexing, and data archiving.
• Ensure high availability and disaster recovery strategies with near-zero RPO and RTO, considering the multi-agency information handled by the system.
• Collaborate with DevOps teams to automate deployment, backup, and monitoring processes.
• Implement data security measures and ensure compliance with industry standards.
• Provide technical guidance and mentorship to the development and operations teams.
• Stay up-to-date with the latest SQL Server technologies and industry trends.
• Perform Bulk Insert, import, export from different data sources.
• Develop scripts to create constraints, defaults, rules, tables, indexes, vies, stored procedures, functions, triggers, cursors and dynamic TSQL queries.
  
  

Required Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• 8+ years of experience in SQL Server database design, development, and administration.
• Proven experience in redesigning and implementing large-scale, high-performance SQL Server databases, with the ability to contribute from day one.
• Strong understanding of database scalability techniques such as sharding, partitioning, and indexing.
• Experience in handling large-volume databases (100TB+) and implementing efficient archival strategies.
• Proficiency in performance tuning, query optimization, and troubleshooting database issues.
• Experience with self-hosted SQL Server databases on virtual machines (VMs).
• Hands-on experience with database migration, backup, and recovery processes.
• Familiarity with data modeling techniques and tools such as ERwin or PowerDesigner.
• Strong knowledge of T-SQL, stored procedures, and triggers.
• Experience with microservices architecture and integrating databases within distributed systems.
• Excellent problem-solving skills and the ability to work in a fast-paced environment.
• Strong communication and collaboration skills.
  
  

Preferred Qualifications

• Tolling Experience is strong plus
• Any relevant SQL Server certification is preferred.
• Experience with NoSQL databases and hybrid database solutions.
• Knowledge of AI-driven database optimization and predictive analytics.
• Knowledge of ETL processes and data warehousing concepts.
  
  

Regards, Himanshu Rawat [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Carman Solutions Group by 2x

Get notified about new Senior Sql Database Administrator jobs in Union, NJ.

Newark, NJ $114,816.00-$165,845.00 1 month ago

New York, NY $114,816.00-$165,845.00 1 month ago

New York, NY $89,301.33-$121,194.66 1 month ago

New York, NY $114,816.00-$165,845.33 1 month ago

Newark, NJ $114,816.00-$165,848.66 1 month ago

Newark, NJ $89,301.33-$121,194.66 1 month ago

New York, NY $89,301.33-$114,816.00 1 month ago

Senior Associate, Database Administrator

New York City Metropolitan Area $100,000.00-$120,000.00 3 weeks ago

Newark, NJ $89,301.33-$114,816.00 1 month ago

New York, NY $135,000.00-$172,000.00 1 month ago

New York, NY $150,000.00-$170,000.00 2 months ago

Azure SQL Database Administrator | W2 only | Multiple locations | Fully onsite

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.