ID
#13523153
Job type
Contract
Salary
Depends on Experience
Source
Spruce Technology Inc.
Date
2021-05-17
Deadline
2021-07-16

Data Architect/ SQLServer DBA

New York, New york city, 10038

Contract

Vacancy expired!

Job Title: Data Architect/ SQL Server DBA

Duration: 6 months

Location:

New York, NY 10041

Spruce Technology is a mid-size and rapidly-growing Information Technology services firm headquartered in New Jersey. An award-winning firm (Inc 5000, Smart CEO) with a steadily growing portfolio of commercial and government clients, Spruce Technology provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide.

Spruce Technology, Inc. is an Equal Opportunity Employer that does not discriminate on the basis of actual or perceived age, sex, pregnancy, race, creed, color, national origin, disability, marital status, sexual orientation, citizenship status, genetic information, religion, or any other characteristic protected by applicable federal, state or local laws.

Skills

12 years of expertise in MS-SQL Server database administration, utilities and tools.
6-8 years of application data modeling experience using tools like ERwin or ER/Studio.
Microsoft Certified Database Administrator.
Proficiency in supporting MS-SQL Server 2014/2016/2017/2019 databases in high availability environments with intimate knowledge of both SQL and T-SQL.
Demonstrated knowledge of designing, developing and integrating databases, data warehouses and multidimensional databases in MS-SQL Server.
Conduct performance analysis and tuning, index maintenance, monitoring, and disaster recovery of data.
Experience with high availability features such as clustering and mirroring.
Facilitate creation, migration and maintenance of database objects across development/QA/ production environments.
Architecting and managing multiple 64 bit SQL 2012/2016/SQL2017 database environments in Development, QA, UAT and Production.
Upgrading all the database servers from SQL 2008, SQL 2012R2 to SQL 2016/2017 in the Application assigned to the database team.
Documented and Implemented secure SQL Server Installation process.
Ability to write and optimize complex SQL queries, triggers, procedures and functions.
Familiarity with SSRS, SSAS, SSIS and data warehousing concepts like ETL, Dimensions, Facts, Cubes.
Experience with database replication techniques.
Ability to perform both database-level and operating system performance tuning and monitoring.
Knowledge of SQL Server backup and recovery scenarios.
Proficiency in SQL Server security management.

If interested, please forward a latest copy of your resume with contact information to (Abdul// )

Vacancy expired!

Report job