SQL Server Architect / DBA / Data Engineer
Job Title: SQL Server Architect / DBA / Data EngineerLocation: New York City, NY — Hybrid, 1 day onsite per weekDuration: ContractMANDATORY- In person (F2F)- Final(Client) Round at NYC, NYMUST-HAVE10+ years of experience in database administration and/or database architecture.Strong hands-on experience with Microsoft SQL Server and SQL/T-SQL scripting.Advanced SQL skills, including stored procedures, query optimization, indexing, and performance tuning.Strong experience with database architecture, data modeling, backup/recovery, high availability, disaster recovery, and database security.Enterprise-level experience with data integration, ETL, data warehousing, and data lakes.Experience supporting large-scale enterprise environments and production databases.PREFERRED / NICE-TO-HAVEPython, PowerShell, Shell Scripting, VBASSIS / ETLPower BIData Lake / Lakehouse architecturesCapacity planning, automation, and monitoring toolsData governance, metadata management, master data management, and data lineageExperience with cloud database/data platformsRESPONSIBILITIESDesign, maintain, and optimize enterprise SQL Server database architectures supporting transactional, analytical, and operational systems.Develop conceptual, logical, and physical data models and establish database architecture and governance standards.Administer SQL Server environments, including performance monitoring, tuning, indexing, backup/recovery, replication, security, and capacity planning.Design and support high availability, disaster recovery, and data resiliency solutions.Develop and maintain ETL processes, data pipelines, data warehouses, data lakes/lakehouses, and data integration solutions.Implement data cleansing, transformation, validation, reconciliation, and reporting processes.Troubleshoot production database issues, perform root-cause analysis, and support critical incidents.Collaborate with business, application, infrastructure, cybersecurity, and data teams while maintaining technical documentation and operational procedures.Other RequirementsHigh School diploma, Associate/Bachelor's degree, or equivalent combination of education and experience.Hybrid work arrangement with 1 day onsite per week.Face-to-face interview required.Participation in planned maintenance windows and occasional after-hours/on-call production support may be required.