Nature of Job

Leads architect in the design of a multi-system hybrid-cloud database environment, including staging/ODS datastores and a cloud-based data warehouse; responsible for decision-making on the technology and hardware used to create and maintain the environment.

Duties and Responsibilities

• Designs, configures, deploys, and administers cloud-based SQL and on-premise Microsoft SQL database technologies in all environments.
• Develops and designs database schema, SQL queries and turning, stored procedures, and SSIS packages.
• Knowledge in data warehouse, ETL, and data modeling.
• Use tools to exchange or transform data among heterogeneous systems and platforms.
• Experience with DevOps, Agile and /or Waterfall methodologies.
• Provides solutions and/or support for non-functional efforts such as Life Cycle Management (Versioning), Performance, Scalability, Reliability, Availability and other capabilities of database technologies.
• Partners with project BA and/or development team(s) in order to fully understand database requirements and configure the on-premise and/or cloud database environments that meet these requirements.
• Mentors, coaches and shares knowledge with other team members throughout the technology organization.
• s independently but as a team player and leader.
• Self-starter that can manage their own workload and an ever-growing task list.
• Creates and updates System documentation and design specifications.
• Applies industry database standards and best practices.
• Researches and recommends new and existing technologies to meet business needs, including creating prototypes, design documents, and solution designs.
• Estimates the effort involved in completing various database tasks.
• Reports activities and progress to management when requested.
• Performs tasks as required by management/supervisory staff.
• Provides support after hours, and on weekends as needed.
• Performs other duties as assigned by supervisor.

• Bachelor’s Degree in Computer Science or equivalent business experience.
• Minimum of 7 years of professional experience designing, implementing, developing, and maintaining database technologies within AWS/Azure SQL and on-premise MS SQL Server.
• Minimum of 5 years of experience as a MS SQL Server.
• Minimum of 7 years working experience in Microsoft SQL Server, SSIS, SSRS.
• Proficiency in SQL database administration including development, performance tuning, high availability and Disaster / Data recovery solutions.
• Experience working with SQL Server and AWS/Azure SQL reporting and monitoring tools, and automated tasks/jobs.
• Experience with Jira, Agile and /or Waterfall methodologies.
• Experience integrating and migration (to AWS/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.
• Excellent communication (verbal and written) and interpersonal skills.
• Working knowledge of Snowflake, Informatica and Python programming is preferred.
• Commitment to company values and customer service.
• Ability to perform the essential functions of the job with or without reasonable accommodation.