job summary: Under the supervision of the Director, IT Infrastructure the Senior SQL Database Administrator is responsible for database technologies meeting business and/or technical requirements. The database administrator will leverage their technical expertise and experiences in building, configuring, transforming, maintaining and documenting cloud and on-premise database technologies within the firm. location: NEW YORK CITY, New York job type: Permanent salary: $150,000 - 165,000 per year work hours: 8am to 4pm education: Bachelors responsibilities: Primary responsibility is to design, configure, deploy, and administer Microsoft Azure SQL and on-premise Microsoft SQL database technologies in all environments.Develop and design database schema, SQL queries and turning, stored procedures, and SSIS packages.Develop, create, and support Azure Data Factories pipelines, Azure Databricks, Azure Data Lake, data flows, SSIS configurations, and code repositories.Use tools to exchange or transform data among heterogeneous systems and platformsExperience with Azure DevOps, Agile and /or Waterfall methodologiesProvide solutions and/or support for non-functional efforts such as Life Cycle Management (Versioning), Performance, Scalability, Reliability, Availability and other capabilities of database technologies.Partner with project/BA and/or development team(s) in order to fully understand database requirements and configure the on-premise and/or Azure database environments which meet these requirements.Mentor, coach and share knowledge with other team members throughout the technology organization.Work independently but a team player and leader.A self-starter that can manage their own workload and an ever-growing task list.Create and update System documentation and design specifications.Apply industry database standards and best practices.Research and recommend new and existing technologies to meet business needs, including creating prototypes, design documents, and solution designs.Estimate effort involved in completing various database tasks.A self-starter that can manage their own, plan and prioritize workload and an ever-growing task list.Report activities and progress to management when requested.Perform tasks as required by management/supervisory staff. Provide support after hours, and on weekends as needed. Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. A minimum of 7 years of professional experience designing, implementing, developing, and maintaining database technologies within Microsoft Azure SQL and on-premise MS SQL Server.Minimum of 5 years of experience as a MS SQL Server and Azure SQL database administratorMinimum of 7 years working experience in Microsoft SQL Server, SSIS, SSRSProficiency in SQL database administration including development, performance tuning, high availability and Disaster / Data recovery solutionsExperience working with SQL Server and Azure SQL reporting and monitoring tools, and automated tasks/jobsExperience with Azure DevOps, Agile and /or Waterfall methodologiesExperience integrating and migration (to Microsoft Azure SQL) databases with on-premise and cloud based applications.Knowledge and implementation of database security solutions.Ability to establish and maintain effective working relationships with peers, project team members, supervisors, and employees from other departments.Candidate must have excellent communication (verbal and written) and interpersonal skills.Knowledge in data warehouse, ETL, data modeling is a plus;Working knowledge of Oracle, PostgreSQL, Mongo and other no-SQL document DBs (preferably cloud hosted, i.e. Azure), and Python programming is a big plus; qualifications: Experience level: ExperiencedMinimum 7 years of experienceEducation: Bachelors skills: SQLSSISSSRSSQL Server DBASQL SERVER REPORTING SERVICEETL Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.