• Share this Job

SQL Server Database Architect

Location : Florham Park, NJ
Job Type : Temp/Contract
Hours : Full Time
Travel : No
Relocation : No

Job Description :
Ridgefield One is a technology and general staffing agency serving NY, CT, and VT.  Our client is a major insurance company with offices in Florham Park, NJ and Charlotte, North Carolina.


Role Summary:

We are seeking a Senior SQL Server Database Architect.  The SQL Server Architect will work under enterprise Architecture team to establish overall SQL Server and Database architectural vision and direction. He or she will design, implement and maintain SQL Server database systems, working with database administrators, software developers, data architects and infrastructure engineers to create optimized and scalable solutions for the company.


Job Requirements:

This position requires expert-level knowledge of Microsoft SQL Server from architecting to administration including design, development, and optimization of SQL Server databases. This is a hands-on role for which a qualified candidate must be able to perform the majority if not all of the tasks below, and lead the current DBA team technically.

Database Design  and Development

-          Assist application development and business intelligence teams during the logical and physical database design and implementation.  Become the primary technical owner of the production databases and ensure they are highly optimized and operate at peak performance.

Maintenance and Support

-          Design and implement multi-environment SQL Server databases in support of multiple product lifecycle environments, from development to never-fail production systems.

-          Design robust but flexible maintenance plans to ensure the databases are fully optimized, secured backed up and fully monitored 24x7. Ensure the database systems have ample storage and memory capacity as they grow and they are protected always with the proper security layers.

-          Support the DBA team as needed with the scheduled maintenance and support release deployment activities after hours

-          Review and rewrite database changes or maintenance scripts (e.g. re-indexing) provided by other DBAs or third party application development vendors as needed.

-          Design and implement 24x7 monitoring processes supported by the best technical solution possible. Implement an operations center for databases either custom or by using commercial off the shelf systems.

-          Work closely with the system administration team to establish proper patching processes and ensure the right patches are applied regularly

-          Work closely with the security management and change management teams to monitor and managing server and database security and permissions

 High Availability, Disaster Recovery, Upgrades and Migrations

-          Design, implement, configure, and monitor SQL Clusters, Always On Availability Groups, Always On Availability Group listeners, and all related dependencies for a never-fail configuration across subnets.

-          Ensure that database structures as well as load-balancing processes are working in synch to eliminate down-time during incidents and/or backup processes

-          Work closely with the operations team to design and implement technologies and processes that ensure all database servers are backed up in support of the business Recovery Point Objectives (RPO) and Recovery Time Objective (RTO). Monitor and audit database backups and restores as well as periodic testing to ensure RPO/RTO service level agreements are being met. 

-          Plan and manage the execution of the database migrations to newer operating system versions, and the database environment mergers during the acquisitions.

 Monitoring and Performance Optimization

-          Develop technologically advanced solutions to monitor databases and the underlying management processes. These solutions should be tailored for applications and business intelligence purposes using native Microsoft and third-party technologies to ensure high levels of performance, capacity, availability and security

-          Work closely with the server administration and service management teams to minimize unnecessary licensing and hardware purchases.

-          Perform and manage high-end performance tuning activities and assist developers in tuning SQL queries to optimize performance

 Database Development

-          Work closely with the application and data architects to translate business requirements into SQL based solutions and ensure proper design and implementation practices are followed by the design and development teams. Act as the final approval signatory for database design

-          Review and optimize functions, scripts, stored procedures, triggers, SSIS and SSRS scripts to ensure optimal coding goes into production.



-          Assist the DBA team in troubleshooting SQL Server service outages and issues as they occur, on a 24x 7 basis. Perform, log reviews, execution plans reviews, configuration parameter investigation, system resource optimization, query tuning and more.

 Knowledge Sharing

-          Provide technical documentation, mentorship and cross-training to peers and team members. Serve as the in-house SQL Server database expert and maintain relationships with Microsoft technical teams, the technical community at large and supporting vendors.  Mentor all DBAs so they can achieve a higher level of proficiency and qualifications.

Required Qualifications :


A Bachelor’s degree in Computer Science/Management Information Systems, engineering or natural science degree, with a minimum of 10 years relevant experience.

  • Proficient in Microsoft SQL Server 2008/2012/2014/2016 and Windows Server 2003-2016. Certification or the ability to acquire it in the next 12 months is required.

  • Proficient in designing/implementing/administering large and complex SQL Server environments

  • Proven work experience troubleshooting transaction logs, viewing execution plans, tuning queries, and indexing strategies.

  • Proven work experience and familiarity with best practices, technologies, concepts, and configurations relating to Backups/Restores, Disaster Recovery, High Availability (AAG, Clustering),Monitoring and Alerting, Data Integration, and System Optimization

  • Familiar with SQL Reporting services including creating, modifying, and managing custom reports

  • Understanding of VMWare and storage PURE and NETAPP technologies is a plus



Ridgefield One provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, gender, sexual orientation, national origin, age, disability, or genetics. In addition to federal law requirements, Ridgefield One complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities or client worksites. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.


Powered by AkkenCloud